C_ProductionSupplyControlCycle

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_ProductionSupplyControlCycle.
-- 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: CPRODSPLYCTRLCYC

CREATE VIEW C_ProductionSupplyControlCycle AS
SELECT
  _KanbanControlCycle.KanbanControlCycle AS KanbanControlCycle,
  _KanbanControlCycle.Plant AS Plant,
  _KanbanControlCycle.ProductionSupplyArea AS ProductionSupplyArea,
  _KanbanControlCycle.Product AS Product,
  _KanbanControlCycle.StorageLocation AS SourceStorageLocation,
  KanbanControlCycleCategory,
  ProductionVersion,
  SupplySourceResponsiblePerson,
  BaseUnit,
  KanbanContainerQuantityInBsUnt,
  NumberOfKanbanContainers,
  MaxNrOfEmptyKanbanContainers,
  InHouseProductionReplnmtStrgy,
  ExtProcurementReplnmtStrgy,
  StockTransferReplnmtStrategy,
  Supplier,
  KanbanCtrlCycleLifeCycleStatus,
  CreationDate,
  ReleaseDate,
  LockDate,
  CostCenter,
  StoringPositionName,
  Warehouse,
  PurchasingOrganization,
  PurchaseOutlineAgreement,
  KanbanCtrlCycReplnmtTriggerGrp,
  NrOfWaitingKnbnCtnsBfrReplnmt,
  PlanningWorkCenter,
  SourceProductionSupplyArea,
  SalesSchedulingAgreement,
  _ProductionSupplyArea.StorageLocation AS StorageLocation,
  _ProductionSupplyArea.ProductionSupplyAreaRespPerson AS ProductionSupplyAreaRespPerson,
  cast('' as pk_container_creation_enabled preserving type) AS EvtDrvnKnbnCtnCrtnIsEnabled,
  cast('' as vdm_pkbst preserving type) AS KanbanContainerStatus,
  cast('' as vdm_spkkz preserving type) AS IsLocked
FROM I_KanbanControlCycle AS _KanbanControlCycle
LEFT OUTER JOIN C_ProductionSupplyItem AS _ProductionSupplyItem ON KanbanControlCycle = _ProductionSupplyItem.KanbanControlCycle  -- association [0..*]
LEFT OUTER JOIN C_ProdnSupEventDrvnCtnCrtn AS _ProdnSupEventDrvnCtnCrtn ON KanbanControlCycle = _ProdnSupEventDrvnCtnCrtn.KanbanControlCycle  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Product ON Product = _Product.Material  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _SupplySourcePlant ON SupplySourcePlant = _SupplySourcePlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _SourceProductionSupplyArea ON Plant = _SourceProductionSupplyArea.Plant AND SourceProductionSupplyArea = _SourceProductionSupplyArea.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_StorageLocationStdVH AS _SourceStorageLocation ON Plant = _SourceStorageLocation.Plant AND SourceStorageLocation = _SourceStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_StorageLocationStdVH AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_KanbanContainerStatus AS _KanbanContainerStatus ON KanbanContainerStatus = _KanbanContainerStatus.KanbanContainerStatus  -- association [1..1]
LEFT OUTER JOIN I_KanbanStatus AS _KanbanStatus ON KanbanContainerStatus = _KanbanStatus.KanbanStatus  -- association [1..1]
LEFT OUTER JOIN I_KnbnReplnmtStrgyType AS _KnbnReplnmtStrgyType ON KanbanReplenishmentStrgyType = _KnbnReplnmtStrgyType.KanbanReplenishmentStrgyType  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyMRPCtrlrVH AS _ResponsiblePerson ON Plant = _ResponsiblePerson.Plant AND SupplySourceResponsiblePerson = _ResponsiblePerson.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyMRPCtrlrVH AS _MRPController ON Plant = _MRPController.Plant AND productionsupplyarearespperson = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_KnbnProdnReplnmtStrgyVH AS _KnbnProdnReplnmtStrgy ON InHouseProductionReplnmtStrgy = _KnbnProdnReplnmtStrgy.InHouseProductionReplnmtStrgy AND Plant = _KnbnProdnReplnmtStrgy.Plant  -- association [0..1]
LEFT OUTER JOIN I_KnbnExtProcmtReplnmtStrgyVH AS _KnbnExtProcmtReplnmtStrgy ON ExtProcurementReplnmtStrgy = _KnbnExtProcmtReplnmtStrgy.ExtProcurementReplnmtStrgy AND Plant = _KnbnExtProcmtReplnmtStrgy.Plant  -- association [0..1]
LEFT OUTER JOIN I_KnbnStkTransfReplnmtStrgyVH AS _KnbnStkTransfReplnmtStrgy ON StockTransferReplnmtStrategy = _KnbnStkTransfReplnmtStrgy.StockTransferReplnmtStrategy AND Plant = _KnbnStkTransfReplnmtStrgy.Plant  -- association [0..1]
LEFT OUTER JOIN I_KnbnControlCycLifeCycSts AS _KnbnControlCycLifeCycSts ON KanbanCtrlCycleLifeCycleStatus = _KnbnControlCycLifeCycSts.KanbanCtrlCycleLifeCycleStatus  -- association [1..1]
LEFT OUTER JOIN I_WrkCtrBySemanticKeyStdVH AS _WorkCenter ON PlanningWorkCenter = _WorkCenter.WorkCenter AND Plant = _WorkCenter.Plant  -- association [0..1]
LEFT OUTER JOIN I_KanbanCostCenterByPlantVH AS _CostCenter ON Plant = _CostCenter.Plant AND CostCenter = _CostCenter.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_WarehouseStdVH AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_KnbnCtrlCycProdMstrDta AS _KnbnCtrlCycProdMstrDta ON KanbanControlCycle = _KnbnCtrlCycProdMstrDta.KanbanControlCycle  -- association [1..1]
LEFT OUTER JOIN E_KanbanControlCycle AS _ControlCycleExtension ON KanbanControlCycle = _ControlCycleExtension.KanbanControlCycle  -- association [0..1]
;