SAP Table MCBIWSTOCK

Extractor Structure for BW Stock Initialization

MCBIWSTOCK (Extractor Structure for BW Stock 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 MCBIWSTOCK to other SAP tables.

MCBIWSTOCK table fields

Field Data element Checktable Datatype Length Decimals
WERKS Plant WERKS_D CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
SPTAG Period to analyze - current date SPTAG DATS 8 0
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
BSTAUS BW: Stock Characteristic Value MCBW_BAUS CHAR 1 0
NULL Undefined
A Unrestr.-use stock
B Quality inspection
C Blocked Stock Returns
D Locked
E Restricted-use stock
F Stock Transfer
G Mat.prov.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 (Transit)
U Subcontractor, Stock in Transfer (Plant-Plant)
X Customer Consignment, Stock in Transfer (Plant-Plant)
LIFNR Vendor Account Number ELIFN CHAR 10 0
KUNNR Account Number of Customer EKUNN CHAR 10 0
LGORT Storage Location LGORT_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
VBELN Sales Order Number with Special Stocks MCBW_VBELN CHAR 10 0
POSNR Sales Order Item with Special Stocks MCBW_POSNR NUMC 6 0
PSPNR Project Structure Plan Item with Special Stocks MCBW_PSPNR NUMC 8 0
BASME Base Unit of Measure MEINS UNIT 3 0
HWAER Local Currency HWAER CUKY 5 0
MTART Material Type MTART CHAR 4 0
BWKEY Valuation Area BWKEY CHAR 4 0
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
BWMNG BW: Quantity in Base Unit of Measure MCBW_MNG QUAN 15 3
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
BKLAS Valuation Class BKLAS CHAR 4 0