I_BPRatgProcedureGradeText

DDL: I_BPRATGPROCEDUREGRADETEXT SQL: IPROCEDGRADETXT Type: view BASIC

Rating Procedure Grade of BP - Text

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

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
tpz22t tpz22t from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BPRatingProcedure _BPRatingProcedure $projection.BusinessPartnerRatingProcedure = _BPRatingProcedure.BusinessPartnerRatingProcedure
[0..1] I_BPRatingProcedureGrade _BPRatingProcedureGrade $projection.BusinessPartnerRatingGrade = _BPRatingProcedureGrade.BusinessPartnerRatingGrade and $projection.BusinessPartnerRatingProcedure = _BPRatingProcedureGrade.BusinessPartnerRatingProcedure
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPROCEDGRADETXT view
EndUserText.label Rating Procedure Grade of BP - Text view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey BusinessPartnerRatingGrade view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Language tpz22t spras
KEY BusinessPartnerRatingProcedure tpz22t grade_method
KEY BusinessPartnerRatingGrade tpz22t grade
BusinessPartnerRatingGradeDesc tpz22t text
_BPRatingProcedure _BPRatingProcedure
_BPRatingProcedureGrade _BPRatingProcedureGrade
_Language _Language 
@AbapCatalog.sqlViewName: 'IPROCEDGRADETXT'
@EndUserText.label: 'Rating Procedure Grade of BP - Text'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.buffering.status: #NOT_ALLOWED
// @AbapCatalog.preserveKey // only if required by ATC check

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'BusinessPartnerRatingGrade'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true // For C1-Release



define view I_BPRatgProcedureGradeText 
  as select from tpz22t
  association [0..1] to I_BPRatingProcedure      as _BPRatingProcedure      on  $projection.BusinessPartnerRatingProcedure = _BPRatingProcedure.BusinessPartnerRatingProcedure 
  association [0..1] to I_BPRatingProcedureGrade as _BPRatingProcedureGrade on  $projection.BusinessPartnerRatingGrade     = _BPRatingProcedureGrade.BusinessPartnerRatingGrade
                                                                            and $projection.BusinessPartnerRatingProcedure = _BPRatingProcedureGrade.BusinessPartnerRatingProcedure
  association [0..1] to I_Language               as _Language               on  $projection.Language = _Language.Language
{

      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key tpz22t.spras             as Language,

      @ObjectModel.foreignKey.association: '_BPRatingProcedure'
  key tpz22t.grade_method      as BusinessPartnerRatingProcedure,

      @ObjectModel.foreignKey.association: '_BPRatingProcedureGrade'
  key tpz22t.grade             as BusinessPartnerRatingGrade,
      
      @Semantics.text: true
      tpz22t.text              as BusinessPartnerRatingGradeDesc,

      _BPRatingProcedure,
      _BPRatingProcedureGrade,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TPZ22T"
],
"ASSOCIATED":
[
"I_BPRATINGPROCEDURE",
"I_BPRATINGPROCEDUREGRADE",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More