C_KnbnCtrlCycleAnalysisCube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_KnbnCtrlCycleAnalysisCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CKNBNCTNSTSCUBE

CREATE VIEW C_KnbnCtrlCycleAnalysisCube AS
SELECT
  KanbanControlCycle,
  ProductionSupplyArea,
  Plant,
  Product,
  I_KanbanControlCycle.StorageLocation AS SourceStorageLocation,
  InHouseProductionReplnmtStrgy,
  ExtProcurementReplnmtStrgy,
  StockTransferReplnmtStrategy,
  KanbanControlCycleCategory,
  BaseUnit,
  Supplier,
  KanbanCtrlCycleLifeCycleStatus,
  ReleaseDate,
  LockDate,
  StoringPositionName,
  PurchasingOrganization,
  KanbanCtrlCycReplnmtTriggerGrp,
  NrOfWaitingKnbnCtnsBfrReplnmt,
  PlanningWorkCenter,
  SourceProductionSupplyArea,
  _ProductionSupplyArea.StorageLocation AS StorageLocation,
  _ContainersByControlCycle.NumberOfKanbanContainers AS NumberOfKanbanContainers,
  _ContainersByControlCycle.NumberOfWaitingKanbanCtns AS NumberOfWaitingKanbanCtns,
  _ContainersByControlCycle.NumberOfEmptyKanbanContainers AS NumberOfEmptyKanbanContainers,
  _ContainersByControlCycle.NumberOfKanbanCtnsInProcess AS NumberOfKanbanCtnsInProcess,
  _ContainersByControlCycle.NumberOfKanbanCtnsInTransit AS NumberOfKanbanCtnsInTransit,
  _ContainersByControlCycle.NumberOfFullKanbanContainers AS NumberOfFullKanbanContainers,
  _ContainersByControlCycle.NumberOfKanbanContainersInUse AS NumberOfKanbanContainersInUse,
  _ContainersByControlCycle.NumberOfKanbanCtnsWithError AS NumberOfKanbanCtnsWithError,
  _ContainersByControlCycle.NumberOfLockedKanbanContainers AS NumberOfLockedKanbanContainers,
  _ContainersByControlCycle.NmbrOfCtnsWhereGoodsRcptIsMisg AS NmbrOfCtnsWhereGoodsRcptIsMisg,
  _ContainersByControlCycle.NmbrOfCtnsWhereGdsRcptIsAhead AS NmbrOfCtnsWhereGdsRcptIsAhead,
  _ContainersByControlCycle.ActualQuantityInBaseUnit AS ActualQuantityInBaseUnit,
  _ContainersByControlCycle.RequestedQuantityInBaseUnit AS RequestedQuantityInBaseUnit,
  _ContainersByControlCycle.CtrlCycNextRcptInUTCDteTme AS CtrlCycNextRcptInUTCDteTme,
  cast(division(TSTMP_SECONDS_BETWEEN(_ContainersByControlCycle.LastChangeDateTime,TSTMP_CURRENT_UTCTIMESTAMP(),'FAIL'),86400,2) as pk_numbr_of_days_since_cont_ch) AS NmbrOfDaysSinceKnbnCtnsChgd
FROM I_KanbanControlCycle
LEFT OUTER JOIN P_KnbnCtnStatusAggregated AS _ContainersByControlCycle ON KanbanControlCycle = _ContainersByControlCycle.KanbanControlCycle  -- association [1..1]
LEFT OUTER JOIN I_KanbanControlCycle AS _KanbanControlCycleVH ON KanbanControlCycle = _KanbanControlCycleVH.KanbanControlCycle  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _SupplySourcePlant ON SupplySourcePlant = _SupplySourcePlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _SourceProductionSupplyArea ON Plant = _SourceProductionSupplyArea.Plant AND SourceProductionSupplyArea = _SourceProductionSupplyArea.ProductionSupplyArea  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _SourceStorageLocation ON Plant = _SourceStorageLocation.Plant AND SourceStorageLocation = _SourceStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _PlanningWorkCenter ON PlanningWorkCenter = _PlanningWorkCenter.WorkCenter AND Plant = _PlanningWorkCenter.Plant  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Product = _Material.Material  -- association [0..1]
;