I_JITOutbCallsCompMatlData

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_JITOutbCallsCompMatlData.
-- 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: IJITOUTBCMD

CREATE VIEW I_JITOutbCallsCompMatlData AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  ParentDraftKey,
  RootDraftKey,
  Material,
  MaterialByCustomer,
  ExtJITCallItemNumber,
  SalesOrder,
  SalesOrderItem,
  RequestedQuantity,
  RequestedQuantityForEdit,
  ActualDeliveredQuantity,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOnDteTme,
  JITOutbStockTransferSts,
  QuantityUnit,
  JITOutbTransferredQuantity,
  JITOutbMinimumQuantity,
  JITOutbPickedQuantity,
  JITOutbOpenQuantity,
  ShortfallQuantity,
  case when RequestedQuantity < JITOutbPickedQuantity and _JITOutbCallCompGrpData.JITReqQtyUpperToleranceLvl is not initial then ( RequestedQuantity + ceil( cast( RequestedQuantity as abap.fltp ) * cast( _JITOutbCallCompGrpData.JITReqQtyUpperToleranceLvl as abap.fltp ) * 0.01 ) ) when RequestedQuantity > JITOutbPickedQuantity and _JITOutbCallCompGrpData.JITReqQtyLowerToleranceLvl is not initial then ( RequestedQuantity - ceil( cast( RequestedQuantity as abap.fltp ) * cast( _JITOutbCallCompGrpData.JITReqQtyLowerToleranceLvl as abap.fltp ) * 0.01 ) ) else 0 end as JITOutbToleranceQuantity AS 01else0endasJITOutbToleranceQuantity
FROM I_JITOutbCallCompMatl
LEFT OUTER JOIN I_JITOutbCallCompGrpData AS _JITOutbCallCompGrpData ON InternalJITCallNumber = _JITOutbCallCompGrpData.InternalJITCallNumber AND CompGrpNumber = _JITOutbCallCompGrpData.CompGrpNumber AND ParentDraftKey = _JITOutbCallCompGrpData.JITCallCompGrpUUID  -- association [1..1]
;