SAP table MC03BX0 (Extraction MM-BW: Non-Cumulative Initialization)

Field Description Data Type Length Decimals Checktable Data Element
ROCANCEL Indicator: Cancel Data Record CHAR 1 0 ROCANCEL
AKTNR Promotion CHAR 10 0 * WAKTION
AUFNR Order Number CHAR 12 0 * AUFNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
BKLAS Valuation Class CHAR 4 0 * BKLAS
BLDAT Document Date in Document DATS 8 0 BLDAT
BNBTR Delivery costs in local currency CURR 15 2 MC_BNBTR
BSTAUS Stock Values in the Logistics Information System CHAR 1 0 BSTAUS
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
U Stock in Transfer for Subcontracting (Plant to Plant)
V Consumption
W Valuated Goods Receipt Blocked Stock
X Stock in Transfer for Customer Consignment (Plant to Plant)
BSTTYP Stock categories in the Logistics Information System CHAR 1 0 BSTTYP
Valuated Stock
B Customer Stock
E Sales Order Stock
K Vendor Consignment
M Returnable Transport Packaging
Q Project Stock
R Blocked Stock Returns
T Issuing Stock in Transit
U Non-Valuated Stock
V Consumption
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BUKRS Company Code CHAR 4 0 BUKRS
BWAPPLNM Application Component CHAR 30 0 RSAPPLNM
BWART Movement type (inventory management) CHAR 3 0 * BWART
BWBREL BW: Stock Relevance CHAR 1 0 MCBW_BREL
BWCOUNTER BW: Unique Identification of Line Item NUMC 6 0 MCBW_COUNTER
BWGEO BW: Cost Value in Local Currency CURR 19 2 MCBW_GEO
BWGVO BW: Retail Value in Local Currency CURR 19 2 MCBW_GVO
BWGVP BW: Retail Value with Tax in Local Currency CURR 19 2 MCBW_GVP
BWKEY Valuation area CHAR 4 0 * BWKEY
BWMNG BW: Quantity in Base Unit of Measure QUAN 15 3 MCBW_MNG
BWPSPEX Work Breakdown Structure Element (External) CHAR 24 0 PS_PSPEX
BWTAR Valuation Type CHAR 10 0 * BWTAR_D
BWVORG SAP BW transaction key NUMC 3 0 MCW_BWVORG
CHARG Batch Number CHAR 10 0 * CHARG_D
DMBTR Amount in local currency CURR 15 2 MC_DMBTR
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 * EBELP
ERFME Unit of entry UNIT 3 0 * ERFME
ERFMG Quantity in unit of entry QUAN 13 3 ERFMG
GRUND Reason for goods movment NUMC 4 0 MB_GRUND
GSBER Business Area CHAR 4 0 * GSBER
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDEIN Delivery schedule for sales order NUMC 4 0 KDEIN
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
KOKRS Controlling Area CHAR 4 0 * KOKRS
KOSTL Cost Center CHAR 10 0 * KOSTL
KSTRG Cost Object CHAR 12 0 * KSTRG
KUNNR Account number of customer CHAR 10 0 * EKUNN
KZBEW Movement Indicator CHAR 1 0 KZBEW
Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
K Goods movement for kanban requirement (WM - internal only)
L Goods movement for delivery note
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 * LGNUM
LGORT Storage location CHAR 4 0 * LGORT_D
LGPLA Storage Bin CHAR 10 0 LGPLA
LGTYP Storage Type CHAR 3 0 LGTYP
LIFNR Vendor's account number CHAR 10 0 ELIFN
MATNR Material Number CHAR 40 0 MATNR
MBLNR Number of Material Document CHAR 10 0 MBLNR
MEINS Base Unit of Measure UNIT 3 0 * MEINS
MENGE Quantity QUAN 15 3 MC_MENG
MJAHR Material Document Year NUMC 4 0 MJAHR
NPLNR Network Number for Account Assignment CHAR 12 0 * NPLNR
PALAN WMS Number of pallets DEC 11 0 PALAN
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRCTR Profit Center CHAR 10 0 PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
SAKTO G/L Account Number CHAR 10 0 SAKNR
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
SOBKZ Special Stock Indicator CHAR 1 0 * SOBKZ
UMWRK Receiving plant/issuing plant CHAR 4 0 * UMWRK
WAERS Local Currency CUKY 5 0 * HWAER
WEMPF Goods Recipient CHAR 12 0 WEMPF
WERKS Plant CHAR 4 0 WERKS_D
ZEILE Item in Material Document NUMC 4 0 MBLPO
PERIV Fiscal Year Variant CHAR 2 0 * PERIV
NOPOS Counter for Items DEC 3 0 MC_NOPOS
ITEM_CAT EA Retail BW Extr. Enhancement: Item Type NUMC 2 0 WRF_BW_ITEM_CATEGORY
00 Original Item
01 Automatically Created Additional Item EA Retail
REC_TYPE EA Retail BW Extr. Enhancement: Data Record Type NUMC 1 0 WRF_BW_RECORD_TYPE
0 Item for Structured Material
1 Item for Single Material
ATTYP 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
VLFKZ Plant category CHAR 1 0 VLFKZ
A Store
B Distribution Center
SAUTO Item automatically created CHAR 1 0 MB_XAUTO
No automatically created item
F Tied 'empties' (full product managed on a value basis)
L Standard tied 'empties' material
M Tied 'empties' in transfer (stocks on a material basis)
S Component of a structured material
U Component of a structured material in stock transfer
W Tied 'empties' in transfer (stocks on a value basis)
X General automatically created item
MATST Structured material CHAR 40 0 * STRNR
VKSTT Value at Sales Prices Including Value-Added Tax CURR 13 2 VKWRT
VKSTA Value at Sales Prices Excluding Value Added Tax CURR 13 2 VKWRA
UMLKZ Indicator: Movement type is stock transfer CHAR 1 0 UMLKZ
RETKZ Indicator: Return from call CHAR 1 0 RETKZ
INVKZ Indicator: Movement type is physical inventory CHAR 1 0 INVKZ
KORR Indicator: Movement type is inventory correction CHAR 1 0 KORR
UMMATKZ Transfer Posting Material to Material CHAR 1 0 UMMATKZ
WAERSST Currency Key CUKY 5 0 * WAERS