P_ABOPRunRqmtAggregationCalc

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_ABOPRunRqmtAggregationCalc.
-- 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.
-- Parameters: P_ExcldRqmtsAreIncldInRsltFigs : boole_d

CREATE VIEW P_ABOPRunRqmtAggregationCalc AS
SELECT
  ABOPRunUUID,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  ATPRelevantDocumentCategory,
  ABOPRunPartUUID,
  IsIterationRequirement,
  Requirement.PurchaseOrderItem AS PurchaseOrderItem,
  Material,
  Plant,
  cast(_SalesDocument.SoldToParty as atp_requirement_recipient ) AS Recipient,
  _SalesDocument._SoldToParty.CustomerName AS RecipientText,
  cast('SP' as atp_recipient_type ) AS ATPRecipientType,
  _SalesDocument._SoldToParty.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  IsSalesDocument,
  IsStockTransportDocument,
  ABOPConfirmationStrategy,
  ATPCheckItemStatus,
  RqmtIsProcessed,
  RqmtIsLocked,
  RqmtIsExcluded,
  RqmtIsWithIssues,
  RqmtIsSupAssgmtRelevant,
  ABOPSegmentUUID,
  RqmtIsIncldInConfirmationFigs,
  RqmtIsIncldInSupAssignmentFigs,
  RqmtIsFullyConfdOnTimeBfrRun,
  RqmtIsFullyConfdOnTimeAfterRun,
  RqmtIsFullyAssgdOnTimeBfrRun,
  RqmtIsFullyAssgdOnTimeAftRun,
  RqmtIsFullyConfdBeforeRun,
  RqmtIsFullyConfdAfterRun,
  RqmtIsFullyAssignedBeforeRun,
  RqmtIsFullyAssignedAfterRun,
  RqmtWasSentToOrderUpdate,
  RqmtWithOrderUpdateIssues,
  BaseUnit AS PurchaseOrderItemkeyABOPRunUUID,
  BaseUnit
FROM P_ABOPRunRqmtAggregation
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON ATPRelevantDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_StockTransportOrderItem AS _StockTransportOrderItem ON ATPRelevantDocument = _StockTransportOrderItem.PurchaseOrder AND PurchaseOrderItem = _StockTransportOrderItem.PurchaseOrderItem  -- association [0..1]
-- UNION ALL with additional select branch(es): P_ABOPRunRqmtAggregation
;