P_BankGroupCompanyCount

DDL: P_BANKGROUPCOMPANYCOUNT SQL: PFIBNKGPBUKRSCNT Type: view BASIC

P_BankGroupCompanyCount is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (fclm_bam_hierbgn, t012) and exposes 2 fields with key field bank_group.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
fclm_bam_hierbgn BankGroup from
t012 HouseBank inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFIBNKGPBUKRSCNT view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY bank_group fclm_bam_hierbgn bank_group
NumberOfCompanyCodes 
@AbapCatalog.sqlViewName: 'PFIBNKGPBUKRSCNT'
@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey:true
define view P_BankGroupCompanyCount
  as select from fclm_bam_hierbgn as BankGroup
    inner join   t012             as HouseBank on  BankGroup.bankl = HouseBank.bankl
                                               and BankGroup.banks = HouseBank.banks
{
  key BankGroup.bank_group,
      count( distinct bukrs) as NumberOfCompanyCodes
}
group by
  bank_group;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_HIERBGN",
"T012"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More