04-05-2007 7:38 AM
Hi all,
I want link between MKPF table and RBKP or EKKO table.
Can any body plz help me.
BALU.
04-05-2007 7:41 AM
Hi,
Links will always maintained in the Item tables.
the tables you mentioned are Header tables:
You can join MKPF and MSEG using MBLNR and MSEG will have EBELN and EBELP fields.
Similarly RBKP and RSEG(item-reservation) join with Reservation Number and RSEG will have EBELN and EBELP to join with EKPO table which is linked with EKKO with EBELN.
reward if useful
regards,
ANJI
Message was edited by:
Anji Reddy Vangala
04-05-2007 7:41 AM
Hi,
Links will always maintained in the Item tables.
the tables you mentioned are Header tables:
You can join MKPF and MSEG using MBLNR and MSEG will have EBELN and EBELP fields.
Similarly RBKP and RSEG(item-reservation) join with Reservation Number and RSEG will have EBELN and EBELP to join with EKPO table which is linked with EKKO with EBELN.
reward if useful
regards,
ANJI
Message was edited by:
Anji Reddy Vangala
04-05-2007 7:41 AM
04-05-2007 7:44 AM
pass mkpf-mblnr to mseg-mblnr,
get mseg-ebeln.
mseg-ebeln = ekko-ebeln.
04-05-2007 7:44 AM
04-05-2007 7:44 AM
with MIGO number goto MKPF .
<b>first u have to get EBELN from EKKO or EKPO
then get GR numbers from EKBE where EKBE-EBELN = EKKO- EBELN
and VGABE = 1 for GR.
wwith this EKBE-BELNR go to MKPF or MSEG.
i dont have SAP system with me otherwise i can give direct link to get the data.</b>
<b>dont link MSEG with EKKO , it has performace issue.</b>
Regards
Prabhu
04-05-2007 7:47 AM
04-05-2007 7:46 AM
<b>MKPF-EKKO </b>
link is between MSEG and EKPO via fields EBELN and EBELP
link MSEG with MKPF via fields MBLNR and MJAHR
link EKPO with EKKO via EBELN
<b>EKKO-RBKP </b>
link is between RSEG and EKPO via fields EBELN and EBELP
link RSEG with RBKP via BELNR and GJAHR
link EKPO with EKKO via EBELN
Regards
04-05-2007 7:54 AM
Useful table will be EKBE "History per Purchasing Document"
there you will find history of "Goods receipt", "Invoice receipt" and other event during the life of your purchase order.
Useful to make report which matches movement, invoice and this kind of things;
Regards