I_MDQltyBPRatingResultFocus

DDL: I_MDQLTYBPRATINGRESULTFOCUS Type: view_entity COMPOSITE
14 Fields 1 Data Sources

BP Rating focused result

I_MDQltyBPRatingResultFocus is a Composite CDS View that provides data about "BP Rating focused result" in SAP S/4HANA. It reads from 1 data source (I_MDQltyBPRatingResult) and exposes 14 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BusinessPartner.

Data Sources (1)

SourceAliasJoin Type
I_MDQltyBPRatingResult BPRatingResult from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Rating focused result view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_MDQltyBPRatingResult MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDQltyBPRatingResult MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_MDQltyBPRatingResult MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_MDQltyBPRatingResult MDChgProcessSrceObject Source ID
KEY BusinessPartner I_MDQltyBPRatingResult BusinessPartner Issuing Authority
KEY BusinessPartnerRatingProcedure I_MDQltyBPRatingResult BusinessPartnerRatingProcedure Rating Procedure
KEY BPRatingValidityEndDate I_MDQltyBPRatingResult BPRatingValidityEndDate Rating Valid To
KEY MDQualityBusinessRuleUUID I_MDQltyBPRatingResult 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_MDQltyBPRatingResultFocus.
-- 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_MDQltyBPRatingResultFocus AS
SELECT
  BPRatingResult.MasterDataChangeProcess AS MasterDataChangeProcess,
  BPRatingResult.MDChgProcessStep AS MDChgProcessStep,
  BPRatingResult.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  BPRatingResult.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  BPRatingResult.BusinessPartner AS BusinessPartner,
  BPRatingResult.BusinessPartnerRatingProcedure AS BusinessPartnerRatingProcedure,
  BPRatingResult.BPRatingValidityEndDate AS BPRatingValidityEndDate,
  BPRatingResult.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_MDQltyBPRatingResult AS BPRatingResult
;

Learn More