C_BankAccountNumberVH

DDL: C_BANKACCOUNTNUMBERVH SQL: CBKACCTNUMBERVH Type: view CONSUMPTION

Bank Account Number

C_BankAccountNumberVH is a Consumption CDS View that provides data about "Bank Account Number" in SAP S/4HANA. It reads from 1 data source (I_BankAccount) and exposes 9 fields with key field BankAccountInternalID.

Data Sources (1)

SourceAliasJoin Type
I_BankAccount I_BankAccount from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CBKACCTNUMBERVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Account Number view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey BankAccountInternalID view
Consumption.ranked true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID
BankAccountNumber BankAccountNumber
BankAccountDescription
BankAccountCurrency BankAccountCurrency
CompanyCode CompanyCode
BankAccountType BankAccountType
Bank Bank
BankCountry BankCountry
IBAN IBAN
@AbapCatalog.sqlViewName: 'CBKACCTNUMBERVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Bank Account Number'
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'BankAccountInternalID'
@Consumption.ranked: true 
define view C_BankAccountNumberVH
  as select from I_BankAccount
{
      @Search: {
              defaultSearchElement: true,
              ranking: #LOW,
              fuzzinessThreshold: 0.9
            }
      @UI.lineItem: [
          { position: 2, importance: #LOW }
          ]
      @Consumption.valueHelpDefinition: [
      //       { association: '_BankAcctNumberVH' }

      { entity:  { name:    'I_BankAccountStdVH',
      element: 'BankAccountInternalID' }
      }]
  key BankAccountInternalID,
      @UI.lineItem: [
       { position: 1, importance: #HIGH }
       ]
      @Search: {
        defaultSearchElement: true,
        ranking: #HIGH,
        fuzzinessThreshold: 0.9
      }
      @Consumption.valueHelpDefinition: [
      //      { association: '_BankAcctNumberVH' }

      { entity:  { name:    'I_BankAcctNumberVH',
                element: 'BankAccountNumber' },
      additionalBinding: [{ localElement: 'BankCountry',
                           element: 'BankCountry' },
                        { localElement: 'Bank',
                           element: 'Bank' },
                        { localElement: 'BankAccountCurrency',
                           element: 'BankAccountCurrency' } ]
      }
      ]
      BankAccountNumber,
      @UI.lineItem: [
      { position: 2, importance: #LOW }
      ]
      @Search: {
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.9
      }
      _Text[1: Language = $session.system_language].BankAccountDescription as BankAccountDescription,
      @UI.lineItem: [
       { position: 3, importance: #LOW }
       ]
      @Search: {
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.9
      }
      @Consumption.valueHelpDefinition: [{
            entity            :  { name:    'C_BankFeeDspCrcyVH',
            element           : 'DisplayCurrency' }
      }]
      BankAccountCurrency,
      @UI.lineItem: [
       { position: 4, importance: #LOW }
       ]
      @Search: {
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.9
      }
      @Consumption.valueHelpDefinition: [{
      entity: { name: 'C_BankAcctCompanyCodeVH', element: 'CompanyCode' } }]
      CompanyCode,
      @UI.lineItem: [
       { position: 5, importance: #LOW}
       ]
      @Search: {
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.9
      }
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_BankAccountTypeVH',
            element: 'BankAccountType' }
      }]
      BankAccountType,
      @UI.lineItem: [
       { position: 6, importance: #LOW }
       ]
      @Search: {
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.9
      }
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_BankStdVH',
               element: 'BankInternalID' },
      additionalBinding: [{ localElement: 'BankCountry',
                          element: 'BankCountry' }]
      }]
      Bank,
      @UI.lineItem: [
       { position: 7, importance: #LOW }
       ]
      @Search: {
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.9
      }
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'C_BankCountryVH',
           element: 'BankCountry' }
      }]
      BankCountry,
      @UI.lineItem: [
       { position: 8, importance: #LOW }
       ]
      @Search: {
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.9
      }
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'C_BankAccountIBANVH',
               element: 'IBAN' }
      }]
      IBAN
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNT",
"I_BANKACCOUNTTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/