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,
  JITInternalStatusText,
  JITIntProcessingStatus,
  ProductionSupplyArea,
  JITControlCycle,
  Responsible,
  JITStockTransferStsText,
  JITOutbStockTransferSts,
  JITOutbDestinationStorLoc,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITOutbTransferredQuantity,
  JITOutbMinimumQuantity,
  JITOutbPickedQuantity,
  Material,
  StorageBin,
  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
;