Skip to Content
0

How to Get Vender Payment Through Rbkp Table

Apr 17, 2017 at 11:33 AM

92

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Gustavo Vazquez Apr 17, 2017 at 02:04 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 17, 2017 at 03:34 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded