SAP table BAPIMATMRA (BAPI CRS Structure for MARA (Material))

Field Description Data Type Length Decimals Checktable Data Element
OPERATION Function CHAR 3 0 MSGFN
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
018 Resend
023 Wait/Adjust: Do not import data
MATERIAL Material Number (18 Characters) CHAR 18 0 MATNR18
CREATED_ON Created On DATS 8 0 ERSDA
CREATED_BY Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
LAST_CHNGE Date of Last Change DATS 8 0 LAEDA
CHANGED_BY Name of Person Who Changed Object CHAR 12 0 AENAM
MAINT_STAT Maintenance status of complete material CHAR 15 0 VPSTA
STATUS Maintenance status CHAR 15 0 PSTAT_D
DEL_FLAG Flag Material for Deletion at Client Level CHAR 1 0 LVOMA
MATL_TYPE Material type CHAR 4 0 T134 MTART
IND_SECTOR Industry Sector CHAR 1 0 T137 MBRSH
MATL_GROUP Material Group CHAR 9 0 T023 MATKL
OLD_MAT_NO Old Material Number (18 Characters, Compatibility Mode) CHAR 18 0 BISMT18
UNBASE Base Unit of Measure UNIT 3 0 T006 MEINS
UNBASE_ISO ISO code for unit of measurement CHAR 3 0 ISOCD_UNIT
UNITPO Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
UNITPO_ISO ISO code for unit of measurement CHAR 3 0 ISOCD_UNIT
DOCUMENT Document number (without document management system) CHAR 22 0 DZEINR
DOC_TYPE Document type (without Document Management system) CHAR 3 0 DZEIAR
DOC_VERS Document version (without Document Management system) CHAR 2 0 DZEIVR
DOC_FORMAT Page format of document (without Document Management system) CHAR 4 0 DZEIFO
DOC_CHG_NO Document change number (without document management system) CHAR 6 0 AESZN
PAGE_NO Page number of document (without Document Management system) CHAR 3 0 BLATT
NO_SHEETS Number of sheets (without Document Management system) NUMC 3 0 BLANZ
PROD_MEMO Production/inspection memo CHAR 18 0 FERTH
PAGEFORMAT Page Format of Production Memo CHAR 4 0 FORMT
SIZE_DIM Size/dimensions CHAR 32 0 GROES
BASIC_MATL Basic Material (Basic Constituent of a Material) CHAR 48 0 CRMWRKST
STD_DESCR Industry Standard Description (such as ANSI or ISO) CHAR 18 0 NORMT
DSN_OFFICE Laboratory/design office CHAR 3 0 T024L LABOR
PUR_VALKEY Purchasing Value Key CHAR 4 0 T405 EKWSL
GROSS_WT Gross weight QUAN 13 3 BRGEW
NET_WEIGHT Net weight QUAN 13 3 NTGEW
UNITWT Weight Unit UNIT 3 0 T006 GEWEI
UNITWT_ISO ISO code for unit of measurement CHAR 3 0 ISOCD_UNIT
VOLUME Volume QUAN 13 3 VOLUM
UNVOL Volume unit UNIT 3 0 T006 VOLEH
UNVOL_ISO ISO code for unit of measurement CHAR 3 0 ISOCD_UNIT
CONTAINER Container requirements CHAR 2 0 T144 BEHVO
STOR_CONDS Storage conditions CHAR 2 0 T142 RAUBE
TEMP_CONDS Temperature conditions indicator CHAR 2 0 T143 TEMPB
L_L_CODE Low-Level Code CHAR 3 0 DISST
TRANS_GRP Transportation Group CHAR 4 0 TTGR TRAGR
HAZ_MAT_NO Hazardous material number (18 char.) CHAR 18 0 STOFF18
DIVISION Division CHAR 2 0 TSPA SPART
COMPETITOR Competitor CHAR 10 0 V_KNA1WETT WETTB
EUR_ART_NR European Article Number (EAN) - obsolete!!!!! CHAR 13 0 EANNR
QTY_GR_GI Quantity: Number of GR/GI slips to be printed QUAN 13 3 WESCH
PROC_RULE Procurement rule CHAR 1 0 BWVOR
SUP_SOURCE Source of Supply CHAR 1 0 TMBW1 BWSCL
SEASON Season Category CHAR 4 0 T6WSP SAISO
LABEL_TYPE Label type CHAR 2 0 T6WP3 ETIAR
LABEL_FORM Label form CHAR 2 0 T6WP4 ETIFO
DUMMYENTAR Deactivated CHAR 1 0 DUMMYENTAR
EAN_UPC International Article Number (EAN/UPC) CHAR 18 0 EAN11
EAN_CAT Category of International Article Number (EAN) CHAR 2 0 TNTP NUMTP
LENGTH Length QUAN 13 3 LAENG
WIDTH Width QUAN 13 3 BREIT
HEIGHT Height QUAN 13 3 HOEHE
UNDIM Unit of Dimension for Length/Width/Height UNIT 3 0 T006 MEABM
UNDIM_ISO ISO code for unit of measurement CHAR 3 0 ISOCD_UNIT
PROD_HIER Product hierarchy CHAR 18 0 T179 PRODH_D
NET_CHANGE Stock Transfer Net Change Costing CHAR 1 0 CK_AEKLK
CAD_ID CAD Indicator CHAR 1 0 CADKZ
QM_PROCMNT QM in Procurement Is Active CHAR 1 0 QMPUR
ALLOWED_WT Allowed packaging weight QUAN 13 3 ERGEW
UNPWT Unit of weight (allowed packaging weight) UNIT 3 0 T006 ERGEI
UNPWT_ISO ISO code for unit of measurement CHAR 3 0 ISOCD_UNIT
ALLWD_VOL Allowed packaging volume QUAN 13 3 ERVOL
UNPVO Volume unit (allowed packaging volume) UNIT 3 0 T006 ERVOE
UNPVO_ISO ISO code for unit of measurement CHAR 3 0 ISOCD_UNIT
WT_TOL_LT Excess Weight Tolerance for Handling unit DEC 3 1 GEWTO
VOL_TOL_LT Excess Volume Tolerance of the Handling Unit DEC 3 1 VOLTO
VAR_ORD_UN Variable Purchase Order Unit Active CHAR 1 0 VABME
Not active
1 Active
2 Active with own price
REV_LEV Revision Level Has Been Assigned to the Material CHAR 1 0 KZREV
CONFIGURED Configurable Material CHAR 1 0 KZKFG
BATCH_MGMT Batch Management Requirement Indicator CHAR 1 0 XCHPF
SH_MAT_TYP Packaging Material Type CHAR 4 0 TVTY VHIART
FILL_LEVEL Maximum level (by volume) DEC 3 0 FUELG
STACK_FACT Stacking factor INT2 5 0 STFAK
MAT_GRP_SM Material Group: Packaging Materials CHAR 4 0 TVEGR MAGRV
AUTHRTYGRP Authorization Group CHAR 4 0 BEGRU
VALID_FROM Valid-From Date DATS 8 0 DATAB
DELN_DATE Deletion date DATS 8 0 LIQDT
SEASON_YR Season Year CHAR 4 0 SAISJ
PRICE_BAND Price Band Category CHAR 2 0 TWPT PLGTP
EMPTIESBOM Empties Bill of Material CHAR 1 0 W_MITLEERG
EXTMATLGRP External Material Group CHAR 18 0 EXTWG
CONF_MATL Cross-Plant Configurable Material (18 ch compatibility mode) CHAR 18 0 SATNR18
MATL_CAT 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
CO_PRODUCT Indicator: Material can be co-product CHAR 1 0 KZKUPMAT
FOLLOW_UP Indicator: The material has a follow-up material CHAR 1 0 KZNFM
PR_REF_MAT Pricing Reference Material CHAR 18 0 PMATN18
PUR_STATUS Cross-Plant Material Status CHAR 2 0 T141 MSTAE
SAL_STATUS Cross-distribution-chain material status CHAR 2 0 TVMS MSTAV
PVALIDFROM Date from which the cross-plant material status is valid DATS 8 0 MSTDE
SVALIDFROM Date from which the X-distr.-chain material status is valid DATS 8 0 MSTDV
TAX_CLASS Tax classification of the material CHAR 1 0 TSKM TAKLV
CATPROFILE Catalog Profile CHAR 9 0 T352B RBNR
MINREMLIFE Minimum Remaining Shelf Life DEC 4 0 MHDRZ
SHELF_LIFE Total shelf life DEC 4 0 MHDHB
STOR_PCT Storage percentage DEC 3 0 MHDLP
UNCNT Content unit UNIT 3 0 T006 INHME
UNCNT_ISO ISO code for unit of measurement CHAR 3 0 ISOCD_UNIT
NET_CONT Net contents QUAN 13 3 INHAL
COMPPRUNIT Comparison price unit DEC 5 0 VPREH
MATLABLGRP IS-R Labeling: material grouping (deactivated in 4.0) CHAR 18 0 ETIAG
GROSS_CONT Gross contents QUAN 13 3 INHBR
CONV_METHD 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)
INT_OBJ_NO Internal object number NUMC 18 0 CUOBM
ENVT_RLVT Environmentally Relevant CHAR 1 0 KZUMW
PROD_ALLOC Product allocation determination procedure CHAR 18 0 T190S KOSCH
PRPROFVAR 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
QUAL_DIK 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
LOGSYS Logical system CHAR 10 0 LOGSYS
MATGUID GUID for Material CHAR 32 0 MATGUID
MANU_MAT Manufacturer Part Number CHAR 40 0 MFRPN
MFR_NO Manufacturer number CHAR 10 0 LFA1 MFRNR
INV_MAT_NO Number of firm's own (internal) inventory-managed material CHAR 18 0 MPMAT18
MANUF_PROF Mfr part profile CHAR 4 0 TMPPF MPROF
UOMUSAGE Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
SEASMATCAT Rollout in a Season CHAR 2 0 T6WSA SAITY
HAZMATPROF Dangerous Goods Indicator Profile CHAR 3 0 TDG41 ADGE_PROFL
HIGH_VISC Indicator: Highly Viscous CHAR 1 0 ADGE_IHIVI
LOOSEORLIQ Indicator: In Bulk/Liquid CHAR 1 0 ADGE_ILOOS
SERLEVEL Level of Explicitness for Serial Number CHAR 1 0 SERLV
Serialization within the stock material number
1 Keep equipment number and serial number synchronous
CLOSED_BOX Packaging Material is Closed Packaging CHAR 1 0 KZGVH
APPD_B_REC Approved Batch Record Required CHAR 1 0 XGCHP
PAR_EFF Assign effectivity parameter values/ override change numbers CHAR 1 0 CC_MTEFF
MATCMPLLVL Material completion level NUMC 2 0 TCSCP_COMP_LVL CSCP_COMP_LVL
PRDIND_EXP Period Indicator for Shelf Life Expiration Date CHAR 1 0 DATTP
Day
1 Week
2 Month
3 Year
RNDUP_EXP 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)
PROD_COMP Indicator: Product composition printed on packaging CHAR 1 0 PRZUS
ITEM_CAT General item category group CHAR 4 0 TPTM MTPOS_MARA
MATERIAL_EXTERN Long Material Number for MATERIAL Field CHAR 40 0 MGV_MATERIAL_EXTERNAL
BPART_GUID CHAR32 for SYST CHAR 32 0 SYCHAR32
MATERIAL_LONG Material No. CHAR 40 0 MATNR40
OLD_MAT_NO_LONG Old material number (40 Characters, Technical Requirement) CHAR 40 0 BISMT40
HAZ_MAT_NO_LONG Hazardous material number (40 char.) CHAR 40 0 STOFF40
CONF_MATL_LONG Cross-Plant Configurable Material (40 ch tech. necessary) CHAR 40 0 SATNR40
PR_REF_MAT_LONG Pricing Reference Material CHAR 40 0 PMATN40
INV_MAT_NO_LONG Number of firm's own (internal) inventory-managed material CHAR 40 0 MPMAT40

BAPIMATMRA foreign key relationships

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