SAP ABAP Table PPH_MRP_BOM_COMPARE_MDSB (MRP Bom Xplosion Attribute Structure)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-MRP (Application Component) Material Requirements Planning
     ⤷ PPH_SUPPORT (Package) PP on HANA: Test Entities

Basic Data

Table Category	INTTAB	Structure
Structure	PPH_MRP_BOM_COMPARE_MDSB	Table Relationship Diagram
Short Description	MRP Bom Xplosion Attribute Structure

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	PLAF_MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	PLWRK	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
3	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
4	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
5	.INCLUDE	☐				0	0	Generated Table for View
6	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
7	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
8	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
9	RSART	☐	RSART	RSART	CHAR	1	0	Record type
10	AUFST	☐	AUFST	AUFST	NUMC	2	0	Order level
11	AUFWG	☐	AUFWG	AUFWG	NUMC	2	0	Order path
12	POSNR	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
13	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
14	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
16	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
17	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	*
18	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
19	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
20	XLOEK	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
21	NODSP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
22	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
23	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
24	TXTPS	☐	TXTPS	XFELD	CHAR	1	0	Item text indicator
25	INPOS	☐	INPOS	XFELD	CHAR	1	0	Indicator: intra material
26	DUMPS	☐	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
27	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
28	CLAKZ	☐	CLAKZ	XFELD	CHAR	1	0	Indicator: classification exists
29	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
30	SANKA	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	TCK08
31	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
32	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
33	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
34	ESMNG	☐	ESMNG	ESMNG	FLTP	16	16	Usage quantity per order unit of measure
35	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
36	BEIKZ	☐	BEIKZ	BEIKZ	CHAR	1	0	Material Provision Indicators	T417
37	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	T413
38	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
39	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
40	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
41	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
42	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
43	ALPOS	☐	ALTPS	XFELD	CHAR	1	0	Alternative item indicator
44	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
45	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
46	ALPRF	☐	CS_ALPRF	NUM2	NUMC	2	0	Alternative Item: Ranking Order
47	ALPST	☐	CS_ALPST	CS_ALPST	CHAR	1	0	Alternative Item: Strategy
48	AUSCH	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
49	AVOAU	☐	AVOAU	DEC3_2	DEC	5	2	Operation Scrap
50	NETAU	☐	NETAU	XFELD	CHAR	1	0	Indicator: Net Scrap
51	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
52	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
53	VERTI	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
54	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
55	BDZTP	☐	BDZTP	BDZTP	TIMS	6	0	Time that reservation quantity required
56	ROHPS	☐	ROHPS	XFELD	CHAR	1	0	Variable-sized item indicator
57	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
58	ROMEN	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
59	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	T006
60	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
61	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
62	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
63	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	T418F
64	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
65	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
66	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
67	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
68	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
69	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
70	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
71	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
72	KZAUS	☐	AUSLF	AUSLF	CHAR	1	0	Discontinuation type
73	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
74	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
75	NFPKZ	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
76	NAFKZ	☐	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
77	NOMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
78	NFUML	☐	NFUML	NFUML	DEC	5	4	NOT USED: Quantity transfer factor for follow-up material
79	NOMAT	☐	NOMAT	MATNR	CHAR	18	0	Follow-Up/Original Material	MARA
80	LTXSP	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	T002
81	POTX1	☐	POTX1	TEXT40	CHAR	40	0	BOM Item Text (Line 1)
82	POTX2	☐	POTX2	TEXT40	CHAR	40	0	BOM Item Text (Line 2)
83	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
84	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
85	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
86	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
87	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
88	EBELE	☐	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	EKET
89	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	MARA
90	BAUST	☐	BAUST	AUFST	NUMC	2	0	Assembly order level
91	BAUWG	☐	BAUWG	AUFWG	NUMC	2	0	Assembly order path
92	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
93	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
94	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
95	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
96	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
97	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
98	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
99	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
100	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
101	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
102	KZKUP	☐	KZKUP	XFELD	CHAR	1	0	Indicator: Co-Product
103	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
104	STVKN	☐	STVKN	KNTNR	NUMC	8	0	Inherited Node Number of BOM Item
105	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
106	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
107	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
108	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
109	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
110	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
111	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
112	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	T006
113	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
114	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PPH_MRP_BOM_COMPARE_MDSB	AENNR	AENR	AENNR	REF	C	CN
2	PPH_MRP_BOM_COMPARE_MDSB	BAUGR	MARA	MATNR	REF	C	CN
3	PPH_MRP_BOM_COMPARE_MDSB	BEIKZ	T417	BEIKZ	REF	C	CN
4	PPH_MRP_BOM_COMPARE_MDSB	BNFPO	EBAN	BNFPO	REF	C	CN
5	PPH_MRP_BOM_COMPARE_MDSB	CHARG	MCHA	CHARG	REF	C	CN
6	PPH_MRP_BOM_COMPARE_MDSB	EBELE	EKET	ETENR	KEY	1	CN
7	PPH_MRP_BOM_COMPARE_MDSB	EBELN	EKKO	EBELN	KEY	1	CN
8	PPH_MRP_BOM_COMPARE_MDSB	EBELP	EKPO	EBELP	KEY	1	CN
9	PPH_MRP_BOM_COMPARE_MDSB	ERFME	T006	MSEHI	REF	C	CN
10	PPH_MRP_BOM_COMPARE_MDSB	ERSKZ	T413	ERSKZ	REF	C	CN
11	PPH_MRP_BOM_COMPARE_MDSB	KDAUF	VBUK	VBELN	REF	C	CN
12	PPH_MRP_BOM_COMPARE_MDSB	KNTTP	T163K	KNTTP	KEY	1	CN
13	PPH_MRP_BOM_COMPARE_MDSB	LGORT	T001L	LGORT	REF	C	CN
14	PPH_MRP_BOM_COMPARE_MDSB	LIFNR	LFA1	LIFNR	REF	C	CN
15	PPH_MRP_BOM_COMPARE_MDSB	LTXSP	T002	SPRAS	REF	C	CN
16	PPH_MRP_BOM_COMPARE_MDSB	MANDT	T000	MANDT	KEY	1	CN
17	PPH_MRP_BOM_COMPARE_MDSB	MATNR	MARA	MATNR	REF	1	CN
18	PPH_MRP_BOM_COMPARE_MDSB	MEINS	T006	MSEHI	REF	1	CN
19	PPH_MRP_BOM_COMPARE_MDSB	NLFMV	T006	MSEHI		1	N
20	PPH_MRP_BOM_COMPARE_MDSB	NOMAT	MARA	MATNR	REF	C	CN
21	PPH_MRP_BOM_COMPARE_MDSB	PLNUM	PLAF	PLNUM	REF	C	CN
22	PPH_MRP_BOM_COMPARE_MDSB	POSTP	T418	POSTP	REF	C	CN
23	PPH_MRP_BOM_COMPARE_MDSB	RFORM	T418F	RFORM	REF	C	CN
24	PPH_MRP_BOM_COMPARE_MDSB	ROMEI	T006	MSEHI	REF	C	CN
25	PPH_MRP_BOM_COMPARE_MDSB	SANKA	TCK08	SELKZ	KEY	1	CN
26	PPH_MRP_BOM_COMPARE_MDSB	SERNR	SNUM	SERNR		C	CN
27	PPH_MRP_BOM_COMPARE_MDSB	SOBKZ	T148	SOBKZ	REF	C	CN
28	PPH_MRP_BOM_COMPARE_MDSB	VERTI	T437V	VERTL	REF	C	CN
29	PPH_MRP_BOM_COMPARE_MDSB	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in