I_JITOutbCallDetails

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_JITOutbCallDetails.
-- 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: IJITOUTBCALL

CREATE VIEW I_JITOutbCallDetails AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITLifecycleStatus,
  _JITLifecycleStatus._Text[1: Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  JITCallType,
  Plant,
  StorageLocation,
  RequirementDateTime,
  JITIntProcessingStatus,
  _JITInternalStatus._Text[1: Language = $session.system_language].JITInternalStatusText AS JITInternalStatusText,
  ProductionSupplyArea,
  JITControlCycle,
  Responsible,
  StorageBin,
  JITOutbStockTransferSts,
  _JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITStockTransferStsText,
  JITOutbDestinationStorLoc,
  Material,
  RequestedQuantity,
  UnitOfMeasureNumberOfDecimals,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITOutbTransferredQuantity,
  JITOutbMinimumQuantity,
  JITOutbPickedQuantity,
  PlannedOrder,
  ProductName,
  JITExternalReplenishment,
  Supplier
FROM I_JITOutbCalls AS _JITOutbCalls
LEFT OUTER JOIN C_JITOutbPlantVH AS _JITOutbPlantVH ON Plant = _JITOutbPlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSupplyAreaVH AS _JITOutbSupplyAreaVH ON ProductionSupplyArea = _JITOutbSupplyAreaVH.ProductionSupplyArea AND Plant = _JITOutbSupplyAreaVH.Plant AND StorageLocation = _JITOutbSupplyAreaVH.StorageLocation  -- association [0..*]
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 C_JITInternalStatusVH AS _JITInternalStatusVH ON JITIntProcessingStatus = _JITInternalStatusVH.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_JITControlCycleVH AS _JITControlCycleVH ON JITControlCycle = _JITControlCycleVH.JITControlCycle  -- association [0..*]
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..*]
;