I_JITOutbCallCube

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_JITOutbCallCube.
-- 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: IJITOUTBCALLCUBE

CREATE VIEW I_JITOutbCallCube AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITLifecycleStatus,
  JITLifecycleStatusText,
  JITCallType,
  Plant,
  StorageLocation,
  cast ( RequirementDateTime as njit_outb_date_time ) AS RequirementDateTime,
  JITIntProcessingStatus,
  JITInternalStatusText,
  ProductionSupplyArea,
  JITControlCycle,
  Responsible,
  JITOutbDestinationStorLoc,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITOutbTransferredQuantity,
  JITOutbPickedQuantity,
  Material,
  StorageBin,
  DestinationStorageBin,
  PlannedOrder,
  ProductName,
  1 AS TotalNumberOfJITCalls,
  cast( 1 as abap.int4 ) AS NumberOfDistinctProducts,
  case when JITExternalReplenishment = 'X' then cast((ActualDeliveredQuantity - RequestedQuantity) as abap.quan(13,3)) else cast((JITOutbPickedQuantity - RequestedQuantity) as abap.quan(13,3)) end as JITOutbDeviationInQty AS quan133endasJITOutbDeviationInQty,
  JITExternalReplenishment,
  Supplier,
  UnitOfMeasureNumberOfDecimals
FROM I_JITOutbCallDetails AS _JITOutbCallDetails
LEFT OUTER JOIN C_JITOutbPlantVH AS _JITOutbPlantVH ON Plant = _JITOutbPlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITOutbMaterialVH AS _JITOutbMaterialVH ON Material = _JITOutbMaterialVH.Product  -- association [0..*]
LEFT OUTER JOIN C_JITLifecycleStatusValueHelp AS _JITLifecycleStatusValueHelp ON JITLifecycleStatus = _JITLifecycleStatusValueHelp.JITLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_JITOutbInternalStatusVH AS _JITOutbInternalStatusVH ON JITIntProcessingStatus = _JITOutbInternalStatusVH.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_JITControlCycleVH AS _JITControlCycleVH ON JITControlCycle = _JITControlCycleVH.JITControlCycle  -- association [0..1]
LEFT OUTER JOIN C_JITCallTypeValueHelp AS _JITCallTypeValueHelp ON JITCallType = _JITCallTypeValueHelp.JITCallType  -- association [0..1]
LEFT OUTER JOIN C_JITOutbStorageBinVH AS _JITOutbStorageBinVH ON StorageBin = _JITOutbStorageBinVH.StorageBin  -- association [0..*]
LEFT OUTER JOIN I_JITOutbMntrSupplyAreaVH AS _JITOutbSupplyAreaVH ON ProductionSupplyArea = _JITOutbSupplyAreaVH.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_JITOutbMntrStorageLocVH AS _JITOutbMntrStorageLocVH ON StorageLocation = _JITOutbMntrStorageLocVH.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_JITOutbSqncMntrSupplierVH AS _JITOutbSqncMntrSupplierVH ON Supplier = _JITOutbSqncMntrSupplierVH.Supplier  -- association [0..1]
LEFT OUTER JOIN I_JITOutbSqncMntrPlndOrd AS _JITOutbSqncMntrPlndOrdVH ON PlannedOrder = _JITOutbSqncMntrPlndOrdVH.JITPlannedOrderNumber  -- association [0..1]
LEFT OUTER JOIN I_JITOutbMntrDestStorLocVH AS _JITOutbMntrDestStorLocVH ON JITOutbDestinationStorLoc = _JITOutbMntrDestStorLocVH.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_JITOutbDestStorLocBin AS _JITOutbDestStorLocBinVH ON DestinationStorageBin = _JITOutbDestStorLocBinVH.DestinationStorageBin  -- association [0..1]
LEFT OUTER JOIN I_JITOutbSqncMntrJITCall AS _JITOutbSqncMntrJITCallVH ON InternalJITCallNumber = _JITOutbSqncMntrJITCallVH.InternalJITCallNumber  -- association [0..1]
;