I_CreditManagementBPRating

DDL: I_CREDITMANAGEMENTBPRATING SQL: ICRBPRATING Type: view BASIC Package: UKM_CDS

Credit Management BP Rating

I_CreditManagementBPRating is a Basic CDS View that provides data about "Credit Management BP Rating" in SAP S/4HANA. It reads from 2 data sources (bp1012, I_CreditManagementBP) and exposes 12 fields with key fields BusinessPartner, BusinessPartnerRatingProcedure. It has 2 associations to related views. Part of development package UKM_CDS.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
bp1012 bp1012 from
I_CreditManagementBP I_CreditManagementBP inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_CreditManagementRating _Rating $projection.BusinessPartnerRatingProcedure = _Rating.BusinessPartnerRatingProcedure and $projection.BusinessPartnerRating = _Rating.BusinessPartnerRating

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICRBPRATING view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Credit Management BP Rating view
ObjectModel.representativeKey BusinessPartnerRatingProcedure view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner bp1012 partner
KEY BusinessPartnerRatingProcedure bp1012 grade_method
AuthorizationGroup _BusinessPartner AuthorizationGroup
BPRatingValidityStartDate date_from
BPRatingValidityEndDate date_to
BusinessPartnerRatingIsAllowed flg_permit
BusinessPartnerRating bp1012 grade
BusinessPartnerRanking _Rating BusinessPartnerRanking
BusinessPartnerRatingName _Rating BusinessPartnerRatingName
BPRatingDescription
_BusinessPartner _BusinessPartner
_Rating _Rating 
@AbapCatalog.sqlViewName: 'ICRBPRATING'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
//@VDM.private: false

@Metadata.ignorePropagatedAnnotations:true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Credit Management BP Rating'
@ObjectModel.representativeKey: 'BusinessPartnerRatingProcedure'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@AccessControl.personalData.blocking: #REQUIRED
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_CreditManagementBPRating
  as select from bp1012
    inner join   I_CreditManagementBP on I_CreditManagementBP.BusinessPartner = bp1012.partner
  association [0..1] to I_BusinessPartner        as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to I_CreditManagementRating as _Rating          on  $projection.BusinessPartnerRatingProcedure = _Rating.BusinessPartnerRatingProcedure
                                                                     and $projection.BusinessPartnerRating          = _Rating.BusinessPartnerRating
{
      @ObjectModel.foreignKey.association: '_BusinessPartner'
  key bp1012.partner                                                           as BusinessPartner,
  key bp1012.grade_method                                                      as BusinessPartnerRatingProcedure,
      _BusinessPartner.AuthorizationGroup,
      date_from                                                                as BPRatingValidityStartDate,
      date_to                                                                  as BPRatingValidityEndDate,
      flg_permit                                                               as BusinessPartnerRatingIsAllowed,
      bp1012.grade                                                             as BusinessPartnerRating,
      _Rating.BusinessPartnerRanking                                           as BusinessPartnerRanking,
      _Rating.BusinessPartnerRatingName                                        as BusinessPartnerRatingName,
      _Rating._Text[1:Language = $session.system_language].BPRatingDescription as BPRatingDescription,
      _BusinessPartner,
      _Rating
}
where
  date_to >= $session.system_date

Learn More