C_CN_MaterialStockSum

China Stock Summary for Material | view: CCNMATSTKSUM | Extraction: Not supported | Component: S4HANA Localization for China
Tables used: ACDOCAMATDOCMARAT001WT001TKA02T156HTMARAT023TMAKTT134TMARAMARVT001T001KT001LMBEWFMLT_CURTP_ML
Column Name Description
StockIdentifyingMaterial Material in Respect of Which Stock is Managed
Plant Plant
StockIdentifyingBatch Batch Number (Stock Identifier)
InventoryValuationType Valuation Type
GoodsMovementType Movement type (inventory management)
StockIdfgStorageLocation Storage Location (Stock Identifier)
MaterialBaseUnit Base Unit of Measure
CompanyCode Company Code
InventorySpecialStockType Special Stock Type
CompanyCodeCurrency Company Code Currency
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
StandardPriceInCoCodeCrcy Standard price
GoodsMovementStkAmtInCCCrcy null
MatlStkDecrQtyAmountInCCCrcy null
PeriodStartStockAmountInCoCrcy null
MatlStkPerdStrtPriceInCCCrcy Amount in Local Currency with Sign of Stock Quantity
PeriodEndStockAmountInCoCrcy null
MatlStkPerdEndPriceInCCCrcy Amount in Local Currency with Sign of Stock Quantity
MatlStkCreditRevalAmtInCCCrcy Credit Revaluation
MatlStkDebitRevalAmtInCCCrcy Debit Revaluation
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MatlStkIncrQtyInMatlBaseUnit null
MatlStkDecrQtyInMatlBaseUnit null
PeriodStartStockQuantity null
PeriodEndStockQuantity null
Column Name Description
Column Name Description
Column Name Description Domain name
MaterialGroupName Product Group Description
MaterialTypeName Description of Material Type
MaterialDescription Material Description TEXT40
CompanyCodeName Name of Company Code or Company
StorageLocationName Storage Location Name
PlantName Name
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
  • C_CN_MATERIALSTOCKSUM.MANDT == T023.MANDT
  • C_CN_MATERIALSTOCKSUM.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • C_CN_MATERIALSTOCKSUM.MANDT == T134.MANDT
  • C_CN_MATERIALSTOCKSUM.MATERIALTYPE == T134.MTART