topic Re: Custom table is inconsistent in active version in Application Development and Automation Discussions

Custom table is inconsistent in active version

kalai_sap — Thu, 11 Dec 2014 06:45:28 GMT

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.

Re: Custom table is inconsistent in active version

Former Member — Thu, 11 Dec 2014 07:03:15 GMT

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

Re: Custom table is inconsistent in active version

archanapawar — Thu, 11 Dec 2014 07:08:19 GMT

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.

Re: Custom table is inconsistent in active version

kalai_sap — Thu, 11 Dec 2014 07:10:32 GMT

Hi Gaurav,

Thanks for your reply.

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

Re: Custom table is inconsistent in active version

kalai_sap — Thu, 11 Dec 2014 07:14:54 GMT

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.

Re: Custom table is inconsistent in active version

Former Member — Thu, 11 Dec 2014 07:17:31 GMT

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

Re: Custom table is inconsistent in active version

archanapawar — Thu, 11 Dec 2014 07:18:41 GMT

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.

Re: Custom table is inconsistent in active version

Former Member — Thu, 11 Dec 2014 07:20:30 GMT

also check your technical settings and buffer settings for second error

Gaurav

Re: Custom table is inconsistent in active version

Former Member — Thu, 11 Dec 2014 07:21:42 GMT

Refer :

ZTable is too long (&gt;4030),&nbsp;DDIC&nbsp;|&nbsp;ABAP,&nbsp;SAP,&nbsp;benX AG,&nbsp;benX…

Re: Custom table is inconsistent in active version

Former Member — Thu, 11 Dec 2014 07:24:15 GMT

hii kalai

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

Gaurav

Re: Custom table is inconsistent in active version

kalai_sap — Thu, 11 Dec 2014 07:25:44 GMT

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

Re: Custom table is inconsistent in active version

ipravir — Thu, 11 Dec 2014 07:27:16 GMT

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.

Re: Custom table is inconsistent in active version

archanapawar — Thu, 11 Dec 2014 07:32:53 GMT

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

Re: Custom table is inconsistent in active version

zenit50 — Tue, 22 Nov 2022 09:28:49 GMT

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