SAP Table BAPIMATMRD

BAPI CRS Structure for MARD (Material)

BAPIMATMRD (BAPI CRS Structure for MARD (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 BAPIMATMRD to other SAP tables.

BAPIMATMRD 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 MARA CHAR 18 0
PLANT Plant WERKS_D MARC CHAR 4 0
STGE_LOC Storage Location LGORT_D T001L CHAR 4 0
MAINT_STAT Maintenance status PSTAT_D CHAR 15 0
DEL_FLAG Flag Material for Deletion at Storage Location Level LVOLG CHAR 1 0
X Yes
NULL No
FISC_YEAR Fiscal Year of Current Period LFGJA NUMC 4 0
PERIOD Current period (posting period) LFMON NUMC 2 0
INV_BLOCK Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
UNRESTRSTK Valuated Unrestricted-Use Stock LABST QUAN 13 3
STOCKINTFR Stock in transfer (from one storage location to another) UMLMD QUAN 13 3
QUINSPSTCK Stock in Quality Inspection INSME QUAN 13 3
RESTR_USE Total Stock of All Restricted Batches EINME QUAN 13 3
STOCKBLOCK Blocked Stock SPEME QUAN 13 3
STKBLKRET Blocked Stock Returns RETME QUAN 13 3
PUNRESTRST Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
STK_IN_TFR Stock in Transfer in Previous Period VMUML QUAN 13 3
QUAL_INSP Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
PRESTR_USE Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
PPER_BLOCK Blocked stock of previous period VMSPE QUAN 13 3
PSTKBLKRET Blocked Stock Returns in Previous Period VMRET QUAN 13 3
WHSE_STOCK Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
QULINSPSTK Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
INVRSTRUSE Physical inventory indicator for restricted-use stock KZILE CHAR 3 0
INDBLOCKED Physical inventory indicator for blocked stock KZILS CHAR 3 0
PWHSE_STCK Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
PQLINSPSTK Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
PINVRSTUSE Physical inventory ind. for restricted-use stock, prev.pd KZVLE CHAR 3 0
INVSTKBLK Phys. inventory indicator for blocked stock in prev. period KZVLS CHAR 3 0
MRP_IND Storage location MRP indicator DISKZ CHAR 1 0
NULL Storage location stock also planned at plant level
1 Storage location stock excluded from MRP
2 Storage location stock planned separately
SPEC_PROC Special procurement type at storage location level LSOBS T460A CHAR 2 0
REORDER_PT Reorder point for storage location MRP LMINB QUAN 13 3
REPL_QTY Replenishment quantity for storage location MRP LBSTF QUAN 13 3
CTRYOR Country of origin of the material HERKL T005 CHAR 3 0
CTRYOR_ISO Country ISO code INTCA CHAR 2 0
PREFERENCE Preference indicator (deactivated) EXPPG CHAR 1 0
EXPORT Export indicator (deactivated) EXVER CHAR 2 0
STGE_BIN Storage Bin LGPBE CHAR 10 0
UNRS_CNSGT Unrestricted-Use Consignment Stock KLABS QUAN 13 3
CNSGT_QINS Consignment Stock in Quality Inspection KINSM QUAN 13 3
RESTRCNSGT Restricted-Use Consignment Stock KEINM QUAN 13 3
BLKD_CNSGT Blocked Consignment Stock KSPEM QUAN 13 3
PHYINVDATE Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
PROFIT_CTR Profit Center PRCTR CHAR 10 0
CREATED_ON Created On ERSDA DATS 8 0
SP_VALUE Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
STCKTR_SP Currency amount for BAPIS (with 9 decimal places) BAPICUREXT DEC 28 9
PICKG_AREA Picking area for lean WM MARD_KOBER CHAR 3 0
INVCORRFAC Inventory correction factor BSKRF FLTP 16 16
PRVMARDHX MARDH rec. already exists for per. before last of MARD per. MDRUE CHAR 1 0
X Yes
NULL No
IND_FISCY Fiscal year of current physical inventory indicator GJINV NUMC 4 0

BAPIMATMRD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIMATMRD CTRYOR SYST MANDT T005 Countries MANDT
BAPIMATMRD CTRYOR BAPIMATMRD CTRYOR T005 Countries LAND1
BAPIMATMRD MATERIAL SYST MANDT MARA General Material Data MANDT
BAPIMATMRD MATERIAL BAPIMATMRD MATERIAL MARA General Material Data MATNR
BAPIMATMRD PLANT BAPIMATMRD MATERIAL MARC Plant Data for Material MATNR
BAPIMATMRD PLANT BAPIMATMRD PLANT MARC Plant Data for Material WERKS
BAPIMATMRD PLANT SYST MANDT MARC Plant Data for Material MANDT
BAPIMATMRD SPEC_PROC SYST MANDT T460A Special procurement key MANDT
BAPIMATMRD SPEC_PROC BAPIMATMRD PLANT T460A Special procurement key WERKS
BAPIMATMRD SPEC_PROC BAPIMATMRD SPEC_PROC T460A Special procurement key SOBSL
BAPIMATMRD STGE_LOC SYST MANDT T001L Storage Locations MANDT
BAPIMATMRD STGE_LOC BAPIMATMRD PLANT T001L Storage Locations WERKS
BAPIMATMRD STGE_LOC BAPIMATMRD STGE_LOC T001L Storage Locations LGORT