P_HouseBankAccountText

@AbapCatalog.sqlViewName: 'PHOUSEBANKACCTT'
@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_HouseBankAccountText
  as select from I_BankAccountValidLinkage as distinct_hba
    inner join   fclm_bam_aclink2      as hba on  hba.acc_id    = distinct_hba.BankAccountInternalID
                                              and hba.valid_to  = distinct_hba.ValidityEndDate
                                              and hba.bukrs     = distinct_hba.CompanyCode
                                              and hba.hbkid     = distinct_hba.HouseBank
                                              and hba.hktid     = distinct_hba.HouseBankAccount
                                              and hba.is_reused = ''
                                              and hba.herku     = ''
                                              and hba.revision  = '0000'
    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,
  distinct_hba.CompanyCode as bukrs,
  distinct_hba.HouseBank as hbkid,
  distinct_hba.HouseBankAccount as hktid,
  cast(substring (acctxt.description, 1, 50) as fclm_bam_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":
[
"I_BANKACCOUNTVALIDLINKAGE",
"FCLM_BAM_ACLINK2",
"FCLM_BAM_AMD",
"FCLM_BAM_AMD_T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/