C_CashBankHouseBankTP

DDL: C_CASHBANKHOUSEBANKTP Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 1 OData Services

House Bank

C_CashBankHouseBankTP is a Consumption CDS View that provides data about "House Bank" in SAP S/4HANA. It reads from 1 data source (R_CashBankHouseBankTP) and exposes 20 fields with key fields CompanyCode, HouseBank, BankCountry, BankInternalID. It is exposed through 1 OData service (UI_CASHBANK_MANAGE).

Data Sources (1)

SourceAliasJoin Type
R_CashBankHouseBankTP R_CashBankHouseBankTP projection

Annotations (7)

NameValueLevelField
EndUserText.label House Bank view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CASHBANK_MANAGE UI_CASHBANK_MANAGE V4 C1 NOT_RELEASED

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY HouseBank HouseBank House Bank
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID BankInternalID Bank Key
PhoneNumber1 PhoneNumber1 Telephone 1
TaxID1 TaxID1 Tax Number 1
ContactPersonName ContactPersonName Full Name
HouseBankForDisplayText HouseBankForDisplayText
BankName _Bank LongBankName
AddressRegion _Bank AddressRegion Region
StreetName _Bank StreetName Text
LongBankBranch _Bank LongBankBranch
BankNetworkGrouping _Bank BankNetworkGrouping
CityName _Bank CityName Name
BankNumber _Bank BankNumber Bank Key
SWIFTCode _Bank SWIFTCode SWIFT/BIC
BankCategory _Bank BankCategory
CountryName _CountryText CountryName Country
CompanyName _CompanyCode CompanyCodeName Company Name
_BankredirectedtoparentC_CashBankTP

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_CashBankHouseBankTP.
-- 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.

CREATE VIEW C_CashBankHouseBankTP AS
SELECT
  CompanyCode,
  HouseBank,
  BankCountry,
  BankInternalID,
  PhoneNumber1,
  TaxID1,
  ContactPersonName,
  HouseBankForDisplayText,
  _Bank.LongBankName AS BankName,
  _Bank.AddressRegion AS AddressRegion,
  _Bank.StreetName AS StreetName,
  _Bank.LongBankBranch AS LongBankBranch,
  _Bank.BankNetworkGrouping AS BankNetworkGrouping,
  _Bank.CityName AS CityName,
  _Bank.BankNumber AS BankNumber,
  _Bank.SWIFTCode AS SWIFTCode,
  _Bank.BankCategory AS BankCategory,
  _CountryText.CountryName AS CountryName,
  _CompanyCode.CompanyCodeName AS CompanyName
FROM R_CashBankHouseBankTP
;

Learn More