stock tables and stock type

Stock tables

Table	Description	SOBKZ
MARC	Plant Data for Material
MARD	Storage Location Data for Material
MCHB	Batch Stocks
MSSL	Total Special Stocks with Vendor	O
MSLB	Special Stocks with Vendor	O
MSKU	Special Stocks with Customer	V,W
MSSA	Total Customer Orders on Hand	E
MSKA	Sales Order Stock	E
MSSQ	Project Stock Total	Q
MSPR	Project Stock	Q
MKOL	Special Stocks from Vendor	K,M

Valuation Tables

Table	Description
MBEW	Material Valuation
EBEW	Sales Order Stock Valuation
QBEW	Project Stock Valuation
OBEW	Valuated Stock with Subcontractor (only for Japan)

Document Tables

Table	Meaning	Key fields
MKPF	Header: Material Document	Document number (MBLNR), year (MJAHR)
MSEG	Material Document - segments/ lines	Document number (MBLNR), year (MJAHR), line number (ZEILE)
BSIM	Index for material to the FI-documents	Material (MATNR), Valuation Area (BWKEY)...
CKMI1	Material ledger index, used to document changes in MBEW for each movement	KALNR, use mbew-kaln1

All Stocks

Table	Field	Meaning	Valuated in	Total in table	History table	Posted with
MARC		Plant Data for Material
MARC	UMLMC	Stock in transfer (plant to plant)	MBEW		MARCH	Transfer without PO, 303 / 305
MARC	TRAME	Stock in transit	MBEW		MARCH	Transfer with PO, 351 / 101, 641
MARC	GLGMG	Tied empties stock	MBEW		MARCH
MARC	VKUMC	Stock transfer sales value (plant to plant) for VO material	MBEW		MARCH
MARC	VKTRW	Transit value at sales price for value-only material	MBEW		MARCH
MARC	BWESB	Valuated Goods Receipt Blocked Stock	MBEW		MARCH
MARD		Storage Location Data for Material
MARD	LABST	Valuated stock with unrestricted use	MBEW		MARDH
MARD	UMLME	Stock in transfer (from one storage location to another)	MBEW		MARDH	313 / 315
MARD	INSME	Stock in quality inspection	MBEW		MARDH
MARD	EINME	Total Stock of All Restricted Batches	MBEW		MARDH
MARD	SPEME	Blocked stock	MBEW		MARDH
MARD	RETME	Blocked Stock Returns			MARDH
MARD	KLABS	Unrestricted-use consignment stock
MARD	KINSM	Consignment stock in quality inspection
MARD	KEINM	Restricted-use consignment stock
MARD	KSPEM	Blocked consignment stock
MCHB		Batch Stocks
MCHB	CLABS	Valuated stock with unrestricted use	MBEW	MARD-LABST	MCHBH
MCHB	CUMLM	Stock in transfer (from one storage location to another)	MBEW	MARD-UMLME	MCHBH
MCHB	CINSM	Stock in quality inspection	MBEW	MARD-INSME	MCHBH
MCHB	CEINM	Total Stock of All Restricted Batches	MBEW	MARD-EINME	MCHBH
MCHB	CSPEM	Blocked stock	MBEW	MARD-SPEME	MCHBH
MCHB	CRETM	Blocked Stock Returns		MARD-RETME	MCHBH
MSSL		Total Special Stocks with Vendor
MSSL	SLLB	Valuated stock with unrestricted use	MBEW**
MSSL	SLINS	Stock in quality inspection	MBEW**
MSSL	SLEIN	Total Stock of All Restricted Batches	MBEW**
MSLB		Special Stocks with Vendor
MSLB	LBLAB	Valuated stock with unrestricted use	MBEW	MSSL-SLLAB	MSLBH
MSLB	LBINS	Stock in quality inspection	MBEW	MSSL-SLINS	MSLBH
MSLB	LBEIN	Total Stock of All Restricted Batches	MBEW	MSSL-SLEIN	MSLBH
MSKU		Special Stocks with Customer
MSKU	KULAB	Valuated stock with unrestricted use	MBEW		MSKUH
MSKU	KUINS	Stock in quality inspection	MBEW		MSKUH
MSKU	KUEIN	Total Stock of All Restricted Batches	MBEW		MSKUH
MSSA		Total Customer Orders on Hand
MSSA	SALAB	Total Customer Orders on Hand	EBEW* MBEW+
MSSA	SAINS	Stock in quality inspection	EBEW* MBEW+
MSSA	SASPE	Blocked stock	EBEW* MBEW+
MSSA	SAEIN	Total Stock of All Restricted Batches	EBEW* MBEW+
MSSA	SATRA	Stock in transit	EBEW* MBEW+		MSSAH
MSKA		Sales Order Stock
MSKA	KALAB	Total Customer Orders on Hand	EBEW* MBEW+	MSSA-SALAB	MSKAH
MSKA	KAINS	Stock in quality inspection	EBEW* MBEW+	MSSA-SAINS	MSKAH
MSKA	KASPE	Blocked stock	EBEW* MBEW+	MSSA-SASPE	MSKAH
MSKA	KAEIN	Total Stock of All Restricted Batches	EBEW* MBEW+	MSSA-SAEIN	MSKAH
MSSQ		Project Stock Total
MSSQ	SQLAB	Total Customer Orders on Hand	QBEW* MBEW+
MSSQ	SQINS	Stock in quality inspection	QBEW* MBEW+
MSSQ	SQSPE	Blocked stock	QBEW* MBEW+
MSSQ	SQEIN	Total Stock of All Restricted Batches	QBEW* MBEW+
MSSQ	SQTRA	Stock in transit	QBEW* MBEW+		MSSQH
MSPR		Project Stock
MSPR	PRLAB	Total Customer Orders on Hand	QBEW* MBEW+	MSSQ-SQLAB	MSPRH
MSPR	PRINS	Stock in quality inspection	QBEW* MBEW+	MSSQ-SQINS	MSPRH
MSPR	PRSPE	Blocked stock	QBEW* MBEW+	MSSQ-SQSPE	MSPRH
MSPR	PREIN	Total Stock of All Restricted Batches	QBEW* MBEW+	MSSQ-SQEIN	MSPRH
MKOL		Special Stocks from Vendor
MKOL	SLABS	Unrestricted-use consignment stock		MARD-KLABS	MKOLH
MKOL	SINSM	Consignment stock in quality inspection		MARD-KINSM	MKOLH
MKOL	SEINM	Restricted-use consignment stock		MARD-KEINM	MKOLH
MKOL	SSPEM	Blocked consignment stock		MARD-KSPEM	MKOLH

* only if MSSA/MSSQ - KZBWS = 'M'
+ only if MSSA/MSSQ - KZBWS = 'A'
** if MSSL-XOBEW = 'X' valuated in table OBEW (only for Japan from 4.6 on)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11782589/viewspace-718394/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11782589/viewspace-718394/