RSAU_GET_AR

DDL: RSAU_GET_AR SQL: PRSAUGETAR Type: view Package: SECU_OPS
4 Fields 3 Data Sources

Security Audit Log - Get Access Rule

RSAU_GET_AR is a CDS View that provides data about "Security Audit Log - Get Access Rule" in SAP S/4HANA. It reads from 3 data sources (t000, rsauprof, rsau_rules) and exposes 4 fields with key fields rsau_rule, value_high. Part of development package SECU_OPS.

Data Sources (3)

SourceAliasJoin Type
t000 my_clnt inner
rsauprof rprof inner
rsau_rules rules from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRSAUGETAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 003 view
EndUserText.label Security Audit Log - Get Access Rule view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY rsau_rule rsau_rules rsau_rule Access Rule
KEY value_high rsau_rules value_high Value for Search
valueALLthenCPelseEQendassel_option
inactive rsau_rules inactive WO Locked

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 RSAU_GET_AR.
-- 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: PRSAUGETAR

CREATE VIEW RSAU_GET_AR AS
SELECT
  rules.rsau_rule AS rsau_rule,
  rules.value_high AS value_high,
  case when rules.value_high > '' then 'BT' when ( rules.value like '%*%' or rules.value = '<ALL>' ) then 'CP' else 'EQ' end as sel_option AS valueALLthenCPelseEQendassel_option,
  rules.inactive AS inactive
FROM rsau_rules AS rules
INNER JOIN rsauprof AS rprof ON /* join condition not captured in parsed metadata */
INNER JOIN t000 AS my_clnt ON /* join condition not captured in parsed metadata */
;

Learn More