Urgently !! Payable invoice and its Contracts?

[FakhriSCR]

Dear Team,

I need report or table with below information

Invoices numbers

Contract numbers

Vendor code

Amount

Date.

Specially i need contracts and its invoices.

[sumesh_gupta · Accepted solution]

Hello you can use below tables to get this info.

MIRO invoices - RBKP, RSEG (you will get PO number in this) then use EBKE table to get details of all documents related to PO.

If you also need details on open invoices (yet to be paid) use BSIK (vendor open item)/BKPF (Accounting document header) table in these you will get MIRO invoice number as well.

Regards,

Sumesh Gupta

[Ahmadfurqoni68]

Hello, 

I think you can use fbl1n. The only thing you can't have directly po or contract number. Usually, people who do invoicing must enter po/contract number in assignment field, in tcode fb60 or miro. So in fbl1n will get the report.

[FakhriSCR]

FBL1N not appropriate for now..Any report else?