I_CN_MaterialStockDetail

China Stock Details for Material | view: ICNMATSTKDETAIL | Extraction: Not supported | Component: S4HANA Localization for China
Tables used: ACDOCAMATDOCMARAT001WT001TKA02T156HTMARAT023TMAKTT134TMARAMARVT001T001KT001LMBEWFMLT_CURTP_ML
Column Name Description
MaterialDocument Number of Material Document
MaterialDocumentYear Material Document Year
MaterialDocumentItem Material Document Item
AccountingDocument Document Number of an Accounting Document
GLAccountLineItem Six-Character Posting Item for Ledger
FiscalYear Fiscal Year
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
StandardPriceInCoCodeCrcy Standard price
GoodsMovementStkAmtInCCCrcy Amount in Local Currency with Sign of Stock Quantity
MatlStkIncrQtyAmountInCCCrcy Amount in Local Currency with Sign of Stock Quantity
MatlStkDecrQtyAmountInCCCrcy Amount in Local Currency with Sign of Stock Quantity
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MatlStkChangeQtyInBaseUnit Inventory Quantity
MatlStkIncrQtyInMatlBaseUnit Stock Quantity
MatlStkDecrQtyInMatlBaseUnit Stock Quantity
Column Name Description
PostingDate Posting Date in the Document
CurrentDate null
Column Name Description
Column Name Description Domain name
StockIdentifyingMaterial Material in Respect of Which Stock is Managed MATNR
Plant Plant WERKS
StockIdfgStorageLocation Storage Location (Stock Identifier) LGORT
StockIdentifyingBatch Batch Number (Stock Identifier) CHARG
CompanyCode Company Code BUKRS
InventorySpecialStockType Special Stock Type SOBKZ
MaterialGroupName Product Group Description
MaterialTypeName Description of Material Type
GoodsMovementType Movement type (inventory management) BWART
GoodsMovementTypeName Movement Type Text (Inventory Management)
InventoryValuationType Valuation Type BWTAR
MaterialDescription Material Description TEXT40
CompanyCodeName Name of Company Code or Company
PlantName Name
StorageLocationName Storage Location Name
AccountingDocumentItem Number of Line Item Within Accounting Document
AccountingDocumentIsExcluded null
IsCrossPlantTransfer Is Cross Plant Transfer
IsStorageLocChangeByTransf Is Storage Location Change
IsBatchChangeByTransf Batch Change by Transfer
Master Data Relations Join Conditions
Material Group
  • Client
  • Material Group
  • I_CN_MATERIALSTOCKDETAIL.MANDT == T023.MANDT
  • I_CN_MATERIALSTOCKDETAIL.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • I_CN_MATERIALSTOCKDETAIL.MANDT == T134.MANDT
  • I_CN_MATERIALSTOCKDETAIL.MATERIALTYPE == T134.MTART