I_BankAccountVH

@AbapCatalog.sqlViewName: 'IFIBANKACC_VH1'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.representativeKey: 'BankAccountInternalID'

@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@Consumption.ranked: true
@Search.searchable: true
@EndUserText.label: 'Explicit value help for I_BankAccount'

/* Comment of Usage
There are several bank account value helps provided.
This cds view will return all activtated bank accounts.
If it does not meet your requirment, you may check below value help CDS Views.
I_BankAcctNumberVH
I_BankAccountStdVH
I_BankAcctIdVH
C_BankAcctIdVH
C_BankAccountVH
*/

define view I_BankAccountVH
  as select from I_BankAccount
{

      //I_BankAccount

      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8
  key BankAccountInternalID,
      BankCountry,
      Bank,
      BankAccountNumber,
      //      _Text[1:Language=$session.system_language].BankAccountDescription,

      BankAccountType,
      BankAccountContractType,
      ValidityStartDate,
      ValidityEndDate,
      IBAN,
      BankAccountStatus,
      CompanyCode,
      Country,
      ProfitCenter,
      BusinessArea,
      Segment,
      BankAccountHolderName,
      BankContactPerson,
      BankRelationshipManager,
      CompanyContactPerson,
      BankAccountSupervisor,
      //      CreatedByUser,

      //      OpenedByUser,

      //      LastChangedByUser,

      //      ReviewedByUser,

      //      ClosedByUser,

      IsMarkedForDeletion,
      DomesticCutOffTime,
      CrossBorderCutOffTime,
      PlannedClosingDate,
      CreationDate,
      CreationTime,
      OpenedDate,
      OpenedTime,
      //      LastChangeDate,

      //      LastChangeTime,

      ClosedDate,
      ClosedTime,
      BankControlKey,
      IBANValidityStartDate,
      //  TransactionCode,

      PaymentTransactionTypeGroup,
      BankAccountCurrency,
      LeadingCashPoolID,
      ParticipantCashPoolID,
      @Semantics.amount.currencyCode:'BankAccountCurrency'
      MaxTargetAmount,
      @Semantics.amount.currencyCode:'BankAccountCurrency'
      MinTransferAmount,
      LeadingPaymentMethod,
      ParticipantPaymentMethod,
      ControllingArea,
      BankStatementCheckTime,
      BankStatementImportMethod,
      IntraDayBankStateImportMethod,
      BankStatementImportChannel,
      IsUploadOfIntraDayStatement,
      IHBAccountHolder,
      /* Associations */
      //I_BankAccount

      @Consumption.hidden:true
      _Bank,
      @Consumption.hidden:true
      _BankAccountCurrency,
      @Consumption.hidden:true
      _BankAccountHierarchyNode,
      @Consumption.hidden:true
      _BankAccountType,
      @Consumption.hidden:true
      _BankCountry,
      @Consumption.hidden:true
      _BusinessArea,
      @Consumption.hidden:true
      _CompanyCode,
      @Consumption.hidden:true
      _ControllingArea,
      @Consumption.hidden:true
      _ProfitCenter,
      @Consumption.hidden:true
      _Segment,
      @Consumption.hidden:true
      _Text

}