FCLM_BAM_DDL_AMD_BASE

@AbapCatalog.sqlViewName: 'VFCLM_BAM_AMD_B'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Base View for AMD'
define view FCLM_BAM_DDL_AMD_BASE as select from    FCLM_BAM_DDL_AMD_DB          as header
//    left outer join VFCLM_BAM_AMD_CUR_REV as accountcurr      on header.acc_id = accountcurr.AccountID and header.revision = accountcurr.revision

    left outer join t001                  as t001             on header.bukrs = t001.bukrs
    left outer join fclm_bam_aclink2      as fclm_bam_aclink2 on header.acc_id            = fclm_bam_aclink2.acc_id
                                                              and(
                                                                fclm_bam_aclink2.herku    is null
                                                                or fclm_bam_aclink2.herku = ''
                                                              )
                                                              and header.revision = fclm_bam_aclink2.revision // Only the central house bank account

                                                              and fclm_bam_aclink2.valid_to >= $session.system_date
                                                              and fclm_bam_aclink2.valid_from <= $session.system_date
    left outer join t001                  as t001_2           on fclm_bam_aclink2.bukrs = t001_2.bukrs
  association [1..*] to VFCLM_BAM_DDL_AMD_SIG as account_sigs  on $projection.acc_id = account_sigs.AccountID
  association [1..*] to VFCLM_BAM_DDL_AMD_LIM as account_lims  on $projection.acc_id = account_lims.AccountID
  association [0..*] to VFCLM_BAM_DDL_CDHDR   as account_cdhdr on $projection.acc_id = account_cdhdr.AccountID
{
  key header.acc_id, 
  key header.revision,
  header.acc_num, 
  header.acc_type_id, 
  header.account_supervisor, 
  header.bank_contact, 
  header.bankl, 
  header.banks, 
  header.beneficial, 
  header.bs_upload_time, 
  header.bukrs, 
  header.cash_pool, 
  header.cash_pool_id, 
  header.cash_pool_id_participant,
  header.changed_at, 
  header.changed_at_dat, 
  header.changed_at_tim, 
  header.changed_by, 
  header.closed_at, 
  header.closed_at_dat, 
  header.closed_at_tim, 
  header.closed_by, 
  header.company_contact, 
  header.control_key, 
  header.created_at, 
  header.created_at_dat, 
  header.created_at_tim, 
  header.created_by, 
  header.cutoff_time_c, 
  header.cutoff_time_d, 
  header.deleted_flag, 
  header.dummy_fclm_bam_amd_incl_eew_ps, 
  header.edbsum, 
  header.gsber, 
  header.iban, 
  header.iban_valid_from, 
  header.idbsum, 
  header.importing_channel, 
  header.mandt, 
  header.vgtyp,                                                                   
  header.procstat_act,
  header.balstat_act,
  header.serstat_act,
  header.reconstat_act,
  header.exp_number,
  header.exp_rhyth,
  header.calendar,
  header.sort_idx,
  header.amt_diff, 
  header.opened_at, 
  header.opened_at_dat, 
  header.opened_at_tim, 
  header.opened_by, 
  header.planned_closing_date, 
  header.prctr, 
  header.rel_manager, 
  header.reviewed_at, 
  header.reviewed_by, 
  header.segment, 
  header.status, 
  header.upload_bs_flag, 
  header.valid_from, 
  header.valid_to,    
      
//      accountcurr.Currency,

  header.waers as Currency,
  header.tolerance_group,
  header.reconcile_intraday,
      
      t001.butxt                  as CompanyCodeDesp,
      t001_2.butxt                as HouseBankCompanyCodeDesp,

      // House bank account

      fclm_bam_aclink2.bukrs      as HouseBankCompanyCode,
      fclm_bam_aclink2.abwae,
      fclm_bam_aclink2.bankn,
      fclm_bam_aclink2.bnkn2,
      fclm_bam_aclink2.dtaai,
      fclm_bam_aclink2.fdgrp,
      fclm_bam_aclink2.hbid1,
      fclm_bam_aclink2.hbid2,
      fclm_bam_aclink2.hbkid,
      fclm_bam_aclink2.hkid1,
      fclm_bam_aclink2.hkid2,
      fclm_bam_aclink2.hkont,
      fclm_bam_aclink2.hktid,
      fclm_bam_aclink2.mindt,
      fclm_bam_aclink2.refzl,
      fclm_bam_aclink2.wekon,
      fclm_bam_aclink2.wikon,
      fclm_bam_aclink2.wkkon,
      // Associations

      //      account_cur as Currencies,

      account_sigs,
      account_lims,
      account_cdhdr
      // Extension


};   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_DDL_AMD_DB",
"FCLM_BAM_ACLINK2",
"T001"
],
"ASSOCIATED":
[
"VFCLM_BAM_DDL_AMD_LIM",
"VFCLM_BAM_DDL_AMD_SIG",
"VFCLM_BAM_DDL_CDHDR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/