VFCLM_BAM_DDL_REQLOG

DDL: FCLM_BAM_REQLOG SQL: VFCLM_BAM_REQLOG Type: view Package: FCLM_BAM

Change Request Log

VFCLM_BAM_DDL_REQLOG is a CDS View that provides data about "Change Request Log" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_reqlog, sotr_head) and exposes 9 fields with key fields RequestID, SequenceNumber. Part of development package FCLM_BAM.

Data Sources (2)

SourceAliasJoin Type
fclm_bam_reqlog header from
sotr_head sotr_head left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BAM_REQLOG view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY RequestID fclm_bam_reqlog request_id Request unique ID
KEY SequenceNumber seq_no Value Number
ActedOn acted_on Date
ActedAt acted_at Field of type TIMS
Action fclm_bam_reqlog action User action
OldStatus old_status Request Status
NewStatus new_status Request Status
Processor processor User Name
stepname_otr fclm_bam_reqlog stepname_otr Alias Name

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 VFCLM_BAM_DDL_REQLOG.
-- 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: VFCLM_BAM_REQLOG

CREATE VIEW VFCLM_BAM_DDL_REQLOG AS
SELECT
  header.request_id AS RequestID,
  seq_no AS SequenceNumber,
  acted_on AS ActedOn,
  acted_at AS ActedAt,
  header.action AS Action,
  old_status AS OldStatus,
  new_status AS NewStatus,
  Processor,
  header.stepname_otr AS stepname_otr
FROM fclm_bam_reqlog AS header
LEFT OUTER JOIN sotr_head ON /* join condition not captured in parsed metadata */
;