Report - PO History Lines

[Former Member]

Hello Friends,

I am trying to build a logic where I can input the Contract Number or Purchase Order Number and in out will expect the all the information related to PO lines up to payment.

For achieving the above result I will consider the below tables:

Table EKPO: From where you can find the Contract Number and Material used in the PO

Table EKBE: From where you can find the Material Document and all the steps performed for PO Line item (PO History)

But still I am not aware how to get the Payment Document , I mean which table is best to refer to find the accounting documents which are related to Advance Payment, Payment Done etc. scenario.

Can any please give me a right guide line as I am not aware the MM part much.

Regards,

Rajesh K.

[Former Member]

hi,

use BSEG table ( ebeln - po number & get belnr )

pass belnr and get awkey in BKPF table.

pass awkey to table RSEG WHERE LFBNR = AWKEY+0(10) to get accounting document number

rbkp table contains the amount value

[nisitshah]

Hi Rajesh.

Get MIRO number from RSEG table,

then you have to pass AWKEY(ref. field) into BKPF table (where AWKEY = MIRO no. + FY)

Thus you will get FI document number..

Pass it to BSAK table & get clearing document number...

This clearing document number is your required payment document number..

[former_member198650]

Hi Rajesh,

You can check the report ME80FN to get purchase order history. If you want payment details against the PO then you can check the table BSEG.

Regards,

Mukthar

[JL23]

Since payment is not part of MM I am moving this discussion to FI