P_ABOPRunAllConfirmations

DDL: P_ABOPRUNALLCONFIRMATIONS SQL: PABOPRUNALLCNF Type: view COMPOSITE
80 Fields 5 Data Sources

P_ABOPRunAllConfirmations is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (P_ABOPRUNConfAfterWithAddUnits, P_ABOPRUNConfBeforeWthAddUnits, P_ABOPFUPProcResAftWthAddUnits, P_ABOPFUPProcResBefWthAddUnits, I_ATPProcessedRequirement) and exposes 80 fields with key fields ATPRequirementUUID, ATPCheckUUID, ATPCheckRelevantUTCDateTime, Product, Plant.

Data Sources (5)

SourceAliasJoin Type
P_ABOPRUNConfAfterWithAddUnits ConfAfter from
P_ABOPRUNConfBeforeWthAddUnits ConfBefore union
P_ABOPFUPProcResAftWthAddUnits P_ABOPFUPProcResAftWthAddUnits union
P_ABOPFUPProcResBefWthAddUnits P_ABOPFUPProcResBefWthAddUnits union
I_ATPProcessedRequirement Requirement inner

Annotations (7)

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

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY ATPRequirementUUID I_ATPProcessedRequirement ATPRequirementUUID Requirement UUID
KEY ATPCheckUUID P_ABOPRUNConfAfterWithAddUnits ATPCheckUUID Check ID
KEY ATPCheckRelevantUTCDateTime P_ABOPRUNConfAfterWithAddUnits ConfdProdAvailabilityUTCDteTme Time Stamp
KEY Product Product Product Sold
KEY Plant SupplyingPlant Supplying Plant
KEY StorageLocation P_ABOPRUNConfAfterWithAddUnits SupplyingStorageLocation Location
ATPCheckRelevantTimeZone P_ABOPRUNConfAfterWithAddUnits ConfdProdAvailabilityTimeZone Time Zone
ConfirmedQtyBeforeInBaseUnit Sum of Confirmed Quantities
ConfirmedQtyAfterInBaseUnit P_ABOPRUNConfAfterWithAddUnits ConfirmedQuantityInBaseUnit Sum of Confirmed Quantities
SupAssgmtQtyBeforeInBaseUnit Requested Qty
SupAssgmtQtyAfterInBaseUnit Requested Qty
ConfirmedQtyBefInComBaseUnit
ConfirmedQtyAftInComBaseUnit P_ABOPRUNConfAfterWithAddUnits ConfirmedQuantityInComBaseUnit
SupAssgmtQtyBefInComBaseUnit
SupAssgmtQtyAftInComBaseUnit
BaseUnit P_ABOPRUNConfAfterWithAddUnits BaseUnit Unit of Measure
BaseToCommonBaseQtyNumerator P_ABOPRUNConfAfterWithAddUnits BaseToCommonBaseQtyNumerator Numerator
BaseToCommonBaseQtyDenominator P_ABOPRUNConfAfterWithAddUnits BaseToCommonBaseQtyDenominator Denominator
SupAssgmtReasonCode
_SupplyingPlant P_ABOPRUNConfAfterWithAddUnits _SupplyingPlant
ATPRequirementUUID Requirement UUID
KEY ATPCheckUUID P_ABOPRUNConfBeforeWthAddUnits ATPCheckUUID Check ID
KEY ATPCheckRelevantUTCDateTime P_ABOPRUNConfBeforeWthAddUnits ConfdProdAvailabilityUTCDteTme Time Stamp
KEY Product Product Product Sold
KEY Plant SupplyingPlant Supplying Plant
KEY StorageLocation SupplyingStorageLocation Location
ATPCheckRelevantTimeZone P_ABOPRUNConfBeforeWthAddUnits ConfdProdAvailabilityTimeZone Time Zone
ConfirmedQtyBeforeInBaseUnit P_ABOPRUNConfBeforeWthAddUnits ConfirmedQuantityInBaseUnit Sum of Confirmed Quantities
ConfirmedQtyAfterInBaseUnit Sum of Confirmed Quantities
SupAssgmtQtyBeforeInBaseUnit Requested Qty
SupAssgmtQtyAfterInBaseUnit Requested Qty
ConfirmedQtyBefInComBaseUnit P_ABOPRUNConfBeforeWthAddUnits ConfirmedQuantityInComBaseUnit
ConfirmedQtyAftInComBaseUnit
SupAssgmtQtyBefInComBaseUnit
SupAssgmtQtyAftInComBaseUnit
BaseUnit P_ABOPRUNConfBeforeWthAddUnits BaseUnit Unit of Measure
BaseToCommonBaseQtyNumerator P_ABOPRUNConfBeforeWthAddUnits BaseToCommonBaseQtyNumerator Numerator
BaseToCommonBaseQtyDenominator P_ABOPRUNConfBeforeWthAddUnits BaseToCommonBaseQtyDenominator Denominator
SupAssgmtReasonCode
_SupplyingPlant P_ABOPRUNConfBeforeWthAddUnits _SupplyingPlant
ATPRequirementUUID Requirement UUID
KEY ATPCheckUUID ATPCheckUUID Check ID
KEY ATPCheckRelevantUTCDateTime ProcessedUTCDateTime Time Stamp
KEY Product Product Sold
KEY Plant Supplying Plant
KEY StorageLocation Location
ATPCheckRelevantTimeZone ProcessedTimeZone Time Zone
ConfirmedQtyBeforeInBaseUnit Sum of Confirmed Quantities
ConfirmedQtyAfterInBaseUnit Sum of Confirmed Quantities
SupAssgmtQtyBeforeInBaseUnit Requested Qty
SupAssgmtQtyAfterInBaseUnit ProcessedQuantityInBaseUnit Requested Qty
ConfirmedQtyBefInComBaseUnit
ConfirmedQtyAftInComBaseUnit
SupAssgmtQtyBefInComBaseUnit
SupAssgmtQtyAftInComBaseUnit ProcessedQuantityInComBaseUnit
BaseUnit BaseUnit Unit of Measure
BaseToCommonBaseQtyNumerator BaseToCommonBaseQtyNumerator Numerator
BaseToCommonBaseQtyDenominator BaseToCommonBaseQtyDenominator Denominator
SupAssgmtReasonCode
_SupplyingPlant
KEY ATPCheckUUID ATPCheckUUID Check ID
KEY ATPCheckRelevantUTCDateTime ProcessedUTCDateTime Time Stamp
KEY Product _ATPConfirmation Product Product Sold
KEY Plant _ATPConfirmation SupplyingPlant Supplying Plant
KEY StorageLocation _ATPConfirmation SupplyingStorageLocation Location
ATPCheckRelevantTimeZone ProcessedTimeZone Time Zone
ConfirmedQtyBeforeInBaseUnit Sum of Confirmed Quantities
ConfirmedQtyAfterInBaseUnit Sum of Confirmed Quantities
SupAssgmtQtyBeforeInBaseUnit ProcessedQuantityInBaseUnit Requested Qty
SupAssgmtQtyAfterInBaseUnit Requested Qty
ConfirmedQtyBefInComBaseUnit
ConfirmedQtyAftInComBaseUnit
SupAssgmtQtyBefInComBaseUnit ProcessedQuantityInComBaseUnit
SupAssgmtQtyAftInComBaseUnit
BaseUnit BaseUnit Unit of Measure
BaseToCommonBaseQtyNumerator BaseToCommonBaseQtyNumerator Numerator
BaseToCommonBaseQtyDenominator BaseToCommonBaseQtyDenominator Denominator
SupAssgmtReasonCode
_SupplyingPlant _ATPConfirmation _SupplyingPlant
_SupplyingStorageLocation _ATPConfirmation _SupplyingStorageLocation

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_ABOPRunAllConfirmations.
-- 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: PABOPRUNALLCNF

CREATE VIEW P_ABOPRunAllConfirmations AS
SELECT
  Requirement.ATPRequirementUUID AS ATPRequirementUUID,
  ConfAfter.ATPCheckUUID AS ATPCheckUUID,
  ConfAfter.ConfdProdAvailabilityUTCDteTme AS ATPCheckRelevantUTCDateTime,
  Product,
  SupplyingPlant AS Plant,
  ConfAfter.SupplyingStorageLocation AS StorageLocation,
  ConfAfter.ConfdProdAvailabilityTimeZone AS ATPCheckRelevantTimeZone,
  cast (0 as bs_atp_cnf_qty) AS ConfirmedQtyBeforeInBaseUnit,
  ConfAfter.ConfirmedQuantityInBaseUnit AS ConfirmedQtyAfterInBaseUnit,
  cast (0 as bs_atp_cnf_qty) AS SupAssgmtQtyBeforeInBaseUnit,
  cast (0 as bs_atp_cnf_qty) AS SupAssgmtQtyAfterInBaseUnit,
  cast (0 as bs_atp_cnf_qty) AS ConfirmedQtyBefInComBaseUnit,
  ConfAfter.ConfirmedQuantityInComBaseUnit AS ConfirmedQtyAftInComBaseUnit,
  cast (0 as bs_atp_cnf_qty) AS SupAssgmtQtyBefInComBaseUnit,
  cast (0 as bs_atp_cnf_qty) AS SupAssgmtQtyAftInComBaseUnit,
  ConfAfter.BaseUnit AS BaseUnit,
  ConfAfter.BaseToCommonBaseQtyNumerator AS BaseToCommonBaseQtyNumerator,
  ConfAfter.BaseToCommonBaseQtyDenominator AS BaseToCommonBaseQtyDenominator,
  cast('' as atp_reason_code) AS SupAssgmtReasonCode,
  ConfAfter._SupplyingPlant AS _SupplyingPlant,
  _ATPConfirmation._SupplyingStorageLocation AS _SupplyingStorageLocation
FROM P_ABOPRUNConfAfterWithAddUnits AS ConfAfter
INNER JOIN I_ATPProcessedRequirement AS Requirement ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): P_ABOPRUNConfBeforeWthAddUnits, P_ABOPFUPProcResAftWthAddUnits, P_ABOPFUPProcResBefWthAddUnits
;

Learn More