Table for Sales Order Value

[Former Member]

Dear All,

I need the table name where i can find the total sales order vale (Net Value + Tax Value) in header level.

in header table (VBAK) it store only net value (VBAK-NETWR) excluding Tax amount.

you can find the net value as well as tax value in item level i.e. in table (VBAP) and condition table (KONV) .

but i don't want to use item table.

i need total value in header level.

pls suggest.

Thanks

Radhashyam Sahoo

[Former Member]

Hi,

I don't think any table have the Total Order tax value. You have to sum up the field VBAP-MWSBP.

Regards

Vinod

[Former Member]

For Gross Value - You need to go at Item level (VBAP).

For any Sale Order - Mat, contract or quotation OR any PO.

Tax calculation is done only at Item level.

And It won't take much - You can directly get 'total tax' field - Loop on it and SUM.

[Former Member]

Hai

you can use the field VBAP-KZWI6 , Hope you ll get the correct value

Regards

Sarath P G

[Former Member]

hi...

u could have use 'SALES_PRICE_READ' from that u can get tax value..

Regards,

Jeya

[Former Member]

Hi...

I too facing the same problem... can anybody help us..

Regards,

Jeya