SAP ABAP Table MDSP (View of BOM items and material master for gross reqmts plng)

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	MDSP	Table Relationship Diagram
Short Description	View of BOM items and material master for gross reqmts plng

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	STKZA	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
2	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
3	DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
4	TECHV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
5	TECHB	☐	TECHB	TECHS	CHAR	12	0	Technical status to
6	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
7	STSOR	☐	SORTP	CHAR10	CHAR	10	0	Sort String
8	POSNR	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
9	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	*
10	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
11	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
12	KMPFE	☐	SANFE	XFELD	CHAR	1	0	Indicator: Item Relevant to Production
13	KMPKA	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	*
14	KMPMT	☐	IDNRK	MATNR	CHAR	18	0	BOM Component	*
15	KMPME	☐	KMPME	MEINS	UNIT	3	0	Component Unit of Measure	*
16	KMPMG	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
17	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
18	ALPOS	☐	ALPOS	XFELD	CHAR	1	0	Indicator: Alternative Item
19	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
20	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
21	ALPRF	☐	CS_ALPRF	NUM2	NUMC	2	0	Alternative Item: Ranking Order
22	ALPST	☐	CS_ALPST	CS_ALPST	CHAR	1	0	Alternative Item: Strategy
23	KMPAS	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
24	AVOAS	☐	AVOAU	DEC3_2	DEC	5	2	Operation Scrap
25	AVONT	☐	NETAU	XFELD	CHAR	1	0	Indicator: Net Scrap
26	BEIKZ	☐	BEIKZ	BEIKZ	CHAR	1	0	Material Provision Indicators	*
27	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	*
28	REKRI	☐	REKRI	XFELD	CHAR	1	0	Indicator: BOM is Recursive
29	REKRS	☐	REKRS	XFELD	CHAR	1	0	Indicator: Recursiveness Allowed
30	KZDUM	☐	CS_KZDUM	XFELD	CHAR	1	0	Indicator: phantom assembly off
31	KZMFG	☐	CS_KZMFG	XFELD	CHAR	1	0	Indicator: switch off direct production/direct procurement
32	KZVPL	☐	CS_KZVPL	XFELD	CHAR	1	0	Indicator: switch off planning
33	KZLFP	☐	CS_KZLFP	XFELD	CHAR	1	0	Indicator: switch off long-term planning
34	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
35	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
36	KNOBJ	☐	KNOBJ	KNOBJ	NUMC	18	0	Number of Object with Assigned Dependencies
37	KLPOS	☐	KLPOS	XFELD	CHAR	1	0	Indicator: class item
38	KZCLB	☐	CS_KZCLB	XFELD	CHAR	1	0	Indicator: Classification as Selection Condition
39	KLART	☐	KLASSENART	KLASSENART	CHAR	3	0	Class Type	*
40	KFKLA	☐	KLASSE_D	KLASSE	CHAR	18	0	Class number
41	CLSZU	☐	CS_CLSZU	NUM8	NUMC	8	0	Classification Number
42	ROMNG	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
43	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	*
44	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
45	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
46	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
47	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
48	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	*
49	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
50	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	*
51	NFPKZ	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
52	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
53	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
54	STLTX	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	*
55	STTX1	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
56	STTX2	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
57	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
58	LIFZT	☐	LIFZT	DEC3	DEC	3	0	Delivery Time in Days
59	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
60	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
61	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
62	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
63	VERTI	☐	SA_VERTI	SA_VERTL	CHAR	4	0	Distribution key for component consumption	*
64	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
65	SAKTO	☐	SAKTO	SAKNR	CHAR	10	0	Cost Element	*
66	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
67	STVKN	☐	STVKN	KNTNR	NUMC	8	0	Inherited Node Number of BOM Item
68	STKNR	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
69	TXPOS	☐	TXPOS	XFELD	CHAR	1	0	Indicator: text item
70	RTPOS	☐	RTPOS	XFELD	CHAR	1	0	Indicator: variable-size item
71	INPOS	☐	INPOS	XFELD	CHAR	1	0	Indicator: intra material
72	KZKUP	☐	KZKUP	XFELD	CHAR	1	0	Indicator: Co-Product
73	KZBSF	☐	KZBSF	XFELD	CHAR	1	0	Inventory management indicator
74	MTMTA	☐	MTART	MTART	CHAR	4	0	Material type	*
75	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
76	MTWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
77	MTLME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
78	MTAME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	*
79	MTURZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
80	MTURN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
81	MTDIM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	*
82	MTMIS	☐	MISKZ	MISKZ	CHAR	1	0	Mixed MRP indicator
83	MTDVF	☐	DISVF	DISVF	CHAR	1	0	MRP procedure
84	MTDST	☐	DISST	DISST	CHAR	3	0	Low-level code
85	MTBES	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
86	MTSOB	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	*
87	MTCHA	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
88	MTSEK	☐	SBDKZ	SBDKZ	CHAR	1	0	Dependent requirements ind. for individual and coll. reqmts
89	MTALT	☐	ALTSL	ALTSL	CHAR	1	0	Method for Selecting Alternative Bills of Material
90	MTAUS	☐	AUSSS	DEC3_2	DEC	5	2	Assembly scrap in percent
91	MTKFM	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
92	MTREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
93	MTDZT	☐	DZEIT	DEC3	DEC	3	0	In-house production time
94	MTPZT	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
95	MTWZT	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
96	MTBZT	☐	BEARZ	DEC3_2	DEC	5	2	Processing time
97	MTRZT	☐	RUEZT	DEC3_2	DEC	5	2	Setup and teardown time
98	MTTZT	☐	TRANZ	DEC3_2	DEC	5	2	Interoperation time
99	MTBMG	☐	BASMG	MENG13	QUAN	13	3	Base quantity
100	MTAKZ	☐	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
101	MTADT	☐	AUSDT	DATUM	DATS	8	0	Effective-out date
102	MTNMT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
103	MTLPR	☐	LGPRO	LGORT	CHAR	4	0	Issue storage location	*
104	MTEPR	☐	EPRIO	EPRIO	CHAR	4	0	Withdrawal sequence group for stocks	*
105	MTSGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
106	MTMNG	☐	MENGU	XFELD	CHAR	1	0	Quantity Updating in Material Master Record
107	MTWRT	☐	WERTU	XFELD	CHAR	1	0	Value Updating in Material Master Record
108	MTPIO	☐	KZPIP	XFELD	CHAR	1	0	Pipeline Handling Mandatory
109	MTPIZ	☐	XPIZU	XFELD	CHAR	1	0	Pipeline handling allowed
110	MTRCD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
111	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	*
112	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
113	KZBED	☐	KZBED	KZBED	CHAR	1	0	Indicator for Requirements Grouping
114	DSPST	☐	CS_DISPO	CS_DISPO	CHAR	2	0	Explosion Types	*
115	MTPVB	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	*
116	APOKZ	☐	APOKZ	APOKZ	CHAR	1	0	Indicator: Is material relevant for APO
117	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
118	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	*
119	ITSOB	☐	CS_SOBSL	SOBSL	CHAR	2	0	Special procurement type for BOM item	*

History

Last changed by/on	SAP	20130529
SAP Release Created in