I_RequestWithBankAccount

@AbapCatalog.sqlViewName: 'IREQBANKACCT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bank Accounts in Change Request'
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #B
@ClientHandling.algorithm: #SESSION_VARIABLE
//@AccessControl.privilegedAssociations:  [ '_BankAccountCurrency' ]

@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: ['SQL_DATA_SOURCE','CDS_MODELING_DATA_SOURCE']

define view I_RequestWithBankAccount
  as select from fclm_bam_reqacnt as header
    inner join   fclm_bam_amd     as amd on  header.acc_id   = amd.acc_id
                                         and header.revision = amd.revision
  //   association [0..1] to I_BankAccountCurrencyRev as _BankAccountCurrency      on  $projection.BankAccountInternalID = _BankAccountCurrency.BankAccountInternalID

  //                                                                               and $projection.BankAccountRevision   = _BankAccountCurrency.BankAccountRevision

  association [0..1] to I_CountryText as _BankCountryText on  $projection.BankCountry   = _BankCountryText.Country
                                                          and _BankCountryText.Language = $session.system_language
{
  key header.request_id as BankAccountChangeRequest,
  key header.acc_id     as BankAccountInternalID,
  key header.revision   as BankAccountRevision,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'BankAccountNumber'
      amd.acc_num       as BankAccount,
      amd.banks         as BankCountry,
      amd.bankl         as Bank,
      amd.acc_type_id   as AccountType,
      amd.bukrs         as CompanyCode,
      amd.acc_type_id   as BankAccountType,
      //amd.contract_type as BankAccountContractType,

      amd.beneficial    as BankAccountHolderName,
      amd.iban          as IBAN,
      //   _BankAccountCurrency.BankAccountCurrency

      amd.waers         as BankAccountCurrency,
      _BankCountryText.CountryName,
      amd.acc_num       as BankAccountNumber,
      amd.status        as BankAccountStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COUNTRYTEXT",
"FCLM_BAM_AMD",
"FCLM_BAM_REQACNT"
],
"ASSOCIATED":
[
"I_COUNTRYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/