Link between MKPF table and EKKO or RBKP table

[Former Member]

Hi all,

I want link between MKPF table and RBKP or EKKO table.

Can any body plz help me.

BALU.

[Former Member]

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

[Former Member]

Hi all,

Can anybody help me in this...

BALU.

[Former Member]

pass mkpf-mblnr to mseg-mblnr,

get mseg-ebeln.

mseg-ebeln = ekko-ebeln.

[Former Member]

HI,

<b>XBLNR</b> Reference document number in MKPF and RBKP.

[Former Member]

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

[Former Member]

Hi Prabhu,

Can u send me in detail plz.

Balu.

[raymond_giuseppi]

<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

[raymond_giuseppi]

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