I_BkRelshpDocBkAcctBasic

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Basic data of bank accounts in bank doc'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #MASTER
}
@VDM.viewType: #BASIC
define view entity I_BkRelshpDocBkAcctBasic as select from fclm_bam_amd
{
  key acc_id                        as BankAccountInternalID,
      banks                         as BankCountry,
      bankl                         as Bank,
      acc_num                       as BankAccountNumber,
      acc_type_id                   as BankAccountType,
      valid_from                    as ValidityStartDate,
      valid_to                      as ValidityEndDate,
      iban                          as IBAN,
      status                        as BankAccountStatus,
      bukrs                         as CompanyCode,
      prctr                         as ProfitCenter,
      gsber                         as BusinessArea,
      segment                       as Segment,
      beneficial                    as BankAccountHolderName,
      bank_contact                  as BankContactPerson,
      rel_manager                   as BankRelationshipManager,
      company_contact               as CompanyContactPerson,
      account_supervisor            as BankAccountSupervisor,
      created_by                    as CreatedByUser,
      opened_by                     as OpenedByUser,
      changed_by                    as LastChangedByUser,
      reviewed_by                   as ReviewedByUser,
      closed_by                     as ClosedByUser,
      deleted_flag                  as IsMarkedForDeletion,
      cutoff_time_d                 as DomesticCutOffTime,
      cutoff_time_c                 as CrossBorderCutOffTime,
      planned_closing_date          as PlannedClosingDate,
      created_at_dat                as CreationDate,
      created_at_tim                as CreationTime,
      opened_at_dat                 as OpenedDate,
      opened_at_tim                 as OpenedTime,
      changed_at_dat                as LastChangeDate,
      changed_at_tim                as LastChangeTime,
      closed_at_dat                 as ClosedDate,
      closed_at_tim                 as ClosedTime,
      control_key                   as BankControlKey,
      iban_valid_from               as IBANValidityStartDate,
      vgtyp                         as PaymentTransactionTypeGroup,
      waers                         as BankAccountCurrency,
      cash_pool_id                  as LeadingCashPoolID,
      cash_pool_id_participant      as ParticipantCashPoolID,
      @Semantics.amount.currencyCode: 'BankAccountCurrency'
      cash_pool_target_amt_max      as MaxTargetAmount,
      @Semantics.amount.currencyCode: 'BankAccountCurrency'
      cash_pool_transfer_amt_min    as MinTransferAmount,
      payment_method_l              as LeadingPaymentMethod,
      payment_method_p              as ParticipantPaymentMethod,
      payment_service_provider      as PaymentServiceProvider,
      tolerance_group               as CashToleranceGroup,
      reconcile_intraday            as IntradayIsReconciled,
      objnr                         as TreasuryFinancialObject,
      bs_upload_time                as BankStatementCheckTime,
      edbsum                        as BankStatementImportMethod,
      idbsum                        as IntraDayBankStateImportMethod,
      importing_channel             as BankStatementImportChannel,
      upload_bs_flag                as IsUploadOfIntraDayStatement,
      reconcile_endofday            as EndOfDayIsReconciled,
      ihb_servicer                  as IHBAccountHolder
}
where
      revision     =  '0000'
  and status       <> '99' //Deleted

  and deleted_flag <> 'X'