Skip to Content
avatar image
Former Member

Table for Sales Order Value

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Apr 22, 2010 at 06:39 AM

    Hi...

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

    Regards,

    Jeya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2010 at 06:41 AM

    hi...

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

    Regards,

    Jeya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2010 at 07:30 AM

    Hai

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

    Regards

    Sarath P G

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2010 at 07:49 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 22, 2010 at 07:53 AM

    Hi,

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

    Regards

    Vinod

    Add comment
    10|10000 characters needed characters exceeded