Custom table is inconsistent in active version

[kalai_sap]

Hi Team,

I have got a new requirement to add few fields to Ztable of FI module. But once I have added those fields and try to activate it,  i'm getting an error message as ' TABL ZFI_FISCALYEAR is inconsistent in active version' along with a warning message 'Table ZFI_FISCALYEAR is too long (>4030)'.

I have searched many threads but it doesn't solve my issue.

It is an urgent requirement to be completed in a short span of time.

Please guide me to overcome this error.

[Former Member]

hii kalai

make sure filed name and data element you are using is not anywhere else.

if this is not the case then go to utilities->database objeject->database ulitlity-> adjust and activate database table button

hope it will solve your problem

Regards

Gaurav

[kalai_sap]

Hi Gaurav,

Thanks for your reply.

I even tried to activate and adjust database in SE14. But it doesnt work.

[archanapawar]

Hi Kalai,

Go to Se14 and try adjusting the table, see if it activates.

Also, Check the enhancement category of the table ZFI_FISCALYEAR, is it 'Can be enhanced'? If not change it to 'Can be enhanced' and then activate your table.

[kalai_sap]

Hi Archana,

Enhancement category of the table ZFI_FISCALYEAR is set to 'Can be enhanced (Character type or Numeric) but still I got same error.

I even tried with  'Can be enhanced(Deep)'. Still it doesnt work.

[archanapawar]

Hi Kalai,

Your table width should not exceed 4030 characters.

Create an append structure with some of the fields in your table and then try activating it.

[kalai_sap]

Hi Archana,

Yes, I have created append structure within the Ztable and also tried creating it within the include structure of the table. Both methods have not solved my issue.

Ztable>> Append structure>> New fields ----> same activation error

Ztable>>Include structure>>Append structure>> New fields  ----> same activation error

[archanapawar]

Hi Kalai,

Please check below thread. I guess, you need to create a new table and relate it with this existing table.

http://scn.sap.com/thread/2026741

[Former Member]

hii kalai

Please check the data element and field you are using... it might be used somewhere else with diff data element.

for that place your cursor and click on three arrows( where used fields) above n see wheather its used in other tables or views.

Regards

gaurav

[Former Member]

also check your technical settings and buffer settings for second error

Gaurav

[Former Member]

Refer :

ZTable is too long (>4030), DDIC | ABAP, SAP, be...

[Former Member]

hii kalai

no of fields in your table might be more or  date elements you are using exceeds permisible length

Gaurav

[ipravir]

Hi kalai,

Is table contains any data? before added the new fields.

If table is contains any data, please try to delete and then activate your table.

Regards.

Praveer.

[zenit50]

Hi Kalai,

Am also facing a similaar issue where I cant even add a field through append structure also as I am getting length too long error. Coudl you please help if you resolved this issue?

Regards