SAP ABAP Table MDKPDB (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
       ⤷ MD03 (Package) Appl. development R/3 MPS/determin. requirements planning

Basic Data

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

History

Last changed by/on	SAP	20130529
SAP Release Created in