How to relate Invoice Creation Date and PO Creation Date

[Former Member]

Hi,

I want to relate Invoice Creation Date and PO Creation Date. Can any one suggest on this.

Thanks,

Arvind

[Former Member · Accepted solution]

use table EKBE. the PO history category BEWTP is 'Q' for invoice document

and column BUDAT will give you creation date of invoice. Creation date of PO can be taken from EKKO -AEDAT.

[Former Member]

Hi

I don't understand the requirement to relate Invoice creation Date to PO creation date? Can u explain clearly why you need to relate both?

Is there in back ground job running for IR creation or You want see the difference in days from PO date to Invoice days? If yes , you just create one SAP Querry to fetch data from PO and IR tables.

Regards

Ramakrishna

[Former Member]

Hi,

Thanks for your response.

I need to create a report which would show all the POs with Invoice creation date > PO creation date.

Thanks,

Arvind