C_ABOPRunFallback

DDL: C_ABOPRUNFALLBACK Type: view_entity CONSUMPTION Package: ATP_BOP_MONITOR_VDM

Run and its fallbacks in BOP

C_ABOPRunFallback is a Consumption CDS View that provides data about "Run and its fallbacks in BOP" in SAP S/4HANA. It reads from 1 data source (I_ABOPRunIteration) and exposes 22 fields with key field ABOPRunUUID. It has 7 associations to related views. Part of development package ATP_BOP_MONITOR_VDM.

Data Sources (1)

SourceAliasJoin Type
I_ABOPRunIteration I_ABOPRunIteration from

Associations (7)

CardinalityTargetAliasCondition
[1..1] C_ABOPRun _ABOPRun $projection.ABOPRunSummaryUUID = _ABOPRun.ABOPRunUUID
[1..1] C_ABOPRunPartAllResultFigures _ResultFiguresForAllRqmts $projection.ABOPRunUUID = _ResultFiguresForAllRqmts.ABOPRunPartUUID
[1..1] C_ABOPRunPartResultFigures _ResultFiguresForProcdRqmts $projection.ABOPRunUUID = _ResultFiguresForProcdRqmts.ABOPRunPartUUID
[0..*] C_ABOPRunIterationProductPlant _MaterialPlants $projection.ABOPRunUUID = _MaterialPlants.ATPCheckIterationUUID
[0..*] C_ABOPRunIterationStrategy _Strategies $projection.ABOPRunUUID = _Strategies.ATPCheckIterationUUID
[0..*] C_ABOPRunIterationSoldToParty _SoldToParties $projection.ABOPRunUUID = _SoldToParties.ATPCheckIterationUUID
[0..*] I_ABOPVariantText _VariantText $projection.ABOPVariantUUID = _VariantText.ABOPVariantUUID

Annotations (9)

NameValueLevelField
EndUserText.label Run and its fallbacks in BOP view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ABOPRunUUID ABOPRunUUID Check ID
ATPCheckUUID ATPCheckUUID Check ID
TransactionCode TransactionCode Transaction Code
ABOPVariantUUID ABOPVariantUUID BOP Variant UUID
ABOPVariantName ABOPVariantName Variant Name
StartedByUser StartedByUser
ABOPRunStartUTCDateTime ABOPRunStartUTCDateTime Time Stamp
ABOPRunEndUTCDateTime ABOPRunEndUTCDateTime Time Stamp
ABOPRunStatus ABOPRunStatus
ATPCheckHasOnlyHeader _ABOPRun ATPCheckHasOnlyHeader Only Header Logged
ABOPExecutionMode ABOPExecutionMode Simulation
ApplicationLogHandle ApplicationLogHandle Log Handle
ABOPRunSummaryUUID ABOPRunSummaryUUID Check ID
ABOPRunExecutionOrder ABOPRunExecutionOrder Execution Order
ABOPRunIsSummary ABOPRunIsSummary
_ResultFiguresForAllRqmts _ResultFiguresForAllRqmts
_ResultFiguresForProcdRqmts _ResultFiguresForProcdRqmts
_MaterialPlants _MaterialPlants
_Strategies _Strategies
_SoldToParties _SoldToParties
_ATPCheckStatusTypeText _ATPCheckStatusTypeText
_VariantText _VariantText

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 C_ABOPRunFallback.
-- 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.

CREATE VIEW C_ABOPRunFallback AS
SELECT
  ABOPRunUUID,
  ATPCheckUUID,
  TransactionCode,
  ABOPVariantUUID,
  ABOPVariantName,
  StartedByUser,
  ABOPRunStartUTCDateTime,
  ABOPRunEndUTCDateTime,
  ABOPRunStatus,
  _ABOPRun.ATPCheckHasOnlyHeader AS ATPCheckHasOnlyHeader,
  ABOPExecutionMode,
  ApplicationLogHandle,
  ABOPRunSummaryUUID,
  ABOPRunExecutionOrder,
  ABOPRunIsSummary
FROM I_ABOPRunIteration
LEFT OUTER JOIN C_ABOPRun AS _ABOPRun ON ABOPRunSummaryUUID = _ABOPRun.ABOPRunUUID  -- association [1..1]
LEFT OUTER JOIN C_ABOPRunPartAllResultFigures AS _ResultFiguresForAllRqmts ON ABOPRunUUID = _ResultFiguresForAllRqmts.ABOPRunPartUUID  -- association [1..1]
LEFT OUTER JOIN C_ABOPRunPartResultFigures AS _ResultFiguresForProcdRqmts ON ABOPRunUUID = _ResultFiguresForProcdRqmts.ABOPRunPartUUID  -- association [1..1]
LEFT OUTER JOIN C_ABOPRunIterationProductPlant AS _MaterialPlants ON ABOPRunUUID = _MaterialPlants.ATPCheckIterationUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPRunIterationStrategy AS _Strategies ON ABOPRunUUID = _Strategies.ATPCheckIterationUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPRunIterationSoldToParty AS _SoldToParties ON ABOPRunUUID = _SoldToParties.ATPCheckIterationUUID  -- association [0..*]
LEFT OUTER JOIN I_ABOPVariantText AS _VariantText ON ABOPVariantUUID = _VariantText.ABOPVariantUUID  -- association [0..*]
;