FCLM_BAM_DDL_AMD_DB

@AbapCatalog.sqlViewName: 'VFCLM_BAM_AMDDB'
@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'
@AbapCatalog.preserveKey:true
define view FCLM_BAM_DDL_AMD_DB as select from    fclm_bam_amd          as header
{
  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,
  header.objnr,
  header.waers,
  header.tolerance_group,
  header.reconcile_intraday
  //header.contract_type 

}
where status <> '99';   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_AMD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/