P_RSAUPROF

DDL: P_RSAUPROF SQL: PRSAUPROF Type: view Package: SECU
13 Fields 1 Data Sources 1 Associations

Security Audit Log - Configuration Data

P_RSAUPROF is a CDS View that provides data about "Security Audit Log - Configuration Data" in SAP S/4HANA. It reads from 1 data source (rsauprof) and exposes 13 fields with key fields profname, slotno. It has 1 association to related views. Part of development package SECU.

Data Sources (1)

SourceAliasJoin Type
rsauprof head from

Associations (1)

CardinalityTargetAliasCondition
[1..1] rsauprofex _profex ( head.profname = _profex.profname and head.slotno = _profex.slotno )

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRSAUPROF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Security Audit Log - Configuration Data view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY profname rsauprof profname Profile name
KEY slotno rsauprof slotno Audit log: Number of the recording parameter (slot)
currprof rsauprof currprof Current Profile
classes rsauprof classes Class
severity rsauprof severity Thresh.Val. Severity
client rsauprof client Workflow definition: Client
uname rsauprof uname User Name
status rsauprof status Workflow Status
cuname rsauprof cuname Changed by
cdate rsauprof cdate Modification date
selvar rsauprof selvar SelVariant
msgvect _profex msgvect SelVector
msgvect_old rsauprof msgvect SelVector

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 P_RSAUPROF.
-- 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: PRSAUPROF

CREATE VIEW P_RSAUPROF AS
SELECT
  head.profname AS profname,
  head.slotno AS slotno,
  head.currprof AS currprof,
  head.classes AS classes,
  head.severity AS severity,
  head.client AS client,
  head.uname AS uname,
  head.status AS status,
  head.cuname AS cuname,
  head.cdate AS cdate,
  head.selvar AS selvar,
  _profex.msgvect AS msgvect,
  head.msgvect AS msgvect_old
FROM rsauprof AS head
LEFT OUTER JOIN rsauprofex AS _profex ON ( head.profname = _profex.profname AND head.slotno = _profex.slotno )  -- association [1..1]
;

Learn More