Skip to Content
0
Former Member
Apr 07, 2007 at 09:41 AM

DB table of VBAP does't exist in database

71 Views

My Requirement is to change the append stucture (ZSALES) field types from 'CHAR' to 'NUMC', which is append to VBAP table.

I went and changed in domain level as 'CHAR' to 'NUMC' for the structure (ZSALES) and activated the domain level of structure (ZSALES).

And I got an error saying I don't have authorization to activate VBAP Data Base table (because ZSALES is dependent structure of VBAP).

At the same time VBAP table became as PARTIALLY ACTIVE. Due to Partially Active of VBAP tabe, T.codes va01and va41are going for dump.

To Rectify VBAP partially active problem, I went to SE14 and VBAP is displayed (EDIT). Inside the SE14, I selected the options are

radio button as 'SAVE DATA' and clicked on "ACTVE AND ADJUST DATABASE". After doing this step, sytem runned for 20 minits in foreground

After 20 minits, system went to Short dump. In the Short dump, I found error as 'An SQL error occurred when accessing a table'.

When I go now in SE11 and see, I am able to see only Data Dictionary object (VBAP table) but Data base table VBAP does not exist in the database.

If you find OSS notes or solution. plz reply to this thred

Thanks,

Anji