FCLM_BAM_DISTINCT_HBA

CDS View

distinct house bank accounts for T012K

FCLM_BAM_DISTINCT_HBA is a CDS View in S/4HANA. distinct house bank accounts for T012K. It contains 4 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 4 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FCLM_BAM_T012K_BASE view from Base view for V_T012K_BAM_DDL
V_T012k_Bam_Sh_Ddl view from DDL Source for Value Help on T012K
V_T012t_Ddl view from T012T Compatibility View

Fields (4)

KeyField CDS FieldsUsed in Views
bukrs bukrs 3
hbkid hbkid 3
hktid hktid 3
mandt mandt 1 
@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":""
}
}*/

Learn More