C_BankAccountOpeningRequestLog

DDL: C_BANKACCOUNTOPENINGREQUESTLOG SQL: CBANKACCTORLOG Type: view CONSUMPTION
9 Fields 1 Data Sources 3 OData Services 2 Fiori Apps

Request log for Bank Account application

C_BankAccountOpeningRequestLog is a Consumption CDS View that provides data about "Request log for Bank Account application" in SAP S/4HANA. It reads from 1 data source (I_BankAccountOpeningRequestLog) and exposes 9 fields with key fields BankAccountChangeRequest, BankAcctChgReqLogSequenceNmbr. It is exposed through 3 OData services (BANKACCOUNTOPENINGREQDRFTTP, BANKACCOUNTOPENINGREQOVW, BANKACCOUNTOPENINGREQWL). It is used in 2 Fiori applications: Approve Bank Account Applications, Bank Account Applications.

Data Sources (1)

SourceAliasJoin Type
I_BankAccountOpeningRequestLog ReqLog from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CBANKACCTORLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
UI.headerInfo.typeName Application Action Log view
UI.headerInfo.typeNamePlural Application Action Logs view
EndUserText.label Request log for Bank Account application view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey BankAccountChangeRequest view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

OData Services (3)

ServiceBindingVersionContractRelease
BANKACCOUNTOPENINGREQDRFTTP BANKACCTOPENINGREQDRFTTP V2 C1 NOT_RELEASED
BANKACCOUNTOPENINGREQOVW BANKACCOUNTOPENINGREQOVW V2 C1 NOT_RELEASED
BANKACCOUNTOPENINGREQWL BANKACCOUNTOPENINGREQWL V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5859 Approve Bank Account Applications Transactional Approve Bank Account Applications
F5860 Bank Account Applications Transactional Bank Account Applications

Approve Bank Account Applications

Business Role: Cash Manager

You can now use the new apps to manage the process of bank account applications, including submitting a bank account application, approving/rejecting a bank account application, and getting an overview of the bank account applications.

Bank Account Applications

Business Role: Cash Manager

You can now use the new apps to manage the process of bank account applications, including submitting a bank account application, approving/rejecting a bank account application, and getting an overview of the bank account applications.

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BankAccountChangeRequest I_BankAccountOpeningRequestLog BankAccountChangeRequest Request unique ID
KEY BankAcctChgReqLogSequenceNmbr I_BankAccountOpeningRequestLog BankAcctChgReqLogSequenceNmbr Value Number
BankAccountChangeRequestAction I_BankAccountOpeningRequestLog BankAccountChangeRequestAction User action
BankAcctChangeReqActionName
BankAccountReqStatusText Application Status
BankAccountReqProcessedBy I_BankAccountOpeningRequestLog BankAccountReqProcessedBy Processed By
BankAcctReqProcessorName
BankAcctReqProcessedDateTime I_BankAccountOpeningRequestLog BankAcctReqProcessedDateTime Processed On/At
BankAccountRequestNote I_BankAccountOpeningRequestLog BankAccountRequestNote TradeRequest Comment

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 C_BankAccountOpeningRequestLog.
-- 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: CBANKACCTORLOG

CREATE VIEW C_BankAccountOpeningRequestLog AS
SELECT
  ReqLog.BankAccountChangeRequest AS BankAccountChangeRequest,
  ReqLog.BankAcctChgReqLogSequenceNmbr AS BankAcctChgReqLogSequenceNmbr,
  ReqLog.BankAccountChangeRequestAction AS BankAccountChangeRequestAction,
  ReqLog._ReqActionText.BankAcctChangeReqActionName AS BankAcctChangeReqActionName,
  ReqLog._ReqStatusText.BankAccountReqStatusText AS BankAccountReqStatusText,
  ReqLog.BankAccountReqProcessedBy AS BankAccountReqProcessedBy,
  ReqLog._Contact.FullName AS BankAcctReqProcessorName,
  ReqLog.BankAcctReqProcessedDateTime AS BankAcctReqProcessedDateTime,
  ReqLog.BankAccountRequestNote AS BankAccountRequestNote
FROM I_BankAccountOpeningRequestLog AS ReqLog
;

Learn More