1. Home
  2. Resources
  3. SAP Tables
  4. MC03BF1 - Extraction MM-BW: Goods Movements

SAP Table MC03BF1

Extraction MM-BW: Goods Movements

MC03BF1 (Extraction MM-BW: Goods Movements) 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 MC03BF1 to other SAP tables.

MC03BF1 table fields

Field Data element Checktable Datatype Length Decimals
AKTNR Promotion WAKTION CHAR 10 0
AUFNR Order Number AUFNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
BKLAS Valuation Class BKLAS CHAR 4 0
BLDAT Document Date in Document BLDAT DATS 8 0
BNBTR Delivery costs in local currency MC_BNBTR CURR 15 2
BSTAUS Stock Values in the Logistics Information System BSTAUS CHAR 1 0
NULL Not Defined
A Unrestricted Use
B Quality Inspection
C Blocked Stock Returns
D Blocked Stock
E Restricted-Use
F Stock Transfer
G Material Provided By Customer
H Transit
K Customer Consignment, Unrestricted Use
L Customer Consignment in Quality Inspection
M Customer Consignment, Restricted Use
N Customer Returnable Packaging, Unrestricted Use
O Customer Returnable Packaging in Quality Inspection
P Customer Returnable Packaging, Restricted Use
Q Unrestricted-Use Material(s) Provided to Vendor
R Materials Provided to Vendor in Quality Inspection
S Stock of Material Provided to Vendor, Restricted Use
T Tied Empties
V Consumption
W Valuated Goods Receipt Blocked Stock
U Stock in Transfer for Subcontracting (Plant to Plant)
X Stock in Transfer for Customer Consignment (Plant to Plant)
BSTTYP Stock categories in the Logistics Information System BSTTYP CHAR 1 0
NULL Valuated Stock
K Vendor Consignment
E Sales Order Stock
Q Project Stock
M Returnable Transport Packaging
R Blocked Stock Returns
V Consumption
U Non-Valuated Stock
T Issuing Stock in Transit
B Customer Stock
BUDAT Posting Date in the Document BUDAT DATS 8 0
BUKRS Company Code BUKRS CHAR 4 0
BWAPPLNM Application Component RSAPPLNM CHAR 30 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
BWBREL BW: Stock Relevance MCBW_BREL CHAR 1 0
BWCOUNTER BW: Unique Identification of Line Item MCBW_COUNTER NUMC 6 0
BWGEO BW: Cost Value in Local Currency MCBW_GEO CURR 19 2
BWGVO BW: Retail Value in Local Currency MCBW_GVO CURR 19 2
BWGVP BW: Retail Value with Tax in Local Currency MCBW_GVP CURR 19 2
BWKEY Valuation Area BWKEY CHAR 4 0
BWMNG BW: Quantity in Base Unit of Measure MCBW_MNG QUAN 15 3
BWPSPEX Work Breakdown Structure Element (External) PS_PSPEX CHAR 24 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
BWVORG SAP BW transaction key MCW_BWVORG NUMC 3 0
CHARG Batch Number CHARG_D CHAR 10 0
DMBTR Amount in local currency MC_DMBTR CURR 15 2
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
ERFME Unit of Entry ERFME UNIT 3 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
GRUND Reason for goods movment MB_GRUND NUMC 4 0
GSBER Business Area GSBER CHAR 4 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KOKRS Controlling Area KOKRS CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
KSTRG Cost Object KSTRG CHAR 12 0
KUNNR Account Number of Customer EKUNN CHAR 10 0
KZBEW Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
LGORT Storage Location LGORT_D CHAR 4 0
LGPLA Storage Bin LGPLA CHAR 10 0
LGTYP Storage Type LGTYP CHAR 3 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
MATNR Material Number MATNR CHAR 18 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MEINS Base Unit of Measure MEINS UNIT 3 0
MENGE Quantity MC_MENG QUAN 15 3
MJAHR Material Document Year MJAHR NUMC 4 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
PALAN WMS Number of pallets PALAN DEC 11 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRCTR Profit Center PRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
SAKTO G/L Account Number SAKNR CHAR 10 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
UMWRK Receiving/Issuing Plant UMWRK CHAR 4 0
WAERS Local Currency HWAER CUKY 5 0
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12 0
WERKS Plant WERKS_D CHAR 4 0
ZEILE Item in Material Document MBLPO NUMC 4 0