C_House_Bank_App

DDL: C_HOUSE_BANK_APP SQL: CHOUSEBANKAPP Type: view CONSUMPTION Package: FCLM_BAM_OBSOLETE
37 Fields 4 Data Sources

House Bank Consumption view

C_House_Bank_App is a Consumption CDS View that provides data about "House Bank Consumption view" in SAP S/4HANA. It reads from 4 data sources (I_Bank, I_CountryText, I_RegionText, I_Housebank) and exposes 37 fields with key fields CompanyCode, HouseBank. Part of development package FCLM_BAM_OBSOLETE.

Data Sources (4)

SourceAliasJoin Type
I_Bank _Bank left_outer
I_CountryText _CountryText left_outer
I_RegionText _RegionText left_outer
I_Housebank HouseBank from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CHOUSEBANKAPP view
EndUserText.label House Bank Consumption view view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_Housebank CompanyCode Receiver Company Code
KEY HouseBank I_Housebank HouseBank House Bank
BankCountry I_Housebank BankCountry Bank Ctry/Rgn. Key
CountryName I_CountryText CountryName Country
CountryNameLanguage
BankInternalID I_Housebank BankInternalID Bank Key
PhoneNumber1 PhoneNumber1 Telephone 1
TaxID1 TaxID1 Tax Number 1
ContactPersonName ContactPersonName Full Name
Language I_Housebank Language Report Text Language
BusinessPlace BusinessPlace Business place
CompanyName _CompanyCode CompanyCodeName Company Name
BankName I_Bank BankName Bank Name
Region I_Bank Region Venue Region
RegionName I_RegionText RegionName Description
RegionNameLanguage
StreetName I_Bank StreetName Text
CityName I_Bank CityName Name
Branch I_Bank Branch Repository branch
SWIFTCode I_Bank SWIFTCode SWIFT/BIC
BankNetworkGrouping I_Bank BankNetworkGrouping Bank group
Bank I_Bank Bank Bank Number
EDIPartner EDIPartner Partner No.
EDISignatureType EDISignatureType Ty.
DataMediumExchangeBank DataMediumExchangeBank Altern.Bank ID
DataMediumReceivingBank DataMediumReceivingBank Bank No. Receiver
CustomerByHouseBank CustomerByHouseBank Customer Number
BankControlKey BankControlKey Control Key
DataExchangeInstruction DataExchangeInstruction Instruction Key
ExecutionLeadDays ExecutionLeadDays Lead Days
CentralBankReportIsRequired CentralBankReportIsRequired Create Central Bank Report
RegionByCentralBank RegionByCentralBank Area Number
PaymentIsForwardedToCentralBk PaymentIsForwardedToCentralBk Forward Pay. Data
ChargeAccountCurrencyISOCode ChargeAccountCurrencyISOCode ISO Currency Cde
ChargeAccount ChargeAccount Account Number
ChargeAccountBank ChargeAccountBank Bank Number
OrderingCompanyByBank OrderingCompanyByBank Company Number

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_House_Bank_App.
-- 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: CHOUSEBANKAPP

CREATE VIEW C_House_Bank_App AS
SELECT
  HouseBank.CompanyCode AS CompanyCode,
  HouseBank.HouseBank AS HouseBank,
  HouseBank.BankCountry AS BankCountry,
  _CountryText.CountryName AS CountryName,
  $session.system_language AS CountryNameLanguage,
  HouseBank.BankInternalID AS BankInternalID,
  PhoneNumber1,
  TaxID1,
  ContactPersonName,
  HouseBank.Language AS Language,
  BusinessPlace,
  _CompanyCode.CompanyCodeName AS CompanyName,
  _Bank.BankName AS BankName,
  _Bank.Region AS Region,
  _RegionText.RegionName AS RegionName,
  $session.system_language AS RegionNameLanguage,
  _Bank.StreetName AS StreetName,
  _Bank.CityName AS CityName,
  _Bank.Branch AS Branch,
  _Bank.SWIFTCode AS SWIFTCode,
  _Bank.BankNetworkGrouping AS BankNetworkGrouping,
  _Bank.Bank AS Bank,
  EDIPartner,
  EDISignatureType,
  DataMediumExchangeBank,
  DataMediumReceivingBank,
  CustomerByHouseBank,
  BankControlKey,
  DataExchangeInstruction,
  ExecutionLeadDays,
  CentralBankReportIsRequired,
  RegionByCentralBank,
  PaymentIsForwardedToCentralBk,
  ChargeAccountCurrencyISOCode,
  ChargeAccount,
  ChargeAccountBank,
  OrderingCompanyByBank
FROM I_Housebank AS HouseBank
LEFT OUTER JOIN I_Bank AS _Bank ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CountryText AS _CountryText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RegionText AS _RegionText ON /* join condition not captured in parsed metadata */
;

Learn More