SAP ABAP Table MDKP (Header Data for MRP Document)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD (Package) Application development R/3 requirements planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MDKP	Table Relationship Diagram
Short Description	Header Data for MRP Document

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DTART	☑	DTART	DTART	CHAR	2	0	Type of MRP list
3	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	PLWRK	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	PLSCN	☑	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	PLSC
6	.INCLUDE	☐				0	0	Data Part for MRP List Header (MDKP, MDKPDB)
7	DTNUM	☐	DTNUM	NUM10	NUMC	10	0	Number of material requirements planning table
8	DSDAT	☐	DSDAT	DATUM	DATS	8	0	MRP date
9	BDBKZ	☐	BDBKZ	XFELD	CHAR	1	0	Selection indicator for processed MRP lists
10	SLKZ1	☐	SLKZX	CHAR1	CHAR	1	0	Selection indicator for exception groups
11	SLKZ2	☐	SLKZX	CHAR1	CHAR	1	0	Selection indicator for exception groups
12	SLKZ3	☐	SLKZX	CHAR1	CHAR	1	0	Selection indicator for exception groups
13	SLKZ4	☐	SLKZX	CHAR1	CHAR	1	0	Selection indicator for exception groups
14	SLKZ5	☐	SLKZX	CHAR1	CHAR	1	0	Selection indicator for exception groups
15	SLKZ6	☐	SLKZX	CHAR1	CHAR	1	0	Selection indicator for exception groups
16	SLKZ7	☐	SLKZX	CHAR1	CHAR	1	0	Selection indicator for exception groups
17	SLKZ8	☐	SLKZX	CHAR1	CHAR	1	0	Selection indicator for exception groups
18	VRKZ1	☐	VRKZ1	XFELD	CHAR	1	0	Processing indicator 01
19	VRKZ2	☐	VRKZ2	XFELD	CHAR	1	0	Processing indicator 02
20	VRKZ3	☐	VRKZ3	XFELD	CHAR	1	0	Processing indicator - 03
21	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
22	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
23	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
24	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
25	SOBSL	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	T460A
26	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
27	WRK02	☐	WRK02	WERKS	CHAR	4	0	Planning/production plant	T001W
28	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
29	DISVF	☐	DISVF	DISVF	CHAR	1	0	MRP procedure
30	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
31	PLDIS	☐	PLDIS	DISPO	CHAR	3	0	Planning controller (no longer used)	T024D
32	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
33	MTWZT	☐	MTWZT	DEC3	DEC	3	0	Material replenishment lead time
34	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
35	BEAZT	☐	BEAZT	DEC3	DEC	3	0	Processing time for purchase order proposal
36	FIXTR	☐	FIXTR	DATUM	DATS	8	0	End of planning time fence (date)
37	MFHKZ	☐	MFHKZ	XFELD	CHAR	1	0	Planning time fence set manually (MFXDT)
38	DISLS	☐	DISLS	DISLS	CHAR	2	0	Lot size (materials planning)	T439A
39	LOSVF	☐	LOSVF	LOSVF	CHAR	1	0	Lot-sizing procedure for short-term period
40	LOSKZ	☐	LOSKZ	LOSKZ	CHAR	1	0	Lot-size indicator for the short-term period
41	PERAZ	☐	PERAZ	DEC03	DEC	3	0	Number of periods for the short-term area
42	EISBE	☐	EISBE	MENG13	QUAN	13	3	Safety stock
43	MINBE	☐	MINBE	MENG13	QUAN	13	3	Reorder point
44	HOEBE	☐	MABST	MENG13	QUAN	13	3	Maximum stock level
45	BSTMI	☐	BSTMI	MENG13	QUAN	13	3	Minimum lot size
46	BSTMA	☐	BSTMA	MENG13	QUAN	13	3	Maximum lot size
47	BSTFX	☐	BSTFE	MENG13	QUAN	13	3	Fixed lot size
48	BSTRF	☐	BSTRF	MENG13	QUAN	13	3	Rounding value for purchase order quantity
49	SUM01	☐	SUM01W	MENG13	QUAN	13	3	Plant stock / only plant segment
50	SUM02	☐	NOUSE	MENG13	QUAN	13	3	No longer used/do not use!!
51	SUM03	☐	NOUSE	MENG13	QUAN	13	3	No longer used/do not use!!
52	SUM04	☐	NOUSE	MENG13	QUAN	13	3	No longer used/do not use!!
53	SUM05	☐	NOUSE	MENG13	QUAN	13	3	No longer used/do not use!!
54	NEGBS	☐	NEGBS	MENG13	QUAN	13	3	Negative stock
55	MSGID	☐	MSGID	ARBGB	CHAR	20	0	Message identification	*
56	MSGAR	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
57	MSGNR	☐	MSGNR	MSGNR	CHAR	3	0	Message number	T100
58	MSGV1	☐	MSGV1	CHAR50	CHAR	50	0	Message variable 01
59	MSGV2	☐	MSGV2	CHAR50	CHAR	50	0	Message variable 02
60	MSGV3	☐	MSGV3	CHAR50	CHAR	50	0	Message variable 03
61	MSGV4	☐	MSGV4	CHAR50	CHAR	50	0	Message variable 04
62	DISGR	☐	DISGR	DISGR	CHAR	4	0	MRP Group	T438M
63	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
64	MRPPP	☐	MRPPP	MRPPP	CHAR	3	0	PPC planning calendar	T439G
65	BDARF	☐	BDARF	MENG13	QUAN	13	3	Requirements quantity from material requirements planning
66	LFRHY	☐	LFRHY	MRPPP	CHAR	3	0	Planning cycle	T439G
67	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	*
68	BERW1	☐	BERW1	DECV3_1	DEC	4	1	Stock Days' Supply Without Receipts
69	BERW2	☐	BERW2	DECV3_1	DEC	4	1	First Receipt Days' Supply
70	KZAUS	☐	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
71	AUSDT	☐	AUSDT	DATUM	DATS	8	0	Effective-out date
72	NFMAT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
73	AUSZ1	☐	AUSZX	CHAR2	CHAR	2	0	Exception group in the MRP list
74	AUSZ2	☐	AUSZX	CHAR2	CHAR	2	0	Exception group in the MRP list
75	AUSZ3	☐	AUSZX	CHAR2	CHAR	2	0	Exception group in the MRP list
76	AUSZ4	☐	AUSZX	CHAR2	CHAR	2	0	Exception group in the MRP list
77	AUSZ5	☐	AUSZX	CHAR2	CHAR	2	0	Exception group in the MRP list
78	AUSZ6	☐	AUSZX	CHAR2	CHAR	2	0	Exception group in the MRP list
79	AUSZ7	☐	AUSZX	CHAR2	CHAR	2	0	Exception group in the MRP list
80	AUSZ8	☐	AUSZX	CHAR2	CHAR	2	0	Exception group in the MRP list
81	BEADA	☐	BEADA	DATUM	DATS	8	0	MRP list processing date
82	NAUKZ	☐	NAUKZ	CHAR1	CHAR	1	0	Indicator: new exception in the MRP list
83	SAUFT	☐	SA_SAUFT	XFELD	CHAR	1	0	Ind.: Repetitive mfg allowed
84	KZPROMO	☐	KZPROMO	CHAR1	CHAR	1	0	Indicator: Material in promotion
85	SHFLG	☐	SHFLG	SHFLG	CHAR	1	0	Safety time indicator (with or without safety time)
86	SHZET	☐	SHZET	NUMC2	NUMC	2	0	Safety time (in workdays)
87	FABKZ	☐	FABKZ	FABKZ	CHAR	1	0	Indicator: Item Relevant to JIT Delivery Schedules
88	MFXDT	☐	MFXDT	DATUM	DATS	8	0	Manual firming date
89	BSKFL	☐	BSKFL	XFLAG	CHAR	1	0	Flag whether stock correction factors exist
90	MAABC	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	*
91	CFLAG	☐	COMPMRPL	XFELD	CHAR	1	0	Aggregated MRP list
92	GRREL	☐	GRREL	XFELD	CHAR	1	0	Relevant for requirements grouping for project stock
93	RWPRO	☐	RWPRO	RWPRO	CHAR	3	0	Range of coverage profile	*
94	SHPRO	☐	SHPRO	SHPRO	CHAR	3	0	Period profile for safety time	*
95	AHDIS	☐	AHDIS	AHDIS	CHAR	1	0	MRP relevancy for dependent requirements
96	BERW4	☐	BERW4	DECV3_1	DEC	4	1	Second Receipt Days' Supply
97	BADON	☐	MD_BADI_ON	XFELD	CHAR	1	0	Indicator: BAdI is Active
98	HANAON	☐	PPH_HANA_ON	XFELD	CHAR	1	0	HANA Optimizations Active / Inactive

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDKP	DISGR	T438M	MTART	KEY	1	CN
2	MDKP	DISLS	T439A	DISLS	KEY	1	CN
3	MDKP	DISMM	T438A	DISMM	KEY	1	CN
4	MDKP	DISPO	T024D	DISPO	KEY	1	CN
5	MDKP	EKGRP	T024	EKGRP	KEY	1	CN
6	MDKP	LFRHY	T439G	MRPPP	REF	C	CN
7	MDKP	MATNR	MARA	MATNR	KEY	1	CN
8	MDKP	MEINS	T006	MSEHI	KEY	1	CN
9	MDKP	MRPPP	T439G	MRPPP	REF	C	CN
10	MDKP	MSGNR	T100	MSGNR	REF	C	CN
11	MDKP	MTART	T134	MTART	KEY	1	CN
12	MDKP	PERIV	T009	PERIV	KEY	1	CN
13	MDKP	PLDIS	T024D	DISPO	KEY	1	CN
14	MDKP	PLSCN	PLSC	PLSCN
15	MDKP	PLWRK	T001W	WERKS	KEY	1	CN
16	MDKP	SOBSL	T460A	SOBSL
17	MDKP	WRK02	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in