1. Home
  2. Resources
  3. SAP Tables
  4. BAPI_MARA - Material Data at Client Level

SAP Table BAPI_MARA

Material Data at Client Level

BAPI_MARA (Material Data at Client Level) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPI_MARA to other SAP tables.

Source: BAPI_MARA (Material Data at Client Level)

BAPI_MARA table fields

Field Data element Checktable Datatype Length Decimals
DEL_FLAG Flag Material for Deletion at Client Level LVOMA CHAR 1 0
X Yes
NULL No
MATL_GROUP Material Group MATKL CHAR 9 0
OLD_MAT_NO Old material number BISMT CHAR 18 0
BASE_UOM Base Unit of Measure MEINS UNIT 3 0
BASE_UOM_ISO Base unit of measure in ISO code MEINS_ISO CHAR 3 0
PO_UNIT Purchase Order Unit of Measure BSTME UNIT 3 0
PO_UNIT_ISO Order unit in ISO code BSTME_ISO CHAR 3 0
DOCUMENT Document number (without document management system) DZEINR CHAR 22 0
DOC_TYPE Document type (without Document Management system) DZEIAR CHAR 3 0
DOC_VERS Document version (without Document Management system) DZEIVR CHAR 2 0
DOC_FORMAT Page format of document (without Document Management system) DZEIFO CHAR 4 0
DOC_CHG_NO Document change number (without document management system) AESZN CHAR 6 0
PAGE_NO Page number of document (without Document Management system) BLATT CHAR 3 0
NO_SHEETS Number of sheets (without Document Management system) BLANZ NUMC 3 0
PROD_MEMO Production/inspection memo FERTH CHAR 18 0
PAGEFORMAT Page Format of Production Memo FORMT CHAR 4 0
SIZE_DIM Size/dimensions GROES CHAR 32 0
BASIC_MATL Basic Material WRKST CHAR 48 0
STD_DESCR Industry Standard Description (such as ANSI or ISO) NORMT CHAR 18 0
DSN_OFFICE Laboratory/design office LABOR CHAR 3 0
PUR_VALKEY Purchasing Value Key EKWSL CHAR 4 0
NET_WEIGHT Net Weight NTGEW QUAN 13 3
UNIT_OF_WT Weight Unit GEWEI UNIT 3 0
UNIT_OF_WT_ISO Unit of weight in ISO code GEWEI_ISO CHAR 3 0
CONTAINER Container requirements BEHVO CHAR 2 0
STOR_CONDS Storage conditions RAUBE CHAR 2 0
TEMP_CONDS Temperature conditions indicator TEMPB CHAR 2 0
TRANS_GRP Transportation Group TRAGR CHAR 4 0
HAZ_MAT_NO Hazardous material number STOFF CHAR 18 0
DIVISION Division SPART CHAR 2 0
COMPETITOR Competitor WETTB CHAR 10 0
QTY_GR_GI Quantity: Number of GR/GI slips to be printed WESCH QUAN 13 3
PROC_RULE Procurement rule BWVOR CHAR 1 0
SUP_SOURCE Source of Supply BWSCL CHAR 1 0
SEASON Season Category SAISO CHAR 4 0
LABEL_TYPE Label type ETIAR CHAR 2 0
LABEL_FORM Label form ETIFO CHAR 2 0
PROD_HIER Product hierarchy PRODH_D CHAR 18 0
CAD_ID CAD Indicator CADKZ CHAR 1 0
X Yes
NULL No
ALLOWED_WT Allowed packaging weight ERGEW QUAN 13 3
PACK_WT_UN Unit of weight (allowed packaging weight) ERGEI UNIT 3 0
PACK_WT_UN_ISO Unit of weight (allowed packaging weight) in ISO code ERGEI_ISO CHAR 3 0
ALLWD_VOL Allowed packaging volume ERVOL QUAN 13 3
PACK_VO_UN Volume unit (allowed packaging volume) ERVOE UNIT 3 0
PACK_VO_UN_ISO Volume unit (allowed packaging volume) in ISO code ERVOE_ISO CHAR 3 0
WT_TOL_LT Excess Weight Tolerance for Handling unit GEWTO DEC 3 1
VOL_TOL_LT Excess Volume Tolerance of the Handling Unit VOLTO DEC 3 1
VAR_ORD_UN Variable Purchase Order Unit Active VABME CHAR 1 0
NULL Not active
1 Active
2 Active with own price
BATCH_MGMT Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
SH_MAT_TYP Packaging Material Type VHIART CHAR 4 0
FILL_LEVEL Maximum level (by volume) FUELG DEC 3 0
STACK_FACT Stacking factor STFAK INT2 5 0
MAT_GRP_SM Material Group: Packaging Materials MAGRV CHAR 4 0
AUTHORITYGROUP Authorization Group BEGRU CHAR 4 0
QM_PROCMNT QM in Procurement is Active QMPUR CHAR 1 0
X Yes
NULL No
CATPROFILE Catalog Profile RBNR CHAR 9 0
MINREMLIFE Minimum Remaining Shelf Life MHDRZ DEC 4 0
SHELF_LIFE Total shelf life MHDHB DEC 4 0
STOR_PCT Storage percentage MHDLP DEC 3 0
PUR_STATUS Cross-Plant Material Status MSTAE CHAR 2 0
SAL_STATUS Cross-distribution-chain material status MSTAV CHAR 2 0
PVALIDFROM Date from which the cross-plant material status is valid MSTDE DATS 8 0
SVALIDFROM Date from which the X-distr.-chain material status is valid MSTDV DATS 8 0
ENVT_RLVT Environmentally Relevant KZUMW CHAR 1 0
X Yes
NULL No
PROD_ALLOC Product allocation determination procedure KOSCH CHAR 18 0
QUAL_DIK Material qualifies for discount in kind NRFHG CHAR 1 0
NULL 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
MANU_MAT Manufacturer Part Number MFRPN CHAR 40 0
MFR_NO Number of a Manufacturer MFRNR CHAR 10 0
INV_MAT_NO Number of firm's own (internal) inventory-managed material MPMAT CHAR 18 0
MANUF_PROF Manufacturer Part Profile MPROF CHAR 4 0
HAZMATPROF Dangerous Goods Indicator Profile ADGE_PROFL CHAR 3 0
HIGH_VISC Indicator: Highly Viscous ADGE_IHIVI CHAR 1 0
X Yes
NULL No
LOOSEORLIQ Indicator: In Bulk/Liquid ADGE_ILOOS CHAR 1 0
X Yes
NULL No
CLOSED_BOX Packaging Material is Closed Packaging KZGVH CHAR 1 0
X Yes
NULL No
APPD_B_REC Indicator: Approved batch record required XGCHP CHAR 1 0
X Yes
NULL No
MATCMPLLVL Material completion level CSCP_COMP_LVL NUMC 2 0
PAR_EFF Assign effectivity parameter values/ override change numbers CC_MTEFF CHAR 1 0
X Yes
NULL No
ROUND_UP_RULE_EXPIRATION_DATE Rounding rule for calculation of SLED RDMHD CHAR 1 0
NULL No rounding off
- Start of chosen period (week, month or year)
+ End of chosen period (week, month or year)
F Start of the following period (week, month, year)
PERIOD_IND_EXPIRATION_DATE Period Indicator for Shelf Life Expiration Date DATTP CHAR 1 0
PROD_COMPOSITION_ON_PACKAGING Indicator: Product composition printed on packaging PRZUS CHAR 1 0
X Yes
NULL No
ITEM_CAT General item category group MTPOS_MARA CHAR 4 0
HAZ_MAT_NO_EXTERNAL Long Material Number for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_EXTERNAL CHAR 40 0
HAZ_MAT_NO_GUID External GUID for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_GUID CHAR 32 0
HAZ_MAT_NO_VERSION Version Number for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_VERSION CHAR 10 0
INV_MAT_NO_EXTERNAL Long Material Number for INV_MAT_NO Field MGV_INV_MAT_NO_EXTERNAL CHAR 40 0
INV_MAT_NO_GUID External GUID for INV_MAT_NO Field MGV_INV_MAT_NO_GUID CHAR 32 0
INV_MAT_NO_VERSION Version Number for INV_MAT_NO Field MGV_INV_MAT_NO_VERSION CHAR 10 0
MATERIAL_FIXED Material Is Locked MATFI CHAR 1 0
X Yes
NULL No
CM_RELEVANCE_FLAG Relevant for Configuration Management DE_CM_RELEVANCE_FLAG CHAR 1 0
NULL Not relevant for Configuration Management
1 Relevant for Configuration Management
SLED_BBD Expiration Date SLED_BBD CHAR 1 0
B Expiration Date
E Shelf Life Expiration Date
GTIN_VARIANT Global Trade Item Number Variant GTIN_VARIANT CHAR 2 0
SERIALIZATION_LEVEL Level of Explicitness for Serial Number SERLV CHAR 1 0
NULL Serialization within the stock material number
1 Keep equipment number and serial number synchronous
PL_REF_MAT Reference material for materials packed in same way PL_RMATP CHAR 18 0
EXTMATLGRP External Material Group EXTWG CHAR 18 0
UOMUSAGE Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
GDS_RELEVANT Indicator: Global Data Synchronization-Relevant GDS_RELEVANT CHAR 1 0
X Yes
NULL No
PL_REF_MAT_EXTERNAL Long Material Number for PL_REF_MAT Field MGV_PL_REF_MAT_EXTERNAL CHAR 40 0
PL_REF_MAT_GUID External GUID for PL_REF_MAT Field MGV_PL_REF_MAT_GUID CHAR 32 0
PL_REF_MAT_VERSION Version Number for PL_REF_MAT Field MGV_PL_REF_MAT_VERSION CHAR 10 0
WE_ORIGIN_ACCEPTANCE Acceptance At Origin WEORA CHAR 1 0
X Yes
NULL No
STD_HU_TYPE Standard HU Type CIFHUTYPDF CHAR 4 0
PILFERABLE Pilferable CIFPILFRBL CHAR 1 0
X Yes
NULL No
WHSE_STORAGE_CONDITION Warehouse Storage Condition CIFWHSTC CHAR 2 0
WHSE_MATERIAL_GROUP Warehouse Material Group CIFWHMATGR CHAR 4 0
HANDLING_INDICATOR Handling Indicator CIFHDLCODE CHAR 4 0
HAZ_MAT_RELEVANT Relevant for Hazardous Substances CIFHAZMAT CHAR 1 0
X Yes
NULL No
HU_TYPE Handling Unit Type CIFHUTYP CHAR 4 0
VARIABLE_TARE_WEIGHT Variable Tare Weight CIFTAREVAR CHAR 1 0
X Yes
NULL No
MAX_ALLOWED_CAPACITY Maximum Allowed Capacity of Packaging Material CIFMAXC DEC 15 3
OVERCAPACITY_TOLERANCE Overcapacity Tolerance of the Handling Unit CIFMAXCTOL DEC 3 1
MAX_ALLOWED_LENGTH Maximum Packing Length of Packaging Material CIFMAXL QUAN 15 3
MAX_ALLOWED_WIDTH Maximum Packing Width of Packaging Material CIFMAXB QUAN 15 3
MAX_ALLOWED_HEIGTH Maximum Packing Height of Packaging Material CIFMAXH QUAN 15 3
MAX_DIMENSION_UN Unit of Measure for Maximum Packing Length/Width/Height CIFMAXDUOM UNIT 3 0
MAX_DIMENSION_UN_ISO Unit for Maximum Packing Length/Width/Height in ISO Code CIFMAXDUOM_ISO CHAR 3 0
COUNTRYORI Country of origin of the material HERKL CHAR 3 0
COUNTRYORI_ISO Material's country of origin in ISO code HERKL_ISO CHAR 2 0
MATFRGTGRP Material freight group MFRGR CHAR 8 0
QUARANTINE_PERIOD Quarantine Period CIFQQTIME QUAN 3 0
QUARANTINE_PERIOD_UN Time Unit for Quarantine Period CIFQQTIMEUOM UNIT 3 0
QUARANTINE_PERIOD_UN_ISO Time Unit for Quarantine Time in ISO Code CIFQQTIMEUOM_ISO CHAR 3 0
QUALITY_INSP_GRP Quality Inspection Group CIFQGRP CHAR 4 0
SERIAL_NUMBER_PROFILE Serial Number Profile CIFSERIAL CHAR 4 0
EWM_CW_TOLERANCE_GROUP EWM-CW: Catch Weight Tolerance Group for EWM CIFCWQTOLGR CHAR 9 0
EWM_CW_INPUT_CONTROL EWM CW: Catch Weight Profile for Entering CW Quantity CIFCWQPROC CHAR 2 0
PCKGING_SMARTFORM Form Name CIFPSSFNAME CHAR 30 0
PACOD Packaging Code CBUNE_PACODE CHAR 10 0
DG_PCKGING_STATUS Dangerous Goods Packaging Status ADGE_DG_PACK_STATUS CHAR 10 0
ADJUST_PROFILE Adjustment Profile CIFADPROF CHAR 3 0
IPMIPPRODUCT ID for an Intellectual Property (CRM Product) CRM_PRODUCT_ID_IP CHAR 40 0
MEDIUM Medium MEDIU CHAR 6 0
NSNID NATO Stock Number DFPS_NSNID CHAR 9 0
PHYSICAL_COMMODITY Physical Commodity TBA_STOEFFCHEN CHAR 18 0