Relation between customer invoice item and accounting document line item

[Former Member]

Dear All,

I have to report customer invoice item net value and customer invoice's accounting document line's values. I have WBS element in sales order item, customer invoice item and Accounting document's account assignmnet view. But, I can't find invoice item number on the accounting document.

How can I find invoice item number on the accounting document?

Thanks a lot.

Gulay Celik

[Former Member · Accepted solution]

Hi,

I have to get this report with abap pgm.

Before, I looked BSEG. I can't see customer invoice item number. Why I use VBFA?. I didn't understand.

This table does not contain customer invoice and customer invoice accounting document's relation.

Gulay Celik

[Former Member · Accepted solution]

Hi Gulay,

Checkout BSEG-POSN2 field :- Sales Document Item

This will relate the invoice doc item with accounting doc item

Thanks

[Former Member · Accepted solution]

Thanks your information.

I checked BSEG-POSN2 and BSEG-VBEL2. But they are blank. Because account asignment is WBS WBS element on the Sales Order item.

Regards

Gulay Celik

[Former Member · Accepted solution]

VBFA is document flow table you can relate sales order line number from BSEG find sales order line in VBFA it will show invoice line number

[Former Member · Accepted solution]

Let me know the sales fields you have populted in BSEG and I will see if I can find the connection

[Former Member]

If you use transaction SE16 look at tables BSEG and VBFA to get the information. You will have to download to Excel and manipulate the data.