I_NumberOfCashBankUsage

DDL: I_NUMBEROFCASHBANKUSAGE SQL: INROFCSHBKUSGE Type: view COMPOSITE

Number of Bank Usage

I_NumberOfCashBankUsage is a Composite CDS View that provides data about "Number of Bank Usage" in SAP S/4HANA. It reads from 2 data sources (I_BankCompanyCodeUsedCount, I_Bank_2) and exposes 5 fields with key fields BankCountry, BankInternalID. It has 3 associations to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_BankCompanyCodeUsedCount _UsedCompanyCount left_outer
I_Bank_2 Bank from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BankWithBankAccountCount _BankAccountUsage $projection.BankCountry = _BankAccountUsage.BankCountry and $projection.BankInternalID = _BankAccountUsage.BankInternalID
[0..1] I_BankWithHouseBankCount _HouseBankUsage $projection.BankCountry = _HouseBankUsage.BankCountry and $projection.BankInternalID = _HouseBankUsage.BankInternalID
[0..1] I_BankUsedBPCount _UsedBpCount $projection.BankCountry = _UsedBpCount.BankCountry and $projection.BankInternalID = _UsedBpCount.BankInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName INROFCSHBKUSGE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Number of Bank Usage view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BankCountry I_Bank_2 BankCountry
KEY BankInternalID I_Bank_2 BankInternalID
int4endasNumberOfBusinessPartnerUsed
int4endasNumberOfCompanyUsed
BankCategory I_Bank_2 BankCategory 
@AbapCatalog.sqlViewName: 'INROFCSHBKUSGE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.authorizationCheck:#MANDATORY
@EndUserText.label: 'Number of Bank Usage'
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #MASTER
}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_NumberOfCashBankUsage as select from I_Bank_2 as Bank 
left outer join I_BankCompanyCodeUsedCount       as _UsedCompanyCount on Bank.BankCountry = _UsedCompanyCount.BankCountry
                                                                     and Bank.BankInternalID = _UsedCompanyCount.BankInternalID
association [0..1] to I_BankWithBankAccountCount as _BankAccountUsage on $projection.BankCountry = _BankAccountUsage.BankCountry
                                                                     and $projection.BankInternalID = _BankAccountUsage.BankInternalID
association [0..1] to I_BankWithHouseBankCount   as _HouseBankUsage   on $projection.BankCountry = _HouseBankUsage.BankCountry
                                                                     and $projection.BankInternalID = _HouseBankUsage.BankInternalID
association [0..1] to I_BankUsedBPCount          as _UsedBpCount      on  $projection.BankCountry    = _UsedBpCount.BankCountry
                                                                     and $projection.BankInternalID = _UsedBpCount.BankInternalID
{

  key Bank.BankCountry,
  key Bank.BankInternalID,
  
  case when _BankAccountUsage.NumberOfBankAccounts is not null then _BankAccountUsage.NumberOfBankAccounts
       else cast ( 0 as farp_bnk_account_count)
       end  as NumberOfBankAccounts,
       
  case when _HouseBankUsage.NumberOfHouseBanks is not null then _HouseBankUsage.NumberOfHouseBanks
       else cast ( 0 as farp_house_bnk_count)
       end  as NumberOfHouseBanks,
  
  case when _UsedBpCount.UnderBankBPQuantity is not null then _UsedBpCount.UnderBankBPQuantity
       else cast ( 0 as abap.int4)
       end  as NumberOfBusinessPartnerUsed,

  case when _UsedCompanyCount.NumberOfCompanyUsed is not null then _UsedCompanyCount.NumberOfCompanyUsed
       else cast ( 0 as abap.int4)
       end   as NumberOfCompanyUsed,
  Bank.BankCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKCOMPANYCODEUSEDCOUNT",
"I_BANKUSEDBPCOUNT",
"I_BANKWITHBANKACCOUNTCOUNT",
"I_BANKWITHHOUSEBANKCOUNT",
"I_BANK_2"
],
"ASSOCIATED":
[
"I_BANKUSEDBPCOUNT",
"I_BANKWITHBANKACCOUNTCOUNT",
"I_BANKWITHHOUSEBANKCOUNT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More