Single invoice and multi line itms sum total qty/net value grp by material

[Former Member]

Hi Experts,

Would appreciate anyone advice me

My user wanted to display in VF01 and printout invoice sum up all the material quantity and net value group by material number from multiple sales order and delivery order at item level.

example :

Qty Net Value

Material A 1 10.00

Material B 2 40.00

Material A 3 30.00

Material B 4 80.00

RESULT

Qty Net Value

Material A 4 40.00

Material B 6 120.00

1) I am able to display in VF01 by entering my D/O and S/O numbers in document number column.

2) I click billing document overview button then i am able to view all line items.

How to configure? where i had tried the billing configuration

Copying control: Delivery document to billing document F2-->LF

ZTAD

Copying requirements 004 Deliv-related item

Data VBRK/VBRP 001 Inv.split (sample)

TAN

Copying requirements 004 Deliv-related item

Data VBRK/VBRP 007 Inv.Split (Rec/Div)

Thanks & Regards,

Yong Kok Wah

[former_member183879 · Accepted solution]

Hi

This is not possible in the invoice document in SAP and is not advisable at all to do it by any other means. If the item level details are coupled together, the document flow of hte invoice will be spoiled. Then it will not be possible to find out the sales orders from the invoice document numbers.

However you can do this in the print out of the invoice when the output is triggered. By this it is possible to club the totals materialwise in the PDF document.