Invoice number vs PO document number

[former_member554246]

Hi Experts,

Can any one explain me how to join the Invoice account number,PO document number and  dates of PO and invoice generated dates?

I want to merge all these fields in one single table. So need some joining condition to merge all these fields.

Thank you,

Vinay 

[Prasoon]

Hi,

   If you want all these data in a single table, you may define user defined LIS info structure as explained in the doc: and then update the historical data to the table as explained in the doc:

   If you just want to track the data, you may link the tables: EKPO, EKBE, RBKP, RSEG, BKPF and BSEG. You may pass the PO number & item to RSEG table and get the invoice number. Pass the invoice number with year to BKPF - AWKEY field and get the accounting document number. Pass the accounting doc number to BSEG table to get the item details.

Regards,

AKPT

[Former Member]

Hi,

Check in std report ME80FN.MB5S

If you need also have an check in EKBE table.

Invoice tables are RBKP- header, RSEG-Line item wise

[Former Member]

Dear vinay,

You can get all the mentined data in EKBE , EKKO tables.any how please explain your requirement in detail.

-

Krishna