fclm_bam_shlp_acctid

@AbapCatalog.sqlViewName: 'VFCLMSHLPACCT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Search help for ACC ID'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
define view fclm_bam_shlp_acctid
  as select from    fclm_bam_amd     as amd
//    left outer join fclm_bam_amd_cur as cur  on  amd.acc_id   = cur.acc_id

//                                             and amd.revision = cur.revision

    left outer join fclm_bam_amd_t   as desc on  amd.acc_id   = desc.acc_id
                                             and amd.revision = desc.revision
                                             and desc.langu   = $session.system_language
  //  association [0..1] to I_Bank as _Bank on  $projection.BankCountry           = _Bank.BankCountry

  //                                        and $projection.BankAccountInternalID = _Bank.BankInternalID

   left outer join fclm_bam_aclink2  as linkage  on  amd.acc_id = linkage.acc_id 
                                                 and amd.revision = linkage.revision
   left outer join bnka              as bank on  amd.banks = bank.banks
                                             and amd.bankl = bank.bankl
{
  amd.acc_id       as BankAccountInternalID,
  amd.acc_num      as BankAccount,
  desc.description as BankAccountDescription,
  //  cur.waers        as BankAccountCurrency,

  amd.waers        as BankAccountCurrency,
  amd.acc_type_id  as BankAccountType,
  amd.bankl        as Bank,
  amd.banks        as BankCountry,
  //  _Bank.BankName,

  bank.banka       as BankName,
  amd.iban         as IBAN,
  bank.swift       as SWIFT,
  linkage.bukrs    as HouseBankCompanyCode,
  linkage.herku    as remoteSystem,
  linkage.hbkid    as HouseBank,
  linkage.hktid    as HouseBankAccount,
  amd.bukrs        as CompanyCode,
  amd.gsber        as BusinessArea,
  amd.segment      as Segment,
  amd.prctr        as ProfitCenter
}
where
      amd.revision     =  '0000'
//  and cur.deleted_flag <> 'X'

  and amd.status = '02'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BNKA",
"FCLM_BAM_ACLINK2",
"FCLM_BAM_AMD",
"FCLM_BAM_AMD_T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/