SAP ABAP Table EMARA (Data Division MARA)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

Table Category	INTTAB	Structure
Structure	EMARA	Table Relationship Diagram
Short Description	Data Division 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	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
2	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
3	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
4	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
5	VPSTA	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
6	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
7	LVORM	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
8	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
9	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
10	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
11	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
12	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
13	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
14	ZEINR	☐	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
15	ZEIAR	☐	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
16	ZEIVR	☐	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
17	ZEIFO	☐	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
18	AESZN	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
19	BLATT	☐	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
20	BLANZ	☐	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
21	FERTH	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
22	FORMT	☐	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
23	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
24	WRKST	☐	WRKST	WRKST	CHAR	48	0	Basic Material	TWSPR
25	NORMT	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
26	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
27	EKWSL	☐	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	T405
28	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
29	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
30	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
31	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
32	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
33	BEHVO	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	T144
34	RAUBE	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	T142
35	TEMPB	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	T143
36	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
37	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
38	STOFF	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	MGEF
39	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
40	KUNNR	☐	WETTB	KUNNR	CHAR	10	0	Competitor	V_KNA1WETT
41	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
42	WESCH	☐	WESCH	MENG13	QUAN	13	3	Quantity: Number of GR/GI slips to be printed
43	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
44	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	TMBW1
45	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
46	ETIAR	☐	ETIAR	ETIAR	CHAR	2	0	Label type	T6WP3
47	ETIFO	☐	ETIFO	ETIFO	CHAR	2	0	Label form	T6WP4
48	ENTAR	☐	DUMMYENTAR	CHAR1	CHAR	1	0	Deactivated
49	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
50	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	TNTP
51	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
52	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
53	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
54	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
55	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
56	AEKLK	☐	CK_AEKLK	XFELD	CHAR	1	0	Stock transfer net change costing
57	CADKZ	☐	CADKZ	XFELD	CHAR	1	0	CAD Indicator
58	QMPUR	☐	QMPUR	XFELD	CHAR	1	0	QM in procurement is active
59	ERGEW	☐	ERGEW	MENG13	QUAN	13	3	Allowed packaging weight
60	ERGEI	☐	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	T006
61	ERVOL	☐	ERVOL	MENG13	QUAN	13	3	Allowed packaging volume
62	ERVOE	☐	ERVOE	MEINS	UNIT	3	0	Volume unit (allowed packaging volume)	T006
63	GEWTO	☐	GEWTO	PRZ21	DEC	3	1	Excess weight tolerance for shipping unit
64	VOLTO	☐	VOLTO	PRZ21	DEC	3	1	Excess volume tolerance limit during packing
65	VABME	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
66	KZREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
67	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
68	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
69	VHART	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
70	FUELG	☐	FUELG	DEC3	DEC	3	0	Filling level (by volume)
71	STFAK	☐	STFAK	INT2	INT2	5	0	Stacking factor
72	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
73	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
74	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
75	LIQDT	☐	LIQDT	DATUM	DATS	8	0	Deletion date
76	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
77	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
78	MLGUT	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
79	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	TWEW
80	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
81	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
82	KZKUP	☐	KZKUPMAT	FLAG	CHAR	1	0	Indicator: Material can be co-product
83	KZNFM	☐	KZNFM	XFELD	CHAR	1	0	Indicator: The material has a follow-up material
84	PMATA	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
85	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
86	MSTAV	☐	MSTAV	VMSTA	CHAR	2	0	Cross-distribution-chain material status	TVMS
87	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
88	MSTDV	☐	MSTDV	DATUM	DATS	8	0	Date from which the X-distr.-chain material status is valid
89	TAKLV	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	TSKM
90	RBNRM	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
91	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
92	MHDHB	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
93	MHDLP	☐	MHDLP	DEC3	DEC	3	0	Storage percentage
94	INHME	☐	INHME	MEINS	UNIT	3	0	Content unit	T006
95	INHAL	☐	INHAL	MENG13	QUAN	13	3	Net contents
96	VPREH	☐	VPREH	PACK3	DEC	5	0	Comparison price unit
97	ETIAG	☐	ETIAG	ETIAG	CHAR	18	0	IS-R Labeling: material grouping (deactivated in 4.0)	*
98	INHBR	☐	INHBR	MENG13	QUAN	13	3	Gross contents
99	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
100	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
101	KZUMW	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
102	KOSCH	☐	KOSCH	KOSCH	CHAR	18	0	Product allocation determination procedure	T190S
103	SPROF	☐	SPROF	SPROF	CHAR	1	0	Pricing profile for variants
104	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
105	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
106	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
107	BMATN	☐	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	MARA
108	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	TMPPF
109	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
110	SAITY	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	T6WSA
111	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	TDG41
112	IHIVI	☐	ADGE_IHIVI	X	CHAR	1	0	Indicator: Highly viscous
113	ILOOS	☐	ADGE_ILOOS	X	CHAR	1	0	Indicator: In bulk/liquid
114	SERLV	☐	SERLV	SERLV	CHAR	1	0	Level of Explicitness for Serial Number
115	KZGVH	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
116	XGCHP	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
117	KZEFF	☐	CC_MTEFF	XFELD	CHAR	1	0	Assign effectivity parameter values/ override change numbers
118	COMPL	☐	CSCP_COMP_LVL	CSCP_COMP_LVL	NUMC	2	0	Material completion level	TCSCP_COMP_LVL
119	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
120	RDMHD	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
121	PRZUS	☐	PRZUS	XFELD	CHAR	1	0	Indicator: Product composition printed on packaging
122	MTPOS_MARA	☐	MTPOS_MARA	MTPOS	CHAR	4	0	General item category group	TPTM
123	BFLME	☐	BFLME	BFLME	CHAR	1	0	Generic Material with Logistical Variants
124	MATFI	☐	MATFI	XFELD	CHAR	1	0	Material Is Locked
125	CMREL	☐	DE_CM_RELEVANCE_FLAG	DO_CM_RELEVANCE_FLAG	CHAR	1	0	Relevant for Configuration Management
126	BBTYP	☐	BBTYP	BBTYP	CHAR	1	0	Assortment List Type	*
127	SLED_BBD	☐	SLED_BBD	SLED_BBD	CHAR	1	0	Expiration Date
128	GTIN_VARIANT	☐	GTIN_VARIANT	GTIN_VARIANT	CHAR	2	0	Global Trade Item Number Variant
129	GENNR	☐	WSTR_SATNR_PP	MATNR	CHAR	18	0	Material Number of the Generic Material in Prepack Materials	MARA
130	RMATP	☐	PL_RMATP	MATNR	CHAR	18	0	Reference material for materials packed in same way	MARA
131	GDS_RELEVANT	☐	GDS_RELEVANT	XFELD	CHAR	1	0	Indicator: Global Data Synchronization-Relevant
132	WEORA	☐	WEORA	XFELD	CHAR	1	0	Acceptance At Origin
133	HUTYP_DFLT	☐	CIFHUTYPDF	CHAR4	CHAR	4	0	Standard HU Type	THUTYP
134	PILFERABLE	☐	CIFPILFRBL	XFELD	CHAR	1	0	Pilferable
135	WHSTC	☐	CIFWHSTC	CHAR2	CHAR	2	0	Warehouse Storage Condition	TWHSTC
136	WHMATGR	☐	CIFWHMATGR	CHAR4	CHAR	4	0	Warehouse Material Group	TWHMATGR
137	HNDLCODE	☐	CIFHDLCODE	CHAR4	CHAR	4	0	Handling Indicator	THNDLCD
138	HAZMAT	☐	CIFHAZMAT	XFELD	CHAR	1	0	Relevant for Hazardous Substances
139	HUTYP	☐	CIFHUTYP	CHAR4	CHAR	4	0	Handling Unit Type	THUTYP
140	TARE_VAR	☐	CIFTAREVAR	XFELD	CHAR	1	0	Variable Tare Weight
141	MAXC	☐	CIFMAXC	DECV15_3	DEC	15	3	Maximum Allowed Capacity of Packaging Material
142	MAXC_TOL	☐	CIFMAXCTOL	DEC2_1	DEC	3	1	Overcapacity Tolerance of the Handling Unit
143	MAXL	☐	CIFMAXL	CIFQUAN15	QUAN	15	3	Maximum Packing Length of Packaging Material
144	MAXB	☐	CIFMAXB	CIFQUAN15	QUAN	15	3	Maximum Packing Width of Packaging Material
145	MAXH	☐	CIFMAXH	CIFQUAN15	QUAN	15	3	Maximum Packing Height of Packaging Material
146	MAXDIM_UOM	☐	CIFMAXDUOM	MEINS	UNIT	3	0	Unit of Measure for Maximum Packing Length/Width/Height	T006
147	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
148	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
149	QQTIME	☐	CIFQQTIME		QUAN	3	0	Quarantine Period
150	QQTIMEUOM	☐	CIFQQTIMEUOM	MEINS	UNIT	3	0	Time Unit for Quarantine Period	T006
151	QGRP	☐	CIFQGRP	CIFQGRP	CHAR	4	0	Quality Inspection Group	TQGRP
152	SERIAL	☐	CIFSERIAL	CIFSERIAL	CHAR	4	0	Serial Number Profile	TSERIAL
153	PS_SMARTFORM	☐	CIFPSSFNAME	TDSFNAME	CHAR	30	0	Form Name	STXFADM
154	LOGUNIT	☐	CIFLOGUNIT	MEINS	UNIT	3	0	EWM CW: Logistics Unit of Measure	MARM
155	CWQREL	☐	CIFCWQREL	XFELD	CHAR	1	0	EWM CW: Material Is a Catch Weight Material
156	CWQPROC	☐	CIFCWQPROC	CIFCWQPROC	CHAR	2	0	EWM CW: Catch Weight Profile for Entering CW Quantity	TCWQPROC
157	CWQTOLGR	☐	CIFCWQTOLGR	CIFCWQTOLGR	CHAR	9	0	EWM-CW: Catch Weight Tolerance Group for EWM	TCWQTOLGR
158	ADPROF	☐	CIFADPROF	CIFADPROF	CHAR	3	0	Adjustment Profile	TAPROF
159	IPMIPPRODUCT	☐	CRM_PRODUCT_ID_IP	CRM_PRODUCT_ID	CHAR	40	0	ID for an Intellectual Property (CRM Product)
160	ALLOW_PMAT_IGNO	☐	WPM_ALLOW_PMAT_IGNO_MAT	XFELD	CHAR	1	0	Variant Price Allowed (for Material Master)
161	MEDIUM	☐	MEDIU	MEDIU	CHAR	6	0	Medium	T372M
162	COMMODITY	☐	TBA_STOEFFCHEN	TBA_STOEFFCHEN	CHAR	18	0	Physical Commodity	TBAC_PHYSCOMM
163	ANIMAL_ORIGIN	☐	WRF_ANIMAL_ORIGIN_FLAG	WRF_ANIMAL_ORIGIN_FLAG	CHAR	1	0	Indicator: Contains Non-Textile Parts of Animal Origin
164	TEXTILE_COMP_IND	☐	WRF_TEXTL_COMP_IND	WRF_TEXTL_COMP_IND	CHAR	1	0	Indicator: New Textile Composition Function
165	.INCLUDE	☐				0	0	Material Master Data - Brazil
166	ANP	☐	J_1BANP	J_1BANP	NUMC	9	0	ANP Code	J_1BTANP
167	.INCLU--AP	☐				0	0	Enhancement for EMARA Loading Units
168	.INCLUDE	☐				0	0	Include Basic Structure (2Field) for Appends
169	/BEV1/LULEINH	☐	/BEV1/LULEINH	/BEV1/LULEINH	NUMC	8	0	Loading Units
170	/BEV1/LULDEGRP	☐	/BEV1/LULDEGRP	/BEV1/LULDEGRP	CHAR	3	0	Loading Unit Group: IS Beverage	/BEV1/LUT906
171	.INCLU--AP	☐				0	0	Empties Management: Enhancement of EMARA
172	/BEV1/NESTRUCCAT	☐	/BEV1/NESTRUC_CAT	/BEV1/NESTRUC_CAT	CHAR	1	0	Structure Category for Material Relationship
173	.INCLU--AP	☐				0	0	DSD Append for Tolerance Types
174	.INCLUDE	☐				0	0	DSD Strucure for Tolerance Types
175	/DSD/SL_TOLTYP	☐	/DSD/SL_TOLTYP_ID	/DSD/SL_TOLTYP_ID	CHAR	4	0	Tolerance Type ID	/DSD/SL_TGTYP
176	.INCLU--AP	☐				0	0	DSD append for Counting Group
177	.INCLUDE	☐				0	0	DSD structure for Counting Group
178	/DSD/SV_CNT_GRP	☐	/DSD/SV_COUNT_GROUP	/DSD/SV_COUNT_GROUP	CHAR	10	0	Counting Group	/DSD/SV_CNTGR
179	.INCLU--AP	☐				0	0	Extension of Material Master for Visit Control (DSD)
180	.INCLUDE	☐				0	0	Extension of Material Master for Visit Control (DSD)
181	/DSD/VC_GROUP	☐	/DSD/VC_GROUP	/DSD/VC_GROUP	CHAR	6	0	DSD Grouping	/DSD/VC_GRP
182	.INCLU--AP	☐				0	0	EMARA Append for Vehicle Space Optimization
183	.INCLUDE	☐				0	0	Include for Append to MARA for Vehicle Space Optimization
184	/VSO/R_TILT_IND	☐	/VSO/M_TILT_IND	/VSO/M_XFIELD	CHAR	1	0	Material may be Tilted (Vehicle Space Optimization)
185	/VSO/R_STACK_IND	☐	/VSO/M_STACK_IND	/VSO/M_XFIELD	CHAR	1	0	Stacking not Allowed (VSO)
186	/VSO/R_BOT_IND	☐	/VSO/M_BOTTOM_IND	/VSO/M_XFIELD	CHAR	1	0	Bottom Layer (Vehicle Space Optimization)
187	/VSO/R_TOP_IND	☐	/VSO/M_TOP_IND	/VSO/M_XFIELD	CHAR	1	0	Top Layer (VSO)
188	/VSO/R_STACK_NO	☐	/VSO/M_STACK_NO	/VSO/M_STACK_NO	NUMC	3	0	Stacking Factor (Vehicle Space Optimization)
189	/VSO/R_PAL_IND	☐	/VSO/M_PALLET_IND	/VSO/M_XFIELD	CHAR	1	0	Load without Packaging Material (VSO)
190	/VSO/R_PAL_OVR_D	☐	/VSO/R_PAL_OVR_D	MENG13	QUAN	13	3	Permissible Overhang (Depth) of Packaging Material (VSO)
191	/VSO/R_PAL_OVR_W	☐	/VSO/R_PAL_OVR_W	MENG13	QUAN	13	3	Permissible Overhang (Width) of Shipping Material (VSO)
192	/VSO/R_PAL_B_HT	☐	/VSO/R_PAL_BIN_HGT	MENG13	QUAN	13	3	Maximum Stacking Height of the Packaging Material (VSO)
193	/VSO/R_PAL_MIN_H	☐	/VSO/R_PAL_MIN_HT	MENG13	QUAN	13	3	Minimum Stacking Height of the Packaging Material (VSO)
194	/VSO/R_TOL_B_HT	☐	/VSO/R_TOL_BIN_HT	MENG13	QUAN	13	3	Tolerance to Exceed the Max. Stacking Height (VSO)
195	/VSO/R_NO_P_GVH	☐	/VSO/M_ANZ_PER_GVH	/VSO/M_ANZ_PER_GVH	NUMC	2	0	Number of Materials for each Closed PKM (VSO)
196	/VSO/R_QUAN_UNIT	☐	/VSO/R_QUAN_UNIT	/VSO/R_QUAN_UNIT	UNIT	3	0	Unit of Measure Vehicle Space Optimization
197	/VSO/R_KZGVH_IND	☐	/VSO/M_KZGVH_IND	/VSO/M_XFIELD	CHAR	1	0	Closed Packaging Material Required (VSO)
198	.INCLU--AP	☐				0	0	Append for EHS on EMARA
199	.INCLUDE	☐				0	0	EHS-INT: Enhancement Fields MARA
200	PACKCODE	☐	CBUNE_PACODE	CBUND_PACOD	CHAR	10	0	Packaging Code	CCUNC121
201	DG_PACK_STATUS	☐	ADGE_DG_PACK_STATUS	CHAR10	CHAR	10	0	Dangerous Goods Packaging Status	TDG101
202	.INCLU--AP	☐				0	0	Extension of MARA by New DFPS Fields
203	.INCLUDE	☐				0	0	Extension of MARA by New DFPS Fields
204	MCOND	☐	DFPS_MCOND	DFPS_MCOND	CHAR	1	0	Material Condition Management
205	RETDELC	☐	DFPS_RETDELC	DFPS_RETDELC	CHAR	1	0	Return Code
206	LOGLEV_RETO	☐	DFPS_LOGLEV_RETO	DFPS_LOGLEV	CHAR	1	0	Return to Logistics Level
207	NSNID	☐	DFPS_NSNID	DFPS_NSNID	CHAR	9	0	NATO Stock Number
208	.INCLU--AP	☐				0	0	PIC: Additional Fields for Parts Interchangeability
209	.INCLUDE	☐				0	0	PIC Additional Fields for Parts Interchangeability
210	IMATN	☐	IMATN	MATNR	CHAR	18	0	FFF class	*
211	PICNUM	☐	PIC_PICNUM_SUS	PIC_PICNUM	CHAR	18	0	Supersession chain number
212	.INCLU--AP	☐				0	0	Creation Status - Seasonal Procurement
213	BSTAT	☐	WRFBSTAT	WRFBSTAT	CHAR	2	0	Creation Status - Seasonal Procurement	WRFMATBSTAT
214	.INCLU--AP	☐				0	0	MARA Extension with New Fashion Fields: Seasonal Procurement
215	.INCLUDE	☐				0	0	MARA Extension with New Fields: Seasonal Procurement
216	COLOR_ATINN	☐	WRF_COLOR_ATINN	ATINN	NUMC	10	0	Internal Charactieristic Number for Color Characteristics	*
217	SIZE1_ATINN	☐	WRF_SIZE1_ATINN	ATINN	NUMC	10	0	Internal Char. Number for Characteristics for Main Sizes	*
218	SIZE2_ATINN	☐	WRF_SIZE2_ATINN	ATINN	NUMC	10	0	Internal Char. Number for Characteristics for Second Sizes	*
219	COLOR	☐	WRF_COLOR	WRF_ATWRT	CHAR	18	0	Characteristic Value for Colors of Variants
220	SIZE1	☐	WRF_SIZE1	WRF_ATWRT	CHAR	18	0	Characteristic Value for Main Sizes of Variants
221	SIZE2	☐	WRF_SIZE2	WRF_ATWRT	CHAR	18	0	Characteristic Value for Second Size for Variants
222	FREE_CHAR	☐	WRF_FREE_CHAR	WRF_ATWRT	CHAR	18	0	Characteristic Value for Evaluation Purposes
223	CARE_CODE	☐	WRF_CARE_CODE	WRF_CARE_CODE	CHAR	16	0	Care Codes (such as Washing Code, Ironing Code, etc.)
224	BRAND_ID	☐	WRF_BRAND_ID	WRF_BRAND_ID	CHAR	4	0	Brand	WRF_BRANDS
225	FIBER_CODE1	☐	WRF_FIBER_CODE_1	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 1)	WRF_FIBER_CODES
226	FIBER_PART1	☐	WRF_FIBER_PART_1	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 1)
227	FIBER_CODE2	☐	WRF_FIBER_CODE_2	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 2)	WRF_FIBER_CODES
228	FIBER_PART2	☐	WRF_FIBER_PART_2	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 2)
229	FIBER_CODE3	☐	WRF_FIBER_CODE_3	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 3)	WRF_FIBER_CODES
230	FIBER_PART3	☐	WRF_FIBER_PART_3	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 3)
231	FIBER_CODE4	☐	WRF_FIBER_CODE_4	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 4)	WRF_FIBER_CODES
232	FIBER_PART4	☐	WRF_FIBER_PART_4	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 4)
233	FIBER_CODE5	☐	WRF_FIBER_CODE_5	WRF_FIBER_CODE	CHAR	3	0	Fiber Code for Textiles (Component 5)	WRF_FIBER_CODES
234	FIBER_PART5	☐	WRF_FIBER_PART_5	WRF_FIBER_PART	NUMC	3	0	Percentage Share of Fiber (Component 5)
235	.INCLU--AP	☐				0	0	Slowseller Management: Degree of Fashion
236	FASHGRD	☐	FASHGRD	FASHGRD	CHAR	4	0	Fashion Grade	T6WFG

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EMARA	/BEV1/LULDEGRP	/BEV1/LUT906	/BEV1/LULDEGRP
2	EMARA	/DSD/SL_TOLTYP	/DSD/SL_TGTYP	TOLTYP_ID	KEY	1	CN
3	EMARA	/DSD/SV_CNT_GRP	/DSD/SV_CNTGR	COUNT_GROUP	KEY
4	EMARA	/DSD/VC_GROUP	/DSD/VC_GRP	GRP	KEY	1	CN
5	EMARA	ADPROF	TAPROF	ADPROF
6	EMARA	ANP	J_1BTANP	J_1BANP	KEY
7	EMARA	BEHVO	T144	BEHVO
8	EMARA	BMATN	MARA	MATNR
9	EMARA	BRAND_ID	WRF_BRANDS	BRAND_ID
10	EMARA	BSTAT	WRFMATBSTAT	BSTAT
11	EMARA	BSTME	T006	MSEHI
12	EMARA	BWSCL	TMBW1	BWSCL	REF	1	CN
13	EMARA	BWVOR	T6WP1	BWVOR	REF
14	EMARA	COMMODITY	TBAC_PHYSCOMM	COMMODITY	REF
15	EMARA	COMPL	TCSCP_COMP_LVL	COMP_LEVEL
16	EMARA	CWQPROC	TCWQPROC	CWQPROC	KEY	1	N
17	EMARA	CWQTOLGR	TCWQTOLGR	CWQTOLGR	KEY	1	N
18	EMARA	DG_PACK_STATUS	TDG101	DG_PACK_STATUS		1	CN
19	EMARA	EKWSL	T405	EKWSL
20	EMARA	ERGEI	T006	MSEHI
21	EMARA	ERVOE	T006	MSEHI
22	EMARA	ETIAR	T6WP3	ETIAR
23	EMARA	ETIFO	T6WP4	ETIFO
24	EMARA	EXTWG	TWEW	EXTWG
25	EMARA	FASHGRD	T6WFG	FASHGRD
26	EMARA	FIBER_CODE1	WRF_FIBER_CODES	FIBER_CODE
27	EMARA	FIBER_CODE2	WRF_FIBER_CODES	FIBER_CODE
28	EMARA	FIBER_CODE3	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
29	EMARA	FIBER_CODE4	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
30	EMARA	FIBER_CODE5	WRF_FIBER_CODES	FIBER_CODE	KEY	1	CN
31	EMARA	GENNR	MARA	MATNR
32	EMARA	GEWEI	T006	MSEHI
33	EMARA	HERKL	T005	LAND1	REF
34	EMARA	HNDLCODE	THNDLCD	HNDLCODE	REF
35	EMARA	HUTYP	THUTYP	HUTYP	REF
36	EMARA	HUTYP_DFLT	THUTYP	HUTYP
37	EMARA	INHME	T006	MSEHI
38	EMARA	KOSCH	T190S	KOSCH
39	EMARA	KUNNR	V_KNA1WETT	KUNNR
40	EMARA	LABOR	T024L	LABOR
41	EMARA	LOGUNIT	MARM	MEINH	KEY	1	N
42	EMARA	MAGRV	TVEGR	MAGRV
43	EMARA	MATKL	T023	MATKL
44	EMARA	MAXDIM_UOM	T006	MSEHI	REF
45	EMARA	MBRSH	T137	MBRSH
46	EMARA	MEABM	T006	MSEHI
47	EMARA	MEDIUM	T372M	MEDIU
48	EMARA	MEINS	T006	MSEHI
49	EMARA	MFRGR	TMFG	MFRGR	REF
50	EMARA	MFRNR	LFA1	LIFNR
51	EMARA	MPROF	TMPPF	MPROF
52	EMARA	MSTAE	T141	MMSTA
53	EMARA	MSTAV	TVMS	VMSTA
54	EMARA	MTART	T134	MTART
55	EMARA	MTPOS_MARA	TPTM	MTPOS
56	EMARA	NUMTP	TNTP	NUMTP
57	EMARA	PACKCODE	CCUNC121	PACKCODE		1	CN
58	EMARA	PLGTP	TWPT	PLGTP
59	EMARA	PMATA	MARA	MATNR
60	EMARA	PRDHA	T179	PRODH
61	EMARA	PROFL	TDG41	PROFL
62	EMARA	PS_SMARTFORM	STXFADM	FORMNAME	REF
63	EMARA	QGRP	TQGRP	QGRP	REF
64	EMARA	QQTIMEUOM	T006	MSEHI	REF
65	EMARA	RAUBE	T142	RAUBE
66	EMARA	RBNRM	T352B	RBNR
67	EMARA	RMATP	MARA	MATNR
68	EMARA	SAISO	T6WSP	SAISO
69	EMARA	SAITY	T6WSA	SAITY
70	EMARA	SATNR	MARA	MATNR
71	EMARA	SERIAL	TSERIAL	SERIAL	REF
72	EMARA	SPART	TSPA	SPART
73	EMARA	STOFF	MGEF	STOFF
74	EMARA	TAKLV	TSKM	TAXKM
75	EMARA	TEMPB	T143	TEMPB
76	EMARA	TRAGR	TTGR	TRAGR
77	EMARA	VHART	TVTY	TRATY
78	EMARA	VOLEH	T006	MSEHI
79	EMARA	WHMATGR	TWHMATGR	WHMATGR	REF
80	EMARA	WHSTC	TWHSTC	WHSTC	REF
81	EMARA	WRKST	TWSPR	WRKST

History

Last changed by/on	SAP	20140121
SAP Release Created in