/AGIL/LUR_I_AuthTraceClassifd

DDL: /AGIL/LUR_I_AUTHTRACECLASSIFD SQL: /AGIL/LURATCLSFD Type: view
11 Fields 1 Data Sources 1 Associations

Classified Auth Trace

/AGIL/LUR_I_AuthTraceClassifd is a CDS View that provides data about "Classified Auth Trace" in SAP S/4HANA. It reads from 1 data source (/AGIL/LUR_I_AuthTraceNormal) and exposes 11 fields with key fields ObjectName, ObjectType, Username, Hash. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/AGIL/LUR_I_AuthTraceNormal /AGIL/LUR_I_AuthTraceNormal from

Associations (1)

CardinalityTargetAliasCondition
[0..1] /agil/lurruleset _rule _rule.objct = $projection.AuthObject and _rule.field = $projection.AuthField and _rule.value = $projection.AuthValue

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName /AGIL/LURATCLSFD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Classified Auth Trace view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ObjectName ObjectName Object name
KEY ObjectType ObjectType Type
KEY Username Username User who owns item
KEY Hash Hash Statement Hash
AuthObject AuthObject Object
AuthField AuthField Authorization Fld
AuthValue AuthValue
AccessLevel
AccessDate AccessDate
AccessTime AccessTime
TimeStamp TimeStamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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 /AGIL/LUR_I_AuthTraceClassifd.
-- 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: /AGIL/LURATCLSFD

CREATE VIEW /AGIL/LUR_I_AuthTraceClassifd AS
SELECT
  ObjectName,
  ObjectType,
  Username,
  Hash,
  AuthObject,
  AuthField,
  AuthValue,
  cast(coalesce(_rule.step, '00') as abap.numc( 2 ) ) AS AccessLevel,
  AccessDate,
  AccessTime,
  TimeStamp
FROM /AGIL/LUR_I_AuthTraceNormal
LEFT OUTER JOIN /agil/lurruleset AS _rule ON _rule.objct = AuthObject AND _rule.field = AuthField AND _rule.value = AuthValue  -- association [0..1]
;

Learn More