I_BPRatingProcedureGrade

DDL: I_BPRATINGPROCEDUREGRADE Type: view BASIC
6 Fields 1 Data Sources 3 Associations

Rating Procedure Grade of BP

I_BPRatingProcedureGrade (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

BusinessPartnerRatingGradeCode · Cross Applications

I_BPRatingProcedureGrade is a Basic CDS View (Dimension) that provides data about "Rating Procedure Grade of BP" in SAP S/4HANA. It reads from 1 data source (tpz22) and exposes 6 fields with key fields BusinessPartnerRatingProcedure, BusinessPartnerRatingGrade. It has 3 associations to related views.

SAP Help Documentation

CategoryConfiguration Data
Data CategoryDimension
Data Extraction TypeFull (physical deletions are possible in source tables)
Corresponding DataSourceIBPRATGPROCGRADE
Purpose
The rating grades indicate the result of a rating for a business partner carried out with a rating procedure. This CDS view provides the prerequisites for answering the following business questions: Which rating grades exist for the rating procedures? How are the rating grades ranked?

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: B_BUPA_GRP ( Business Partner: Authorization Groups ) B_BUPA_RLT ( Business Partner: BP Roles ) B_BUP_PCPT ( Business Partner: Purpose Completed ) B_BUPA_PGM ( Grouping Characteristic for SAP BP-FS ) Configuration Rating procedures have to be customized.

Structure
Measures and attributes Some important measures and attributes are: Business partner rating procedure Business partner rating procedure grade Ranking

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentFS-BP
CapabilitiesData Source for Defining CDS Entities, Analytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>The rating grades indicate the result of a rating for a business partner carried out with a rating procedure.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which rating grades exist for the rating procedures?</p></li> <li><p>How are the rating grades ranked?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tpz22 tpz22 from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_BPRatgProcedureGradeText _Text $projection.BusinessPartnerRatingProcedure = _Text.BusinessPartnerRatingProcedure and $projection.BusinessPartnerRatingGrade = _Text.BusinessPartnerRatingGrade
[0..1] I_BPRatingProcedure _RatingProcedure $projection.BusinessPartnerRatingProcedure = _RatingProcedure.BusinessPartnerRatingProcedure
[0..*] I_BusinessPartnerRating _BPRating $projection.BusinessPartnerRatingProcedure = _BPRating.BusinessPartnerRatingProcedure and $projection.BusinessPartnerRatingGrade = _BPRating.BusinessPartnerRatingGrade

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IBPRATGPROCGRADE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.representativeKey BusinessPartnerRatingGrade view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.sapObjectNodeType.name BusinessPartnerRatingGradeCode view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Rating Procedure Grade of BP view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerRatingProcedure tpz22 grade_method Valuation Procedure
KEY BusinessPartnerRatingGrade tpz22 grade Standard Value
BusinessPartnerRatingRanking tpz22 ranking Rank of Rating
_BPRating _BPRating
_RatingProcedure _RatingProcedure
_Text _Text

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_BPRatingProcedureGrade.
-- 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_BPRatingProcedureGrade AS
SELECT
  tpz22.grade_method AS BusinessPartnerRatingProcedure,
  tpz22.grade AS BusinessPartnerRatingGrade,
  tpz22.ranking AS BusinessPartnerRatingRanking
FROM tpz22
LEFT OUTER JOIN I_BPRatgProcedureGradeText AS _Text ON BusinessPartnerRatingProcedure = _Text.BusinessPartnerRatingProcedure AND BusinessPartnerRatingGrade = _Text.BusinessPartnerRatingGrade  -- association [0..*]
LEFT OUTER JOIN I_BPRatingProcedure AS _RatingProcedure ON BusinessPartnerRatingProcedure = _RatingProcedure.BusinessPartnerRatingProcedure  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerRating AS _BPRating ON BusinessPartnerRatingProcedure = _BPRating.BusinessPartnerRatingProcedure AND BusinessPartnerRatingGrade = _BPRating.BusinessPartnerRatingGrade  -- association [0..*]
;

Learn More