SAIS_DBTABLOG_CLI_TSTMP

DDL: SAIS_DBTABLOG_CLI_TSTMP Type: view_entity
10 Fields 1 Data Sources

DBTABLOG with Timestamp for Client Table

SAIS_DBTABLOG_CLI_TSTMP is a CDS View that provides data about "DBTABLOG with Timestamp for Client Table" in SAP S/4HANA. It reads from 1 data source (dbtablog) and exposes 10 fields with key fields Mandt, Log_key, Tstmp.

Data Sources (1)

SourceAliasJoin Type
dbtablog dbtablog from

Parameters (1)

NameTypeDefault
p_tabl tabname

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label DBTABLOG with Timestamp for Client Table view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Mandt
KEY Log_key
KEY Tstmp
Tabname tabname Table/Constant Value
Username username User who owns item
Tcode tcode Undefined range (can be used for patch levels)
Progname progname Tcode/program
Optype optype OP
Dataln dataln Actual length of vardata
Logdata logdata Modified Data Record

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 SAIS_DBTABLOG_CLI_TSTMP.
-- 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.
-- Parameters: p_tabl : tabname

CREATE VIEW SAIS_DBTABLOG_CLI_TSTMP AS
SELECT
  left( logkey , 3 ) AS Mandt,
  substring( logkey, 4, 251 ) AS Log_key,
  concat( logdate, logtime ) AS Tstmp,
  Tabname,
  Username,
  Tcode,
  Progname,
  Optype,
  Dataln,
  Logdata
FROM dbtablog
;

Learn More