I_BankAccountInWorkflowCount

DDL: I_BANKACCOUNTINWORKFLOWCOUNT SQL: IBNKACCINWF Type: view BASIC Package: FCLM_BAM
3 Fields 1 Data Sources

Bank Accounts in Work Flow

I_BankAccountInWorkflowCount is a Basic CDS View that provides data about "Bank Accounts in Work Flow" in SAP S/4HANA. It reads from 1 data source (I_BankAcctChangeRequest) and exposes 3 fields. Part of development package FCLM_BAM.

Data Sources (1)

SourceAliasJoin Type
I_BankAcctChangeRequest cr from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IBNKACCINWF view
VDM.viewType #BASIC view
EndUserText.label Bank Accounts in Work Flow view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
BankAccountChangeRequestStatus BankAccountChangeRequestStatus Trade Req. Status
BankAccountReqStatusText BankAccountReqStatusText
ChangeRequestQuantity

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_BankAccountInWorkflowCount.
-- 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: IBNKACCINWF

CREATE VIEW I_BankAccountInWorkflowCount AS
SELECT
  BankAccountChangeRequestStatus,
  BankAccountReqStatusText,
  count( * ) AS ChangeRequestQuantity
FROM I_BankAcctChangeRequest AS cr
;

Learn More