I_BankNumberVH

DDL: I_BANKNUMBERVH SQL: IBANKNUMBERVH Type: view COMPOSITE

Bank Number

I_BankNumberVH is a Composite CDS View that provides data about "Bank Number" in SAP S/4HANA. It reads from 1 data source (I_Bank_2) and exposes 9 fields with key fields BankCountry, BankInternalID.

Data Sources (1)

SourceAliasJoin Type
I_Bank_2 I_Bank_2 from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBANKNUMBERVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BankInternalID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
EndUserText.label Bank Number view
Consumption.ranked true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry
KEY BankInternalID BankInternalID
BankName BankName
SWIFTCode SWIFTCode
BankNetworkGrouping BankNetworkGrouping
BankNumber Bank
InternalBankCategoryDesc _BankAdditionalFields InternalBankCategoryDesc
InternalBankCategory _BankAdditionalFields InternalBankCategory
_Country _Country
@AbapCatalog.sqlViewName: 'IBANKNUMBERVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'BankInternalID'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@EndUserText.label: 'Bank Number'
@Consumption.ranked: true
define view I_BankNumberVH as select from I_Bank_2
{
      @UI.lineItem: [
      { position: 2, importance: #HIGH } ]
      @ObjectModel.foreignKey.association: '_Country'
      @Search: {
      defaultSearchElement: true,
      ranking: #LOW,
      fuzzinessThreshold: 0.8
       }        
  key BankCountry,
      @UI.lineItem: [
      { position: 3, importance: #HIGH } ]  
      @ObjectModel.text.element: ['BankName']
      @Search: {
      defaultSearchElement: true,
      ranking: #HIGH,
      fuzzinessThreshold: 0.8
       }      
  key BankInternalID,
      @UI.lineItem: [
      { position: 4, importance: #HIGH } ]      
      @Search: {
      defaultSearchElement: true,
      ranking: #LOW,
      fuzzinessThreshold: 0.8
       }
      BankName,
      @UI.lineItem: [
      { position: 5, importance: #HIGH, label: 'SWIFT/BIC' }
          ]
      @EndUserText: {
       label:     'SWIFT/BIC',
       quickInfo: 'SWIFT/BIC'
       }
      @Search: {
      defaultSearchElement: true,
      ranking: #LOW,
      fuzzinessThreshold: 0.8
       }
      SWIFTCode,
      @UI.lineItem: [
      { position: 6, importance: #HIGH, label: 'Bank Group' }
       ]
      @EndUserText: {
       label:     'Bank Group',
       quickInfo: 'Bank Group'
        }
      @Search: {
         defaultSearchElement: true,
         ranking: #LOW,
         fuzzinessThreshold: 0.8
       }
      //BankGroup,

      BankNetworkGrouping,
      @UI.lineItem: [
      { position: 1, importance: #HIGH, label: 'Bank Number' }
       ]
      @EndUserText: {
       label:     'Bank Number',
       quickInfo: 'Bank Number'
       }
      @Search: {
       defaultSearchElement: true,
       ranking: #HIGH,
       fuzzinessThreshold: 0.8
       }
      Bank as BankNumber,
      @UI.lineItem: [
      { position: 7, importance: #LOW, label: 'Bank Category Description' }
          ]
      @EndUserText: {
       label:     'Bank Category Description',
       quickInfo: 'Bank Category Description'
       }
      @Search: {
       defaultSearchElement: true,
       ranking: #LOW,
       fuzzinessThreshold: 0.8
       }       
      _BankAdditionalFields.InternalBankCategoryDesc,
      @UI.lineItem: [
      { position: 8, importance: #LOW, label: 'Bank Category' }
          ]
      @EndUserText: {
       label:     'Bank Category',
       quickInfo: 'Bank Category'
       }
      @Search: {
       defaultSearchElement: true,
       ranking: #LOW,
       fuzzinessThreshold: 0.8
       }       
      _BankAdditionalFields.InternalBankCategory,
      @Consumption.hidden: true
      _Country
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKADDITIONALFIELDS",
"I_BANK_2"
],
"ASSOCIATED":
[
"I_COUNTRY"
],
"BASE":
[
"I_BANK_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/