I_BankHierBankGroupMapping

DDL: I_BANKHIERBANKGROUPMAPPING SQL: IBANKHIERBGMAP Type: view BASIC

Bank Hierarchy Bank Group Name Mapping

I_BankHierBankGroupMapping is a Basic CDS View that provides data about "Bank Hierarchy Bank Group Name Mapping" in SAP S/4HANA. It reads from 3 data sources (I_Bank_2, but000, fclm_bam_hierbgn) and exposes 8 fields with key field BankAccountInternalID.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_Bank_2 bank left_outer
but000 BP left_outer
fclm_bam_hierbgn hierbgn left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IBANKHIERBGMAP view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bank Hierarchy Bank Group Name Mapping view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID header acc_id
BankAccountNumber header acc_num
BankCountry header banks
Bank header bankl
BankName I_Bank_2 BankName
BankAccountStatus header status
BankGroup fclm_bam_hierbgn bank_group
BusinessPartnerName but000 name_org1 
@AbapCatalog.sqlViewName: 'IBANKHIERBGMAP'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Bank Hierarchy Bank Group Name Mapping'
@AccessControl.personalData.blocking:#REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC                 
//Get data from VFCLM_BAM_DDL_BANK_HIER_BGN

define view I_BankHierBankGroupMapping
as select distinct from fclm_bam_amd as header
left outer join fclm_bam_hierbgn as hierbgn on hierbgn.banks = header.banks and hierbgn.bankl = header.bankl
left outer join I_Bank_2 as bank on bank.BankCountry = header.banks and bank.BankInternalID = header.bankl
left outer join but000 as BP on BP.partner = hierbgn.bank_group 
{
  key header.acc_id as BankAccountInternalID,
      header.acc_num as BankAccountNumber,
      header.banks as BankCountry,
      header.bankl as Bank,
      bank.BankName,    
      header.status as BankAccountStatus, 
      hierbgn.bank_group as BankGroup,
      BP.name_org1 as BusinessPartnerName
    
}
where hierbgn.bank_group is not null
  and header.revision = '0000'
  and header.status <> '99';      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANK_2",
"BUT000",
"FCLM_BAM_AMD",
"FCLM_BAM_HIERBGN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More