FCLM_BAM_DISTINCT_HBA

@AbapCatalog.sqlViewName: 'V_DISNT_HBA'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality: 'C'
@ObjectModel.usageType.sizeCategory: 'M'
@ObjectModel.usageType.dataClass: 'MASTER'
@EndUserText.label: 'distinct house bank accounts for T012K'
define view FCLM_BAM_DISTINCT_HBA
  as select from fclm_bam_aclink2 as hba
    inner join   fclm_bam_amd     as acc on  acc.acc_id   = hba.acc_id
                                         and hba.revision = acc.revision
{
  hba.mandt,
  hba.bukrs,
  hba.hbkid,
  hba.hktid,
  hba.acc_id,
  max(hba.valid_to) as valid_to
}
where
           hba.herku      =  ''
  and      hba.hbkid      <> ''
  and      hba.hktid      <> ''
  and      hba.is_reused  =  ''
  and      hba.revision   =  '0000'
  and      hba.valid_from <= $session.system_date
  and(
           acc.status     =  '15' //Closed in System

    or(
      (
           acc.status     =  '02' //Active

        or acc.status     =  '09' //Marked for Closing

        or acc.status     =  '10' //To Be Closed

        or acc.status     =  '11' //Closed at Bank

      )
      and  hba.valid_to   >= $session.system_date
    )
  )
group by
  hba.bukrs,
  hba.hbkid,
  hba.hktid,
  hba.acc_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_ACLINK2",
"FCLM_BAM_AMD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/