Sales order tables

[Former Member]

Hi Guru,

Can anybody tell me in which tables the data in sales order like delivering plant, total weight, unit of weight, volume, volume unit etc stored.

For example in my sales order the delivery plant for Sales Order no 100 is J100, in which table is this value J100 stored? I am unable to locate it in VBAK, VBKD or VBAP.

When i try to get it from technical info, i find that it is in structures

RV45A DWERK

RV45A BTGEW

RV45A GEWEI

RV45A VOLUM

RV45A VOLEH

Can anybody tell me where the values for these fields are stored?

Thanks,

Venkat

[Former Member]

Hi,

You can find all the data in VBAP Table itself. The fields are as follows:

Delivering Plant : WERKS

Total weight : BRGEW

Net Weight : NTGEW

Weight Unit : GEWEI

Volume : VOLUM

Volume unit : VOLEH

The weight & related data will be there in VBAP Table only if you have maintained the Data in Material Master MM01 (Under Basic Data 1 Tab).

Regards,

Vishal