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