Urgent : Link b/w MKPF and BKPF and BSIS

[Former Member]

Hi,

I am making a report in which i have to display the vendor payment status.

In table BKPF there is a field called AWKEY and AWTYP and i want to reterive data form it and after that in BSIS table there is a field called XREF3 which is similar to the AWKEY in the BKPF table.

plzz tel me how to make the realtion b/w these tables as help will be deifnately rewarded.

[ak_upadhyay]

Hi,

Check this link...

http://www.erpgenie.com/abap/tables.htm

Regards

AK

[Former Member]

hi,

actually i had tried the other fields frmo the table but i am not able to get the requeired result. plzz provide me guide lines for it..as help will

be definately rewarded.

[Former Member]

Retrieve AWKEY from BKPF where AWTYP = MKPF

and pass the first 10 characters of AWKEY to MBLNR of MKPF

You JOIN BKPF and BSIS on BUKRS, BELNR and GJAHR.

[Former Member]

hi,

i am able to reterive data from now but i want to have this method also which u had told.

i am doing inner join concept but accorind to tyou :-

pass the first 10 characters of AWKEY to MBLNR of MKPF.

how should i use this concept?

Edited by: abaper2008 on May 24, 2008 8:48 AM

[former_member184657]

first link MKPF and BKPF using MKPF-MBLNR with BKPF-BELNR and MKPF-MJAHR with BKPF-GJAHR.

then link BKPF and BSIS using fields BKPF-BUKRS with BSIS-BUKRS, BKPF-BELNR with BSIS-AUGBL,

BKPF-GHAJR with BSIS-GJAHR, BKPF-BLDAT with BSIS-AUGDT and BKPF-DBBLG with BSIS-BELNR.

hope it helps,

regards

pk