I_Bank_2
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.
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA