FCLM_BAM_AMD

@AbapCatalog.sqlViewName: 'VFCLM_BAM_AMD_VW'
//@AbapCatalog.buffering.status: #ACTIVE

//@AbapCatalog.buffering.type:   #SINGLE

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE 
define view VFCLM_BAM_DDL_AMD
  as select from    FCLM_BAM_DDL_AMD_REV0 as header
{
  key header.acc_id               as AccountID,
      header.banks                as BankCountry,
      header.bankl                as BankKey,
      header.acc_num              as AccountNumber,
      header.acc_type_id          as AccountType,
      header.valid_from           as ValidFrom,
      header.valid_to             as ValidTo,
      header.iban                 as IBAN,
      header.status               as Status,
      header.bukrs                as CompanyCode,
      header.prctr                as ProfitCenter,
      header.gsber                as BusinessArea,
      header.segment              as Segment,
      header.beneficial           as AccountHolder,
      header.bank_contact         as BankContact,
      header.rel_manager          as RelationshipManager,
      header.company_contact      as CompanyContact,
      header.account_supervisor   as AccountSupervisor,
      header.edbsum               as EoDImort,
      header.idbsum               as IntradayImport,
      header.bs_upload_time       as BankStatementUpload,
      header.created_at_dat       as CreatedAtDate,
      header.created_at_tim       as CreatedAtTime,
      header.created_by           as CreatedBy,
      header.opened_at_dat        as OpenedAtDate,
      header.opened_at_tim        as OpenedAtTime,
      header.opened_by            as OpenedBy,
      header.changed_at_dat       as ChangedAtDate,
      header.changed_at_tim       as ChangedAtTime,
      header.changed_by           as ChangedBy,
      header.closed_at_dat        as ClosedAtDate,
      header.closed_at_tim        as ClosedAtTime,
      header.closed_by            as ClosedBy,
      header.deleted_flag,
      header.importing_channel    as ImportingChannel,
      header.cutoff_time_d        as CutOffDomestic,
      header.cutoff_time_c        as CutOffCrossBorder,
      header.planned_closing_date as PlannedClosingDate,
      header.upload_bs_flag       as UploadBSFlag,
      header.vgtyp as TransactionCode,                                                                   
      header.procstat_act as ProcessingStatus,
      header.balstat_act as DifferenceStatus,
      header.serstat_act as SerialNumberStatus,
      header.reconstat_act as ReconciliationStatus,
      header.exp_number as ExpectedInterval,
      header.exp_rhyth as ControlFrequency,
      header.calendar as FactoryCalendar,
      header.sort_idx as DisplayItem,
      header.amt_diff as DifferenceAmount,  
      header.control_key,
      header.edbsum,
      header.iban_valid_from,      
      header.Currency,        
      header.CompanyCodeDesp,
      // House bank account

      header.HouseBankCompanyCode,
      header.HouseBankCompanyCodeDesp,
      header.abwae,
      header.bankn,
      header.bnkn2,
      header.dtaai,
      header.fdgrp,
      header.hbid1,
      header.hbid2,
      header.hbkid,
      header.hkid1,
      header.hkid2,
      header.hkont,
      header.hktid,
      header.mindt,
      header.refzl,
      header.wekon,
      header.wikon,
      header.wkkon,
      header.cash_pool_id                as LeadingCashPoolID,
      header.cash_pool_id_participant    as ParticipantCashPoolID,
      header.account_sigs                as Signatories,
      header.account_lims                as OverdraftLimits,
      header.account_cdhdr               as ChangeHistory,
      header.tolerance_group             as CashToleranceGroup, 
      header.reconcile_intraday          as IntradayIsReconciled

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