SAP ABAP Table MDCL (Transf. struct. for printing the component list in plnd ord.)

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	INTTAB	Structure
Structure	MDCL	Table Relationship Diagram
Short Description	Transf. struct. for printing the component list in plnd ord.

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	.INCLUDE	☐				0	0	View of Material Components in the Planned Order
2	AUFST	☐	AUFST	AUFST	NUMC	2	0	Order level
3	AUFWG	☐	AUFWG	AUFWG	NUMC	2	0	Order path
4	PMSOR	☐	PMSOR	RSPOS	NUMC	4	0	Internal sort key
5	XPOSN	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
6	PMSO1	☐	PMSO1	CHAR2	CHAR	2	0	Sort fiels 1 for discontinued and substitute parts
7	EPOSN	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
8	STSOR	☐	SORTP	CHAR10	CHAR	10	0	Sort String
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
12	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
13	POSNR	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
14	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
15	DUMPS	☐	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
16	TXTPS	☐	TXTPS	XFELD	CHAR	1	0	Item text indicator
17	INPOS	☐	INPOS	XFELD	CHAR	1	0	Indicator: intra material
18	SGTPS	☐	SGTPS	XFELD	CHAR	1	0	Bulk material indicator
19	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
20	KZKUP	☐	KZKUP	XFELD	CHAR	1	0	Indicator: Co-Product
21	KLPOS	☐	KLPOS	XFELD	CHAR	1	0	Indicator: class item
22	CLAKZ	☐	CLAKZ	XFELD	CHAR	1	0	Indicator: classification exists
23	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
24	MTKFM	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
25	KMPKA	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	TCK08
26	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
27	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
28	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
29	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
30	BEIKZ	☐	BEIKZ	BEIKZ	CHAR	1	0	Material Provision Indicators	*
31	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	T413
32	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
33	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
34	LAGME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
35	ESMNG	☐	ESMNG	ESMNG	FLTP	16	16	Usage quantity per order unit of measure
36	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
37	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T158B
38	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
39	ERFMG	☐	CO_MENGE	MENGV13	QUAN	13	3	Requirement quantity of the component
40	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	*
41	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
42	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
43	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
44	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
45	ALTPS	☐	ALTPS	XFELD	CHAR	1	0	Alternative item indicator
46	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
47	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
48	ALPRF	☐	CS_ALPRF	NUM2	NUMC	2	0	Alternative Item: Ranking Order
49	ALPST	☐	CS_ALPST	CS_ALPST	CHAR	1	0	Alternative Item: Strategy
50	KMPAS	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
51	AVOAS	☐	AVOAU	DEC3_2	DEC	5	2	Operation Scrap
52	AVONT	☐	NETAU	XFELD	CHAR	1	0	Indicator: Net Scrap
53	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
54	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
55	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
56	ASTTR	☐	ASTTR	DATUM	DATS	8	0	Order start date
57	VERTI	☐	SA_VERTI	SA_VERTL	CHAR	4	0	Distribution key for component consumption	*
58	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
59	ROHPS	☐	ROHPS	XFELD	CHAR	1	0	Variable-sized item indicator
60	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
61	ROAME	☐	ROAME	MEINS	UNIT	3	0	Unit of measure for variable-size items	*
62	ROMNG	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
63	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	*
64	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
65	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
66	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
67	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	*
68	LGPRO	☐	LGPRO	LGORT	CHAR	4	0	Issue storage location	T001L
69	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	PVBE
70	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
71	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	*
72	STLTX	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	*
73	SGTX1	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
74	SGTX2	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
75	NFPKZ	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
76	KZAUS	☐	AUSLF	AUSLF	CHAR	1	0	Discontinuation type
77	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
78	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
79	NAFKZ	☐	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
80	NFMAT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
81	NOMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
82	NFUML	☐	NFUML	NFUML	DEC	5	4	NOT USED: Quantity transfer factor for follow-up material
83	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
84	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	*
85	BAUST	☐	BAUST	AUFST	NUMC	2	0	Assembly order level
86	BAUWG	☐	BAUWG	AUFWG	NUMC	2	0	Assembly order path
87	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
88	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
89	STKNR	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
90	STKZA	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
91	STVKN	☐	STVKN	KNTNR	NUMC	8	0	Inherited Node Number of BOM Item
92	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
93	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
94	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
95	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
96	LIFZT	☐	LIFZT	DEC3	DEC	3	0	Delivery Time in Days
97	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
98	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
99	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
100	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
101	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
102	SAKTO	☐	SAKTO	SAKNR	CHAR	10	0	Cost Element	*
103	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
104	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	*
105	DISVF	☐	DISVF	DISVF	CHAR	1	0	MRP procedure
106	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
107	MISKZ	☐	MISKZ	MISKZ	CHAR	1	0	Mixed MRP indicator
108	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
109	SBDKZ	☐	SBDKZ	SBDKZ	CHAR	1	0	Dependent requirements ind. for individual and coll. reqmts
110	KZBED	☐	KZBED	KZBED	CHAR	1	0	Indicator for Requirements Grouping
111	EPRIO	☐	EPRIO	EPRIO	CHAR	4	0	Withdrawal sequence group for stocks	*
112	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
113	MTAKZ	☐	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
114	MTADT	☐	AUSDT	DATUM	DATS	8	0	Effective-out date
115	MTNMT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
116	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
117	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
118	RSART	☐	RSART	RSART	CHAR	1	0	Record type
119	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
120	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
121	SMBLN	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
122	SMBLP	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
123	VSTAT	☐	VSTAT_D	VSTAT	CHAR	1	0	Processing Status
124	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
125	IMDCI	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
126	ACENQ	☐	ACENQ	XFELD	CHAR	1	0	Material block in availability check with transfer of qties
127	IFIXX	☐	IFIXX	CHAR1	CHAR	1	0	Internal fixing indicator when fixing phantom assemblies
128	STALT	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
129	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	*
130	PUMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
131	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
132	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
133	NOSRQ	☐	EINBD	CHAR1	CHAR	1	0	No individual requirements in table RESB
134	DBKZG	☐	DBKZG	CHAR1	CHAR	1	0	Requirement as total record in table RQIT
135	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
136	OBNUM	☐	OBNUM	OBNUM	CHAR	20	0	Object reference: Document log - repetitive manufacturing
137	EDGNO	☐	EDGNO	EDGNO	NUMC	17	0	Internal number for edge of object dependencies tree	*
138	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
139	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	*
140	APOKZ	☐	APOKZ	APOKZ	CHAR	1	0	Indicator: Is material relevant for APO
141	.INCLUDE	☐				0	0	Structure for Goods Movement - Reason Code
142	MB_GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
143	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
144	NODSP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
145	MLSCR	☐	MLSC_RELEVANT	XFELD	CHAR	1	0	Multilevel Subcontracting Indicator
146	.INCLUDE	☐				0	0	Add.Structure f. Pick List, Reproc. Goods Mvmt, MatlOverview
147	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
148	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
149	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
150	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
151	KTEXT	☐	CR_KTEXT	TEXT40	CHAR	40	0	Short description
152	AUFPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
153	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	*
154	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	*
155	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
156	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
157	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
158	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
159	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
160	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
161	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
162	ELGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
163	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	*
164	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	*
165	AVAIL	☐	SA_AVAIL	MENG13V	QUAN	13	3	Current warehouse stock
166	LMINB	☐	LMINB	MENG13	QUAN	13	3	Reorder point for storage location MRP
167	DISKZ	☐	DISKZ	DISKZ	CHAR	1	0	Storage location MRP indicator
168	KANBN	☐	SA_ISKANB	XFELD	CHAR	1	0	Indicator: Kanban part
169	NBDMG	☐	SA_NBDMG	MENG13	QUAN	13	3	Net requirements quantity for material provision
170	MISSQ	☐	SA_MISSQ	MENG13	QUAN	13	3	Missing quantity
171	ERFGME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	*
172	WMPPI	☐	T340DWMPPI	XFELD	CHAR	1	0	Active WM-PP interface
173	ELORT	☐	SA_ELORT	LGORT	CHAR	4	0	Replenishment storage location for pull list	*
174	ESOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
175	ELIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
176	EQUAN	☐	SA_EQUAN	MENG13	QUAN	13	3	Proposed quantity for stock transfer from pull list
177	RMISS	☐	SA_RMISS	MENG13	QUAN	13	3	Remaining material shortage after stck transfer in pull list
178	EXCEP	☐	SA_EXCEP	SA_EXCEP	CHAR	1	0	Exception message in the pull list
179	MSGID	☐	ARBGB	ARBGB	CHAR	20	0	Application Area	*
180	MSGNO	☐	MSGNO	MSGNR	CHAR	3	0	System Message Number	*
181	MSGTY	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
182	MSGV1	☐	MSGV1	CHAR50	CHAR	50	0	Message variable 01
183	MSGV2	☐	MSGV2	CHAR50	CHAR	50	0	Message variable 02
184	MSGV3	☐	MSGV3	CHAR50	CHAR	50	0	Message variable 03
185	MSGV4	☐	MSGV4	CHAR50	CHAR	50	0	Message variable 04
186	WEBLNR	☐	WEBLNR	BELNR	CHAR	10	0	Number of a document from a goods movement with errors
187	WEBLPOS	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
188	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
189	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
190	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
191	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
192	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
193	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
194	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
195	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
196	FWDAT	☐	CO_FWDAT	DATUM	DATS	8	0	Date when the error first arose
197	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
198	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
199	XSTOR	☐	XSTOR	XFELD	CHAR	1	0	Reverse posting indicator
200	SJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
201	QPLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
202	MHDAT	☐	TMHHD	DATUM	DATS	8	0	SLED/Best-Before Date or Date of Production
203	DNOTW	☐	DNOTW	XFELD	CHAR	1	0	Indicator: Dialog necessary
204	BERKZ	☐	BERKZ	LVS_BERKZ	CHAR	1	0	Material Staging Indicator for Production Supply
205	TBMNG	☐	TBMNG	MENG13	QUAN	13	3	Transfer requirement quantity already requested
206	PRREG	☐	PRREG	PRREG	CHAR	2	0	Checking rule for the availability check	*
207	KZECH	☐	KZECH	KZECH	CHAR	1	0	Determination of batch entry in the production/process order
208	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
209	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
210	KONTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
211	KTOMA	☐	KTOMA	CHAR1	CHAR	1	0	Acct entered manually

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDCL	BWART	T158B	BWART
2	MDCL	BWTAR	T149D	BWTAR
3	MDCL	CHARG	MCHA	CHARG
4	MDCL	ELIFNR	LFA1	LIFNR
5	MDCL	ERSKZ	T413	ERSKZ
6	MDCL	ESOBKZ	T148	SOBKZ
7	MDCL	KMPKA	TCK08	SELKZ
8	MDCL	KNTTP	T163K	KNTTP
9	MDCL	LGPRO	T001L	LGORT
10	MDCL	MATNR	MARA	MATNR
11	MDCL	MB_GRUND	T157D	GRUND
12	MDCL	POSTP	T418	POSTP
13	MDCL	PRVBE	PVBE	PRVBE
14	MDCL	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in