P_ABOPRunRqmtAggregationCalc_2

DDL: P_ABOPRUNRQMTAGGREGATIONCALC_2 Type: view_entity COMPOSITE

P_ABOPRunRqmtAggregationCalc_2 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_ABOPRunRqmtAggregation_2, P_ABOPRunRqmtAggregation_2) and exposes 43 fields with key fields ABOPRunUUID, ATPRelevantDocument, ATPRelevantDocument. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_ABOPRunRqmtAggregation_2 P_ABOPRunRqmtAggregation_2 from
P_ABOPRunRqmtAggregation_2 P_ABOPRunRqmtAggregation_2 union_all

Parameters (1)

NameTypeDefault
P_RqmtIsABOPRunItrtnRelevant abap_boolean

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SalesDocument _SalesDocument $projection.ATPRelevantDocument = _SalesDocument.SalesDocument
[0..1] I_StockTransportOrderItem _StockTransportOrderItem $projection.ATPRelevantDocument = _StockTransportOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _StockTransportOrderItem.PurchaseOrderItem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY ABOPRunUUID ABOPRunUUID Check ID
KEY ATPRelevantDocument ATPRelevantDocument MRP element number
ABOPRunPartUUID ABOPRunPartUUID
RqmtIsABOPRunItrtnRelevant RqmtIsABOPRunItrtnRelevant
PurchaseOrderItem Requirement PurchaseOrderItem Purchasing Document Item
Recipient _SalesDocument SoldToParty Receiving Plant
RqmtIsProcessed RqmtIsProcessed
RqmtIsLocked RqmtIsLocked
RqmtIsWithIssues RqmtIsWithIssues
RqmtIsSupAssgmtRelevant RqmtIsSupAssgmtRelevant
RqmtIsIncldInConfirmationFigs RqmtIsIncldInConfirmationFigs
RqmtIsIncldInSupAssignmentFigs RqmtIsIncldInSupAssignmentFigs
RqmtIsFullyConfdOnTimeBfrRun RqmtIsFullyConfdOnTimeBfrRun
RqmtIsFullyConfdOnTimeAfterRun RqmtIsFullyConfdOnTimeAfterRun
RqmtIsFullyAssgdOnTimeBfrRun RqmtIsFullyAssgdOnTimeBfrRun
RqmtIsFullyAssgdOnTimeAftRun RqmtIsFullyAssgdOnTimeAftRun
RqmtIsFullyConfdBeforeRun RqmtIsFullyConfdBeforeRun
RqmtIsFullyConfdAfterRun RqmtIsFullyConfdAfterRun
RqmtIsFullyAssignedBeforeRun RqmtIsFullyAssignedBeforeRun
RqmtIsFullyAssignedAfterRun RqmtIsFullyAssignedAfterRun
RqmtWasSentToOrderUpdate RqmtWasSentToOrderUpdate
PurchaseOrderItemkeyABOPRunUUID
KEY ATPRelevantDocument ATPRelevantDocument MRP element number
ABOPRunPartUUID ABOPRunPartUUID
RqmtIsABOPRunItrtnRelevant RqmtIsABOPRunItrtnRelevant
PurchaseOrderItem Requirement PurchaseOrderItem Purchasing Document Item
Recipient _StockTransportOrderItem ReceivingPlant Receiving Plant
RqmtIsProcessed RqmtIsProcessed
RqmtIsLocked RqmtIsLocked
RqmtIsWithIssues RqmtIsWithIssues
RqmtIsSupAssgmtRelevant RqmtIsSupAssgmtRelevant
RqmtIsIncldInConfirmationFigs RqmtIsIncldInConfirmationFigs
RqmtIsIncldInSupAssignmentFigs RqmtIsIncldInSupAssignmentFigs
RqmtIsFullyConfdOnTimeBfrRun RqmtIsFullyConfdOnTimeBfrRun
RqmtIsFullyConfdOnTimeAfterRun RqmtIsFullyConfdOnTimeAfterRun
RqmtIsFullyAssgdOnTimeBfrRun RqmtIsFullyAssgdOnTimeBfrRun
RqmtIsFullyAssgdOnTimeAftRun RqmtIsFullyAssgdOnTimeAftRun
RqmtIsFullyConfdBeforeRun RqmtIsFullyConfdBeforeRun
RqmtIsFullyConfdAfterRun RqmtIsFullyConfdAfterRun
RqmtIsFullyAssignedBeforeRun RqmtIsFullyAssignedBeforeRun
RqmtIsFullyAssignedAfterRun RqmtIsFullyAssignedAfterRun
RqmtWasSentToOrderUpdate RqmtWasSentToOrderUpdate
RqmtWithOrderUpdateIssues RqmtWithOrderUpdateIssues

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_2.
-- 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_RqmtIsABOPRunItrtnRelevant : abap_boolean

CREATE VIEW P_ABOPRunRqmtAggregationCalc_2 AS
SELECT
  ABOPRunUUID,
  ATPRelevantDocument,
  ABOPRunPartUUID,
  RqmtIsABOPRunItrtnRelevant,
  Requirement.PurchaseOrderItem AS PurchaseOrderItem,
  _SalesDocument.SoldToParty AS Recipient,
  RqmtIsProcessed,
  RqmtIsLocked,
  RqmtIsWithIssues,
  RqmtIsSupAssgmtRelevant,
  RqmtIsIncldInConfirmationFigs,
  RqmtIsIncldInSupAssignmentFigs,
  RqmtIsFullyConfdOnTimeBfrRun,
  RqmtIsFullyConfdOnTimeAfterRun,
  RqmtIsFullyAssgdOnTimeBfrRun,
  RqmtIsFullyAssgdOnTimeAftRun,
  RqmtIsFullyConfdBeforeRun,
  RqmtIsFullyConfdAfterRun,
  RqmtIsFullyAssignedBeforeRun,
  RqmtIsFullyAssignedAfterRun,
  RqmtWasSentToOrderUpdate,
  RqmtWithOrderUpdateIssues AS PurchaseOrderItemkeyABOPRunUUID,
  RqmtWithOrderUpdateIssues
FROM P_ABOPRunRqmtAggregation_2
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_2
;