I_JITControlCycleTP

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_JITControlCycleTP.
-- 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: IJITCTRLCYCLETP

CREATE VIEW I_JITControlCycleTP AS
SELECT
  JITControlCycle,
  JITCtrlCycLifeCycSts,
  cast('' as ddtext) AS JITCtrlCycLifeCycStsTxt,
  Plant,
  cast('' as name1) AS PlantName,
  Material,
  cast('' as productdescription) AS ProductName,
  JITContainerQuantityInBsUnt,
  QuantityUnit,
  ProductionSupplyArea,
  cast('' as pvbtx) AS ProductionSupplyAreaName,
  Responsible,
  StorageLocation,
  UnloadingPointName,
  AutomotiveLoadingPoint,
  ReplenishmentStrategy,
  cast('' as njit_repl_strat_desc) AS ReplenishmentStrategyDesc,
  StorageType,
  StorageTypeName,
  ControlCycleIsPrimary,
  ControlCycleIsSecondary,
  WarehouseNumber,
  Warehouse,
  WarehouseName,
  StorageBin,
  StoringPositionName,
  cast('' as abap.char(5)) AS SourceStorageType,
  cast('' as abap.char(40)) AS SourceStorageTypeName,
  SourceProductionSupplyArea,
  cast('' as pvbtx) AS SourceSupplyAreaName,
  JITExternalReplenishment,
  SourceStorageBin,
  EWMWarehouse,
  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,
  cast ('' as pksbz) AS InhProdnReplnmtStrgyName,
  JITCallProfile,
  RequestedDeliveryDateTime,
  JITSupplyDateTime,
  JITCallImmediateRequest,
  JITCallPriorityType,
  JITCallPriorityID,
  JITActionCtrl,
  cast('' as njit_act_cntrlt) AS JITActionCtrlText,
  Threshold,
  JITReqQtyUpperToleranceLvl,
  JITReqQtyLowerToleranceLvl,
  HundredInPercent,
  UnitOfMeasureNumberOfDecimals,
  case UnitOfMeasureNumberOfDecimals when 0 then cast(MinimumQuantityMass as abap.dec(13,0) ) when 1 then cast(MinimumQuantityMass as abap.dec(13,1) ) when 2 then cast(MinimumQuantityMass as abap.dec(13,2) ) when 3 then cast(MinimumQuantityMass as abap.dec(13,3) ) else cast(MinimumQuantityMass as abap.dec(13,3) ) end as MinimumQuantityMass AS dec133endasMinimumQuantityMass,
  IsPartiallyDelivered,
  MaxNumberOfOpenJITCallDisplay,
  MaxNumberOfOpenJITCalls,
  cast( 0 as int4 ) AS NumberOfActiveJITCalls,
  cast('' as lgobe) AS DestinationStorageLocDesc,
  cast('' as pabprt) AS JITCallProfileDesc,
  ReplnmtLeadTimeInWorkdays,
  ReplnmtLeadTimeInHours,
  BufferLeadTime,
  ReplnmtLeadTimeInMinutes,
  PlannedDurationInMinutes,
  ReplnmtLeadTimeInHoursAndMins,
  concat(BufferLeadTime,concat(':', PlannedDurationInMinutes)) AS ReplenishmentLeadTime,
  JITControlCycleCategory,
  cast('' as ddtext) AS JITControlCycleCategoryText,
  ReplnmtPlanningProcedure,
  cast('' as ddtext) AS JITPlanningProcedureText,
  concat(PlanningHorizonTimeInHours,concat(':',PlanningHorizonTimeInMinutes)) AS PlanningHorizonInHoursAndMins,
  PlanningHorizonTime,
  MinimumStockQuantity,
  ReplnmtSafetyTimeInDays,
  concat(SafetyTimeInHours,concat(':', SafetyTimeInMinutes)) AS SafetyTimeInHoursAndMins,
  ReplnmtSafetyTimeInMins,
  JITOutbCommunicationGroup,
  cast('' as njit_communication_group_desc) AS JITOutbCommunicationGroupDesc,
  Supplier,
  cast('' as md_supplier_name) AS SupplierName,
  cast('' as bu_partner) AS BusinessPartner,
  cast('' as bu_partner) AS BusinessPartner1,
  cast('' as bu_partner) AS BusinessPartner2,
  cast(concat(JITProdnOffstTimeInHours,concat(':', JITProdnOffstTimeInMinutes))as njit_duration) AS JITOffstFromStartOfProduction,
  JITProdnOffstInHoursAndMins,
  JITInternalReplenishment,
  JITIsForwardingRelevant,
  SupplyControlID,
  JITTransferTimeInDays,
  TransferTimeDuration,
  cast(concat(TransferTimeInHours,concat(':', TransferTimeInMinutes))as njit_duration) AS TransferTimeInHoursMinutes,
  GoodsReceivingPoint,
  JITExtProcmtReplnmtProfile,
  cast('' as njit_extprocmt_replnmtprfl_txt) AS JITExtProcmtReplnmtProfileDesc,
  JITLogisticsIntegrationRlvnce,
  cast('' as ddtext) AS JITLogisticsIntegRlvnceTxt,
  JITCtrlCycIsReordRlvt,
  JITReferenceControlCycle,
  JITCompMatlStorageLocation,
  JITControlCycleIsSetRelevant,
  JITCtrlCycleReleaseDateTime,
  JITCtrlCycleLockDateTime
FROM I_JITControlCycleCalc
LEFT OUTER JOIN I_JITOutbCallsTP AS _JITOutbCalls ON JITControlCycle = _JITOutbCalls.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN I_JITOutbCallsBOMTP AS _JITOutbCallsBOMTP ON JITControlCycle = _JITOutbCallsBOMTP.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN E_JITControlCycle AS _JITControlCycle ON JITControlCycle = _JITControlCycle.JITControlCycle  -- association [0..1]
LEFT OUTER JOIN I_JITActvCallCntForCtrlCycle AS _JITActvCallCntForCtrlCycle ON JITControlCycle = _JITActvCallCntForCtrlCycle.JITControlCycle  -- association [0..1]
LEFT OUTER JOIN I_JITOutbSchedgAgrmtTP AS _JITOutbSchedgAgrmtTP ON JITControlCycle = _JITOutbSchedgAgrmtTP.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN I_JITOutbBOMLink AS _JITOutbBOMLink ON Material = _JITOutbBOMLink.Material AND Plant = _JITOutbBOMLink.Plant AND ProductionSupplyArea = _JITOutbBOMLink.ProductionSupplyArea  -- association [0..*]
;