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]

Hello

You can use index table VAPMA to see WERK.

Regards

Rafal

[Former Member]

I forgot to add:

for data stored in material master (MM01) you don't need them to be repeated in sales order tables.

This data are not different for several sales orders, so its no need system saves them

Please check MARA for material

regards

RAfal

[Former Member]

I quickly checked

BTGEW is not the filed you can change

BRGEW you can change for each position and it is stored in VBEP-BRGEW (here I was wrong in last post. You can change what was taken from material master and this will be stored in VBAP table).

BTGEW is calculated value, because the F1 help says its total and its calculated.

I think this answers your question.

regards

Rafal

Edited by: Rafal Drezek on Jul 9, 2009 4:37 PM

Edited by: Rafal Drezek on Jul 9, 2009 4:38 PM

[Shivareddy]

VBAP