R_KanbanControlCycleTP

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 R_KanbanControlCycleTP.
-- 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.

CREATE VIEW R_KanbanControlCycleTP AS
SELECT
  KanbanControlCycle,
  KanbanControlCycleCategory,
  Product,
  Plant,
  ProductionSupplyArea,
  StoringPositionName,
  KanbanContainerDeliveryAddress,
  Warehouse,
  StorageType,
  StorageBin,
  EWMWarehouse,
  DestinationStorageBin,
  KanbanCtrlCycleLifeCycleStatus,
  CreationDate,
  ReleaseDate,
  LockDate,
  BaseUnit,
  KanbanContainerQuantityInBsUnt,
  NumberOfKanbanContainers,
  PackingInstruction,
  NumberOfLoadCarriers,
  KanbanContainerPackggProduct,
  MaxNrOfEmptyKanbanContainers,
  ReplnmtIsCtrldBySupplySource,
  KanbanCtnReplnmtTriggerLogic,
  KnbnCtnReplnmtTrggrQtyInBsUnt,
  SeparateGRIsNeededIfSetToFull,
  CostCenter,
  KanbanContainerStatusSequence,
  SalesSchedulingAgreement,
  SalesSchedulingAgreementItem,
  KanbanContainerCalculationType,
  KanbanCtnCalcSafetyFactor,
  KanbanCtnCalculationConstant,
  KanbanCtnRoundingQtyInBsUnt,
  FixedKanbanContainerQtyInBsUnt,
  KanbanContainerCalcProfile,
  ReplnmtLeadTimeInWorkdays,
  ReplnmtLeadTimeInHoursAndMins,
  cast(mod(cast(ceil(div(ReplnmtLeadTimeInHoursAndMins, 100)) as integer), 100)+60*ceil(div(ReplnmtLeadTimeInHoursAndMins, 10000)) as kwbz_min) AS ReplnmtLeadTimeInMinutes,
  PullIntervalInWorkdays,
  PullIntervalInHoursAndMinutes,
  cast(mod(cast(ceil(div(PullIntervalInHoursAndMinutes, 100)) as integer), 100)+60*ceil(div(PullIntervalInHoursAndMinutes, 10000)) as pintv_min) AS PullIntervalInMinutes,
  KanbanCtnRefillTimeInDays,
  KanbanCtnRefillTmeInHrsAndMins,
  cast(mod(cast(ceil(div(KanbanCtnRefillTmeInHrsAndMins, 100)) as integer), 100)+60*ceil(div(KanbanCtnRefillTmeInHrsAndMins, 10000)) as knfz_min) AS KanbanCtnRefillTmeInMinutes,
  KanbanCtnWaitTimeInDays,
  KanbanCtnWaitTimeInHrsAndMins,
  cast(mod(cast(ceil(div(KanbanCtnWaitTimeInHrsAndMins, 100)) as integer), 100)+60*ceil(div(KanbanCtnWaitTimeInHrsAndMins, 10000)) as kwtz_min) AS KanbanCtnWaitTimeInMinutes,
  KanbanCtnTransportTimeInDays,
  KnbnCtnTransptTmeInHrsAndMins,
  cast(mod(cast(ceil(div(KnbnCtnTransptTmeInHrsAndMins,100)) as integer), 100)+60*ceil(div(KnbnCtnTransptTmeInHrsAndMins, 10000)) as kitz_min) AS KanbanCtnTransportTmeInMinutes,
  KnbnCtnCalcRqmtBufferInPercent,
  KnbnCtnCalcSupplySrceBufInPct,
  NrOfKanbanCtnsFlaggedToUnlock,
  KanbanCardPrintControl,
  ProdnSupplySpoolOutputDevice,
  KanbanCardPrintQueue,
  ControlCyclePrintQueue,
  KanbanCardFormTemplate,
  ControlCycleSAPScriptForm,
  ControlCyclePrintFormTemplate,
  SupplySourcePlant,
  InHouseProductionReplnmtStrgy,
  ProductionVersion,
  SupplySourceResponsiblePerson,
  cast(BackflushReportingPoint as pk_sa_zpunkt preserving type) AS BackflushReportingPoint,
  NrOfWaitingKnbnCtnsBfrReplnmt,
  KanbanCtrlCycReplnmtTriggerGrp,
  PlanningWorkCenter,
  ProductionOrdersAreCombined,
  ExtProcurementReplnmtStrgy,
  Supplier,
  PurchasingOrganization,
  PurchaseOutlineAgreement,
  PurchaseOutlineAgreementItem,
  JITCallProfile,
  StockTransferReplnmtStrategy,
  StorageLocation,
  SourceProductionSupplyArea,
  SourceStorageBin,
  WarehouseProcessType,
  cast(' ' as pk_change_doc_act preserving type) AS KnbnCtrlCycleChgDocsAreActive
FROM I_KanbanControlCycle
LEFT OUTER JOIN E_KanbanControlCycle AS _KanbanControlCycleExtension ON KanbanControlCycle = _KanbanControlCycleExtension.KanbanControlCycle  -- association [0..1]
LEFT OUTER JOIN R_KanbanContainerTP AS _KanbanContainer ON /* condition not available in parsed metadata */  -- association [0..*]
;