C_BankAccountChangeRequestLog

DDL: C_BANKACCOUNTCHANGEREQUESTLOG SQL: CFIBAMCHGREQLOG Type: view CONSUMPTION Package: FCLM_BAM
14 Fields 1 Data Sources 1 OData Services

Bank Account Change Request Log

C_BankAccountChangeRequestLog is a Consumption CDS View that provides data about "Bank Account Change Request Log" in SAP S/4HANA. It reads from 1 data source (I_BankAccountChangeRequestLog) and exposes 14 fields with key fields BankAccountChangeRequest, BankAcctChgReqLogSequenceNmbr. It is exposed through 1 OData service (ASQL_F7166). Part of development package FCLM_BAM.

Data Sources (1)

SourceAliasJoin Type
I_BankAccountChangeRequestLog ReqLog from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Account Change Request Log view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CFIBAMCHGREQLOG view
ObjectModel.representativeKey BankAccountChangeRequest view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
UI.headerInfo.typeName Approval History view
UI.headerInfo.typeNamePlural Approval History view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F7166 ASQL_F7166 C2 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BankAccountChangeRequest I_BankAccountChangeRequestLog BankAccountChangeRequest Request unique ID
KEY BankAcctChgReqLogSequenceNmbr I_BankAccountChangeRequestLog BankAcctChgReqLogSequenceNmbr Value Number
BankAccountInternalID BankAccountInternalID Technical ID
BankAccountRevision BankAccountRevision Revision Number
BankAccountChangeRequestAction I_BankAccountChangeRequestLog BankAccountChangeRequestAction User action
BankAcctChangeReqActionDate I_BankAccountChangeRequestLog BankAcctChangeReqActionDate Date
BankAcctChangeReqActionTime I_BankAccountChangeRequestLog BankAcctChangeReqActionTime Field of type TIMS
BankAcctReqProcessedDateTime I_BankAccountChangeRequestLog BankAcctReqProcessedDateTime
BankAcctChangeRequestNewStatus I_BankAccountChangeRequestLog BankAcctChangeRequestNewStatus Request Status
BankAcctChangeRequestProcessor I_BankAccountChangeRequestLog BankAcctChangeRequestProcessor Processor
BankAcctReqProcessorName
BankAcctChangeReqActionName Action
BankAcctChangeRequestStepName I_BankAccountChangeRequestLog BankAcctChangeRequestStepName Alias Name
BankAccountReqStatusText

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_BankAccountChangeRequestLog.
-- 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: CFIBAMCHGREQLOG

CREATE VIEW C_BankAccountChangeRequestLog AS
SELECT
  ReqLog.BankAccountChangeRequest AS BankAccountChangeRequest,
  ReqLog.BankAcctChgReqLogSequenceNmbr AS BankAcctChgReqLogSequenceNmbr,
  BankAccountInternalID,
  BankAccountRevision,
  ReqLog.BankAccountChangeRequestAction AS BankAccountChangeRequestAction,
  ReqLog.BankAcctChangeReqActionDate AS BankAcctChangeReqActionDate,
  ReqLog.BankAcctChangeReqActionTime AS BankAcctChangeReqActionTime,
  ReqLog.BankAcctReqProcessedDateTime AS BankAcctReqProcessedDateTime,
  ReqLog.BankAcctChangeRequestNewStatus AS BankAcctChangeRequestNewStatus,
  ReqLog.BankAcctChangeRequestProcessor AS BankAcctChangeRequestProcessor,
  ReqLog._Contact.FullName AS BankAcctReqProcessorName,
  ReqLog._ReqActionText.BankAcctChangeReqActionName AS BankAcctChangeReqActionName,
  ReqLog.BankAcctChangeRequestStepName AS BankAcctChangeRequestStepName,
  ReqLog._ReqStatusText.BankAccountReqStatusText AS BankAccountReqStatusText
FROM I_BankAccountChangeRequestLog AS ReqLog
;

Learn More