C_RO_SAFTCompanyHouseBank

DDL: C_RO_SAFTCOMPANYHOUSEBANK SQL: CROSAFTCHB Type: view CONSUMPTION
6 Fields 2 Data Sources

HouseBank accounts

C_RO_SAFTCompanyHouseBank is a Consumption CDS View that provides data about "HouseBank accounts" in SAP S/4HANA. It reads from 2 data sources (I_BankAccount, I_HouseBankAccount) and exposes 6 fields with key fields CompanyCode, HouseBank, HouseBankAccount.

Data Sources (2)

SourceAliasJoin Type
I_BankAccount ba inner
I_HouseBankAccount hba from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTCHB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label HouseBank accounts view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_HouseBankAccount CompanyCode Receiver Company Code
KEY HouseBank I_HouseBankAccount HouseBank House Bank
KEY HouseBankAccount I_HouseBankAccount HouseBankAccount House Bank Account
IBAN I_BankAccount IBAN IBAN House Bank
BankAccount I_HouseBankAccount BankAccount Bank acct
Bank

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 C_RO_SAFTCompanyHouseBank.
-- 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: CROSAFTCHB

CREATE VIEW C_RO_SAFTCompanyHouseBank AS
SELECT
  hba.CompanyCode AS CompanyCode,
  hba.HouseBank AS HouseBank,
  hba.HouseBankAccount AS HouseBankAccount,
  ba.IBAN AS IBAN,
  hba.BankAccount AS BankAccount,
  hba._HouseBank.BankInternalID AS Bank
FROM I_HouseBankAccount AS hba
INNER JOIN I_BankAccount AS ba ON /* join condition not captured in parsed metadata */
;

Learn More