I_ABOPRunPrtRsltFigsByProdPlnt

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

CREATE VIEW I_ABOPRunPrtRsltFigsByProdPlnt AS
SELECT
  ABOPRunPartUUID,
  Material,
  Plant,
  count(*) AS NumberOfRequirements,
  sum(RqmtIsProcessed) AS NumberOfProcessedRequirements,
  sum(RqmtIsLocked) AS NumberOfLockedRequirements,
  sum(RqmtIsExcluded) AS NumberOfExcludedRequirements,
  sum(RqmtIsWithIssues) AS NumberOfRequirementsWithIssues,
  sum(RqmtIsSupAssgmtRelevant) AS NumberOfSupAssgmtRelevantRqmts,
  sum(RqmtIsIncldInConfirmationFigs) AS NumberOfRqmtsIncldInConfFigs,
  sum(RqmtIsIncldInSupAssignmentFigs) AS NumberOfRqmtsIncldInAssgmtFigs,
  sum(RqmtIsFullyConfdOnTimeBfrRun) AS NmbrOfConfdRqmtsOnTimeBfrRun,
  sum(RqmtIsFullyConfdOnTimeAfterRun) AS NmbrOfConfdRqmtsOnTimeAfterRun,
  sum(RqmtIsFullyAssgdOnTimeBfrRun) AS NmbrOfSupAssgdRqmtsOnTmeBfrRun,
  sum(RqmtIsFullyAssgdOnTimeAftRun) AS NmbrOfSupAssgdRqmtsOnTmeAftRun,
  sum(RqmtIsFullyConfdBeforeRun) AS NmbrOfConfdRqmtsBeforeRun,
  sum(RqmtIsFullyConfdAfterRun) AS NmbrOfConfdRqmtsAfterRun,
  sum(RqmtIsFullyAssignedBeforeRun) AS NmbrOfSupAssgdRqmtsBeforeRun,
  sum(RqmtIsFullyAssignedAfterRun) AS NmbrOfSupAssgdRqmtsAfterRun,
  sum(RqmtWasSentToOrderUpdate) AS NmbrOfRqmtsSentToOrderUpdate,
  sum(RqmtWithOrderUpdateIssues) AS NmbrOfRqmtsWithOrderUpdtIssues
FROM P_ABOPRunRqmtAggregation
;