I_HouseBankAccountLinkage

DDL: I_HOUSEBANKACCOUNTLINKAGE SQL: IHBALINKAGE Type: view COMPOSITE
22 Fields 1 Data Sources 3 Associations

House Bank Account Linkage

I_HouseBankAccountLinkage (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_HouseBankAccountLinkage is a Composite CDS View that provides data about "House Bank Account Linkage" in SAP S/4HANA. It reads from 1 data source (P_HouseBankAccount) and exposes 22 fields with key fields CompanyCode, HouseBank, HouseBankAccount. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Cash and Liquidity Management
StatusReleased
Purpose
This CDS view provides you with access to the information of banks, house banks, bank accounts, and house bank accounts. It provides the prerequisites for answering the following business questions: Which account of which bank should I use to make a payment?

Structure
Measures and attributes Some important measures and attributes are: Company Code House Bank House Bank Account Bank Key Bank Country/Region Bank Name Swift Code Bank Account Number IBAN

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CLM-BAM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides you with access to the information of banks, house banks, bank accounts, and house bank accounts. It provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which account of which bank should I use to make a payment?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_HouseBankAccount HouseBankAccount from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BankAccount _BankAccount HouseBankAccount.acc_id = _BankAccount.BankAccountInternalID
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Housebank _HouseBank $projection.HouseBank = _HouseBank.HouseBank and $projection.CompanyCode = _HouseBank.CompanyCode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IHBALINKAGE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey HouseBankAccount view
EndUserText.label House Bank Account Linkage view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_HouseBankAccount bukrs Company Code
KEY HouseBank hbkid Short Key for a House Bank
KEY HouseBankAccount hktid House Bank Account
BankAccountInternalID acc_id Bank Account Technical ID
BankInternalID _HouseBank BankInternalID Bank Keys
BankCountry _HouseBank BankCountry Bank Country/Region Key
SWIFTCode SWIFT/BIC for International Payments
BankName Name of Financial Institution
BankNumber Bank Number
BankAccount bankn Bank Account Number
BankAccountAlternative bnkn2 Alternative Bank Account Number (for Ambiguous Acct Number)
ReferenceInfo refzl Reference Information
BankControlKey bkont Bank Control Key
BankAccountCurrency waers Transaction Currency
IBAN _BankAccount IBAN IBAN (International Bank Account Number)
BankAccountDescription Account Description
GLAccount hkont General Ledger Account
BankAccountHolderName _BankAccount BankAccountHolderName Bank Account Holder
BankAccountNumber _BankAccount BankAccountNumber Bank Account Number
_CompanyCode _CompanyCode
_HouseBank _HouseBank
_BankAccount _BankAccount

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_HouseBankAccountLinkage.
-- 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: IHBALINKAGE

CREATE VIEW I_HouseBankAccountLinkage AS
SELECT
  HouseBankAccount.bukrs AS CompanyCode,
  hbkid AS HouseBank,
  hktid AS HouseBankAccount,
  acc_id AS BankAccountInternalID,
  _HouseBank.BankInternalID AS BankInternalID,
  _HouseBank.BankCountry AS BankCountry,
  _HouseBank._Bank.SWIFTCode AS SWIFTCode,
  _HouseBank._Bank.BankName AS BankName,
  _HouseBank._Bank.Bank AS BankNumber,
  bankn AS BankAccount,
  bnkn2 AS BankAccountAlternative,
  refzl AS ReferenceInfo,
  bkont AS BankControlKey,
  waers AS BankAccountCurrency,
  _BankAccount.IBAN AS IBAN,
  _BankAccount._Text[1: Language = $session.system_language].BankAccountDescription AS BankAccountDescription,
  hkont AS GLAccount,
  _BankAccount.BankAccountHolderName AS BankAccountHolderName,
  _BankAccount.BankAccountNumber AS BankAccountNumber
FROM P_HouseBankAccount AS HouseBankAccount
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON HouseBankAccount.acc_id = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
;

Learn More