Problems with exceeding the total field length.

[Former Member]

Hi Gurus,

I am facing a problem, it seems there is a limit on total field length that can be added to a table using the user exit. However i need to use more fields than i already have.

I am facing problem in the table QMEL if i can not seem to add more fields in this once the total fields length reaches 1962.

Is there a way around this?

Regards,

Chinmaya

[raviprakash]

>

> Hi Gurus,
> 
> I am facing a problem, it seems there is a limit on total field length that can be added to a table using the user exit. However i need to use more fields than i already have. 
> I am facing problem in the table QMEL if i can not seem to add more fields in this once the total fields length reaches 1962.
> 
> Is there a way around this?
> 
> Regards,
> Chinmaya

Hi Chinmaya,

The only work around i can think of right now is, that you create a new Table with same Key Fields: MANDT and QMNUM and create maintainence view for the table QMEL.

Regards,

Ravi.

[raviprakash]

Hi Chinmaya,

Just to add:-

A maintenance view permits you to maintain the data of an application object together. The data is automatically distributed in the underlying database tables.

All the tables in a maintenance view must be linked with foreign keys, that is the join conditions for maintenance views are always derived from the foreign key.

Check the foloowing for more information:-

[Maintenance View|http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecf9446011d189700000e8322d00/frameset.htm]

Regards,

Ravi.

[Former Member]

Hi,

Yes there is a limit for a table to contain number of characte per record.

it is 4030 character per record.

i faced teh same problem when i was using ztable, so i created 2 ztables some same key fields and

saved the data.

if you declare fields with 255 char, then it will allow you to inter 255 characters by in database it will save upto 132 characters only.

Try out this if fit for your requirement