I_MDQltyBPRoleResultFocus

DDL: I_MDQLTYBPROLERESULTFOCUS Type: view_entity COMPOSITE Package: MDQ_PF_VAL_SIMULATION
12 Fields 1 Data Sources 2 OData Services

Business Partner Role Flat Result Code

I_MDQltyBPRoleResultFocus is a Composite CDS View that provides data about "Business Partner Role Flat Result Code" in SAP S/4HANA. It reads from 1 data source (I_MDQltyBPRoleResult) and exposes 12 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BusinessPartnerRole. It is exposed through 2 OData services (ASQL_F7205A, X_MDQLTYPROCBPDETAILS_SRV). Part of development package MDQ_PF_VAL_SIMULATION.

Data Sources (1)

SourceAliasJoin Type
I_MDQltyBPRoleResult BPRoleResult from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Partner Role Flat Result Code view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED
X_MDQLTYPROCBPDETAILS_SRV

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_MDQltyBPRoleResult MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDQltyBPRoleResult MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_MDQltyBPRoleResult MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_MDQltyBPRoleResult MDChgProcessSrceObject Source ID
KEY BusinessPartnerRole I_MDQltyBPRoleResult BusinessPartnerRole BP Role
KEY MDQualityBusinessRuleUUID I_MDQltyBPRoleResult MDQualityBusinessRuleUUID Rule UUID
MDQltyBusRuleResultOutOfScope OutOfScopeResult MDQltyBusRuleEvalResultCode Result Type
MDQltyNmbrOfRecdOutOfScope OutOfScopeResult MDQltyNmbrOfBusRuleEvalResults Total Results
MDQltyBusRuleResultSuccess SuccessResult MDQltyBusRuleEvalResultCode Result Type
MDQltyNmbrOfRecdSuccess SuccessResult MDQltyNmbrOfBusRuleEvalResults Total Results
MDQltyBusRuleResultFailed FailedResult MDQltyBusRuleEvalResultCode Result Type
MDQltyNmbrOfRecdFailed FailedResult MDQltyNmbrOfBusRuleEvalResults Total Results

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 I_MDQltyBPRoleResultFocus.
-- 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 I_MDQltyBPRoleResultFocus AS
SELECT
  BPRoleResult.MasterDataChangeProcess AS MasterDataChangeProcess,
  BPRoleResult.MDChgProcessStep AS MDChgProcessStep,
  BPRoleResult.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  BPRoleResult.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  BPRoleResult.BusinessPartnerRole AS BusinessPartnerRole,
  BPRoleResult.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  OutOfScopeResult.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleResultOutOfScope,
  OutOfScopeResult.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfRecdOutOfScope,
  SuccessResult.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleResultSuccess,
  SuccessResult.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfRecdSuccess,
  FailedResult.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleResultFailed,
  FailedResult.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfRecdFailed
FROM I_MDQltyBPRoleResult AS BPRoleResult
;

Learn More