VBAP table does not exits

[Former Member]

Hi,

For one of my requirement testing purpose I have created a new field in VBAP table using append structure and reverted my changes in development system. After my changes reverted back i tried to adjust the database using tcode SE14 in backgound. But from last 17 hours it is still running the background job the table VBAP has size: 160 GB .

Because of this reason all sales related transactions are giving dump saying that VBAP table is not exists. In SE16 also it is giving the same error VBAP is not exists in database.

Please suggest me what needs to be done to rectify this major issue.

Thanks in advance.

Swapna

[ThomasZloch]

Are you sure the adjustment process is still running? Check the status and protocols in SE14. In order to adjust a 160 GB table you need time and another 160 GB available on the file system, check this also.

The adjustment must finish successfully, then the table will be visible again for the SAP applications.

Thomas

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21f1ab446011d189700000e8322d00/frameset.htm

[Former Member]

Thanks for the reply, Can you let me know still how much time it takes to finish the job. It is running since last 17 hrs.

Regards,

Swapna

[ThomasZloch]

Do you know how many entries VBAP had? Maybe you can still see it in tx DB20.

Can you see an active BTC process in SM50 that is busy with tables QCMVBAP or QCM8VBAP?

If yes, double click and check the details, how many records have been read and inserted so far? With the two figures (total, processed so far) you might be able to derive the further runtime.

Can you see progress when refreshing the display?

Thomas

[Former Member]

Thanks for your answers, my issue got resolved.

[DipeshKothari]

While appending fields to BIG tables - NEVER select checkbox "INITIAL VALUES" - When you select this - SAP need to go and set initial value for all the records in the table for the newly added field and that takes long time.

[Former Member]

Hi,

The adjustment should run properly and should get finished.

Only then the dump will stop.

Regards,

Ankur Parab