Include structure in standard table

[former_member1330001]

Hi Friends,

I need to add some fields to a standard table. SAP has given a provision to add custom fields by providing an include structure within the table so that we can add fields there in the structure and get it added in the standard table. The problem here is whenever i add some fields to the structure and activate, its only partially active. So as the standard table.

In the log it says that the standard table is inconsistent and the length of the table exceeds 1962. Is there any workaround for this? Is there anyway to delete the fields added through the structure to the standard table without an access key? Or is there any way to increase the maximum length of the table?

[Former Member]

Hi,

Can you tell me how you added include in standard. I was trying to add but that options is in disable mode.

Thanks in advance.

Thanks,

Pradeep

[christian_wohlfahrt]

Hi!

I remember a restriction in the number of key fields and I know, that long fields are created as raw / cluster. So there seems to be the border of 1962 bytes for table structure length.

To be honest: restrict your fields! 2kb for each entry will be very soon a very big table. You might run into memory problems, if you try to read 'into table' like normal.

If you need some long texts, you can try to create a separate text table and save only a link in the original SAP table. (e.g. 10 numbers, taken from a number range.) Then you can also include LANGU as key field and be able to save multilingual.

Regards,

Christian

P.S.: To get rid of partial activation: be sure, no one locks anything in the system (late evening, early morning), push activation again (for each object with problems in activation log).

[Former Member]

I understand that standard table and ur include structure is partially active. even if u delete them and activate them it will still be partially active.. All you have to do is

1. goto SE14 transaction

2. give ur SAP standard table name in obj.name.

3. let the radio button be on TABLES.

4. click EDIT.

5. It takes you to the next screen.

6.processing type can be direct or background. click on save data radio button.

7. click on ACTIVATE AND ADJUST DATABASE TABLE.

8. After this procedure wait till it finsihes adjusting and activating the tables. then goto to ur table and check if ur table is activated. Then u can goto ur include and activate it there. Sometimes the include is activated directly else u can now go and activate it. This will def solve ur problem ))))..