A_BusinessPartnerRating

DDL: A_BUSINESSPARTNERRATING SQL: ABPRATING Type: view BASIC

Ratings

A_BusinessPartnerRating is a Basic CDS View that provides data about "Ratings" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerRating) and exposes 17 fields with key fields BusinessPartner, BusinessPartnerRatingProcedure, BPRatingValidityEndDate. It has 1 association to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerRating I_BusinessPartnerRating from

Associations (1)

CardinalityTargetAliasCondition
[0..1] A_BPFinancialServicesExtn _BPFinancialServicesExtn $projection.BusinessPartner = _BPFinancialServicesExtn.BusinessPartner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ABPRATING view
EndUserText.label Ratings view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY BusinessPartnerRatingProcedure BusinessPartnerRatingProcedure
KEY BPRatingValidityEndDate BPRatingValidityEndDate
BusinessPartnerRatingGrade BusinessPartnerRatingGrade
BusinessPartnerRatingTrend BusinessPartnerRatingTrend
BPRatingValidityStartDate BPRatingValidityStartDate
BPRatingCreationDate BPRatingCreationDate
BusinessPartnerRatingComment BusinessPartnerRatingComment
BusinessPartnerRatingIsAllowed BusinessPartnerRatingIsAllowed
BPRatingIsValidOnKeyDate BPRatingIsValidOnKeyDate
BusinessPartnerRatingKeyDate BusinessPartnerRatingKeyDate
BusinessPartnerRatingIsExpired BusinessPartnerRatingIsExpired
_BPFinancialServicesExtn _BPFinancialServicesExtn
_BPRatingProcedure _BPRatingProcedure
_BPRatingProcedureGrade _BPRatingProcedureGrade
_BPRatingTrend _BPRatingTrend
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'ABPRATING'
@EndUserText.label: 'Ratings'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #BASIC
@ObjectModel.usageType: {
   serviceQuality: #B,
   sizeCategory: #XL ,
   dataClass: #MASTER }
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_BusinessPartnerRating
  as select from I_BusinessPartnerRating
  association[1..1] to A_BusinessPartner  as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to A_BPFinancialServicesExtn  as _BPFinancialServicesExtn   on $projection.BusinessPartner = _BPFinancialServicesExtn.BusinessPartner // <--- to inherit authorizations in DCL

{
  key BusinessPartner,
  key BusinessPartnerRatingProcedure,
  key BPRatingValidityEndDate,
      BusinessPartnerRatingGrade,
      BusinessPartnerRatingTrend,
      BPRatingValidityStartDate,
      BPRatingCreationDate,
      BusinessPartnerRatingComment,
      BusinessPartnerRatingIsAllowed,
      BPRatingIsValidOnKeyDate,
      BusinessPartnerRatingKeyDate,
      BusinessPartnerRatingIsExpired,
      /* Associations */
      @Consumption.hidden:true
      _BPFinancialServicesExtn,
      @Consumption.hidden:true
      _BPRatingProcedure,
      @Consumption.hidden:true
      _BPRatingProcedureGrade,
      @Consumption.hidden:true
      _BPRatingTrend,  
      @Consumption.hidden:true
      _BusinessPartner
}

Learn More