SAP ABAP Table MDSM (Simulative dependent requirements)

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	MDSM	Table Relationship Diagram
Short Description	Simulative dependent requirements

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	T000
2	SBNUM	☑	SBNUM	SBNUM	NUMC	10	0	Simulation requirements number
3	SBPOS	☑	SBPOS	RSPOS	NUMC	4	0	Simulation requirements item number
4	SBART	☑	RSART	RSART	CHAR	1	0	Record type
5	AUFST	☐	AUFST	AUFST	NUMC	2	0	Order level
6	AUFWG	☐	AUFWG	AUFWG	NUMC	2	0	Order path
7	POSNR	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
8	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
9	PLSCN	☐	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	PLSC
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
13	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	PVBE
14	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
15	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
16	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
17	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
18	TXTPS	☐	TXTPS	XFELD	CHAR	1	0	Item text indicator
19	INPOS	☐	INPOS	XFELD	CHAR	1	0	Indicator: intra material
20	DUMPS	☐	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
21	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
22	NODSP	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
23	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
24	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
25	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
26	ESMNG	☐	ESMNG	ESMNG	FLTP	16	16	Usage quantity per order unit of measure
27	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
28	BEIKZ	☐	BEIKZ	BEIKZ	CHAR	1	0	Material Provision Indicators	T417
29	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	T413
30	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
31	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
32	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
33	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
34	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
35	ALPOS	☐	ALTPS	XFELD	CHAR	1	0	Alternative item indicator
36	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
37	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
38	ALPRF	☐	CS_ALPRF	NUM2	NUMC	2	0	Alternative Item: Ranking Order
39	ALPST	☐	CS_ALPST	CS_ALPST	CHAR	1	0	Alternative Item: Strategy
40	AUSCH	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
41	AVOAU	☐	AVOAU	DEC3_2	DEC	5	2	Operation Scrap
42	NETAU	☐	NETAU	XFELD	CHAR	1	0	Indicator: Net Scrap
43	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
44	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
45	VERTI	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	*
46	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
47	BDZTP	☐	BDZTP	BDZTP	TIMS	6	0	Time that reservation quantity required
48	ROHPS	☐	ROHPS	XFELD	CHAR	1	0	Variable-sized item indicator
49	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
50	ROMEN	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
51	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	T006
52	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
53	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
54	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
55	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	T418F
56	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
57	NFPKZ	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
58	KZAUS	☐	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
59	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
60	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
61	NAFKZ	☐	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
62	NOMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
63	NOMAT	☐	NOMAT	MATNR	CHAR	18	0	Follow-Up/Original Material	*
64	NFUML	☐	NFUML	NFUML	DEC	5	4	NOT USED: Quantity transfer factor for follow-up material
65	LTXSP	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	T002
66	POTX1	☐	POTX1	TEXT40	CHAR	40	0	BOM Item Text (Line 1)
67	POTX2	☐	POTX2	TEXT40	CHAR	40	0	BOM Item Text (Line 2)
68	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
69	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	MARA
70	BAUST	☐	BAUST	AUFST	NUMC	2	0	Assembly order level
71	BAUWG	☐	BAUWG	AUFWG	NUMC	2	0	Assembly order path
72	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
73	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
74	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
75	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
76	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
77	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
78	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
79	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
80	FLGAT	☐	FOLGENART	FLGAT	CHAR	1	0	Sequence category	TCA07
81	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
82	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
83	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
84	STVKN	☐	STVKN	KNTNR	NUMC	8	0	Inherited Node Number of BOM Item
85	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
86	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
87	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
88	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
89	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
90	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
91	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
92	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
93	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
94	CLAKZ	☐	CLAKZ	XFELD	CHAR	1	0	Indicator: classification exists
95	SANKA	☐	SANKA	KAREL	CHAR	1	0	Indicator: item relevant to costing
96	KZKUP	☐	KZKUP	XFELD	CHAR	1	0	Indicator: Co-Product
97	STLAL	☐	STLAL	ALTNR	CHAR	2	0	Alternative BOM
98	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
99	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
100	EDGNO	☐	EDGNO	EDGNO	NUMC	17	0	Internal number for edge of object dependencies tree	M60I
101	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
102	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	*
103	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDSM	AENNR	AENR	AENNR	REF	C	CN
2	MDSM	BAUGR	MARA	MATNR	REF	C	CN
3	MDSM	BEIKZ	T417	BEIKZ	REF	C	CN
4	MDSM	EDGNO	M60I	EDGNO
5	MDSM	ERFME	T006	MSEHI	REF	C	CN
6	MDSM	ERSKZ	T413	ERSKZ	REF	C	CN
7	MDSM	FLGAT	TCA07	FLGAT	REF	C	CN
8	MDSM	KDAUF	VBUK	VBELN	REF	C	CN
9	MDSM	KNTTP	T163K	KNTTP	KEY	1	CN
10	MDSM	LGORT	T001L	LGORT	REF	C	CN
11	MDSM	LIFNR	LFA1	LIFNR	REF	1	CN
12	MDSM	LTXSP	T002	SPRAS	REF	C	CN
13	MDSM	MANDT	T000	MANDT	KEY	1	CN
14	MDSM	MATNR	MARA	MATNR	REF	C	CN
15	MDSM	MEINS	T006	MSEHI	REF	C	CN
16	MDSM	OBJNR	ONR00	OBJNR	REF	C	CN
17	MDSM	PLNUM	PLAF	PLNUM	REF	C	CN
18	MDSM	PLSCN	PLSC	PLSCN	KEY	1	CN
19	MDSM	POSTP	T418	POSTP		C	CN
20	MDSM	PRVBE	PVBE	PRVBE	REF	C	CN
21	MDSM	PSPEL	PRPS	PSPNR	KEY	1	CN
22	MDSM	RFORM	T418F	RFORM	REF	C	CN
23	MDSM	ROMEI	T006	MSEHI		C	CN
24	MDSM	SOBKZ	T148	SOBKZ	REF	C	CN
25	MDSM	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in