Question Re: VBDATA-VBMOD-VBHDR tables in Technology Q&A

VBDATA-VBMOD-VBHDR tables

Former Member — Mon, 11 Feb 2008 14:58:33 GMT

Hello,

What are the functions of VBDATA, VBMOD, VBHDR tables in the system? VBDATA has got 23.000.000 entries. Is it dangerous to delete the tables after back up?help if anyone knows...thanks...

regards

ismail KARAYAKA

Re: VBDATA-VBMOD-VBHDR tables

Former Member — Mon, 11 Feb 2008 15:15:18 GMT

Hi Ismail

These tables are holding your update requests. You should NEVER delete anything from theses tables, this can lead to serious application inconsistencies!

Check out transaction SM13, all administration should be done there.

Best regards, Michael

Re: VBDATA-VBMOD-VBHDR tables

Former Member — Thu, 14 Feb 2008 15:14:41 GMT

hi ismail,

while doing updates it will be initiated by dialog work process.

first the information will be stored in VB* tables.And update work process

reads this information, updates in the database.

we should not delete any thing in theese VB* table data. Once it is completed

we can do reorganize using standard background job called RSM130002.

fallowing information will be stored in these tables

VBDATA-----data fro the update work process.

VBHDR-------header information

VBMOD-------module information

VBERR----

for error information

in SM13, sm14 we can monitor and do administration for updates.

please reward if it is usefull

regards,

Raju.

Re: VBDATA-VBMOD-VBHDR tables

Former Member — Mon, 18 Feb 2008 09:25:47 GMT

Hello Ismail,

All these tables mentioned are specific to Updates in your system.There is no issue if it contains so many entries in vbdata.You can perform a reorganization using the SAP standard job for cleaning up the old entries.If you delete some entry from these tables and some update is not complete then it would create inconsitencies in your database.So in unavoidable circumstances you can touch these tables and otherwise use SAP standard tools to administer all these stuffs.

Thanks and Regards,

-Bijesh.

Re: VBDATA-VBMOD-VBHDR tables

Former Member — Fri, 22 Feb 2008 15:37:25 GMT

Hello,

Thank you for Help...

regards

ismail Karayaka

Re: VBDATA-VBMOD-VBHDR tables

Former Member — Mon, 15 Apr 2013 15:13:15 GMT

Hi all ,

I need a small help on my understanding .I have an update FM which is not getting triggered in Development but triggering in Q.The code is the same in both .

I see these 3 tables i see no entries in development (se11).

In Q i see some entries .Should these tables be empty ideally ?Is there any system setting that we have missed .

Regards

Harish.