Get total amount for an order

[Former Member]

Hello experts,

I want to get the total amount for an order (with taxes) , if possible directly from tables, can you tell me how I can do that ?

Thanks

[Lakshmipathi · Accepted solution]

Not sure, what exactly you are looking for and why you want that.  In VBAP table, you can find both Net Value and Tax and you have to cumulate these two line item wise.  You cannot find this at header level.

G. Lakshmipathi

[Former Member · Accepted solution]

Hi,

Direct value from single field we will not be able to get.

We can add the sales order line items and print the total value

Logic:

Goto -VBAP and pass VBELN

Take all PONSR, and then  Add (NETWR + MWSBP)= total value

The above logic you can give to ABAP tem they will do put the same as logic.

Hope this will helpful.

Thanks,

Anil.G

[RahulHanda]

Hi Benoit,

Did you already checked SAP tables VBAK & VBAP? Take one sales order and check the same on header & item level. It will show you net value.

regards

Rahul

[Former Member]

Hi Rahul,

Well as I said I want total amount (ENDBK), not the net value,

Regards

[RahulHanda]

Hi Benoit,

Could you mention the table you are referring to for the above mentioned field? Though cross check the below thread.

https://scn.sap.com/thread/488679

Regards

Rahul

[Former Member]

Rahul,

I read this post twice, it's not much help.

I just want the total amount of the order, which is net amount + taxes.

RV45A-ENDBK in program SAPMV45A.

Regards

[moazzam_ali]

Hi

I think you can do this by changing your pricing procedure settings. You have to add total tax value and net value in a subtotal and assign KZWI1 to KZWI6 any subtotal to this step. This will save your required value in this subtotal in VBAP and you can very well get this in your smartform or report etc.

Thank$