I_BankAccountProfiles

DDL: I_BANKACCOUNTPROFILES SQL: IACCTPRO Type: view COMPOSITE

Bank Accounts Count

I_BankAccountProfiles is a Composite CDS View that provides data about "Bank Accounts Count" in SAP S/4HANA. It reads from 1 data source (I_BankAccount) and exposes 9 fields with key fields BankAccountStatus, BankCountry, Bank, CompanyCode. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_BankAccount amd from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BankAccountStatus _BankAccountStatus $projection.BankAccountStatus = _BankAccountStatus.BankAccountStatus and _BankAccountStatus.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IACCTPRO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Accounts Count view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BankAccountStatus I_BankAccount BankAccountStatus
KEY BankCountry I_BankAccount BankCountry
KEY Bank I_BankAccount Bank
KEY CompanyCode I_BankAccount CompanyCode
BankAccountQuantity
_BankAccountStatus _BankAccountStatus
_BankCountry _BankCountry
_Bank _Bank
_CompanyCode _CompanyCode 
@AbapCatalog.sqlViewName: 'IACCTPRO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bank Accounts Count'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
    usageType: {
        sizeCategory: #M,
        serviceQuality: #D,
        dataClass: #MIXED
    }
}
define view I_BankAccountProfiles as select from I_BankAccount as amd 
  association [0..1] to I_BankAccountStatus     as _BankAccountStatus   on  $projection.BankAccountStatus = _BankAccountStatus.BankAccountStatus
                                                and _BankAccountStatus.Language = $session.system_language
{
 key amd.BankAccountStatus,
 key amd.BankCountry,
 key amd.Bank,
 key amd.CompanyCode,
 count( * ) as BankAccountQuantity,
 _BankAccountStatus,
 _BankCountry,
 _Bank,
 _CompanyCode 
}
where amd.BankAccountStatus = '02'
   or amd.BankAccountStatus = '09'
   or amd.BankAccountStatus = '10'
   or amd.BankAccountStatus = '11'
   or amd.BankAccountStatus = '15'
group by BankAccountStatus,
         amd.BankCountry,
         amd.Bank,
         amd.CompanyCode

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNT"
],
"ASSOCIATED":
[
"I_BANKACCOUNTSTATUS",
"I_BANK_2",
"I_COMPANYCODE",
"I_COUNTRY"
],
"BASE":
[
"I_BANKACCOUNT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More