SAP ABAP Table MDKE (Extract of 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	INTTAB	Structure
Structure	MDKE	Table Relationship Diagram
Short Description	Extract of header data for MRP document

Delivery and Maintenance

Pool/cluster
Delivery Class
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	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	PLWRK	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	T001W
4	PLSCN	☐	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	PLSC
5	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
6	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
7	BDBKZ	☐	BDBKZ	XFELD	CHAR	1	0	Selection indicator for processed MRP lists
8	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
9	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
10	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
11	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
12	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
13	ESOBS	☐	ESOBS	ESOBS	CHAR	1	0	Special procurement - external display	*
14	AUSNM	☐	AUSNG	CHAR8	CHAR	8	0	Group of exception messages
15	DTNUM	☐	DTNUM	NUM10	NUMC	10	0	Number of material requirements planning table
16	BERW1	☐	BERW1	DECV3_1	DEC	4	1	Stock Days' Supply Without Receipts
17	BERW2	☐	BERW2	DECV3_1	DEC	4	1	First Receipt Days' Supply
18	BERW4	☐	BERW4	DECV3_1	DEC	4	1	Second Receipt Days' Supply
19	NAUKZ	☐	NAUKZ	CHAR1	CHAR	1	0	Indicator: new exception in the MRP list
20	AUSZ1	☐	AUSZ1_D	CHAR2	CHAR	2	0	Exception group MRP list no. 1
21	AUSZ2	☐	AUSZ2_D	CHAR2	CHAR	2	0	Exception group MRP list no. 2
22	AUSZ3	☐	AUSZ3	CHAR2	CHAR	2	0	Exception group MRP list no. 3
23	AUSZ4	☐	AUSZ4	CHAR2	CHAR	2	0	Exception group MRP list no. 4
24	AUSZ5	☐	AUSZ5	CHAR2	CHAR	2	0	Exception group MRP list no. 5
25	AUSZ6	☐	AUSZ6	CHAR2	CHAR	2	0	Exception group MRP list no. 6
26	AUSZ7	☐	AUSZ7	CHAR2	CHAR	2	0	Exception group MRP list no. 7
27	AUSZ8	☐	AUSZ8	CHAR2	CHAR	2	0	Exception group MRP list no. 8
28	DSDAT	☐	DSDAT	DATUM	DATS	8	0	MRP date
29	KZPROMO	☐	KZPROMO	CHAR1	CHAR	1	0	Indicator: Material in promotion
30	MAKZG	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
31	SUM01	☐	SUM01W	MENG13	QUAN	13	3	Plant stock / only plant segment
32	EISBE	☐	EISBE	MENG13	QUAN	13	3	Safety stock
33	MINBE	☐	MINBE	MENG13	QUAN	13	3	Reorder point
34	BERX1	☐	BERW1	DECV3_1	DEC	4	1	Stock Days' Supply Without Receipts
35	BERX2	☐	BERW2	DECV3_1	DEC	4	1	First Receipt Days' Supply
36	BERX3	☐	BERW4	DECV3_1	DEC	4	1	Second Receipt Days' Supply
37	ALINE	☐	XLINE	XLINE	INT4	10	0	Line index for internal table processing
38	ABLKZ	☐	ABLKZ	XFELD	CHAR	1	0	Current stock/requirements list was created
39	LAZKZ	☐	LAZKZ	XFELD	CHAR	1	0	Indicator: List was already accessed (displayed)
40	KZSEASN	☐	KZSEASN	XFLAG	CHAR	1	0	Indicator: Seasonal material
41	MAABC	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	TMABC
42	DISGR	☐	DISGR	DISGR	CHAR	4	0	MRP Group	*
43	EVAPR	☐	MD_EVAPR	MD_EVAPR	CHAR	3	0	Evaluation Profile for Range-of-Coverage Data
44	MODBAD	☐	MD_BADI_MOD	XFELD	CHAR	1	0	Indicator: Modified By BAdI
45	BERTX	☐	BERTX	BERTX	CHAR	40	0	MRP area text
46	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
47	FIXTR	☐	FIXTR	DATUM	DATS	8	0	End of planning time fence (date)
48	MFHKZ	☐	MFHKZ	XFELD	CHAR	1	0	Planning time fence set manually (MFXDT)
49	.INCLUDE	☐				0	0	CPU time for the planning run for a material
50	RTIME	☐	MDRTIME	INT4	INT4	10	0	MRP run: Total duration for each material
51	READT	☐	READT	INT4	INT4	10	0	MRP run: Time required for reading the initial situation
52	LOTST	☐	LOTST	INT4	INT4	10	0	MRP run: Time for calculating net requirements and lot-size
53	EXPLT	☐	EXPLT	INT4	INT4	10	0	MRP run: Time for BOM explosion
54	SCHET	☐	SCHET	INT4	INT4	10	0	MRP run: Time required for lead time scheduling
55	POSTT	☐	POSTT	INT4	INT4	10	0	MRP run: Time for posting
56	MDTBT	☐	MDTBT	INT4	INT4	10	0	MRP run: Time for deleting/saving MRP list
57	RESBT	☐	RESBT	INT4	INT4	10	0	MRP run: Time required for saving dependent requirements
58	ARBPT	☐	ARBPT	INT4	INT4	10	0	MRP run: Time to read routing
59	EINZT	☐	EINZT	INT4	INT4	10	0	MRP run: Time for evaluating the operating time
60	RQITT	☐	RQITT	INT4	INT4	10	0	MRP run: Time required for saving total requirements
61	ICON_BDBKZ	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
62	ICON_AMPEL	☐	MD_ICON_AMPEL	SYCHAR132	CHAR	132	0	Icon for Traffic Light Status of Ranges of Coverage
63	AMPEL	☐	AMPEL_I	ICON	CHAR	4	0	Traffic light icon	*
64	COL_CHAR1_CONT	☐	MD_COL_CONT_CHAR	MD_COL_CONT_CHAR	CHAR	30	0	BAdI MRP: Column Content (Type CHAR)
65	COL_CHAR2_CONT	☐	MD_COL_CONT_CHAR	MD_COL_CONT_CHAR	CHAR	30	0	BAdI MRP: Column Content (Type CHAR)
66	COL_CHAR3_CONT	☐	MD_COL_CONT_CHAR	MD_COL_CONT_CHAR	CHAR	30	0	BAdI MRP: Column Content (Type CHAR)
67	COL_DEC1_CONT	☐	MD_COL_CONT_DEC	MD_COL_CONT_DEC	DEC	13	3	BAdI MRP: Column Content (Type DEC)
68	COL_DEC2_CONT	☐	MD_COL_CONT_DEC	MD_COL_CONT_DEC	DEC	13	3	BAdI MRP: Column Content (Type DEC)
69	COL_DATS1_CONT	☐	MD_COL_CONT_DATS	MD_COL_CONT_DATS	DATS	8	0	BAdI MRP: Column Content (Type DATS)
70	COL_DATS2_CONT	☐	MD_COL_CONT_DATS	MD_COL_CONT_DATS	DATS	8	0	BAdI MRP: Column Content (Type DATS)
71	MMSTA	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	*
72	DSTMP	☐	MD_CREASTMP	TZNTSTMPS	DEC	15	0	Timestamp for Setup Date of Planning Situation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDKE	DISMM	T438A	DISMM
2	MDKE	DISPO	T024D	DISPO
3	MDKE	MAABC	TMABC	MAABC
4	MDKE	MATNR	MARA	MATNR
5	MDKE	MEINS	T006	MSEHI
6	MDKE	MTART	T134	MTART
7	MDKE	PLSCN	PLSC	PLSCN
8	MDKE	PLWRK	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in