P_HouseBankAccountDesc

@AbapCatalog.sqlViewName: 'PHBACDESC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #BASIC
@VDM.private: true

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S

@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_HouseBankAccountDesc
  as select from fclm_bam_aclink2 as hba
    inner join   fclm_bam_amd_t   as acctxt on acctxt.acc_id = hba.acc_id and acctxt.revision = '0000'
    inner join   fclm_bam_amd     as acc   on acc.acc_id = hba.acc_id and acc.revision = '0000'
{
  hba.mandt,
  acctxt.langu                           as spras,
  hba.bukrs,
  hba.hbkid,
  hba.hktid,
  acctxt.description as text1
}
where
       hba.herku           =  ''
  and  acctxt.deleted_flag =  ''
  and  hba.hbkid           <> ''
  and  hba.hktid           <> ''
  and(
       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

    or acc.status       =  '15' //Closed in System

  )                                //Closed    

  and hba.revision = '0000'
  and hba.is_reused != 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_ACLINK2",
"FCLM_BAM_AMD",
"FCLM_BAM_AMD_T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/