I_HouseBankText

DDL: I_HOUSEBANKTEXT SQL: IHOUSEBANKTEXT Type: view BASIC

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 (t012t) and exposes 8 fields with key fields Language, CompanyCode, HouseBank, HouseBankAccount. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
t012t t012t 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
KEY CompanyCode bukrs
KEY HouseBank hbkid
KEY HouseBankAccount hktid
HouseBankName text1
_Language _Language
_HouseBank _HouseBank
_CompanyCode _CompanyCode 
@Analytics.dataExtraction.enabled: true //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'IHOUSEBANKTEXT'
@ObjectModel.dataCategory: #TEXT 
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'HouseBankAccount'
@EndUserText.label: 'House Bank Account Names'
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@Metadata.ignorePropagatedAnnotations: true 
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view I_HouseBankText as select from t012t
association[0..1] to I_Language as _Language on $projection.Language = _Language.Language
association [0..1] to I_Housebank as _HouseBank on $projection.HouseBank = _HouseBank.HouseBank 
                                                 and $projection.CompanyCode = _HouseBank.CompanyCode
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode                                                  
{
  @Semantics.language
  key spras as Language,
  @ObjectModel.foreignKey.association: '_CompanyCode'  
  key bukrs as CompanyCode,
  @ObjectModel.foreignKey.association: '_HouseBank'
  key hbkid as HouseBank,
  key hktid as HouseBankAccount,
  @Semantics.text
  text1 as HouseBankName,
  _Language,
  _HouseBank,
  _CompanyCode
  
}
         
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"T012T"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_HOUSEBANK",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More