How to Get Vender Payment Through Rbkp Table

[Former Member]

Hi,

I have use ekko, ekpo, ekbe, mkpf mseg rbkp rseg tables to get GR and IR.

Now I wanted to get payment details against particular invoice.

So I have to add 2 filed that is payment no and payment status.

So how can I link bsak and bsik tables to rbkp to get above details?

Thank you.

Regards,

jags

[Former Member]

Hi - Try below standard report with regards to Payment Analysis - It meets to P2P reporting requirement. Though the report says for Country "Russia" but it can be executed for any country.

Report output is user-friendly and it captures all the P2P life cycle event.

J3RFPCR - Vendor Payment Analysis

Give it a try. Thanks.

Jaymin B.

[Gustavo_Vazquez]

Hi Jags,

If you reached RBKP table, you can go to BKPF with

AWTYP = RMRP

AWKEY = concatenate rbkp-belnr , rbkp-gjahr

You could also use bkpf-xblnr, budat or bldat to narrow your search. Once in BKPF you can access BSIK, BSAK ( or REGUH if you use F110)

Kind Regards