I_BkAcctWithHouseBkAcctCount

DDL: I_BKACCTWITHHOUSEBKACCTCOUNT SQL: IHBACNTPERACCT Type: view BASIC Package: FCLM_BRM
5 Fields 2 Data Sources

Bank Acct with house bank acct count

I_BkAcctWithHouseBkAcctCount is a Basic CDS View that provides data about "Bank Acct with house bank acct count" in SAP S/4HANA. It reads from 2 data sources (I_HouseBankAccount, I_BankAccountBasicData) and exposes 5 fields with key field BankAccountInternalID. Part of development package FCLM_BRM.

Data Sources (2)

SourceAliasJoin Type
I_HouseBankAccount _HouseBankAcct inner
I_BankAccountBasicData BankAcct from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IHBACNTPERACCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bank Acct with house bank acct count view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID I_BankAccountBasicData BankAccountInternalID Technical ID
BankCountry I_BankAccountBasicData BankCountry Bank Ctry/Rgn. Key
Bank I_BankAccountBasicData Bank Bank Number
BankAccountNumber I_BankAccountBasicData BankAccountNumber Bank Account
NumberOfHouseBankAccts

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BkAcctWithHouseBkAcctCount.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IHBACNTPERACCT

CREATE VIEW I_BkAcctWithHouseBkAcctCount AS
SELECT
  BankAcct.BankAccountInternalID AS BankAccountInternalID,
  BankAcct.BankCountry AS BankCountry,
  BankAcct.Bank AS Bank,
  BankAcct.BankAccountNumber AS BankAccountNumber,
  count( * ) AS NumberOfHouseBankAccts
FROM I_BankAccountBasicData AS BankAcct
INNER JOIN I_HouseBankAccount AS _HouseBankAcct ON /* join condition not captured in parsed metadata */
;

Learn More