1. Home
  2. Resources
  3. SAP Tables
  4. BAPIMATMRA - BAPI CRS Structure for MARA (Material)

SAP Table BAPIMATMRA

BAPI CRS Structure for MARA (Material)

BAPIMATMRA (BAPI CRS Structure for MARA (Material)) 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 BAPIMATMRA to other SAP tables.

BAPIMATMRA table fields

Field Data element Checktable Datatype Length Decimals
OPERATION Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
MATERIAL Material Number MATNR CHAR 18 0
CREATED_ON Created On ERSDA DATS 8 0
CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
LAST_CHNGE Date of Last Change LAEDA DATS 8 0
CHANGED_BY Name of Person Who Changed Object AENAM CHAR 12 0
MAINT_STAT Maintenance status of complete material VPSTA CHAR 15 0
STATUS Maintenance status PSTAT_D CHAR 15 0
DEL_FLAG Flag Material for Deletion at Client Level LVOMA CHAR 1 0
X Yes
NULL No
MATL_TYPE Material Type MTART T134 CHAR 4 0
IND_SECTOR Industry sector MBRSH T137 CHAR 1 0
MATL_GROUP Material Group MATKL T023 CHAR 9 0
OLD_MAT_NO Old material number BISMT CHAR 18 0
UNBASE Base Unit of Measure MEINS T006 UNIT 3 0
UNBASE_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
UNITPO Purchase Order Unit of Measure BSTME T006 UNIT 3 0
UNITPO_ISO ISO code for unit of measurement ISOCD_UNIT 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 (Basic Constituent of a Material) CRMWRKST CHAR 48 0
STD_DESCR Industry Standard Description (such as ANSI or ISO) NORMT CHAR 18 0
DSN_OFFICE Laboratory/design office LABOR T024L CHAR 3 0
PUR_VALKEY Purchasing Value Key EKWSL T405 CHAR 4 0
GROSS_WT Gross Weight BRGEW QUAN 13 3
NET_WEIGHT Net Weight NTGEW QUAN 13 3
UNITWT Weight Unit GEWEI T006 UNIT 3 0
UNITWT_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
VOLUME Volume VOLUM QUAN 13 3
UNVOL Volume unit VOLEH T006 UNIT 3 0
UNVOL_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
CONTAINER Container requirements BEHVO T144 CHAR 2 0
STOR_CONDS Storage conditions RAUBE T142 CHAR 2 0
TEMP_CONDS Temperature conditions indicator TEMPB T143 CHAR 2 0
L_L_CODE Low-Level Code DISST CHAR 3 0
TRANS_GRP Transportation Group TRAGR TTGR CHAR 4 0
HAZ_MAT_NO Hazardous material number STOFF MGEF CHAR 18 0
DIVISION Division SPART TSPA CHAR 2 0
COMPETITOR Competitor WETTB V_KNA1WETT CHAR 10 0
EUR_ART_NR European Article Number (EAN) - obsolete!!!!! EANNR CHAR 13 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 TMBW1 CHAR 1 0
SEASON Season Category SAISO T6WSP CHAR 4 0
LABEL_TYPE Label type ETIAR T6WP3 CHAR 2 0
LABEL_FORM Label form ETIFO T6WP4 CHAR 2 0
DUMMYENTAR Deactivated DUMMYENTAR CHAR 1 0
EAN_UPC International Article Number (EAN/UPC) EAN11 CHAR 18 0
EAN_CAT Category of International Article Number (EAN) NUMTP TNTP CHAR 2 0
LENGTH Length LAENG QUAN 13 3
WIDTH Width BREIT QUAN 13 3
HEIGHT Height HOEHE QUAN 13 3
UNDIM Unit of Dimension for Length/Width/Height MEABM T006 UNIT 3 0
UNDIM_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
PROD_HIER Product hierarchy PRODH_D T179 CHAR 18 0
NET_CHANGE Stock Transfer Net Change Costing CK_AEKLK CHAR 1 0
X Yes
NULL No
CAD_ID CAD Indicator CADKZ CHAR 1 0
X Yes
NULL No
QM_PROCMNT QM in Procurement is Active QMPUR CHAR 1 0
X Yes
NULL No
ALLOWED_WT Allowed packaging weight ERGEW QUAN 13 3
UNPWT Unit of weight (allowed packaging weight) ERGEI T006 UNIT 3 0
UNPWT_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
ALLWD_VOL Allowed packaging volume ERVOL QUAN 13 3
UNPVO Volume unit (allowed packaging volume) ERVOE T006 UNIT 3 0
UNPVO_ISO ISO code for unit of measurement ISOCD_UNIT 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
REV_LEV Revision Level Has Been Assigned to the Material KZREV CHAR 1 0
X Yes
NULL No
CONFIGURED Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
BATCH_MGMT Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
SH_MAT_TYP Packaging Material Type VHIART TVTY 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 TVEGR CHAR 4 0
AUTHRTYGRP Authorization Group BEGRU CHAR 4 0
VALID_FROM Valid-From Date DATAB DATS 8 0
DELN_DATE Deletion date LIQDT DATS 8 0
SEASON_YR Season Year SAISJ CHAR 4 0
PRICE_BAND Price Band Category PLGTP TWPT CHAR 2 0
EMPTIESBOM Empties Bill of Material W_MITLEERG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
EXTMATLGRP External Material Group EXTWG CHAR 18 0
CONF_MATL Cross-Plant Configurable Material SATNR MARA CHAR 18 0
MATL_CAT Material Category ATTYP CHAR 2 0
NULL Single material (industry)
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
CO_PRODUCT Indicator: Material can be co-product KZKUPMAT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
FOLLOW_UP Indicator: The material has a follow-up material KZNFM CHAR 1 0
X Yes
NULL No
PR_REF_MAT Pricing Reference Material PMATN MARA CHAR 18 0
PUR_STATUS Cross-Plant Material Status MSTAE T141 CHAR 2 0
SAL_STATUS Cross-distribution-chain material status MSTAV TVMS 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
TAX_CLASS Tax classification of the material TAKLV TSKM CHAR 1 0
CATPROFILE Catalog Profile RBNR T352B 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
UNCNT Content unit INHME T006 UNIT 3 0
UNCNT_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
NET_CONT Net contents INHAL QUAN 13 3
COMPPRUNIT Comparison price unit VPREH DEC 5 0
MATLABLGRP IS-R Labeling: material grouping (deactivated in 4.0) ETIAG CHAR 18 0
GROSS_CONT Gross contents INHBR QUAN 13 3
CONV_METHD Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
INT_OBJ_NO Internal object number CUOBM NUMC 18 0
ENVT_RLVT Environmentally Relevant KZUMW CHAR 1 0
X Yes
NULL No
PROD_ALLOC Product allocation determination procedure KOSCH T190S CHAR 18 0
PRPROFVAR Pricing profile for variants SPROF CHAR 1 0
NULL 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
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
LOGSYS Logical system LOGSYS CHAR 10 0
MATGUID GUID for Material MATGUID CHAR 32 0
MANU_MAT Manufacturer Part Number MFRPN CHAR 40 0
MFR_NO Number of a Manufacturer MFRNR LFA1 CHAR 10 0
INV_MAT_NO Number of firm's own (internal) inventory-managed material MPMAT MARA CHAR 18 0
MANUF_PROF Manufacturer Part Profile MPROF TMPPF CHAR 4 0
UOMUSAGE Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
SEASMATCAT Rollout in a Season SAITY T6WSA CHAR 2 0
HAZMATPROF Dangerous Goods Indicator Profile ADGE_PROFL TDG41 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
SERLEVEL 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
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
PAR_EFF Assign effectivity parameter values/ override change numbers CC_MTEFF CHAR 1 0
X Yes
NULL No
MATCMPLLVL Material completion level CSCP_COMP_LVL TCSCP_COMP_LVL NUMC 2 0
PRDIND_EXP Period Indicator for Shelf Life Expiration Date DATTP CHAR 1 0
RNDUP_EXP 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)
PROD_COMP Indicator: Product composition printed on packaging PRZUS CHAR 1 0
X Yes
NULL No
ITEM_CAT General item category group MTPOS_MARA TPTM CHAR 4 0
MATERIAL_EXTERN Long Material Number for MATERIAL Field MGV_MATERIAL_EXTERNAL CHAR 40 0
BPART_GUID CHAR32 data element for SYST SYCHAR32 CHAR 32 0

BAPIMATMRA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIMATMRA CATPROFILE BAPIMATMRA CATPROFILE T352B Technical report RBNR
BAPIMATMRA CATPROFILE SYST MANDT T352B Technical report MANDT
BAPIMATMRA COMPETITOR SYST MANDT V_KNA1WETT Generated Table for View MANDT
BAPIMATMRA COMPETITOR BAPIMATMRA COMPETITOR V_KNA1WETT Generated Table for View KUNNR
BAPIMATMRA CONF_MATL SYST MANDT MARA General Material Data MANDT
BAPIMATMRA CONF_MATL BAPIMATMRA CONF_MATL MARA General Material Data MATNR
BAPIMATMRA CONTAINER SYST MANDT T144 Container Requirements for Storing Materials MANDT
BAPIMATMRA CONTAINER BAPIMATMRA CONTAINER T144 Container Requirements for Storing Materials BEHVO
BAPIMATMRA DIVISION BAPIMATMRA DIVISION TSPA Organizational Unit: Sales Divisions SPART
BAPIMATMRA DIVISION SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
BAPIMATMRA DSN_OFFICE SYST MANDT T024L Laboratory/office for material MANDT
BAPIMATMRA DSN_OFFICE BAPIMATMRA DSN_OFFICE T024L Laboratory/office for material LABOR
BAPIMATMRA EAN_CAT SYST MANDT TNTP International Article Number (EAN) Categories MANDT
BAPIMATMRA EAN_CAT BAPIMATMRA EAN_CAT TNTP International Article Number (EAN) Categories NUMTP
BAPIMATMRA HAZMATPROF SYST MANDT TDG41 DG: DG Indicator Profiles for Material Master MANDT
BAPIMATMRA HAZMATPROF BAPIMATMRA HAZMATPROF TDG41 DG: DG Indicator Profiles for Material Master PROFL
BAPIMATMRA HAZ_MAT_NO SYST MANDT MGEF Hazardous materials MANDT
BAPIMATMRA HAZ_MAT_NO BAPIMATMRA HAZ_MAT_NO MGEF Hazardous materials STOFF
BAPIMATMRA HAZ_MAT_NO * MGEF Hazardous materials REGKZ
BAPIMATMRA IND_SECTOR SYST MANDT T137 Industries for materials MANDT
BAPIMATMRA IND_SECTOR BAPIMATMRA IND_SECTOR T137 Industries for materials MBRSH
BAPIMATMRA INV_MAT_NO SYST MANDT MARA General Material Data MANDT
BAPIMATMRA INV_MAT_NO BAPIMATMRA INV_MAT_NO MARA General Material Data MATNR
BAPIMATMRA ITEM_CAT BAPIMATMRA ITEM_CAT TPTM Materials: Item Category Groups in Material Master MTPOS
BAPIMATMRA ITEM_CAT SYST MANDT TPTM Materials: Item Category Groups in Material Master MANDT
BAPIMATMRA LABEL_FORM BAPIMATMRA LABEL_FORM T6WP4 Check Table for Label Shape ETIFO
BAPIMATMRA LABEL_FORM SYST MANDT T6WP4 Check Table for Label Shape MANDT
BAPIMATMRA LABEL_TYPE SYST MANDT T6WP3 Check Table for Labelling Type MANDT
BAPIMATMRA LABEL_TYPE BAPIMATMRA LABEL_TYPE T6WP3 Check Table for Labelling Type ETIAR
BAPIMATMRA MANUF_PROF SYST MANDT TMPPF Control Profile for Manufacturer Part Number Management MANDT
BAPIMATMRA MANUF_PROF BAPIMATMRA MANUF_PROF TMPPF Control Profile for Manufacturer Part Number Management MPROF
BAPIMATMRA MATCMPLLVL SYST MANDT TCSCP_COMP_LVL Material completion levels (including their sequence) MANDT
BAPIMATMRA MATCMPLLVL BAPIMATMRA MATCMPLLVL TCSCP_COMP_LVL Material completion levels (including their sequence) COMP_LEVEL
BAPIMATMRA MATL_GROUP SYST MANDT T023 Material Groups MANDT
BAPIMATMRA MATL_GROUP BAPIMATMRA MATL_GROUP T023 Material Groups MATKL
BAPIMATMRA MATL_TYPE BAPIMATMRA MATL_TYPE T134 Material Types MTART
BAPIMATMRA MATL_TYPE SYST MANDT T134 Material Types MANDT
BAPIMATMRA MAT_GRP_SM SYST MANDT TVEGR Material Group: Packaging Materials MANDT
BAPIMATMRA MAT_GRP_SM BAPIMATMRA MAT_GRP_SM TVEGR Material Group: Packaging Materials MAGRV
BAPIMATMRA MFR_NO SYST MANDT LFA1 Vendor Master (General Section) MANDT
BAPIMATMRA MFR_NO BAPIMATMRA MFR_NO LFA1 Vendor Master (General Section) LIFNR
BAPIMATMRA PRICE_BAND SYST MANDT TWPT Price band categories MANDT
BAPIMATMRA PRICE_BAND BAPIMATMRA PRICE_BAND TWPT Price band categories PLGTP
BAPIMATMRA PROD_ALLOC SYST MANDT T190S Product Allocation: Definition Procedure MANDT
BAPIMATMRA PROD_ALLOC BAPIMATMRA PROD_ALLOC T190S Product Allocation: Definition Procedure KOSCH
BAPIMATMRA PROD_HIER SYST MANDT T179 Materials: Product Hierarchies MANDT
BAPIMATMRA PROD_HIER BAPIMATMRA PROD_HIER T179 Materials: Product Hierarchies PRODH
BAPIMATMRA PR_REF_MAT SYST MANDT MARA General Material Data MANDT
BAPIMATMRA PR_REF_MAT BAPIMATMRA PR_REF_MAT MARA General Material Data MATNR
BAPIMATMRA PUR_STATUS SYST MANDT T141 Material Status from Materials Management/PPC View MANDT
BAPIMATMRA PUR_STATUS BAPIMATMRA PUR_STATUS T141 Material Status from Materials Management/PPC View MMSTA
BAPIMATMRA PUR_VALKEY SYST MANDT T405 Purchasing Value Key MANDT
BAPIMATMRA PUR_VALKEY BAPIMATMRA PUR_VALKEY T405 Purchasing Value Key EKWSL
BAPIMATMRA SAL_STATUS SYST MANDT TVMS Materials: Status in Sales and Distribution MANDT
BAPIMATMRA SAL_STATUS BAPIMATMRA SAL_STATUS TVMS Materials: Status in Sales and Distribution VMSTA
BAPIMATMRA SEASMATCAT SYST MANDT T6WSA Categories of seasonal materials MANDT
BAPIMATMRA SEASMATCAT BAPIMATMRA SEASMATCAT T6WSA Categories of seasonal materials SAITY
BAPIMATMRA SEASON SYST MANDT T6WSP Check Table for Season Indicator MANDT
BAPIMATMRA SEASON BAPIMATMRA SEASON T6WSP Check Table for Season Indicator SAISO
BAPIMATMRA SH_MAT_TYP SYST MANDT TVTY Packaging Material Types MANDT
BAPIMATMRA SH_MAT_TYP BAPIMATMRA SH_MAT_TYP TVTY Packaging Material Types TRATY
BAPIMATMRA STOR_CONDS BAPIMATMRA STOR_CONDS T142 Storage Conditions for Materials RAUBE
BAPIMATMRA STOR_CONDS SYST MANDT T142 Storage Conditions for Materials MANDT
BAPIMATMRA SUP_SOURCE BAPIMATMRA SUP_SOURCE TMBW1 Source of Supply Keys BWSCL
BAPIMATMRA SUP_SOURCE SYST MANDT TMBW1 Source of Supply Keys MANDT
BAPIMATMRA TAX_CLASS SYST MANDT TSKM Material Taxes MANDT
BAPIMATMRA TAX_CLASS * TSKM Material Taxes TATYP
BAPIMATMRA TAX_CLASS BAPIMATMRA TAX_CLASS TSKM Material Taxes TAXKM
BAPIMATMRA TEMP_CONDS SYST MANDT T143 Temperature Conditions for Storing Materials MANDT
BAPIMATMRA TEMP_CONDS BAPIMATMRA TEMP_CONDS T143 Temperature Conditions for Storing Materials TEMPB
BAPIMATMRA TRANS_GRP SYST MANDT TTGR Delivery Scheduling: Transportation Groups MANDT
BAPIMATMRA TRANS_GRP BAPIMATMRA TRANS_GRP TTGR Delivery Scheduling: Transportation Groups TRAGR
BAPIMATMRA UNBASE SYST MANDT T006 Units of Measurement MANDT
BAPIMATMRA UNBASE BAPIMATMRA UNBASE T006 Units of Measurement MSEHI
BAPIMATMRA UNCNT SYST MANDT T006 Units of Measurement MANDT
BAPIMATMRA UNCNT BAPIMATMRA UNCNT T006 Units of Measurement MSEHI
BAPIMATMRA UNDIM BAPIMATMRA UNDIM T006 Units of Measurement MSEHI
BAPIMATMRA UNDIM SYST MANDT T006 Units of Measurement MANDT
BAPIMATMRA UNITPO SYST MANDT T006 Units of Measurement MANDT
BAPIMATMRA UNITPO BAPIMATMRA UNITPO T006 Units of Measurement MSEHI
BAPIMATMRA UNITWT SYST MANDT T006 Units of Measurement MANDT
BAPIMATMRA UNITWT BAPIMATMRA UNITWT T006 Units of Measurement MSEHI
BAPIMATMRA UNPVO BAPIMATMRA UNPVO T006 Units of Measurement MSEHI
BAPIMATMRA UNPVO SYST MANDT T006 Units of Measurement MANDT
BAPIMATMRA UNPWT SYST MANDT T006 Units of Measurement MANDT
BAPIMATMRA UNPWT BAPIMATMRA UNPWT T006 Units of Measurement MSEHI
BAPIMATMRA UNVOL SYST MANDT T006 Units of Measurement MANDT
BAPIMATMRA UNVOL BAPIMATMRA UNVOL T006 Units of Measurement MSEHI