SAP Table MC03BX0

Extraction MM-BW: Non-Cumulative Initialization

MC03BX0 (Extraction MM-BW: Non-Cumulative Initialization) 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 MC03BX0 to other SAP tables.

Source: MC03BX0 (Extraction MM-BW: Non-Cumulative Initialization)

MC03BX0 table fields

Field Data element Checktable Datatype Length Decimals
ROCANCEL Indicator: Cancel Data Record ROCANCEL CHAR 1 0
X TRUE
NULL FALSE
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
PERIV Fiscal Year Variant PERIV CHAR 2 0
NOPOS Counter for Items MC_NOPOS DEC 3 0
ITEM_CAT EA Retail BW Extr. Enhancement: Item Type WRF_BW_ITEM_CATEGORY NUMC 2 0
00 Original Item
01 Automatically Created Additional Item EA Retail
REC_TYPE EA Retail BW Extr. Enhancement: Data Record Type WRF_BW_RECORD_TYPE NUMC 1 0
0 Item for Structured Material
1 Item for Single Material
ATTYP 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
VLFKZ Plant category VLFKZ CHAR 1 0
A Store
B Distribution Center
SAUTO Item automatically created MB_XAUTO CHAR 1 0
NULL No automatically created item
X General automatically created item
S Component of a structured material
U Component of a structured material in stock transfer
L Standard tied 'empties' material
M Tied 'empties' in transfer (stocks on a material basis)
W Tied 'empties' in transfer (stocks on a value basis)
F Tied 'empties' (full product managed on a value basis)
MATST Structured material STRNR CHAR 18 0
VKSTT Value at Sales Prices Including Value-Added Tax VKWRT CURR 13 2
VKSTA Value at sales prices excluding value-added tax VKWRA CURR 13 2
UMLKZ Indicator: Movement type is stock transfer UMLKZ CHAR 1 0
RETKZ Indicator: Return from call RETKZ CHAR 1 0
X Yes
NULL No
INVKZ Indicator: Movement type is physical inventory INVKZ CHAR 1 0
KORR Indicator: Movement type is inventory correction KORR CHAR 1 0
UMMATKZ Transfer Posting Material to Material UMMATKZ CHAR 1 0
X Yes
NULL No
WAERSST Currency Key WAERS CUKY 5 0