Total net order value Customer wise

[Former Member]

Dear All,

I want to extract total Net sales order value customer wise for developing a report. I need to know SAP table details to get Total sales order values customer wise.

Standard report does not match my requirment.

I need to extract details from VBAP, customer wise. Please advise me to build a logic.

Thanks,

sajeewa.

[Former Member]

You can get the Net value from VBAP-NETWR by line item & the sold to is on VBAK-KUNNR, then make a join on VBAK-VBELN & VBAP-VBELN, then group it by KUNNR to display totals by Customer.

[Lakshmipathi]

Check in MC(I, MC+2 & MCTE

thanks

G. Lakshmipathi

[Former Member]

Refer table VBAK - KUNNR (Customer) & VBAK - NETWR (Net Value).

Best Regards,

Ankur