I_BANKACCOUNTINVERIFICATION

CDS View

To be verfied bank account

I_BANKACCOUNTINVERIFICATION is a CDS View in S/4HANA. To be verfied bank account. It contains 1 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BankAccountWithVerification view from COMPOSITE Bank Account With Verification

Fields (1)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 1
@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';