Database object for table VBAP is inconsistent

Former Member · ‎2011 Jul 19

Hello gurus,

We are facing Inconsistencies between the database object and the runtime object of the table VBAP.

The problem occurred while an append structure was deleted.

In particular, we created a new zfield in tables VBAPKOZ and VBAPKOZX and after activating these two tables we created an append structure for table VBAP.

Using the Database utility (se14 functionality), the first time the database table was activated and adjusted.

Following backwards the same steps we tried to delete the append structure. This process was not completed successfully switching the status of the table VBAP and the new append structure to partly active. (The system first checks the database object and finds it is inconsistent so refuses to do anything)

Following the instructions of message GT264 we tried unsuccessfully to activate and convert the table to solve the issue. The problem still remains as table VBAP has status partly active, please advice us how to proceed.

Former Member · ‎2011 Jul 19

Hi,

I may not have a solution for this right now. but will tell you wy this may happen.

This is one of the major issues we face sometimes with the standard tables. We start getting runtime errors when we add a new field to a standard table in SAP through append structure as this change when moves to production takes very long time even some time days together to get activated and adjusted due to the amount of data inside them. But works fine in Quality and Development systems.

May i know the problem for you is in which system?. It is very strange that even when you adjust it with SE14 it shows as partially active. Try doing the same step once more and check if it is working fine. it may take long time but finally it may get activated.

We normally move the standard table changes in the weekend so that there will sometime for the standard tables to got activated and adjusted. Because if we try to actiave the table when some one is using them then it will not get activated rather will be in partially active state.

Also can you check if there are any errors in the table?

Thanks,

Venkatesh.

vikrant_guptarya · ‎2011 Jul 19

Hope you have deleted the fields in the structure first & then the append structure itself.

Also hope you have not inserted any data in the enhanced field in the database table.

Former Member · ‎2011 Jul 20

Get back the previous version in version management if its possible. This might help you out getting the previous version of table.

I got in Custom table in past while i was trying to do some changes, i am not sure of standard table, so just give a try.

former_member753329 · ‎2011 Jul 21

Hi Nefeli,

I hope you got the status as Partial active, when you are trying to enhance the table VBAP and on activating it.

1) So, Check the consistency of the Two Structure which you enhanced with new fields and make sure that its in active state, as

this state of Partial Active, may occur if there was an issue with the dependent objects too.

2) But as you said you are trying to reset the table VBAP, only thing it "Try to adjust and activate it again" as the structure would have already resetted by you before.

Note : Dont delete the dependent objects before correcting the issue with the Table.

Thanks.

Hope could it helps to identify your issue.

revert me if it doesn't help you,. we shall look further to fix.

gopu

lijisusan_mathews · ‎2011 Jul 21

Can you try deleting the contents of your append structures first. Then try deleting it and try adjusting too

lijisusan_mathews · ‎2011 Jul 21

Can you try deleting the contents of your append structures first. Then try deleting it and try adjusting too

shahid · ‎2011 Jul 21

well i too have faced the same problem when working with vbapoz,,,, structures.

sometimes it gets activates very easily and sometimes it wont.

I am not sure about the solution, but whenever i couldnt able to activate it..i used to RECREATE the whole structure. its like going back to step 1 and doing the required.

Former Member · ‎2011 Jul 22

Thank you all for your responses.

Some of you said that i should try to adjust the table through se14. That was something that i did a couple of times. I also tried to force conversion , but because the table wasn't active , it didn't let me. So I created again tha appended field but in a new append structure. After this the table turned to active but conversion wasn't enough so we did reconstruction through se14, that finally worked.

Thank you again.

shahid · ‎2011 Jul 22

Yeah... I too failed to make it active.

As i told I used to do it from STEP 1, creating all over again