P_JitOutbCallStockTransfer

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 P_JitOutbCallStockTransfer.
-- 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: PJITSTKTRNSR

CREATE VIEW P_JitOutbCallStockTransfer AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITControlCycle,
  JITHeaderUUID,
  Material,
  Plant,
  StorageLocation,
  JITCallType,
  JITLifecycleStatus,
  QuantityUnit,
  JITCallPriorityType,
  JITCallPriorityID,
  JITOutbStockTransferSts,
  JITCallImmediateRequest,
  cast(sum(_JITStkAnlysAtStorLoc.MatlWrhsStkQtyInMatlBaseUnit)as behmg) AS JITOutbStockQuantity,
  ProductionSupplyArea,
  RequirementDateTime,
  JITSupplyDateTime,
  JITOutbDestinationStorLoc,
  JITActionCtrl,
  JITSourceWarehouseNumber,
  RequestedQuantity,
  ActualDeliveredQuantity,
  JITOutbTransferredQuantity,
  JITOutbOpenQuantity,
  JITOutbMinimumQuantity,
  JITOutbPickedQuantity,
  ShortfallQuantity,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOnDteTme
FROM I_JITOutbCallStockTransfBasic
LEFT OUTER JOIN I_MaterialStock AS _JITStkAnlysAtStorLoc ON Material = _JITStkAnlysAtStorLoc.Material AND Plant = _JITStkAnlysAtStorLoc.Plant AND StorageLocation = _JITStkAnlysAtStorLoc.StorageLocation AND QuantityUnit = _JITStkAnlysAtStorLoc.MaterialBaseUnit AND _JITStkAnlysAtStorLoc.InventoryStockType = '01' AND _JITStkAnlysAtStorLoc.MatlDocLatestPostgDate <= $session.system_date  -- association [0..*]
;