SALES INVOICE & PURCHASE ORDER REPORTS

[Former Member]

HOW TO GET THE SALES INVOICE (VBRK-VBELN) BY USING THE PURCHASE ORDER (EKPO - EBELN)

& ALSO HOW DO WE GET THE RSEG - BELNR & RSEG - XBLNR

please dont use CAPS under any circumstances in this forum

Edited by: Lakshmipathi on Sep 10, 2009 8:56 PM

[Former Member · Accepted solution]

Hi ,

There is no direct link between the PURCHASE ORDER & BILLING DOCUMENT

You have to get the sales order number from the Purchase order using the table MSEG

Goto the table MSEG and give the EBELN as the Purchase order number and get the KDAUF.

Then goto the VBAF table and give the Sales order number and pick the subsequence document with the category M.

It will give the Billing document number.

In the same way

Goto the table RSEG and give the Purchase ordr number and fetch the BELNR & XBLNR.

Hope it will solve.

regards,

santosh

[Former Member]

You have to follow the Process as Purchase Order > Stock Transfer Delivery ( VL10B) > STO Billing (VF01).

Best Regards,

Ankur