I_Bank_2

DDL: I_BANK_2 Type: view_entity BASIC

Bank

I_Bank_2 is a Basic CDS View (Dimension) that provides data about "Bank" in SAP S/4HANA. It reads from 2 data sources (bnkain, bnka) and exposes 26 fields with key fields BankCountry, BankInternalID. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
bnkain ad left_outer
bnka bk from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Address _Address $projection.AddressID = _Address.AddressID
[0..*] I_OrganizationAddress _BankAddress $projection.AddressID = _BankAddress.AddressID
[0..1] I_Region _Region $projection.Region = _Region.Region and $projection.BankCountry = _Region.Country
[0..1] I_Country _Country $projection.BankCountry = _Country.Country

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.representativeKey BankInternalID view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY BankCountry bnka banks
KEY BankInternalID bnka bankl
CreationDate bnka erdat
CreatedByUser bnka ernam
BankName bnka banka
Region bnka provz
StreetName bnka stras
ShortStreetName bnka stras
CityName bnka ort01
ShortCityName bnka ort01
SWIFTCode bnka swift
BankNetworkGrouping bnka bgrup
IsPostBankAccount bnka xpgro
IsMarkedForDeletion bnka loevm
Bank bnka bnklz
PostOfficeBankAccount bnka pskto
Branch bnka brnch
BankBranch bnka brnch
CheckDigitCalculationMethod bnka chkme
BankDataFileFormat bnka vers
AddressID bnka adrnr
BankCategory bnkain bintk
_Address _Address
_BankAddress _BankAddress
_Region _Region
_Country _Country
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bank'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #L,
  dataClass: #MASTER
}
@Metadata.allowExtensions:true
@Search.searchable: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
@ObjectModel.representativeKey: 'BankInternalID'
//@ObjectModel.sapObjectNodeType.name: 'Bank'

@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}


define view entity I_Bank_2
  as select from    bnka   as bk
    left outer join bnkain as ad on  bk.banks = ad.banks
                                 and bk.bankl = ad.bankl
  association [0..1] to I_Address             as _Address     on  $projection.AddressID = _Address.AddressID
  association [0..*] to I_OrganizationAddress as _BankAddress on  $projection.AddressID = _BankAddress.AddressID
  association [0..1] to I_Region              as _Region      on  $projection.Region      = _Region.Region
                                                              and $projection.BankCountry = _Region.Country
  association [0..1] to I_Country             as _Country     on  $projection.BankCountry = _Country.Country

{
      @ObjectModel.foreignKey.association: '_Country'
  key bk.banks as BankCountry,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key bk.bankl as BankInternalID,
      bk.erdat as CreationDate,
      bk.ernam as CreatedByUser,
      @Semantics.text: true
      bk.banka as BankName,
      bk.provz as Region,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'ShortStreetName'
      bk.stras as StreetName,
      bk.stras as ShortStreetName, //successor for StreetName

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'ShortCityName'
      bk.ort01 as CityName,
      bk.ort01 as ShortCityName, //successor for CityName

      bk.swift as SWIFTCode,
      bk.bgrup as BankNetworkGrouping,
      bk.xpgro as IsPostBankAccount,
      bk.loevm as IsMarkedForDeletion,
      bk.bnklz as Bank,
      bk.pskto as PostOfficeBankAccount,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'BankBranch'
      bk.brnch as Branch,
      bk.brnch as BankBranch, //successor for Branch

      bk.chkme as CheckDigitCalculationMethod,
      bk.vers  as BankDataFileFormat,
      bk.adrnr as AddressID,
      @ObjectModel.sapObjectNodeTypeReference: 'BankCategory'
      ad.bintk as BankCategory,

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_BankAddress'
      _Address,
      _BankAddress,
      _Region,
      _Country
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BNKA",
"BNKAIN"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_COUNTRY",
"I_ORGANIZATIONADDRESS",
"I_REGION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/