FCLM_BAM_DDL_AMD_BASE_NO_HBA

@AbapCatalog.sqlViewName: 'VFCLM_BAM_AMD_N'
@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 without multiple HBA'
@AbapCatalog.preserveKey:true
define view FCLM_BAM_DDL_AMD_BASE_NO_HBA
  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
/*    inner 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 

    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,
      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.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.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,
      header.waers as Currency,
      //header.contract_type, 

//      accountcurr.Currency,


      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


} where header.revision = '0000';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_DDL_AMD_DB",
"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":""
}
}*/