C_ABOPRunFallback_2

DDL: C_ABOPRUNFALLBACK_2 Type: view_entity CONSUMPTION
34 Fields 1 Data Sources 2 Associations

Run And Its Fallbacks in BOP

C_ABOPRunFallback_2 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_2) and exposes 34 fields with key field ABOPRunUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ABOPRunIteration_2 I_ABOPRunIteration_2 projection

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_ABOPRunFallbackStatus _ProcessStatus $projection.ABOPRunUUID = _ProcessStatus.ABOPRunUUID
[1..1] C_ABOPRunStatusText _ABOPRunStatusText $projection.ABOPRunStatus = _ABOPRunStatusText.ATPCheckStatus and _ABOPRunStatusText.Language = $session.system_language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Run And Its Fallbacks in BOP view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ABOPRunUUID ABOPRunUUID Check ID
ABOPVariantUUID ABOPVariantUUID BOP Variant UUID
virtualDocumentHeaderTexttext1024 Processing Identifier Description
ABOPVariantDescriptionlocalized
ABOPRunSummaryUUID ABOPRunSummaryUUID Check ID
ABOPRunName ABOPVariantName Run Name
StartedByUser StartedByUser Excuted By
ABOPRunStatus ABOPRunStatus
ABOPRunStartUTCDateTime ABOPRunStartUTCDateTime Started
ABOPRunEndUTCDateTime ABOPRunEndUTCDateTime Completed
ABOPExecutionMode ABOPExecutionMode
ABOPExecutionModeText ABOPExecutionModeText Execution Mode
NumberOfRequirements NumberOfRequirements Requirements
NumberOfProcessedRequirements NumberOfProcessedRequirements Processed Requirements
BaseUnit BaseUnit Unit of Measure
OnTimeConfdRqmtsBeforeRunPct OnTimeConfdRqmtsBeforeRunPct Processed Req. Fully Conf. On-Time Bfr.
OnTimeConfdRqmtsAfterRunPct OnTimeConfdRqmtsAfterRunPct Processed Req. Fully Conf. On-Time Aft.
ConfdRqmtsBeforeRunPercent ConfdRqmtsBeforeRunPercent Processed Requirements Fully Conf. Bfr.
ConfdRqmtsAfterRunPercent ConfdRqmtsAfterRunPercent Processed Requirements Fully Conf. Aft.
SupAssgdRqmtsBeforeRunPercent SupAssgdRqmtsBeforeRunPercent Processed Requirements Fully Assgn. Bfr.
SupAssgdRqmtsAfterRunPercent SupAssgdRqmtsAfterRunPercent Processed Requirements Fully Assgn. Aft.
NumberOfRqmtsIncldInAssgmtFigs NumberOfRqmtsIncldInAssgmtFigs
NmbrOfRqmtsWithOrderUpdtIssues NmbrOfRqmtsWithOrderUpdtIssues
NumberOfRequirementsWithIssues NumberOfRequirementsWithIssues Processing Issues
NumberOfRqmtsIncldInConfFigs NumberOfRqmtsIncldInConfFigs
ATPCheckHasOnlyHeader ATPCheckHasOnlyHeader Only Header Logged
ApplicationLogHandle ApplicationLogHandle Log Handle
NmbrOfRqmtsWthConfOrARunIssues NmbrOfRqmtsWthConfOrARunIssues
CritltyCodeForRqmtsWithIssue CritltyCodeForRqmtsWithIssue
ABOPRunApplicationType ABOPRunApplicationType
_ABOPRunredirectedtoparentC_ABOPRun_2
_ABOPRunStatusText _ABOPRunStatusText
_ProcessStatus _ProcessStatus
_ResultFiguresForProcdRqmts _ResultFiguresForProcdRqmts

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

CREATE VIEW C_ABOPRunFallback_2 AS
SELECT
  ABOPRunUUID,
  ABOPVariantUUID,
  virtual DocumentHeaderText : text1024 AS virtualDocumentHeaderTexttext1024,
  _ABOPRun._Variant._Text.ABOPVariantDescription : localized AS ABOPVariantDescriptionlocalized,
  ABOPRunSummaryUUID,
  ABOPVariantName AS ABOPRunName,
  StartedByUser,
  ABOPRunStatus,
  ABOPRunStartUTCDateTime,
  ABOPRunEndUTCDateTime,
  ABOPExecutionMode,
  ABOPExecutionModeText,
  NumberOfRequirements,
  NumberOfProcessedRequirements,
  BaseUnit,
  OnTimeConfdRqmtsBeforeRunPct,
  OnTimeConfdRqmtsAfterRunPct,
  ConfdRqmtsBeforeRunPercent,
  ConfdRqmtsAfterRunPercent,
  SupAssgdRqmtsBeforeRunPercent,
  SupAssgdRqmtsAfterRunPercent,
  NumberOfRqmtsIncldInAssgmtFigs,
  NmbrOfRqmtsWithOrderUpdtIssues,
  NumberOfRequirementsWithIssues,
  NumberOfRqmtsIncldInConfFigs,
  ATPCheckHasOnlyHeader,
  ApplicationLogHandle,
  NmbrOfRqmtsWthConfOrARunIssues,
  CritltyCodeForRqmtsWithIssue,
  ABOPRunApplicationType
FROM I_ABOPRunIteration_2
LEFT OUTER JOIN C_ABOPRunFallbackStatus AS _ProcessStatus ON ABOPRunUUID = _ProcessStatus.ABOPRunUUID  -- association [0..1]
LEFT OUTER JOIN C_ABOPRunStatusText AS _ABOPRunStatusText ON ABOPRunStatus = _ABOPRunStatusText.ATPCheckStatus AND _ABOPRunStatusText.Language = $session.system_language  -- association [1..1]
;

Learn More