SAP table EMARA (Data Division MARA)

Field Description Data Type Length Decimals Checktable Data Element
ERSDA Created On DATS 8 0 ERSDA
CREATED_AT_TIME Time of Creation TIMS 6 0 CREATED_AT_TIME
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
LAEDA Date of Last Change DATS 8 0 LAEDA
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
VPSTA Maintenance status of complete material CHAR 15 0 VPSTA
PSTAT Maintenance status CHAR 15 0 PSTAT_D
LVORM Flag Material for Deletion at Client Level CHAR 1 0 LVOMA
MTART Material type CHAR 4 0 T134 MTART
MBRSH Industry Sector CHAR 1 0 T137 MBRSH
MATKL Material Group CHAR 9 0 T023 MATKL
BISMT Old material number CHAR 40 0 BISMT
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
BSTME Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
ZEINR Document number (without document management system) CHAR 22 0 DZEINR
ZEIAR Document type (without Document Management system) CHAR 3 0 DZEIAR
ZEIVR Document version (without Document Management system) CHAR 2 0 DZEIVR
ZEIFO Page format of document (without Document Management system) CHAR 4 0 DZEIFO
AESZN Document change number (without document management system) CHAR 6 0 AESZN
BLATT Page number of document (without Document Management system) CHAR 3 0 BLATT
BLANZ Number of sheets (without Document Management system) NUMC 3 0 BLANZ
FERTH Production/inspection memo CHAR 18 0 FERTH
FORMT Page Format of Production Memo CHAR 4 0 FORMT
GROES Size/dimensions CHAR 32 0 GROES
WRKST Basic Material CHAR 48 0 TWSPR WRKST
NORMT Industry Standard Description (such as ANSI or ISO) CHAR 18 0 NORMT
LABOR Laboratory/design office CHAR 3 0 T024L LABOR
EKWSL Purchasing Value Key CHAR 4 0 T405 EKWSL
BRGEW Gross weight QUAN 13 3 BRGEW
NTGEW Net weight QUAN 13 3 NTGEW
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 13 3 VOLUM
VOLEH Volume unit UNIT 3 0 T006 VOLEH
BEHVO Container requirements CHAR 2 0 T144 BEHVO
RAUBE Storage conditions CHAR 2 0 T142 RAUBE
TEMPB Temperature conditions indicator CHAR 2 0 T143 TEMPB
DISST Low-Level Code CHAR 3 0 DISST
TRAGR Transportation Group CHAR 4 0 TTGR TRAGR
STOFF Hazardous material number CHAR 40 0 MGEF STOFF
SPART Division CHAR 2 0 TSPA SPART
KUNNR Competitor CHAR 10 0 V_KNA1WETT WETTB
EANNR European Article Number (EAN) - obsolete!!!!! CHAR 13 0 EANNR
WESCH Quantity: Number of GR/GI slips to be printed QUAN 13 3 WESCH
BWVOR Procurement rule CHAR 1 0 T6WP1 BWVOR
BWSCL Source of Supply CHAR 1 0 TMBW1 BWSCL
SAISO Season Category CHAR 4 0 T6WSP SAISO
ETIAR Label type CHAR 2 0 T6WP3 ETIAR
ETIFO Label form CHAR 2 0 T6WP4 ETIFO
ENTAR Deactivated CHAR 1 0 DUMMYENTAR
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
NUMTP Category of International Article Number (EAN) CHAR 2 0 TNTP NUMTP
LAENG Length QUAN 13 3 LAENG
BREIT Width QUAN 13 3 BREIT
HOEHE Height QUAN 13 3 HOEHE
MEABM Unit of Dimension for Length/Width/Height UNIT 3 0 T006 MEABM
PRDHA Product hierarchy CHAR 18 0 T179 PRODH_D
AEKLK Stock Transfer Net Change Costing CHAR 1 0 CK_AEKLK
CADKZ CAD Indicator CHAR 1 0 CADKZ
QMPUR QM in Procurement Is Active CHAR 1 0 QMPUR
ERGEW Allowed packaging weight QUAN 13 3 ERGEW
ERGEI Unit of weight (allowed packaging weight) UNIT 3 0 T006 ERGEI
ERVOL Allowed packaging volume QUAN 13 3 ERVOL
ERVOE Volume unit (allowed packaging volume) UNIT 3 0 T006 ERVOE
GEWTO Excess Weight Tolerance for Handling unit DEC 3 1 GEWTO
VOLTO Excess Volume Tolerance of the Handling Unit DEC 3 1 VOLTO
VABME Variable Purchase Order Unit Active CHAR 1 0 VABME
Not active
1 Active
2 Active with own price
KZREV Revision Level Has Been Assigned to the Material CHAR 1 0 KZREV
KZKFG Configurable Material CHAR 1 0 KZKFG
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
VHART Packaging Material Type CHAR 4 0 TVTY VHIART
FUELG Maximum level (by volume) DEC 3 0 FUELG
STFAK Stacking factor INT2 5 0 STFAK
MAGRV Material Group: Packaging Materials CHAR 4 0 TVEGR MAGRV
BEGRU Authorization Group CHAR 4 0 BEGRU
DATAB Valid-From Date DATS 8 0 DATAB
LIQDT Deletion date DATS 8 0 LIQDT
SAISJ Season Year CHAR 4 0 SAISJ
PLGTP Price Band Category CHAR 2 0 TWPT PLGTP
MLGUT Empties Bill of Material CHAR 1 0 W_MITLEERG
EXTWG External Material Group CHAR 18 0 TWEW EXTWG
SATNR Cross-Plant Configurable Material CHAR 40 0 MARA SATNR
ATTYP Material Category CHAR 2 0 ATTYP
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
KZKUP Indicator: Material can be co-product CHAR 1 0 KZKUPMAT
KZNFM Indicator: The material has a follow-up material CHAR 1 0 KZNFM
PMATA Pricing Reference Material CHAR 40 0 MARA PMATN
MSTAE Cross-Plant Material Status CHAR 2 0 T141 MSTAE
MSTAV Cross-distribution-chain material status CHAR 2 0 TVMS MSTAV
MSTDE Date from which the cross-plant material status is valid DATS 8 0 MSTDE
MSTDV Date from which the X-distr.-chain material status is valid DATS 8 0 MSTDV
TAKLV Tax classification of the material CHAR 1 0 TSKM TAKLV
RBNRM Catalog Profile CHAR 9 0 T352B RBNR
MHDRZ Minimum Remaining Shelf Life DEC 4 0 MHDRZ
MHDHB Total shelf life DEC 4 0 MHDHB
MHDLP Storage percentage DEC 3 0 MHDLP
INHME Content unit UNIT 3 0 T006 INHME
INHAL Net contents QUAN 13 3 INHAL
VPREH Comparison price unit DEC 5 0 VPREH
ETIAG IS-R Labeling: material grouping (deactivated in 4.0) CHAR 18 0 ETIAG
INHBR Gross contents QUAN 13 3 INHBR
CMETH Quantity Conversion Method CHAR 1 0 OIB_CMETH
Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
CUOBF Internal object number NUMC 18 0 CUOBM
KZUMW Environmentally Relevant CHAR 1 0 KZUMW
KOSCH Product allocation determination procedure CHAR 18 0 T190S KOSCH
SPROF Pricing profile for variants CHAR 1 0 SPROF
Variants priceable diff.; do not propose GMaterial as ref.
1 Variants priceable differently; propose GMaterial as ref.
2 All variants have the sales price of the generic material
NRFHG Material qualifies for discount in kind CHAR 1 0 NRFHG
Not eligible for discount in kind
1 Eligible for discount in kind for purchasing and sales
2 Eligible for discount in kind only for purchasing
3 Eligible for discount in kind only for sales
MFRPN Manufacturer Part Number CHAR 40 0 MFRPN
MFRNR Manufacturer number CHAR 10 0 LFA1 MFRNR
BMATN Number of firm's own (internal) inventory-managed material CHAR 40 0 MARA MPMAT
MPROF Mfr part profile CHAR 4 0 TMPPF MPROF
KZWSM Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
SAITY Rollout in a Season CHAR 2 0 T6WSA SAITY
PROFL Dangerous Goods Indicator Profile CHAR 3 0 TDG41 ADGE_PROFL
IHIVI Indicator: Highly Viscous CHAR 1 0 ADGE_IHIVI
ILOOS Indicator: In Bulk/Liquid CHAR 1 0 ADGE_ILOOS
SERLV Level of Explicitness for Serial Number CHAR 1 0 SERLV
Serialization within the stock material number
1 Keep equipment number and serial number synchronous
KZGVH Packaging Material is Closed Packaging CHAR 1 0 KZGVH
XGCHP Approved Batch Record Required CHAR 1 0 XGCHP
KZEFF Assign effectivity parameter values/ override change numbers CHAR 1 0 CC_MTEFF
COMPL Material completion level NUMC 2 0 TCSCP_COMP_LVL CSCP_COMP_LVL
IPRKZ Period Indicator for Shelf Life Expiration Date CHAR 1 0 DATTP
Day
1 Week
2 Month
3 Year
RDMHD Rounding rule for calculation of SLED CHAR 1 0 RDMHD
No rounding off
+ End of chosen period (week, month or year)
- Start of chosen period (week, month or year)
F Start of the following period (week, month, year)
PRZUS Indicator: Product composition printed on packaging CHAR 1 0 PRZUS
MTPOS_MARA General item category group CHAR 4 0 TPTM MTPOS_MARA
BFLME Generic Material with Logistical Variants CHAR 1 0 BFLME
Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
MATFI Material Is Locked CHAR 1 0 MATFI
CMREL Relevant for Configuration Management CHAR 1 0 DE_CM_RELEVANCE_FLAG
BBTYP Assortment List Type CHAR 1 0 BBTYP
SLED_BBD Expiration Date CHAR 1 0 SLED_BBD
B Expiration Date
E Shelf Life Expiration Date
GTIN_VARIANT Global Trade Item Number Variant CHAR 2 0 GTIN_VARIANT
GENNR Material Number of the Generic Material in Prepack Materials CHAR 40 0 MARA WSTR_SATNR_PP
RMATP Reference material for materials packed in same way CHAR 40 0 MARA PL_RMATP
GDS_RELEVANT Indicator: Global Data Synchronization-Relevant CHAR 1 0 GDS_RELEVANT
WEORA Acceptance At Origin CHAR 1 0 WEORA
HUTYP_DFLT Standard HU Type CHAR 4 0 THUTYP CIFHUTYPDF
PILFERABLE Pilferable CHAR 1 0 CIFPILFRBL
WHSTC Warehouse Storage Condition CHAR 2 0 TWHSTC CIFWHSTC
WHMATGR Warehouse Material Group CHAR 4 0 TWHMATGR CIFWHMATGR
HNDLCODE Handling Indicator CHAR 4 0 THNDLCD CIFHDLCODE
HAZMAT Relevant for Hazardous Substances CHAR 1 0 CIFHAZMAT
HUTYP Handling Unit Type CHAR 4 0 THUTYP CIFHUTYP
TARE_VAR Variable Tare Weight CHAR 1 0 CIFTAREVAR
MAXC Maximum Allowed Capacity of Packaging Material DEC 15 3 CIFMAXC
MAXC_TOL Overcapacity Tolerance of the Handling Unit DEC 3 1 CIFMAXCTOL
MAXL Maximum Packing Length of Packaging Material QUAN 15 3 CIFMAXL
MAXB Maximum Packing Width of Packaging Material QUAN 15 3 CIFMAXB
MAXH Maximum Packing Height of Packaging Material QUAN 15 3 CIFMAXH
MAXDIM_UOM Unit of Measure for Maximum Packing Length/Width/Height UNIT 3 0 T006 CIFMAXDUOM
HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 T005 HERKL
MFRGR Material freight group CHAR 8 0 TMFG MFRGR
QQTIME Quarantine Period QUAN 3 0 CIFQQTIME
QQTIMEUOM Time Unit for Quarantine Period UNIT 3 0 T006 CIFQQTIMEUOM
QGRP Quality Inspection Group CHAR 4 0 TQGRP CIFQGRP
SERIAL Serial Number Profile CHAR 4 0 TSERIAL CIFSERIAL
PS_SMARTFORM Form Name CHAR 30 0 STXFADM CIFPSSFNAME
LOGUNIT EWM CW: Logistics Unit of Measure UNIT 3 0 MARM CIFLOGUNIT
CWQREL EWM CW: Material Is a Catch Weight Material CHAR 1 0 CIFCWQREL
CWQPROC EWM CW: Catch Weight Profile for Entering CW Quantity CHAR 2 0 TCWQPROC CIFCWQPROC
CWQTOLGR Catch Weight Tolerance Group CHAR 9 0 TCWQTOLGR CIFCWQTOLGR
ADPROF Adjustment Profile CHAR 3 0 /SCWM/TMEDI_AP CIFADPROF
IPMIPPRODUCT ID for an Intellectual Property (CRM Product) CHAR 40 0 CRM_PRODUCT_ID_IP
ALLOW_PMAT_IGNO Variant Price Allowed (for Material Master) CHAR 1 0 WPM_ALLOW_PMAT_IGNO_MAT
MEDIUM Medium CHAR 6 0 T372M MEDIU
COMMODITY Commodity CHAR 18 0 TBAC_PHYSCOMM TBA_STOEFFCHEN
ANIMAL_ORIGIN Indicator: Contains Non-Textile Parts of Animal Origin CHAR 1 0 WRF_ANIMAL_ORIGIN_FLAG
No Animal Origin
X Contains Non-Textile Parts of Animal Origin
TEXTILE_COMP_IND Indicator: New Textile Composition Function CHAR 1 0 WRF_TEXTL_COMP_IND
New Textile Comp. Funct. not active
X New Textile Comp. Funct. is active
LAST_CHANGED_TIME Time of Last Change TIMS 6 0 LAST_CHANGED_TIME
MATNR_EXTERNAL External Representation of Material Number CHAR 40 0 MATNR_EXTERNAL
CHML_CMPLNC_RLVNCE_IND Chemical Compliance Relevance Indicator CHAR 1 0 CHML_CMPLNC_RLVNCE_IND
Not Decided
N No
Y Yes
LOGISTICAL_MAT_CATEGORY Category of a Logistical Material CHAR 1 0 DE_LOGISTICAL_MAT_CATEGORY
SALES_MATERIAL Material Number of a Sales Material CHAR 40 0 MARA DE_SALES_MATERIAL
IDENTIFICATION_TAG_TYPE Identification Tag Type CHAR 2 0 IDENTIFICATIONTAGTYPE
No Identification Tag
01 RFID Tag
SGT_CSGR Segmentation Structure CHAR 4 0 SGT_CSGR_T SGT_CSGR
SGT_COVSA Segmentation Strategy CHAR 8 0 SGT_COVS_T SGT_COVSA
SGT_STAT Segmentation Material Master Status CHAR 1 0 SGT_STATD
SGT_SCOPE Segmentation Strategy Scope CHAR 1 0 SGT_SCOPE
1 Requirement and Stock Segments maintained
2 Only Requirement Segments maintained
SGT_REL Segmentation Relevant CHAR 1 0 SGT_REL
ANP ANP Code NUMC 9 0 J_1BTANP J_1BANP
PSM_CODE Code of Protected Species Management CHAR 2 0 * WRF_PSM_CODE
FSH_MG_AT1 Fashion Information Field: 1 CHAR 10 0 FSH_MG_ATTRIBUTE1
FSH_MG_AT2 Fashion Information Field: 2 CHAR 10 0 FSH_MG_ATTRIBUTE2
FSH_MG_AT3 Fashion Information Field: 3 CHAR 6 0 FSH_MG_ATTRIBUTE3
FSH_SEALV Indicator: Use of Season CHAR 1 0 FSH_SEALV
Do not use Season Year / Season
C Season Year / Season / Collection
S Use Season Year / Season
T Season Year / Season / Collection / Theme
FSH_SEAIM Indicator: Season Active in Inventory Management CHAR 1 0 FSH_SEAIM
FSH_SC_MID Material Conversion ID for Characteristic Value Conversion CHAR 2 0 FSH_SC_VCIDS FSH_SC_MID
DUMMY_PRD_INCL_EEW_PS Dummy Field CHAR 1 0 PRD_INCL_EEW
ZZ1_CUSTOMFIELDHIGHRIS_PRD Custom Field: High Risk ? CHAR 1 0 ZZ1_CUSTOMFIELDHIGHRIS
ZZ1_CUSTOMFIELDRISKMIT_PRD Custom Field: Risk Mitigation CHAR 80 0 ZZ1_CUSTOMFIELDRISKMIT
ZZ1_CUSTOMFIELDRISKREA_PRD Custom Field: Risk Reason CHAR 80 0 ZZ1_CUSTOMFIELDRISKREA
SCM_MATID_GUID16 Internal Key for Product RAW 16 0 /SCMB/MDL_MATID
SCM_MATID_GUID22 Internal Number (UID) for Product CHAR 22 0 /SAPAPO/MATID
SCM_MATURITY_DUR Maturation Time DEC 11 0 /SAPAPO/MATURITY_DUR
SCM_SHLF_LFE_REQ_MIN Obsolete. Use /SAPAPO/MATKEY-/SAPAPO/SHELF_LIFE_REQ_MIN. DEC 11 0 PRD_SCM_SHELF_LIFE_REQ_MIN
SCM_SHLF_LFE_REQ_MAX Required Maximum Shelf Life DEC 11 0 /SAPAPO/SHELF_LIFE_REQ_MAX
SCM_PUOM Preferred Alternative UoM for Warehouse Operations UNIT 3 0 T006 /SCWM/DE_PUOM
RMATP_PB Reference Product for Package Building CHAR 40 0 /SAPAPO/MATNR_RMATP_PB
PROD_SHAPE Product Shape CHAR 2 0 /SAPAPO/PROD_SHAPE
Cuboid (Default)
01 Cylinder – Axis along Length
02 Cylinder – Axis along Width
03 Cylinder – Axis along Height
MO_PROFILE_ID Product Orientation Profile CHAR 20 0 /SCMB/MO_PROFILE_ID
OVERHANG_TRESH Overhang Threshold [%] DEC 5 2 /SAPAPO/OVERHANG_TRESH
BRIDGE_TRESH Bridge Threshold [%] DEC 5 2 /SAPAPO/BRIDGE_TRESH
BRIDGE_MAX_SLOPE Maximum Slope for Bridges [°] DEC 5 2 /SAPAPO/BRIDGE_MAX_SLOPE
HEIGHT_NONFLAT Absolute Height Threshold for Stacking on Non-Flat Surface QUAN 13 3 /SAPAPO/HEIGHT_NONFLAT
HEIGHT_NONFLAT_UOM UoM of Abs. Height Threshold (Stacking on Non-Flat Surface) UNIT 3 0 * /SAPAPO/HEIGHT_NONFLAT_UOM
SCM_KITCOMP Product for Kit-to-Order CHAR 1 0 /SAPAPO/CMPKIT
SCM_PROD_PAOOPT Product can be used for Procure-to-Order CHAR 1 0 /SAPAPO/PAOOPT
SCM_BOD_DEPLVL Carry Out Push Deployment from Supplier CHAR 1 0 /SAPAPO/BODDEPLVL
SCM_RESTRICT_INVBAL Inventory Balancing Not Allowed CHAR 1 0 /SAPAPO/RESTRICT_INVBAL
SCM_DRP_GL_STOCK Global Stock on Entry Location DRP CHAR 1 0 /SAPAPO/DRP_GL_STOCK
SCM_EXCL_EXPEDITE Exclude from Express Shipment CHAR 1 0 /SAPAPO/EXCLEXP
/CWM/XCWMAT Material Is Activated for CW CHAR 1 0 /CWM/XCWMAT
/CWM/VALUM Valuation Unit of Measure UNIT 3 0 * /CWM/VALUM
/CWM/TOLGR Tolerance Group for CWM CHAR 9 0 * /CWM/TOLGR
/CWM/TARA Consider Complete Tare for each Reference Unit of Measure CHAR 1 0 /CWM/TARA
/CWM/TARUM Reference Unit of Measure for the TARE Calculation UNIT 3 0 T006 /CWM/TARUM
/BEV1/LULEINH Loading Units NUMC 8 0 /BEV1/LULEINH
/BEV1/LULDEGRP Loading Unit Group: IS Beverage CHAR 3 0 /BEV1/LUT906 /BEV1/LULDEGRP
/BEV1/NESTRUCCAT Structure Category for Material Relationship CHAR 1 0 /BEV1/NESTRUC_CAT
No structure
F Full Product
S Structured Empties
/DSD/SL_TOLTYP Tolerance Type ID CHAR 4 0 /DSD/SL_TGTYP /DSD/SL_TOLTYP_ID
/DSD/SV_CNT_GRP Counting Group CHAR 10 0 /DSD/SV_CNTGR /DSD/SV_COUNT_GROUP
/DSD/VC_GROUP DSD Grouping CHAR 6 0 /DSD/VC_GRP /DSD/VC_GROUP
/SAPMP/KADU Cable Diameter DEC 7 2 /SAPMP/KADU
/SAPMP/ABMEIN Unit for Dimensions UNIT 3 0 * /SAPMP/ABMEIN
/SAPMP/KADP Cable Diameter Allowance in Percent DEC 5 2 /SAPMP/KADP
/SAPMP/BRAD Bending Factor DEC 4 0 /SAPMP/BRAD
/SAPMP/SPBI Inner Width DEC 7 2 /SAPMP/SPBI
/SAPMP/TRAD Outer Diameter DEC 7 2 /SAPMP/TRAD
/SAPMP/KEDU Core Diameter DEC 7 2 /SAPMP/KEDU
/SAPMP/SPTR Load Capacity QUAN 13 3 /SAPMP/SPTR
/SAPMP/FBDK Run-Out Flange Thickness DEC 7 2 /SAPMP/FBDK
/SAPMP/FBHK R-O Flange Height DEC 7 2 /SAPMP/FBHK
/SAPMP/RILI Coil Delivery CHAR 1 0 /SAPMP/RILI
/SAPMP/FBAK Run-Out Flange CHAR 1 0 /SAPMP/FBAK
/SAPMP/AHO Maximum Number of Vertical Layers NUMC 3 0 /SAPMP/AHO
/SAPMP/MIFRR Smallest Permissible Reel Clearance for a Cable DEC 7 2 /SAPMP/MIFRR
/STTPEC/SERTYPE Serialization Type INT1 3 0 /STTPEC/E_SERTYPE
/STTPEC/SYNCACT Synchronization Active CHAR 1 0 /STTPEC/E_SYNCACTIVE
/STTPEC/SYNCTIME Synchronization Time Stamp DEC 15 0 /STTPEC/E_SYNCTIME
/STTPEC/SYNCCHG Indicator Changed Since Integration CHAR 1 0 /STTPEC/E_SERCHG
/STTPEC/COUNTRY_REF Profile Relevant Country/Region CHAR 3 0 /STTPEC/E_PR_REL_COUNTRY
/STTPEC/PRDCAT Product Category CHAR 10 0 * /STTPEC/E_PRDCAT
/VSO/R_TILT_IND Material may be Tilted (Vehicle Space Optimization) CHAR 1 0 /VSO/M_TILT_IND
/VSO/R_STACK_IND Stacking not Allowed (VSO) CHAR 1 0 /VSO/M_STACK_IND
/VSO/R_BOT_IND Bottom Layer (Vehicle Space Optimization) CHAR 1 0 /VSO/M_BOTTOM_IND
/VSO/R_TOP_IND Top Layer (VSO) CHAR 1 0 /VSO/M_TOP_IND
/VSO/R_STACK_NO Stacking Factor (Vehicle Space Optimization) NUMC 3 0 /VSO/M_STACK_NO
/VSO/R_PAL_IND Load without Packaging Material (VSO) CHAR 1 0 /VSO/M_PALLET_IND
/VSO/R_PAL_OVR_D Permissible Overhang (Depth) of Packaging Material (VSO) QUAN 13 3 /VSO/R_PAL_OVR_D
/VSO/R_PAL_OVR_W Permissible Overhang (Width) of Shipping Material (VSO) QUAN 13 3 /VSO/R_PAL_OVR_W
/VSO/R_PAL_B_HT Maximum Stacking Height of the Packaging Material (VSO) QUAN 13 3 /VSO/R_PAL_BIN_HGT
/VSO/R_PAL_MIN_H Minimum Stacking Height of the Packaging Material (VSO) QUAN 13 3 /VSO/R_PAL_MIN_HT
/VSO/R_TOL_B_HT Tolerance to Exceed the Max. Stacking Height (VSO) QUAN 13 3 /VSO/R_TOL_BIN_HT
/VSO/R_NO_P_GVH Number of Materials for each Closed PKM (VSO) NUMC 2 0 /VSO/M_ANZ_PER_GVH
/VSO/R_QUAN_UNIT Unit of Measure Vehicle Space Optimization UNIT 3 0 /VSO/R_QUAN_UNIT
/VSO/R_KZGVH_IND Closed Packaging Material Required (VSO) CHAR 1 0 /VSO/M_KZGVH_IND
PACKCODE Packaging Code CHAR 10 0 CCUNC121 CBUNE_PACODE
DG_PACK_STATUS Dangerous Goods Packaging Status CHAR 10 0 TDG101 ADGE_DG_PACK_STATUS
SRV_DURA Duration of Work QUAN 13 3 CRMT_PR_DURATION
SRV_DURA_UOM Unit for Duration of Work UNIT 3 0 T006 CRMT_PR_DURATION_UOM
SRV_SERWI Service Profile CHAR 10 0 CRMD_SERWI SRV_SERWI
SRV_ESCAL Response Profile CHAR 10 0 CRMD_ESCAL SRV_ESCAL
SOM_CYCLE Billing Cycle CHAR 4 0 TFK2607 CYCLE_KK
SOM_CYCLE_RULE Billing Cycle Determination Rule ID CHAR 4 0 CRMC_ISX_BCDETR CRM_ISX_CYCLE_RULE
SOM_TC_SCHEMA Assignment Schema CHAR 2 0 CRMS4C_SOM_TRAS CRMT_TC_SCHEMA
SOM_CTR_AUTORENEWAL Contract Auto Renewal Indicator CHAR 1 0 CRMS4_SOM_CTR_AUTORENEWAL
No Selection, can be changed
1 Set to Yes, can be changed
2 Not relevant for Auto Renewal
3 Set to Yes, cannot be changed
MCOND Material Condition Management CHAR 1 0 DFPS_MCOND
No Condition Management
1 Condition Management Only
2 Condition Management with Batch Number
RETDELC Return Code CHAR 1 0 DFPS_RETDELC
LOGLEV_RETO Return to Logistics Level CHAR 1 0 DFPS_LOGLEV_RETO
NSNID NATO Stock Number CHAR 9 0 DFPS_NSNID
ICFA Interchangeability Code for Ammunition CHAR 8 0 DFS_ICFA
RIC_ID Reportable Item Code - Numerical ID INT8 19 0 /ISDFPS/RIC_ID
DFS_SENSITIVITY_KEY Sensitivity for Characteristics CHAR 4 0 * DFS_SENSITIVITY_KEY
DFS_MFRP2 Long Manufacturer Part Number CHAR 60 0 DFS_MFRP2
OVLPN Overlength Part Number CHAR 32 0 ADSPC_OPN
ADSPC_SPC Spare Part Class Code NUMC 1 0 ADSPC_SPC
0 Reference item
1 Expendable spare
2 Repairable spare, having a supporting CMM
6 Repairable spare, not having a supporting CMM
VARID GUID Variable Object Identification RAW 16 0 DI_VARID
MSBOOKPARTNO Manufacturer Book Part Number CHAR 40 0 DIMP_DRM_MSBOOKPART
TOLERANCE_TYPE Tolerance Type CHAR 4 0 * LMD_MDE_TOLERANCE_TYPE
DPCBT Single-Unit Batch Def. Value CHAR 1 0 MILL_DPCBT
Single-Unit Batches not Allowed
A Single-Unit Batches Allowed, but not Proposed
B Single-Unit Batches Allowed and Proposed
C Handled in Single-Unit Batches
XGRDT Goods Receipt to Posted Single-Unit Batch Allowed CHAR 1 0 MILL_XGRDT
IMATN FFF class CHAR 40 0 * IMATN
PICNUM Supersession chain number CHAR 40 0 PIC_PICNUM_SUS
BSTAT Creation Status - Seasonal Procurement CHAR 2 0 WRFMATBSTAT WRFBSTAT
COLOR_ATINN Internal Charactieristic Number for Color Characteristics NUMC 10 0 * WRF_COLOR_ATINN
SIZE1_ATINN Internal Char. Number for Characteristics for Main Sizes NUMC 10 0 * WRF_SIZE1_ATINN
SIZE2_ATINN Internal Char. Number for Characteristics for Second Sizes NUMC 10 0 * WRF_SIZE2_ATINN
COLOR Characteristic Value for Colors of Variants CHAR 18 0 WRF_COLOR
SIZE1 Characteristic Value for Main Sizes of Variants CHAR 18 0 WRF_SIZE1
SIZE2 Characteristic Value for Second Size for Variants CHAR 18 0 WRF_SIZE2
FREE_CHAR Characteristic Value for Evaluation Purposes CHAR 18 0 WRF_FREE_CHAR
CARE_CODE Care Codes (such as Washing Code, Ironing Code, etc.) CHAR 16 0 WRF_CARE_CODE
BRAND_ID Brand CHAR 4 0 WRF_BRANDS WRF_BRAND_ID
FIBER_CODE1 Fiber Code for Textiles (Component 1) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_1
FIBER_PART1 Percentage Share of Fiber (Component 1) NUMC 3 0 WRF_FIBER_PART_1
FIBER_CODE2 Fiber Code for Textiles (Component 2) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_2
FIBER_PART2 Percentage Share of Fiber (Component 2) NUMC 3 0 WRF_FIBER_PART_2
FIBER_CODE3 Fiber Code for Textiles (Component 3) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_3
FIBER_PART3 Percentage Share of Fiber (Component 3) NUMC 3 0 WRF_FIBER_PART_3
FIBER_CODE4 Fiber Code for Textiles (Component 4) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_4
FIBER_PART4 Percentage Share of Fiber (Component 4) NUMC 3 0 WRF_FIBER_PART_4
FIBER_CODE5 Fiber Code for Textiles (Component 5) CHAR 3 0 WRF_FIBER_CODES WRF_FIBER_CODE_5
FIBER_PART5 Percentage Share of Fiber (Component 5) NUMC 3 0 WRF_FIBER_PART_5
FASHGRD Fashion Grade CHAR 4 0 T6WFG FASHGRD

EMARA foreign key relationships

Table Field Check Table Check Field
0 EMARA /CWM/TARUM T006 Units of Measurement MANDT
1 EMARA BEHVO T144 Container Requirements for Storing Materials MANDT
1 EMARA BEHVO T144 Container Requirements for Storing Materials BEHVO
0 EMARA BMATN MARA General Material Data MANDT
0 EMARA BMATN MARA General Material Data MATNR
1 EMARA BRAND_ID WRF_BRANDS Markers MANDT
1 EMARA BRAND_ID WRF_BRANDS Markers BRAND_ID
0 EMARA BSTAT WRFMATBSTAT Creation Status - Seasonal Procurement MANDT
0 EMARA BSTAT WRFMATBSTAT Creation Status - Seasonal Procurement BSTAT
1 EMARA BSTME T006 Units of Measurement MANDT
0 EMARA BWSCL TMBW1 Source of Supply Keys MANDT
0 EMARA BWSCL TMBW1 Source of Supply Keys BWSCL
1 EMARA BWVOR T6WP1 Check table, supply source entry MANDT
0 EMARA COMMODITY TBAC_PHYSCOMM Customizing table for physical commodities COMMODITY
1 EMARA COMPL TCSCP_COMP_LVL Material completion levels (including their sequence) MANDT
0 EMARA CWQPROC TCWQPROC EWM-CW: EWM-CW: Catch Weight Quantity Input Control MANDT
0 EMARA CWQPROC TCWQPROC EWM-CW: EWM-CW: Catch Weight Quantity Input Control CWQPROC
1 EMARA CWQTOLGR TCWQTOLGR EWM-CW: Tolerance Groups MANDT
0 EMARA DG_PACK_STATUS TDG101 Dangerous Goods Packaging Status MANDT
0 EMARA DG_PACK_STATUS TDG101 Dangerous Goods Packaging Status DG_PACK_STATUS
1 EMARA EKWSL T405 Purchasing Value Key MANDT
1 EMARA EKWSL T405 Purchasing Value Key EKWSL
0 EMARA ERGEI T006 Units of Measurement MANDT
1 EMARA ERVOE T006 Units of Measurement MANDT
0 EMARA ETIAR T6WP3 Check Table for Labelling Type ETIAR
1 EMARA ETIFO T6WP4 Check Table for Label Shape MANDT
1 EMARA ETIFO T6WP4 Check Table for Label Shape ETIFO
0 EMARA EXTWG TWEW External Material Groups MANDT
1 EMARA FASHGRD T6WFG Degree of Fashion MANDT
0 EMARA FIBER_CODE1 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
1 EMARA FIBER_CODE2 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
0 EMARA FIBER_CODE3 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
1 EMARA FIBER_CODE4 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
0 EMARA FIBER_CODE5 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
1 EMARA FSH_SC_MID FSH_SC_VCIDS Customer- & material-IDs MANDT
1 EMARA FSH_SC_MID FSH_SC_VCIDS Customer- & material-IDs FSH_SC_IDT
1 EMARA FSH_SC_MID FSH_SC_VCIDS Customer- & material-IDs FSH_SC_ID
0 EMARA GENNR MARA General Material Data MANDT
0 EMARA GENNR MARA General Material Data MATNR
1 EMARA GEWEI T006 Units of Measurement MANDT
1 EMARA GEWEI T006 Units of Measurement MSEHI
0 EMARA HERKL T005 Countries MANDT
0 EMARA HERKL T005 Countries LAND1
1 EMARA HNDLCODE THNDLCD Handling Indicator MANDT
1 EMARA HNDLCODE THNDLCD Handling Indicator HNDLCODE
0 EMARA HUTYP THUTYP Handling Unit Types MANDT
0 EMARA HUTYP THUTYP Handling Unit Types HUTYP
1 EMARA HUTYP_DFLT THUTYP Handling Unit Types MANDT
1 EMARA HUTYP_DFLT THUTYP Handling Unit Types HUTYP
0 EMARA INHME T006 Units of Measurement MANDT
1 EMARA KOSCH T190S Product Allocation: Definition Procedure MANDT
1 EMARA KOSCH T190S Product Allocation: Definition Procedure KOSCH
0 EMARA KUNNR V_KNA1WETT Generated Table for View KUNNR
1 EMARA LABOR T024L Laboratory/office for material MANDT
0 EMARA LOGUNIT MARM Units of Measure for Material MANDT
0 EMARA LOGUNIT MARM Units of Measure for Material MEINH
1 EMARA MAGRV TVEGR Material Group: Packaging Materials MANDT
1 EMARA MAGRV TVEGR Material Group: Packaging Materials MAGRV
0 EMARA MATKL T023 Material Groups MATKL
1 EMARA MAXDIM_UOM T006 Units of Measurement MANDT
0 EMARA MBRSH T137 Industries for materials MANDT
1 EMARA MEABM T006 Units of Measurement MANDT
0 EMARA MEDIUM T372M Medium MANDT
0 EMARA MEDIUM T372M Medium MEDIU
1 EMARA MEINS T006 Units of Measurement MANDT
1 EMARA MEINS T006 Units of Measurement MSEHI
0 EMARA MFRGR TMFG Material freight groups MANDT
0 EMARA MFRGR TMFG Material freight groups MFRGR
1 EMARA MFRNR LFA1 Supplier Master (General Section) MANDT
1 EMARA MFRNR LFA1 Supplier Master (General Section) LIFNR
0 EMARA MPROF TMPPF Control Profile for Manufacturer Part Number Management MPROF
1 EMARA MSTAE T141 Material Status from Materials Management/PPC View MANDT
1 EMARA MSTAE T141 Material Status from Materials Management/PPC View MMSTA
0 EMARA MSTAV TVMS Materials: Status in Sales and Distribution MANDT
0 EMARA MSTAV TVMS Materials: Status in Sales and Distribution VMSTA
1 EMARA MTART T134 Material Types MANDT
1 EMARA MTART T134 Material Types MTART
0 EMARA MTPOS_MARA TPTM Materials: Item Category Groups in Material Master MTPOS
1 EMARA NUMTP TNTP International Article Number (EAN) Categories MANDT
1 EMARA NUMTP TNTP International Article Number (EAN) Categories NUMTP
0 EMARA PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) MANDT
0 EMARA PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) LWDG
0 EMARA PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) PACKCODE
1 EMARA PLGTP TWPT Price band categories MANDT
1 EMARA PLGTP TWPT Price band categories PLGTP
0 EMARA PMATA MARA General Material Data MANDT
0 EMARA PMATA MARA General Material Data MATNR
1 EMARA PRDHA T179 Materials: Product Hierarchies PRODH
0 EMARA PROFL TDG41 DG: DG Indicator Profiles for Material Master MANDT
0 EMARA PROFL TDG41 DG: DG Indicator Profiles for Material Master PROFL
1 EMARA PS_SMARTFORM STXFADM Smart Forms: Administration FORMNAME
0 EMARA QGRP TQGRP Quality Inspection Group MANDT
0 EMARA QGRP TQGRP Quality Inspection Group QGRP
1 EMARA QQTIMEUOM T006 Units of Measurement MANDT
0 EMARA RAUBE T142 Storage Conditions for Materials MANDT
0 EMARA RAUBE T142 Storage Conditions for Materials RAUBE
1 EMARA RBNRM T352B Technical report MANDT
0 EMARA RMATP MARA General Material Data MANDT
0 EMARA RMATP MARA General Material Data MATNR
1 EMARA SAISO T6WSP Check Table for Season Indicator MANDT
1 EMARA SAISO T6WSP Check Table for Season Indicator SAISO
0 EMARA SAITY T6WSA Categories of seasonal materials MANDT
0 EMARA SAITY T6WSA Categories of seasonal materials SAITY
1 EMARA SALES_MATERIAL MARA General Material Data MANDT
1 EMARA SALES_MATERIAL MARA General Material Data MATNR
0 EMARA SATNR MARA General Material Data MATNR
1 EMARA SCM_PUOM T006 Units of Measurement MANDT
0 EMARA SERIAL TSERIAL Serial Number Profile MANDT
0 EMARA SERIAL TSERIAL Serial Number Profile SERIAL
1 EMARA SGT_COVSA SGT_COVS_T Segmentation Strategies MANDT
1 EMARA SGT_COVSA SGT_COVS_T Segmentation Strategies WERKS
0 EMARA SGT_CSGR SGT_CSGR_T Segmentation Structures MANDT
1 EMARA SOM_CYCLE TFK2607 Billing Cycles CYCLE
0 EMARA SOM_CYCLE_RULE CRMC_ISX_BCDETR Billing Cycle Determination Rules CLIENT
0 EMARA SOM_CYCLE_RULE CRMC_ISX_BCDETR Billing Cycle Determination Rules RULE_ID
1 EMARA SOM_TC_SCHEMA CRMS4C_SOM_TRAS Assignment Schema for Technical Resources ASSIGN_SCHEMA
0 EMARA SPART TSPA Organizational Unit: Sales Divisions MANDT
0 EMARA SPART TSPA Organizational Unit: Sales Divisions SPART
1 EMARA SRV_DURA_UOM T006 Units of Measurement MANDT
0 EMARA SRV_ESCAL CRMD_ESCAL Service Response Time Schema SRV_ESCAL
1 EMARA SRV_SERWI CRMD_SERWI Service Availability Profile SRV_SERWI
0 EMARA STOFF MGEF Hazardous materials MANDT
0 EMARA STOFF MGEF Hazardous materials STOFF
0 EMARA STOFF MGEF Hazardous materials REGKZ
1 EMARA TAKLV TSKM Material Taxes MANDT
1 EMARA TAKLV TSKM Material Taxes TATYP
0 EMARA TEMPB T143 Temperature Conditions for Storing Materials MANDT
0 EMARA TEMPB T143 Temperature Conditions for Storing Materials TEMPB
1 EMARA TRAGR TTGR Delivery Scheduling: Transportation Groups TRAGR
0 EMARA VHART TVTY Packaging Material Types MANDT
0 EMARA VHART TVTY Packaging Material Types TRATY
1 EMARA VOLEH T006 Units of Measurement MANDT
1 EMARA VOLEH T006 Units of Measurement MSEHI
0 EMARA WHMATGR TWHMATGR Warehouse Material Group MANDT
0 EMARA WHMATGR TWHMATGR Warehouse Material Group WHMATGR
1 EMARA WHSTC TWHSTC Warehouse Storage Condition WHSTC