C_MaterialKPIForCycleCounting

C View Material KPIs for Cycle Counting | view: CMATKPIFORCYC | TRAN | Extraction: Not supported | Component: VDM Physical Inventory
Column Name Description
Plant FK Plant
Material FK Product Number
Column Name Description
💲 Currency Key (Currency):
StockValueInCCCrcyEnd Stock Value on End Date in Company Code Currency
AvgMatlStkAmountInCompanyCrcy Average Material Value in Company Code Currency
CnsmpnAmountInCCCrcyInPeriod Consumption Value in Reference Period
DifferenceAmtPerYrInCoCodeCrcy Inventory Difference Value per Year in Company Code Currency
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
CnsmpnQtyInBaseUnitInPeriod Consumption Quantity in Reference Period
PInvDiffQtyPerYearInBaseUnit Adjusted Quantity Last 12 Months
Column Name Description
Column Name Description
CycleCountingIndicatorIsFixed Cycle Counting Indicator Fixed Show values
Column Name Description Domain name
PlantName Plant Name TEXT30
MaterialName Product Description TEXT40
MaterialGroupName Material Group Description TEXT20
MaterialTypeName Description of Material Type TEXT25
NmbrOfPhysInvtryPerFiscalYear Physical Inventories per Fiscal Year for Cycle Counting
PhysInvtryIntvlForCycCounting Physical Inventory Interval (in Workdays) for Cycle Counting NUM3
PhysInvtryFloatTimeCycCounting Float Time (in Workdays) for Cycle Counting NUM2
MatlWrhsStkQtyOnEndDate Stock Quantity on End Date in Base Unit of Measure
AvgMatlStkQtyInMatlBaseUnit Average Material Stock Quantity in Base Unit of Measure
InventoryTurnover Inventory Turnover
InvtryDiffToAvgMatlStkRatio Inventory Differences to Average Stock Ratio
StockValueToPlantAverageRatio Stock Value Material to Plant Ratio
InvtryDiffValToPlantAvgRatio Inventory Difference Material to Plant Ratio
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • C_MATERIALKPIFORCYCLECOUNTING.MANDT == TCURC.MANDT
  • C_MATERIALKPIFORCYCLECOUNTING.CURRENCY == TCURC.WAERS
Product Number
  • Product Number
  • Client
  • C_MATERIALKPIFORCYCLECOUNTING.MATERIAL == MARA.MATNR
  • C_MATERIALKPIFORCYCLECOUNTING.MANDT == MARA.MANDT
Unit of Measure
  • Base Unit of Measure
  • Client
  • C_MATERIALKPIFORCYCLECOUNTING.MATERIALBASEUNIT == T006.MSEHI
  • C_MATERIALKPIFORCYCLECOUNTING.MANDT == T006.MANDT
Material Group
  • Client
  • Material Group
  • C_MATERIALKPIFORCYCLECOUNTING.MANDT == T023.MANDT
  • C_MATERIALKPIFORCYCLECOUNTING.MATERIALGROUP == T023.MATKL
Material type
  • Material type
  • Client
  • C_MATERIALKPIFORCYCLECOUNTING.MATERIALTYPE == T134.MTART
  • C_MATERIALKPIFORCYCLECOUNTING.MANDT == T134.MANDT
Plant
  • Client
  • Plant
  • C_MATERIALKPIFORCYCLECOUNTING.MANDT == T001W.MANDT
  • C_MATERIALKPIFORCYCLECOUNTING.PLANT == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Cycle Counting Indicator
  • Cycle Counting Indicator
  • Client
  • Plant
  • C_MATERIALKPIFORCYCLECOUNTING.CYCLECOUNTTYPE == T159C.ABCIN
  • C_MATERIALKPIFORCYCLECOUNTING.MANDT == T159C.MANDT
  • C_MATERIALKPIFORCYCLECOUNTING.PLANT == T159C.WERKS