C_ABOPRunStrategy_2

DDL: C_ABOPRUNSTRATEGY_2 Type: view_entity CONSUMPTION

Run Confirmation Details by Strategy

C_ABOPRunStrategy_2 is a Consumption CDS View that provides data about "Run Confirmation Details by Strategy" in SAP S/4HANA. It reads from 1 data source (I_ABOPRunStrategy_2) and exposes 30 fields with key fields ABOPRunUUID, ABOPConfirmationStrategy. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ABOPRunStrategy_2 I_ABOPRunStrategy_2 projection

Associations (3)

CardinalityTargetAliasCondition
[1..*] C_ABOPRunRequirement_2 _Requirements $projection.ABOPRunUUID = _Requirements.ABOPRunUUID and $projection.ABOPConfirmationStrategy = _Requirements.ABOPConfirmationStrategy
[0..1] C_ABOPRunStatusByStrategy _ProcessStatus $projection.ABOPRunUUID = _ProcessStatus.ABOPRunUUID and $projection.ABOPConfirmationStrategy = _ProcessStatus.ABOPConfirmationStrategy
[1..1] C_ABOPRunStatusText _ABOPRunStatusText $projection.ABOPRunStatus = _ABOPRunStatusText.ATPCheckStatus and _ABOPRunStatusText.Language = $session.system_language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Run Confirmation Details by Strategy view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Search.searchable true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ABOPRunUUID ABOPRunUUID Check ID
KEY ABOPConfirmationStrategy ABOPConfirmationStrategy Confirmation Strategy
ABOPConfirmationStrategyTextlocalized
ABOPVariantUUID ABOPVariantUUID BOP Variant UUID
virtualDocumentHeaderTexttext1024 Processing Identifier Description
ABOPRunStatus ABOPRunStatus Processing Status
ATPCheckHasOnlyHeader ATPCheckHasOnlyHeader Only Header Logged
NumberOfRqmtsIncldInConfFigs NumberOfRqmtsIncldInConfFigs
NumberOfRqmtsIncldInAssgmtFigs NumberOfRqmtsIncldInAssgmtFigs
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.
NmbrOfSuccessfullyUpdatedRqmts NmbrOfSuccessfullyUpdatedRqmts Updated
ABOPExecutionMode ABOPExecutionMode
ABOPExecutionModeText ABOPExecutionModeText
NumberOfRequirements NumberOfRequirements Requirements
NumberOfProcessedRequirements NumberOfProcessedRequirements Processed Requirements
NumberOfRequirementsWithIssues NumberOfRequirementsWithIssues Processing Issues
NmbrOfRqmtsWthConfOrARunIssues NmbrOfRqmtsWthConfOrARunIssues
NmbrOfRqmtsWithOrderUpdtIssues NmbrOfRqmtsWithOrderUpdtIssues Update Issues
CritltyCodeForRqmtsWithIssue CritltyCodeForRqmtsWithIssue
BaseUnit BaseUnit Unit of Measure
ABOPRunApplicationType _ABOPRun ABOPRunApplicationType
_ABOPRunredirectedtoparentC_ABOPRun_2
_Requirements _Requirements
_ProcessStatus _ProcessStatus
_ABOPRunStatusText _ABOPRunStatusText

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_ABOPRunStrategy_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_ABOPRunStrategy_2 AS
SELECT
  ABOPRunUUID,
  ABOPConfirmationStrategy,
  _ABOPStrategyText.ABOPConfirmationStrategyText : localized AS ABOPConfirmationStrategyTextlocalized,
  ABOPVariantUUID,
  virtual DocumentHeaderText : text1024 AS virtualDocumentHeaderTexttext1024,
  ABOPRunStatus,
  ATPCheckHasOnlyHeader,
  NumberOfRqmtsIncldInConfFigs,
  NumberOfRqmtsIncldInAssgmtFigs,
  OnTimeConfdRqmtsBeforeRunPct,
  OnTimeConfdRqmtsAfterRunPct,
  ConfdRqmtsBeforeRunPercent,
  ConfdRqmtsAfterRunPercent,
  SupAssgdRqmtsBeforeRunPercent,
  SupAssgdRqmtsAfterRunPercent,
  NmbrOfSuccessfullyUpdatedRqmts,
  ABOPExecutionMode,
  ABOPExecutionModeText,
  NumberOfRequirements,
  NumberOfProcessedRequirements,
  NumberOfRequirementsWithIssues,
  NmbrOfRqmtsWthConfOrARunIssues,
  NmbrOfRqmtsWithOrderUpdtIssues,
  CritltyCodeForRqmtsWithIssue,
  BaseUnit,
  _ABOPRun.ABOPRunApplicationType AS ABOPRunApplicationType
FROM I_ABOPRunStrategy_2
LEFT OUTER JOIN C_ABOPRunRequirement_2 AS _Requirements ON ABOPRunUUID = _Requirements.ABOPRunUUID AND ABOPConfirmationStrategy = _Requirements.ABOPConfirmationStrategy  -- association [1..*]
LEFT OUTER JOIN C_ABOPRunStatusByStrategy AS _ProcessStatus ON ABOPRunUUID = _ProcessStatus.ABOPRunUUID AND ABOPConfirmationStrategy = _ProcessStatus.ABOPConfirmationStrategy  -- association [0..1]
LEFT OUTER JOIN C_ABOPRunStatusText AS _ABOPRunStatusText ON ABOPRunStatus = _ABOPRunStatusText.ATPCheckStatus AND _ABOPRunStatusText.Language = $session.system_language  -- association [1..1]
;