name and primary key

[former_member1193869]

hi,

Can any one plz tell the name and primary key of MKPF & MSEG.

[Former Member · Accepted solution]

hi,

MKPF-Header-Material Document

Key fields are

MBLNR-Number of material document

MJAHR-Material document year

MSEG-Document Segment Material

ZEILE-Item in Material Document and also the key fields of MKPF.

[Former Member]

Primary keys of MKPF ( Header: Material Document )

MANDT : Client

MBLNR : Number of Material Document

MJAHR : Material Document Year

Primary keys of MSEG ( Document Segment: Material )

MANDT : Client

MBLNR : Number of Material Document

MJAHR : Material Document Year

ZEILE : Item in Material Document

Hope this is helpgul.

rgds,

Rajashree

[Former Member]

Hi Naveen,

<b> 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.</b>

Regards

Sathish

[Former Member]

hi

the same can be checked at se11...or u should clear ur ques..

mkpf

MANDT MANDT CLNT 3 0 Client

MBLNR MBLNR CHAR 10 0 Number of Material doc

MJAHR MJAHR NUMC 4 0 Material Document Year

mseg

MANDT MANDT CLNT 3 0 Client

MBLNR MBLNR CHAR 10 0 Number of Material Document

MJAHR MJAHR NUMC 4 0 Material Document Year

ZEILE MBLPO NUMC 4 0 Item in Material Document

regards

dinesh

[Former Member]

<b>Primary key of MKPF:</b>

MANDT	MANDT	CLNT	3	Client
MBLNR	MBLNR	CHAR	10	0	Number of Material Document
MJAHR	MJAHR	NUMC	4	0	Material Document Year

<b>Primary key of MSEG:</b>

MANDT	MANDT	CLNT	3	0	Client
MBLNR	MBLNR	CHAR	10	0	Number of Material Document
MJAHR	MJAHR	NUMC	4	0	Material Document Year
ZEILE	MBLPO	NUMC	4	0	Item in Material Document

[former_member1193869]

can ugive the names plz

[Former Member]

Hi,

goto Se11 , give the table name MKPF and choose display. You can see the table fields . Check which fields have been selected as primary key fields. Same thing for the other table.

Regards,

Shruthi R