C_ABOPRunMaterialPlant_2

DDL: C_ABOPRUNMATERIALPLANT_2 Type: view_entity CONSUMPTION
36 Fields 1 Data Sources 3 Associations

Run Conf Details by Material Plant

C_ABOPRunMaterialPlant_2 is a Consumption CDS View that provides data about "Run Conf Details by Material Plant" in SAP S/4HANA. It reads from 1 data source (I_ABOPRunMaterialPlant_2) and exposes 36 fields with key fields ABOPRunUUID, Material, Plant. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ABOPRunMaterialPlant_2 I_ABOPRunMaterialPlant_2 projection

Associations (3)

CardinalityTargetAliasCondition
[1..*] C_ABOPRunRequirement_2 _Requirements $projection.ABOPRunUUID = _Requirements.ABOPRunUUID and $projection.Material = _Requirements.Material and $projection.Plant = _Requirements.Plant
[0..1] C_ABOPRunStatusByProductPlant _ProcessStatus $projection.ABOPRunUUID = _ProcessStatus.ABOPRunUUID and $projection.Material = _ProcessStatus.Material and $projection.Plant = _ProcessStatus.Plant
[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 Conf Details by Material Plant 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 (36)

KeyFieldSource TableSource FieldDescription
KEY ABOPRunUUID ABOPRunUUID Check ID
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
ProductNamelocalized
PlantName _SupplyingPlant PlantName Plant Name
ABOPVariantUUID ABOPVariantUUID BOP Variant UUID
virtualDocumentHeaderTexttext1024 Processing Identifier Description
ABOPRunStatus ABOPRunStatus Processing Status
ATPCheckHasOnlyHeader ATPCheckHasOnlyHeader Only Header Logged
NumberOfRqmtsIncldInConfFigs NumberOfRqmtsIncldInConfFigs
NumberOfRqmtsIncldInAssgmtFigs NumberOfRqmtsIncldInAssgmtFigs
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.
NumberOfRequirementsWithIssues NumberOfRequirementsWithIssues Processing Issues
NmbrOfRqmtsWthConfOrARunIssues NmbrOfRqmtsWthConfOrARunIssues
NmbrOfRqmtsWithOrderUpdtIssues NmbrOfRqmtsWithOrderUpdtIssues Update Issues
NumberOfRequirements NumberOfRequirements Requirements
NumberOfProcessedRequirements NumberOfProcessedRequirements Processed Requirements
CritltyCodeForRqmtsWithIssue CritltyCodeForRqmtsWithIssue
NmbrOfSuccessfullyUpdatedRqmts NmbrOfSuccessfullyUpdatedRqmts Updated
ABOPExecutionMode ABOPExecutionMode
ABOPExecutionModeText ABOPExecutionModeText
ABOPRunStartUTCDateTime _ABOPRun ABOPRunStartUTCDateTime Started
ABOPRunEndUTCDateTime _ABOPRun ABOPRunEndUTCDateTime Completed
ABOPRunApplicationType _ABOPRun ABOPRunApplicationType
_ABOPRunredirectedtoparentC_ABOPRun_2
_ABOPRunStatusText _ABOPRunStatusText
_ProcessStatus _ProcessStatus
_ProductText _ProductText
_Requirements _Requirements
_SupplyingPlant _SupplyingPlant

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_ABOPRunMaterialPlant_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_ABOPRunMaterialPlant_2 AS
SELECT
  ABOPRunUUID,
  Material,
  Plant,
  _ProductText.ProductName : localized AS ProductNamelocalized,
  _SupplyingPlant.PlantName AS PlantName,
  ABOPVariantUUID,
  virtual DocumentHeaderText : text1024 AS virtualDocumentHeaderTexttext1024,
  ABOPRunStatus,
  ATPCheckHasOnlyHeader,
  NumberOfRqmtsIncldInConfFigs,
  NumberOfRqmtsIncldInAssgmtFigs,
  BaseUnit,
  OnTimeConfdRqmtsBeforeRunPct,
  OnTimeConfdRqmtsAfterRunPct,
  ConfdRqmtsBeforeRunPercent,
  ConfdRqmtsAfterRunPercent,
  SupAssgdRqmtsBeforeRunPercent,
  SupAssgdRqmtsAfterRunPercent,
  NumberOfRequirementsWithIssues,
  NmbrOfRqmtsWthConfOrARunIssues,
  NmbrOfRqmtsWithOrderUpdtIssues,
  NumberOfRequirements,
  NumberOfProcessedRequirements,
  CritltyCodeForRqmtsWithIssue,
  NmbrOfSuccessfullyUpdatedRqmts,
  ABOPExecutionMode,
  ABOPExecutionModeText,
  _ABOPRun.ABOPRunStartUTCDateTime AS ABOPRunStartUTCDateTime,
  _ABOPRun.ABOPRunEndUTCDateTime AS ABOPRunEndUTCDateTime,
  _ABOPRun.ABOPRunApplicationType AS ABOPRunApplicationType
FROM I_ABOPRunMaterialPlant_2
LEFT OUTER JOIN C_ABOPRunRequirement_2 AS _Requirements ON ABOPRunUUID = _Requirements.ABOPRunUUID AND Material = _Requirements.Material AND Plant = _Requirements.Plant  -- association [1..*]
LEFT OUTER JOIN C_ABOPRunStatusByProductPlant AS _ProcessStatus ON ABOPRunUUID = _ProcessStatus.ABOPRunUUID AND Material = _ProcessStatus.Material AND Plant = _ProcessStatus.Plant  -- 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