I_BankAccountInVerification

@AbapCatalog.sqlViewName: 'IFIBKACCTINVERIF'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'To be verfied bank account'
define view I_BankAccountInVerification
  as select from fclm_bam_reqacnt as reqaccount
    inner join   fclm_bam_req     as reqheader on reqaccount.request_id = reqheader.request_id
{
  key reqheader.request_id      as BankAccountChangeRequest,
  key reqaccount.acc_id         as BankAccountInternalID,
  key reqaccount.revision       as BankAccountRevision,
      reqheader.request_status  as BankAccountChangeRequestStatus,
      reqheader.account_action  as BankAccountAction,
      reqheader.title           as BankAcctChangeReqHeadingText,
      reqheader.request_step    as BankAccountChangeRequestStep,
      reqheader.created_on      as CreationDate,
      reqheader.created_by      as CreatedByUser,
      reqheader.created_tm      as CreationTime,
      reqheader.lastchged_on    as LastChangeDate,
      reqheader.lastchged_by    as LastChangedByUser,
      reqheader.lastchged_tm    as LastChangeTime,
      reqheader.duedate         as BankAcctChangeRequestDueDate
}
where
      reqheader.request_process = '02'
  and reqheader.request_status  = '05';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_REQ",
"FCLM_BAM_REQACNT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/