FCLM_BAM_T012K_BASE

@AbapCatalog.sqlViewName: 'V_T012K_BASE'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality: 'C'
@ObjectModel.usageType.sizeCategory: 'M'
@ObjectModel.usageType.dataClass: 'MASTER'
@EndUserText.label: 'Base view for V_T012K_BAM_DDL'
define view FCLM_BAM_T012K_BASE
  as select from FCLM_BAM_DISTINCT_HBA as distinct_hba
    inner join   fclm_bam_aclink2      as hba on  hba.acc_id    = distinct_hba.acc_id
                                              and hba.valid_to  = distinct_hba.valid_to
                                              and hba.bukrs     = distinct_hba.bukrs
                                              and hba.hbkid     = distinct_hba.hbkid
                                              and hba.hktid     = distinct_hba.hktid
                                              and hba.is_reused = ''
                                              and hba.herku     = ''
                                              and hba.revision  = '0000'
    inner join   fclm_bam_amd          as acc on  acc.acc_id   = hba.acc_id
                                              and acc.revision = '0000'
{
  hba.mandt,
  distinct_hba.bukrs,
  distinct_hba.hbkid,
  distinct_hba.hktid,
  hba.bankn,
  acc.control_key as bkont,
  @Semantics.currencyCode
  acc.waers,
  hba.refzl,
  hba.dtaai,
  hba.bnkn2,
  hba.fdgrp,
  @Semantics.currencyCode
  hba.abwae,
  hba.hkont,
  hba.wekon,
  hba.mindt,
  hba.hbid1,
  hba.hkid1,
  hba.hbid2,
  hba.hkid2,
  hba.wkkon,
  hba.wikon,
  acc.status
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_DISTINCT_HBA",
"FCLM_BAM_ACLINK2",
"FCLM_BAM_AMD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/