I_JITControlCycleCalc

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 I_JITControlCycleCalc.
-- 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: IJITCTRLCYCCALC

CREATE VIEW I_JITControlCycleCalc AS
SELECT
  JITControlCycle,
  JITCtrlCycLifeCycSts,
  JITCtrlCycLifeCycStsTxt,
  Plant,
  PlantName,
  Material,
  ProductName,
  case _UnitOfMeasure.UnitOfMeasureNumberOfDecimals when 0 then cast(ceil(JITContainerQuantityInBsUnt) as abap.dec(13,0) ) when 1 then cast(JITContainerQuantityInBsUnt as abap.dec(13,1) ) when 2 then cast(JITContainerQuantityInBsUnt as abap.dec(13,2) ) else cast(JITContainerQuantityInBsUnt as abap.dec(13,3) ) end as JITContainerQuantityInBsUnt AS dec133endasJITContainerQuantityInBsUnt,
  QuantityUnit,
  ProductionSupplyArea,
  ProductionSupplyAreaName,
  Responsible,
  StorageLocation,
  UnloadingPointName,
  AutomotiveLoadingPoint,
  ReplenishmentStrategy,
  ReplenishmentStrategyDesc,
  StorageType,
  StorageTypeName,
  WarehouseNumber,
  cast('' as /scwm/lgnum ) AS Warehouse,
  cast('' as /scwm/de_desc40 ) AS WarehouseName,
  cast('' as abap.char(1)) AS ControlCycleIsPrimary,
  cast('' as abap.char(1)) AS ControlCycleIsSecondary,
  cast('' as /scwm/lgnum ) AS EWMWarehouse,
  StorageBin,
  StoringPositionName,
  SourceStorageBin,
  SourceProductionSupplyArea,
  SourceSupplyAreaName,
  JITExternalReplenishment,
  JITCtrlCycleCreationDate,
  JITCtrlCycleReleaseDate,
  LockDate,
  JITCtrlCycleReleaseTime,
  JITCtrlCycleLockTime,
  LastChangedByUserName,
  UserDescription,
  LastChangeDateTime,
  NumberOfLoadCarriers,
  JITContainer,
  JITContainerDesc,
  IssuingOrReceivingStorageLoc,
  StorageLocationName,
  InHouseProductionReplnmtStrgy,
  JITCallProfile,
  JITActionCtrl,
  JITActionCtrlText,
  Threshold,
  JITReqQtyUpperToleranceLvl,
  JITReqQtyLowerToleranceLvl,
  HundredInPercent,
  MinimumQuantityVolume,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  IsPartiallyDelivered,
  case MaxNumberOfOpenJITCalls when 0 then cast('-' as abap.char(11)) else cast(MaxNumberOfOpenJITCalls as abap.char(11)) end as MaxNumberOfOpenJITCallDisplay AS char11endasMaxNumberOfOpenJITCallDisplay,
  MaxNumberOfOpenJITCalls,
  NumberOfActiveJITCalls,
  JITCallProfileDesc,
  RequestedDeliveryDateTime,
  JITSupplyDateTime,
  JITCallImmediateRequest,
  JITCallPriorityType,
  JITCallPriorityID,
  ReplnmtLeadTimeInWorkdays,
  ReplnmtLeadTimeInHours,
  ReplnmtLeadTimeInMinutes,
  ReplnmtLeadTimeInHoursAndMins,
  JITControlCycleCategory,
  JITControlCycleCategoryText,
  ReplnmtPlanningProcedure,
  JITPlanningProcedureText,
  PlanningHorizonTime,
  case _UnitOfMeasure.UnitOfMeasureNumberOfDecimals when 0 then ceil(MinimumStockQuantity) when 1 then cast(MinimumStockQuantity as abap.dec(13,1) ) when 2 then cast(MinimumStockQuantity as abap.dec(13,2) ) else cast(MinimumStockQuantity as abap.dec(13,3) ) end as MinimumStockQuantity AS dec133endasMinimumStockQuantity,
  ReplnmtSafetyTimeInDays,
  ReplnmtSafetyTimeInMins,
  JITOutbCommunicationGroup,
  JITOutbCommunicationGroupDesc,
  Supplier,
  SupplierName,
  JITProdnOffstInHoursAndMins,
  JITInternalReplenishment
FROM P_JITControlCycle
;