I_BankAccountInVerification

DDL: I_BANKACCOUNTINVERIFICATION SQL: IFIBKACCTINVERIF Type: view BASIC Package: FCLM_BAM
14 Fields 2 Data Sources

To be verfied bank account

I_BankAccountInVerification is a Basic CDS View that provides data about "To be verfied bank account" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_reqacnt, fclm_bam_req) and exposes 14 fields with key fields BankAccountChangeRequest, BankAccountInternalID, BankAccountRevision. Part of development package FCLM_BAM.

Data Sources (2)

SourceAliasJoin Type
fclm_bam_reqacnt reqaccount from
fclm_bam_req reqheader inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFIBKACCTINVERIF view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label To be verfied bank account view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BankAccountChangeRequest fclm_bam_req request_id Request unique ID
KEY BankAccountInternalID fclm_bam_reqacnt acc_id Technical ID
KEY BankAccountRevision fclm_bam_reqacnt revision Revision Number
BankAccountChangeRequestStatus fclm_bam_req request_status Trade Req. Status
BankAccountAction fclm_bam_req account_action Action
BankAcctChangeReqHeadingText fclm_bam_req title View Title
BankAccountChangeRequestStep fclm_bam_req request_step Request Step
CreationDate fclm_bam_req created_on Variant created on
CreatedByUser fclm_bam_req created_by Version Created By
CreationTime fclm_bam_req created_tm Entered at
LastChangeDate fclm_bam_req lastchged_on Changed On
LastChangedByUser fclm_bam_req lastchged_by Changed By
LastChangeTime fclm_bam_req lastchged_tm Entered at
BankAcctChangeRequestDueDate fclm_bam_req duedate Promised For

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BankAccountInVerification.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFIBKACCTINVERIF

CREATE VIEW I_BankAccountInVerification AS
SELECT
  reqheader.request_id AS BankAccountChangeRequest,
  reqaccount.acc_id AS BankAccountInternalID,
  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
FROM fclm_bam_reqacnt AS reqaccount
INNER JOIN fclm_bam_req AS reqheader ON /* join condition not captured in parsed metadata */
;

Learn More