Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Problems with exceeding the total field length.

Former Member
0 Kudos
805

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
293

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

3 REPLIES 3

raviprakash
Product and Topic Expert
Product and Topic Expert
0 Kudos
293

>

> 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
Product and Topic Expert
Product and Topic Expert
0 Kudos
293

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
0 Kudos
294

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