C_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 C_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: CJITCTRLCYCLETP

CREATE VIEW C_JITControlCycleTP AS
SELECT
  JITControlCycle,
  JITCtrlCycLifeCycSts,
  _JITCtrlCycleLifeCycleStatus._Text[1: Language = $session.system_language].JITCtrlCycLifeCycStsTxt AS JITCtrlCycLifeCycStsTxt,
  Plant,
  PlantName,
  Material,
  ProductName,
  JITContainerQuantityInBsUnt,
  QuantityUnit,
  ProductionSupplyArea,
  ProductionSupplyAreaName,
  JITExternalReplenishment,
  JITOutbCommunicationGroup,
  JITOutbCommunicationGroupDesc,
  Supplier,
  SupplierName,
  BusinessPartner,
  BusinessPartner1,
  BusinessPartner2,
  Responsible,
  StorageLocation,
  UnloadingPointName,
  AutomotiveLoadingPoint,
  ReplenishmentStrategy,
  ReplenishmentStrategyDesc,
  StorageType,
  StorageTypeName,
  ControlCycleIsPrimary,
  ControlCycleIsSecondary,
  StorageBin,
  StoringPositionName,
  JITCtrlCycleCreationDate,
  JITCtrlCycleReleaseDate,
  LockDate,
  JITCtrlCycleReleaseTime,
  JITCtrlCycleLockTime,
  JITOffstFromStartOfProduction,
  LastChangeDateTime,
  LastChangedByUserName,
  UserDescription,
  NumberOfLoadCarriers,
  JITContainer,
  JITContainerDesc,
  IssuingOrReceivingStorageLoc,
  InhProdnReplnmtStrgyName,
  InHouseProductionReplnmtStrgy,
  StorageLocationName,
  JITCallProfile,
  JITCallProfileDesc,
  JITActionCtrl,
  JITActionCtrlText,
  Threshold,
  JITReqQtyUpperToleranceLvl,
  JITReqQtyLowerToleranceLvl,
  HundredInPercent,
  UnitOfMeasureNumberOfDecimals,
  MinimumQuantityMass,
  IsPartiallyDelivered,
  MaxNumberOfOpenJITCallDisplay,
  MaxNumberOfOpenJITCalls,
  NumberOfActiveJITCalls,
  WarehouseNumber,
  cast('' as /scwm/lgnum ) AS Warehouse,
  cast('' as /scwm/de_desc40 ) AS WarehouseName,
  EWMWarehouse,
  SourceStorageType,
  SourceStorageTypeName,
  SourceProductionSupplyArea,
  SourceSupplyAreaName,
  SourceStorageBin,
  ReplnmtLeadTimeInWorkdays,
  ReplnmtLeadTimeInHoursAndMins,
  ReplenishmentLeadTime,
  JITControlCycleCategory,
  JITControlCycleCategoryText,
  ReplnmtPlanningProcedure,
  JITPlanningProcedureText,
  PlanningHorizonInHoursAndMins,
  MinimumStockQuantity,
  ReplnmtSafetyTimeInDays,
  SafetyTimeInHoursAndMins,
  ReplnmtSafetyTimeInMins,
  PlanningHorizonTime,
  cast(_JITOutbCallCreationDate.CreationDateTime as njit_req_date_time) AS JITCallLastCreationDateTime,
  JITInternalReplenishment,
  JITCtrlCycleReleaseDateTime,
  JITCtrlCycleLockDateTime,
  _JITProdnSupAreaOvw.FactoryCalendar AS FactoryCalendar,
  _JITProdnSupAreaOvw.ShiftGrouping AS ShiftGrouping,
  _JITProdnSupAreaOvw.ShiftSequence AS ShiftSequence,
  _JITProdnSupAreaOvw._JustInTimeOutboundTimeStream.JITOutbTmeStreamID AS JITOutbTmeStreamID,
  JITIsForwardingRelevant,
  SupplyControlID,
  JITTransferTimeInDays,
  TransferTimeInHoursMinutes,
  GoodsReceivingPoint,
  JITExtProcmtReplnmtProfile,
  JITExtProcmtReplnmtProfileDesc,
  JITLogisticsIntegrationRlvnce,
  JITLogisticsIntegRlvnceTxt,
  JITCtrlCycIsReordRlvt,
  JITReferenceControlCycle,
  JITCompMatlStorageLocation,
  cast('' as njit_ext_repl_ind ) AS JITExtReplnmtFacetIsVisible
FROM I_JITControlCycleTP AS _JITControlCycleTP
LEFT OUTER JOIN C_JITOutbCalls AS _JITOutbCalls ON JITControlCycle = _JITOutbCalls.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN C_JITOutbCallsBOMTP AS _JITOutbCallsBOMTP ON JITControlCycle = _JITOutbCallsBOMTP.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN C_JITProdnSupAreaOvw AS _JITProdnSupAreaOvw ON Plant = _JITProdnSupAreaOvw.Plant AND ProductionSupplyArea = _JITProdnSupAreaOvw.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN C_JITReplnmtStrategyOvw AS _JITReplnmtStrategyOvw ON Plant = _JITReplnmtStrategyOvw.Plant AND ReplenishmentStrategy = _JITReplnmtStrategyOvw.ReplenishmentStrategy  -- association [0..1]
LEFT OUTER JOIN I_JITReldControlCycleVH AS _JITReldControlCycleVH ON JITControlCycle = _JITReldControlCycleVH.JITControlCycle AND Material = _JITReldControlCycleVH.Material AND Plant = _JITReldControlCycleVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_JITOutbActionControlVH AS _JITOutbActionControlVH ON JITActionCtrl = _JITOutbActionControlVH.JITActionCtrl  -- association [0..1]
LEFT OUTER JOIN I_JITOutbCallCreationDate AS _JITOutbCallCreationDate ON JITControlCycle = _JITOutbCallCreationDate.JITControlCycle  -- association [1..1]
LEFT OUTER JOIN C_JITOutbSchedgAgrmtTP AS _JITOutbSchedgAgrmtTP ON JITControlCycle = _JITOutbSchedgAgrmtTP.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN C_JITOutbBOMLink AS _JITOutbBOMLink ON Material = _JITOutbBOMLink.Material AND Plant = _JITOutbBOMLink.Plant AND ProductionSupplyArea = _JITOutbBOMLink.ProductionSupplyArea  -- association [0..*]
LEFT OUTER JOIN C_JITOutbControlCyclePrimary AS _JITControlCyclePrimary ON Material = _JITControlCyclePrimary.Material AND Plant = _JITControlCyclePrimary.Plant AND ProductionSupplyArea = _JITControlCyclePrimary.SourceProductionSupplyArea  -- association [0..*]
LEFT OUTER JOIN C_JITInHouseReplnmtStrgyVH AS _JITProdnReplnmtStrgy ON InHouseProductionReplnmtStrgy = _JITProdnReplnmtStrgy.InHouseProductionReplnmtStrgy AND Plant = _JITProdnReplnmtStrgy.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITOutbControlCycleSecondary AS _JITControlCycleSecondary ON Material = _JITControlCycleSecondary.Material AND Plant = _JITControlCycleSecondary.Plant AND SourceProductionSupplyArea = _JITControlCycleSecondary.ProductionSupplyArea  -- association [0..*]
;