P_ABOPRunRqmtQuantityBefore

DDL: P_ABOPRUNRQMTQUANTITYBEFORE SQL: PABOPRUNRQTYBFR Type: view COMPOSITE
10 Fields 1 Data Sources 2 Associations

P_ABOPRunRqmtQuantityBefore is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ABOPRunConfDatesBefore) and exposes 10 fields with key field ATPRequirementUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ABOPRunConfDatesBefore P_ABOPRunConfDatesBefore from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_ABOPRunConfBfrByAvailyDate _EarliestConfirmation $projection.ATPRequirementUUID = _EarliestConfirmation.ATPRequirementUUID and $projection.ErlstConfdProdAvailyDteTme = _EarliestConfirmation.ATPCheckRelevantUTCDateTime
[0..1] P_ABOPConfBfrRunByAvailyDate _LatestConfirmation $projection.ATPRequirementUUID = _LatestConfirmation.ATPRequirementUUID and $projection.LatestConfdProdAbailyDteTme = _LatestConfirmation.ATPCheckRelevantUTCDateTime

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PABOPRUNRQTYBFR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ATPRequirementUUID ATPRequirementUUID Requirement UUID
ATPCheckUUID ATPCheckUUID Check ID
ErlstConfdProdAvailyDteTme ErlstConfdProdAvailyDteTme
ErlstConfdQtyInBaseUnit _EarliestConfirmation ConfirmedQtyInBaseUnit
ErlstConfdQtyInComBaseUnit _EarliestConfirmation ConfirmedQtyInComBaseUnit
ErlstConfdProdAvailyTimeZone _EarliestConfirmation ATPCheckRelevantTimeZone
LatestConfdProdAbailyDteTme LatestConfdProdAbailyDteTme
LatestConfdProdAvailyTimeZone _LatestConfirmation ATPCheckRelevantTimeZone
ConfirmedQtyInBaseUnit ConfirmedQtyInBaseUnit
ConfirmedQtyInComBaseUnit ConfirmedQtyInComBaseUnit

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_ABOPRunRqmtQuantityBefore.
-- 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: PABOPRUNRQTYBFR

CREATE VIEW P_ABOPRunRqmtQuantityBefore AS
SELECT
  ATPRequirementUUID,
  ATPCheckUUID,
  ErlstConfdProdAvailyDteTme,
  _EarliestConfirmation.ConfirmedQtyInBaseUnit AS ErlstConfdQtyInBaseUnit,
  _EarliestConfirmation.ConfirmedQtyInComBaseUnit AS ErlstConfdQtyInComBaseUnit,
  _EarliestConfirmation.ATPCheckRelevantTimeZone AS ErlstConfdProdAvailyTimeZone,
  LatestConfdProdAbailyDteTme,
  _LatestConfirmation.ATPCheckRelevantTimeZone AS LatestConfdProdAvailyTimeZone,
  ConfirmedQtyInBaseUnit,
  ConfirmedQtyInComBaseUnit
FROM P_ABOPRunConfDatesBefore
LEFT OUTER JOIN P_ABOPRunConfBfrByAvailyDate AS _EarliestConfirmation ON ATPRequirementUUID = _EarliestConfirmation.ATPRequirementUUID AND ErlstConfdProdAvailyDteTme = _EarliestConfirmation.ATPCheckRelevantUTCDateTime  -- association [0..1]
LEFT OUTER JOIN P_ABOPConfBfrRunByAvailyDate AS _LatestConfirmation ON ATPRequirementUUID = _LatestConfirmation.ATPRequirementUUID AND LatestConfdProdAbailyDteTme = _LatestConfirmation.ATPCheckRelevantUTCDateTime  -- association [0..1]
;

Learn More