SAP ABAP Table /ISDFPS/S_BI_MARA (Provider Structure for Material Master Data from MARA)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS (Application Component) Defense Forces and Public Security
     ⤷ /ISDFPS/BI_CONTENT (Package) BI Content Defense (Extractors And So On)

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/S_BI_MARA	Table Relationship Diagram
Short Description	Provider Structure for Material Master Data from MARA

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	Provider Structure for Material Master Data from MARA
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
4	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
7	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	VPSTA	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
9	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
10	LVORM	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
11	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
12	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	*
13	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
14	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
15	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
16	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
17	ZEINR	☐	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
18	ZEIAR	☐	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
19	ZEIVR	☐	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
20	ZEIFO	☐	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
21	AESZN	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
22	BLATT	☐	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
23	BLANZ	☐	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
24	FERTH	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
25	FORMT	☐	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
26	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
27	WRKST	☐	WRKST	WRKST	CHAR	48	0	Basic Material	*
28	NORMT	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
29	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	*
30	EKWSL	☐	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	*
31	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
32	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
33	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
34	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
35	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
36	BEHVO	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	*
37	RAUBE	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	*
38	TEMPB	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	*
39	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
40	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	*
41	STOFF	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	*
42	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
43	KUNNR	☐	WETTB	KUNNR	CHAR	10	0	Competitor	*
44	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
45	WESCH	☐	WESCH	MENG13	QUAN	13	3	Quantity: Number of GR/GI slips to be printed
46	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	*
47	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
48	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	*
49	ETIAR	☐	ETIAR	ETIAR	CHAR	2	0	Label type	*
50	ETIFO	☐	ETIFO	ETIFO	CHAR	2	0	Label form	*
51	ENTAR	☐	ENTAR	ENTAR	CHAR	1	0	Disposal type	*
52	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
53	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	*
54	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
55	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
56	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
57	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	*
58	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
59	AEKLK	☐	CK_AEKLK	XFELD	CHAR	1	0	Stock transfer net change costing
60	CADKZ	☐	CADKZ	XFELD	CHAR	1	0	CAD Indicator
61	QMPUR	☐	QMPUR	XFELD	CHAR	1	0	QM in procurement is active
62	ERGEW	☐	ERGEW	MENG13	QUAN	13	3	Allowed packaging weight
63	ERGEI	☐	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	*
64	ERVOL	☐	ERVOL	MENG13	QUAN	13	3	Allowed packaging volume
65	ERVOE	☐	ERVOE	MEINS	UNIT	3	0	Volume unit (allowed packaging volume)	*
66	GEWTO	☐	GEWTO	PRZ21	DEC	3	1	Excess weight tolerance for shipping unit
67	VOLTO	☐	VOLTO	PRZ21	DEC	3	1	Excess volume tolerance limit during packing
68	VABME	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
69	KZREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
70	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
71	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
72	VHART	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	*
73	FUELG	☐	FUELG	DEC3	DEC	3	0	Filling level (by volume)
74	STFAK	☐	STFAK	INT2	INT2	5	0	Stacking factor
75	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	*
76	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
77	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
78	LIQDT	☐	LIQDT	DATUM	DATS	8	0	Deletion date
79	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
80	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	*
81	MLGUT	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
82	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	*
83	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
84	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
85	KZKUP	☐	KZKUPMAT	FLAG	CHAR	1	0	Indicator: Material can be co-product
86	KZNFM	☐	KZNFM	XFELD	CHAR	1	0	Indicator: The material has a follow-up material
87	PMATA	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
88	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	*
89	MSTAV	☐	MSTAV	VMSTA	CHAR	2	0	Cross-distribution-chain material status	*
90	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
91	MSTDV	☐	MSTDV	DATUM	DATS	8	0	Date from which the X-distr.-chain material status is valid
92	TAKLV	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	*
93	RBNRM	☐	RBNR	RBNR	CHAR	9	0	Report layout	*
94	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
95	MHDHB	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
96	MHDLP	☐	MHDLP	DEC3	DEC	3	0	Storage percentage
97	INHME	☐	INHME	MEINS	UNIT	3	0	Content unit	*
98	INHAL	☐	INHAL	MENG13	QUAN	13	3	Net contents
99	VPREH	☐	VPREH	PACK3	DEC	5	0	Comparison price unit
100	ETIAG	☐	ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	*
101	INHBR	☐	INHBR	MENG13	QUAN	13	3	Gross contents
102	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
103	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
104	KZUMW	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
105	KOSCH	☐	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	*
106	SPROF	☐	SPROF	SPROF	CHAR	1	0	Pricing profile for variants
107	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
108	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
109	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
110	BMATN	☐	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	*
111	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
112	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
113	SAITY	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	*
114	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	*
115	IHIVI	☐	ADGE_IHIVI	X	CHAR	1	0	Indicator: Highly viscous
116	ILOOS	☐	ADGE_ILOOS	X	CHAR	1	0	Indicator: In bulk/liquid
117	SERLV	☐	SERLV	SERLV	CHAR	1	0	Level of Explicitness for Serial Number
118	KZGVH	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
119	XGCHP	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
120	KZEFF	☐	CC_MTEFF	XFELD	CHAR	1	0	Assign effectivity parameter values/ override change numbers
121	COMPL	☐	CSCP_COMP_LVL	CSCP_COMP_LVL	NUMC	2	0	Material completion level	*
122	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
123	RDMHD	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
124	PRZUS	☐	PRZUS	XFELD	CHAR	1	0	Indicator: Product composition printed on packaging
125	MTPOS_MARA	☐	MTPOS_MARA	MTPOS	CHAR	4	0	General item category group	*
126	BFLME	☐	BFLME	BFLME	CHAR	1	0	Generic Material with Logistical Variants
127	.INCLU--AP	☐				0	0	Append MARA-NSNID
128	NSNID	☐	DFPS_NSNID	DFPS_NSNID	CHAR	9	0	NATO Stock Number
129	.INCLU--AP	☐				0	0	Vendor Structure Enhancement: Fashion Fields for Mat. Master
130	.INCLUDE	☐				0	0	MARA Extension with New Fields: Seasonal Procurement
131	COLOR_ATINN	☐	WRF_COLOR_ATINN	ATINN	NUMC	10	0	Internal Charactieristic Number for Color Characteristics	*
132	SIZE1_ATINN	☐	WRF_SIZE1_ATINN	ATINN	NUMC	10	0	Internal Char. Number for Characteristics for Main Sizes	*
133	SIZE2_ATINN	☐	WRF_SIZE2_ATINN	ATINN	NUMC	10	0	Internal Char. Number for Characteristics for Second Sizes	*
134	COLOR	☐	WRF_COLOR	WRF_ATWRT	CHAR	18	0	Characteristic Value for Colors of Variants
135	SIZE1	☐	WRF_SIZE1	WRF_ATWRT	CHAR	18	0	Characteristic Value for Main Sizes of Variants
136	SIZE2	☐	WRF_SIZE2	WRF_ATWRT	CHAR	18	0	Characteristic Value for Second Size for Variants
137	FREE_CHAR	☐	WRF_FREE_CHAR	WRF_ATWRT	CHAR	18	0	Characteristic Value for Evaluation Purposes
138	CARE_CODE	☐	WRF_CARE_CODE	WRF_CARE_CODE	CHAR	16	0	Care Codes (such as Washing Code, Ironing Code, etc.)
139	BRAND_ID	☐	WRF_BRAND_ID	WRF_BRAND_ID	CHAR	4	0	Brand	WRF_BRANDS
140	FIBER_CODE1	☐	WRF_FIBER_CODE_1	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 1)	WRF_FIBER_CODES
141	FIBER_PART1	☐	WRF_FIBER_PART_1	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 1)
142	FIBER_CODE2	☐	WRF_FIBER_CODE_2	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 2)	WRF_FIBER_CODES
143	FIBER_PART2	☐	WRF_FIBER_PART_2	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 2)
144	FIBER_CODE3	☐	WRF_FIBER_CODE_3	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 3)	WRF_FIBER_CODES
145	FIBER_PART3	☐	WRF_FIBER_PART_3	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 3)
146	FIBER_CODE4	☐	WRF_FIBER_CODE_4	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 4)	WRF_FIBER_CODES
147	FIBER_PART4	☐	WRF_FIBER_PART_4	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 4)
148	FIBER_CODE5	☐	WRF_FIBER_CODE_5	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 5)	WRF_FIBER_CODES
149	FIBER_PART5	☐	WRF_FIBER_PART_5	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 5)
150	.INCLU--AP	☐				0	0	Degree of Fashion Extension
151	FASHGRD	☐	FASHGRD	FASHGRD	CHAR	4	0	Fashion Grade
152	MCOND	☐	/ISDFPS/MCOND	/ISDFPS/MCOND	CHAR	1	0	Material Condition Management
153	RETDELC	☐	/ISDFPS/RETDELC	/ISDFPS/RETDELC	CHAR	1	0	Return Code	*
154	LOGLEV_RETO	☐	/ISDFPS/LOGLEV_RETO	/ISDFPS/LOGLEV	CHAR	1	0	Return to Logistics Level	*
155	RIC	☐	/ISDFPS/RICODE	/ISDFPS/RICODE	CHAR	6	0	Reportable Item Code	*
156	MPO_MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/S_BI_MARA	BRAND_ID	WRF_BRANDS	BRAND_ID
2	/ISDFPS/S_BI_MARA	FIBER_CODE1	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
3	/ISDFPS/S_BI_MARA	FIBER_CODE2	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
4	/ISDFPS/S_BI_MARA	FIBER_CODE3	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
5	/ISDFPS/S_BI_MARA	FIBER_CODE4	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
6	/ISDFPS/S_BI_MARA	FIBER_CODE5	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	470