I_HouseBankText

DDL: I_HOUSEBANKTEXT SQL: IHOUSEBANKTEXT Type: view BASIC Package: FCLM_BAM_OBSOLETE
8 Fields 1 Data Sources 2 Associations

House Bank Account Names

I_HouseBankText is a Basic CDS View that provides data about "House Bank Account Names" in SAP S/4HANA. It reads from 1 data source (V_T012t_Ddl) and exposes 8 fields with key fields Language, CompanyCode, HouseBank, HouseBankAccount. It has 2 associations to related views. Part of development package FCLM_BAM_OBSOLETE.

Data Sources (1)

SourceAliasJoin Type
V_T012t_Ddl V_T012t_Ddl from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Housebank _HouseBank $projection.HouseBank = _HouseBank.HouseBank and $projection.CompanyCode = _HouseBank.CompanyCode
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (12)

NameValueLevelField
Analytics.dataExtraction.enabled true view
AbapCatalog.sqlViewName IHOUSEBANKTEXT view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
ObjectModel.representativeKey HouseBankAccount view
EndUserText.label House Bank Account Names view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
KEY CompanyCode bukrs Value
KEY HouseBank hbkid House Bank
KEY HouseBankAccount hktid House Bank Account
HouseBankName text1 Vertikalization Text
_Language _Language
_HouseBank _HouseBank
_CompanyCode _CompanyCode

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_HouseBankText.
-- 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: IHOUSEBANKTEXT

CREATE VIEW I_HouseBankText AS
SELECT
  spras AS Language,
  bukrs AS CompanyCode,
  hbkid AS HouseBank,
  hktid AS HouseBankAccount,
  text1 AS HouseBankName
FROM V_T012t_Ddl
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More