P_BankGroupCompanyCount

DDL: P_BANKGROUPCOMPANYCOUNT Type: view_entity BASIC Package: FCLM_BAM

Count of company code per bank group

P_BankGroupCompanyCount is a Basic CDS View that provides data about "Count of company code per bank group" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_hierbgn, t012) and exposes 2 fields with key field bank_group. Part of development package FCLM_BAM.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
fclm_bam_hierbgn BankGroup from
t012 HouseBank inner

Annotations (3)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY bank_group fclm_bam_hierbgn bank_group
NumberOfCompanyCodes 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity 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 HouseBank.bukrs) as NumberOfCompanyCodes
}
group by
  BankGroup.bank_group;

Learn More