P_JITControlCycle

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 P_JITControlCycle.
-- 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: PJITCTRLCYCLETP

CREATE VIEW P_JITControlCycle AS
SELECT
  JITControlCycle,
  JITCtrlCycLifeCycSts,
  cast('' as ddtext) AS JITCtrlCycLifeCycStsTxt,
  Plant,
  cast('' as name1) AS PlantName,
  Material,
  cast('' as productdescription) AS ProductName,
  JITContainerQuantityInBsUnt,
  _Product.BaseUnit AS QuantityUnit,
  ProductionSupplyArea,
  cast('' as pvbtx) AS ProductionSupplyAreaName,
  _ProductionSupplyArea.ProductionSupplyAreaRespPerson AS Responsible,
  _ProductionSupplyArea.StorageLocation AS StorageLocation,
  _ProductionSupplyArea.UnloadingPointName AS UnloadingPointName,
  _ProductionSupplyArea.AutomotiveLoadingPoint AS AutomotiveLoadingPoint,
  ReplenishmentStrategy,
  cast('' as njit_repl_strat_desc) AS ReplenishmentStrategyDesc,
  StorageType,
  StorageTypeName,
  WarehouseNumber,
  StorageBin,
  DestinationStorageBin,
  StoringPositionName,
  SourceStorageBin,
  SourceProductionSupplyArea,
  cast('' as pvbtx) AS SourceSupplyAreaName,
  ExtProcurementReplnmtStrgy,
  JITCtrlCycleCreationDate,
  JITCtrlCycleReleaseDate,
  LockDate,
  JITCtrlCycleReleaseTime,
  JITCtrlCycleLockTime,
  LastChangedByUserName,
  cast('' as vdm_userdescription) AS UserDescription,
  LastChangeDateTime,
  NumberOfLoadCarriers,
  JITContainer,
  cast('' as maktx) AS JITContainerDesc,
  IssuingOrReceivingStorageLoc,
  cast('' as lgobe) AS StorageLocationName,
  InHouseProductionReplnmtStrgy,
  JITCallProfile,
  JITActionCtrl,
  cast('' as njit_act_cntrlt) AS JITActionCtrlText,
  Threshold,
  JITReqQtyUpperToleranceLvl,
  JITReqQtyLowerToleranceLvl,
  HundredInPercent,
  MinimumQuantityVolume,
  IsPartiallyDelivered,
  MaxNumberOfOpenJITCalls,
  0 AS NumberOfActiveJITCalls,
  RequestedDeliveryDateTime,
  JITSupplyDateTime,
  JITCallImmediateRequest,
  JITCallPriorityType,
  JITCallPriorityID,
  cast('' as pabprt) AS JITCallProfileDesc,
  ReplnmtLeadTimeInWorkdays,
  ReplnmtLeadTimeInHoursAndMins,
  ReplnmtLeadTimeInHours,
  ReplnmtLeadTimeInMinutes,
  JITControlCycleCategory,
  cast('' as ddtext) AS JITControlCycleCategoryText,
  ReplnmtPlanningProcedure,
  PlanningHorizonTime,
  cast(cast(div(mod(ceil(div(PlanningHorizonTime,100)),100)+60*ceil(div(PlanningHorizonTime,10000)),60) as kwbz_min) as abap.char(30)) AS PlanningHorizonTimeInHours,
  cast(cast(mod(mod(ceil(div(PlanningHorizonTime,100)),100)+60*ceil(div(PlanningHorizonTime,10000)),60) as kwbz_min) as abap.char(30)) AS PlanningHorizonTimeInMinutes,
  MinimumStockQuantity,
  ReplnmtSafetyTimeInDays,
  ReplnmtSafetyTimeInMins,
  cast(cast(div(mod(ceil(div(ReplnmtSafetyTimeInMins,100)),100)+60*ceil(div(ReplnmtSafetyTimeInMins,10000)),60) as kwbz_min) as abap.char(30)) AS SafetyTimeInHours,
  cast(cast(mod(mod(ceil(div(ReplnmtSafetyTimeInMins,100)),100)+60*ceil(div(ReplnmtSafetyTimeInMins,10000)),60) as kwbz_min) as abap.char(30)) AS SafetyTimeInMinutes,
  _JITPlngProcedure._Text[1: Language = $session.system_language].JITPlanningProcedureText AS JITPlanningProcedureText,
  JITOutbCommunicationGroup,
  cast('' as njit_communication_group_desc) AS JITOutbCommunicationGroupDesc,
  Supplier,
  cast('' as md_supplier_name) AS SupplierName,
  JITProdnOffstInHoursAndMins,
  cast(cast(div(mod(ceil(div(JITProdnOffstInHoursAndMins,100)),100)+60*ceil(div(JITProdnOffstInHoursAndMins,10000)),60) as kwbz_min) as njit_time) AS JITProdnOffstTimeInHours,
  cast(cast(mod(mod(ceil(div(JITProdnOffstInHoursAndMins,100)),100)+60*ceil(div(JITProdnOffstInHoursAndMins,10000)),60) as kwbz_min) as njit_time) AS JITProdnOffstTimeInMinutes,
  SupplyControlID,
  JITTransferTimeInDays,
  TransferTimeDuration,
  cast(cast(div(mod(ceil(div(TransferTimeDuration,100)),100)+60*ceil(div(TransferTimeDuration,10000)),60) as kwbz_min) as abap.char(30)) AS TransferTimeInHours,
  cast(cast(mod(mod(ceil(div(TransferTimeDuration,100)),100)+60*ceil(div(TransferTimeDuration,10000)),60) as kwbz_min) as abap.char(30)) AS TransferTimeInMinutes,
  GoodsReceivingPoint,
  JITExtProcmtReplnmtProfile,
  cast('' as njit_extprocmt_replnmtprfl_txt) AS JITExtProcmtReplnmtProfileDesc,
  JITLogisticsIntegrationRlvnce,
  cast('' as ddtext) AS JITLogisticsIntegRlvnceTxt,
  JITReferenceControlCycle,
  JITCompMatlStorageLocation,
  JITControlCycleIsSetRelevant
FROM I_JITControlCycle
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;