Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Mkpf- Rbkp Relationships

Former Member
0 Kudos

Hi !

I need to find the foriegn key field relationships between the tables:

Mkpf- Header Material Document and

RBKP- Document Header: Invoice Receipt.

What is the foriegn key field relationships between those tables ?

In General What is the way to find foriegn key field relationships between tables ?

Where do i find a charts of foriegn key field relationships between tables ?

Thanks

Moshe

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

There is no foreign key field relationship between these tables.But these two tables having common field MANDT & BLART.The Field MANDT is having the Check Table as T000 & BLART is having the Check Table as T003.

Regards,

Padmam.

7 REPLIES 7

Former Member
0 Kudos

Hi,

There is no foreign key field relationship between these tables.But these two tables having common field MANDT & BLART.The Field MANDT is having the Check Table as T000 & BLART is having the Check Table as T003.

Regards,

Padmam.

Former Member
0 Kudos

Hi,

Can you please tell us why you need the Foreign key Relationship for these tables? What is you requiremnt?

Former Member
0 Kudos

Hi

MKPF and MSEG are the header and item tables for material document which are linked with MBLNR and GJAGR fields

join them and take the EBELN and EBELP fields

and link the Tables RSEG which is the Item level table and RBKP which is the header level table for the with the EBELN and EBELP

So join RBKP and RSEG

RSEG have EBELN and EBELP fields

So link the TABLES MSEG and RSEG with EBELN and EBELP fields

and fetch the required data.

Reward points if useful

Regards

Anji

0 Kudos

Hi Anji !

First thanks for your answer.

When i use the relation ships between Rbkp Rseg and Mkpf Mseg via Ebeln

Ebelp i get all material documents that belongs to the PO of all invoices, however i don't get a certain material document that belongs to certain invoice !.

What else foreign key relation ships between Rbkp Rseg and Mkpf Mseg

i need to use that for a certain invoice i will get only the appropriate material document of the certain invoice and not other material documents that belongs to other invoices of the PO ?

Thanks

Moshe

0 Kudos

Hi

Check the fields XBLNR and the LFBNR fields in the RSEG table

and findout what are all the reference doc's stored in those fields

may be based on those reference doc we have to fetch other data from other tables.

Reward points if useful

Regards

Anji

Former Member
0 Kudos

Hi SS ,

there is no link B/w Invoice and Material Document.

u have to link MIGO document and MKPF.

EKBE-BELNR = MKPF or MSEG-MBLNR where EKBE-VGABE = 1.

Regards

Peram

0 Kudos

HI

Relationship of MKPF & RBKP is

MKPF-MBLNR <----> RBKP-BELNR.

MKPF-MJAHR <----> RBKP-GJAHR.

Regards

Muralitharan.C