I_BankRating

DDL: I_BANKRATING SQL: IFIBANKRATING Type: view COMPOSITE

Bank rating

I_BankRating is a Composite CDS View that provides data about "Bank rating" in SAP S/4HANA. It reads from 2 data sources (I_Bank, I_BPBankLinkage) and exposes 7 fields with key fields BankCountry, Bank. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_Bank Bank from
I_BPBankLinkage BPBankLinkage inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BPCreditWorthiness _BankRating $projection.BusinessPartnerNumber = _BankRating.BusinessPartner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFIBANKRATING view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bank rating view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BankCountry I_Bank BankCountry
KEY Bank I_BPBankLinkage Bank
BankName BankName
CreditRating _BankRating BPCreditStandingRating
BusinessPartnerNumber I_BPBankLinkage BusinessPartnerNumber
_Country _Country
_BPCreditWorthinessRating _BankRating _BPCreditWorthinessRating 
@AbapCatalog.sqlViewName: 'IFIBANKRATING'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Bank rating'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED

define view I_BankRating
  as select from I_Bank          as Bank
    inner join   I_BPBankLinkage as BPBankLinkage on  Bank.BankInternalID = BPBankLinkage.Bank
                                                  and Bank.BankCountry    = BPBankLinkage.BankCountry
  association [0..1] to I_BPCreditWorthiness as _BankRating on $projection.BusinessPartnerNumber = _BankRating.BusinessPartner
{
      @ObjectModel.foreignKey.association: '_Country'
  key Bank.BankCountry,
  key BPBankLinkage.Bank,
      BankName,
      @ObjectModel.foreignKey.association: '_BPCreditWorthinessRating'
      _BankRating.BPCreditStandingRating as CreditRating,
      BPBankLinkage.BusinessPartnerNumber,
      _Country,
      _BankRating._BPCreditWorthinessRating
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANK",
"I_BPBANKLINKAGE",
"I_BPCREDITWORTHINESS"
],
"ASSOCIATED":
[
"I_BPCREDITWORTHINESS",
"I_BPCREDITWORTHINESSRATING",
"I_COUNTRY"
],
"BASE":
[
"I_BANK",
"I_BPCREDITWORTHINESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More