I_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 I_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: IJITCTRLCYC

CREATE VIEW I_JITControlCycle AS
SELECT
  pknum AS JITControlCycle,
  lcm_status AS JITCtrlCycLifeCycSts,
  werks AS Plant,
  matnr AS Material,
  behmg AS JITContainerQuantityInBsUnt,
  meins AS QuantityUnit,
  prvbe AS ProductionSupplyArea,
  jit_stck_transfer_repl_strat AS ReplenishmentStrategy,
  ablad AS StoringPositionName,
  lgnum AS WarehouseNumber,
  nlpla AS StorageBin,
  cast('' as abap.char(5)) AS StorageType,
  cast('' as abap.char(40)) AS StorageTypeName,
  vlpla AS SourceStorageBin,
  qupvb AS SourceProductionSupplyArea,
  jit_ext_proc_repl_strat AS ExtProcurementReplnmtStrgy,
  cre_date AS JITCtrlCycleCreationDate,
  rls_date AS JITCtrlCycleReleaseDate,
  obs_date AS LockDate,
  release_time AS JITCtrlCycleReleaseTime,
  lock_time AS JITCtrlCycleLockTime,
  lastchange_user AS LastChangedByUserName,
  anzlt AS NumberOfLoadCarriers,
  pkbht AS JITContainer,
  lastchange_datetime AS LastChangeDateTime,
  umlgo AS IssuingOrReceivingStorageLoc,
  pkste AS InHouseProductionReplnmtStrgy,
  pabprf AS JITCallProfile,
  jit_action_control AS JITActionCtrl,
  repl_qty_lower_tolerance_lvl AS Threshold,
  supl_qty_upper_tolerance_lvl AS JITReqQtyUpperToleranceLvl,
  supl_qty_lower_tolerance_lvl AS JITReqQtyLowerToleranceLvl,
  cast(' % ' as abap.unit(3)) AS HundredInPercent,
  (cast ( division(repl_qty_lower_tolerance_lvl * behmg,100,3) as abap.dec(13,3))) AS MinimumQuantityVolume,
  partial_gr_allowed_ind AS IsPartiallyDelivered,
  max_number_open_calls AS MaxNumberOfOpenJITCalls,
  kwbzd AS ReplnmtLeadTimeInWorkdays,
  cast(kwbzm as abap.dec(11)) AS ReplnmtLeadTimeInHoursAndMins,
  rksta AS JITControlCycleCategory,
  cast( '0' as int4 ) AS NumberOfActiveJITCalls,
  cast(0000 as abap.dec(15,0)) AS RequestedDeliveryDateTime,
  cast(0000 as njit_supply_date_time ) AS JITSupplyDateTime,
  cast('' as njit_immediate_req) AS JITCallImmediateRequest,
  cast('' as njit_priority_type) AS JITCallPriorityType,
  cast('' as lprio) AS JITCallPriorityID,
  plng_procedure AS ReplnmtPlanningProcedure,
  cast(plng_horizon as abap.dec(11)) AS PlanningHorizonTime,
  min_stock AS MinimumStockQuantity,
  safety_time_in_days AS ReplnmtSafetyTimeInDays,
  cast(safety_time_in_minutes as abap.dec(11)) AS ReplnmtSafetyTimeInMins,
  communication_group AS JITOutbCommunicationGroup,
  _JITCommunicationGroup.JITOutbCommunicationGroupDesc AS JITOutbCommunicationGroupDesc,
  _JITCommunicationGroup.Supplier AS Supplier,
  _JITCommunicationGroup._Supplier.SupplierName AS SupplierName,
  cast(offset_from_start_of_prodn as abap.dec(11)) AS JITProdnOffstInHoursAndMins,
  cast(cast(div(mod(ceil(div(kwbzm,100)),100)+60*ceil(div(kwbzm,10000)),60) as kwbz_min) as abap.char(30)) AS ReplnmtLeadTimeInHours,
  cast(cast(mod(mod(ceil(div(kwbzm,100)),100)+60*ceil(div(kwbzm,10000)),60) as kwbz_min) as abap.char(30)) AS ReplnmtLeadTimeInMinutes,
  _ProductionSupplyArea.StorageLocation AS StorageLocation,
  _ProductionSupplyArea.UnloadingPointName AS UnloadingPointName,
  jit_fwdng_rlvnce AS JITIsForwardingRelevant,
  jit_supplycontrolid AS SupplyControlID,
  cast(kitzd as njit_transfer_time_in_days) AS JITTransferTimeInDays,
  cast(kitzm as abap.dec(11)) AS TransferTimeDuration,
  jit_receiving_point AS GoodsReceivingPoint,
  jit_extprocmt_replnmt_prfl AS JITExtProcmtReplnmtProfile,
  jit_logistics_integ_rlvnce AS JITLogisticsIntegrationRlvnce,
  jit_ctrlcycleisreordrelevant AS JITCtrlCycIsReordRlvt,
  jit_referencecontrolcycle AS JITReferenceControlCycle,
  jit_compmatlstoragelocation AS JITCompMatlStorageLocation
FROM pkhd
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON Plant = _ProductionSupplyArea.Plant AND ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea  -- association [1..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _SourceSupplyArea ON Plant = _SourceSupplyArea.Plant AND SourceProductionSupplyArea = _SourceSupplyArea.ProductionSupplyArea  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_JITCtrlCycleLifeCycleStatus AS _JITCtrlCycleLifeCycleStatus ON JITCtrlCycLifeCycSts = _JITCtrlCycleLifeCycleStatus.JITCtrlCycLifeCycSts  -- association [0..1]
LEFT OUTER JOIN I_JITCtrlCycleCategory AS _JITCtrlCycleCategory ON JITControlCycleCategory = _JITCtrlCycleCategory.JITControlCycleCategory  -- association [0..1]
LEFT OUTER JOIN I_JITOutbReplnmtStrgy AS _JITOutbReplenish ON Plant = _JITOutbReplenish.Plant AND ReplenishmentStrategy = _JITOutbReplenish.ReplenishmentStrategy  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _ResponsiblePerson ON Plant = _ResponsiblePerson.Plant  -- association [0..*]
LEFT OUTER JOIN I_Product AS _JITContainer ON JITContainer = _JITContainer.Product  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON IssuingOrReceivingStorageLoc = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_JITOutbCallProfile AS _JITOutbCallProfile ON JITCallProfile = _JITOutbCallProfile.JITCallProfile  -- association [0..1]
LEFT OUTER JOIN I_JITActionCtrl AS _JITActionCtrl ON JITActionCtrl = _JITActionCtrl.JITActionCtrl  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUserName = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPlngProcedure AS _JITPlngProcedure ON ReplnmtPlanningProcedure = _JITPlngProcedure.JITPlanningProcedure  -- association [0..1]
LEFT OUTER JOIN I_JITOutbCommunicationGroup AS _JITCommunicationGroup ON JITOutbCommunicationGroup = _JITCommunicationGroup.JITOutbCommunicationGroup  -- association [0..1]
LEFT OUTER JOIN I_JITSupplyControlHeader AS _JITSupplyControlHeader ON SupplyControlID = _JITSupplyControlHeader.SupplyControlID  -- association [0..1]
LEFT OUTER JOIN I_JITLogisticsIntegRlvnce AS _JITLogisticsIntegRlvnce ON JITLogisticsIntegrationRlvnce = _JITLogisticsIntegRlvnce.JITLogisticsIntegrationRlvnce  -- association [0..1]
LEFT OUTER JOIN I_JITExtProcmtReplnmtPrfl AS _JITExtProcmtReplnmtPrfl ON JITExtProcmtReplnmtProfile = _JITExtProcmtReplnmtPrfl.JITExtProcmtReplnmtProfile AND Plant = _JITExtProcmtReplnmtPrfl.Plant  -- association [0..1]
;