RSAU_APP_STAT_CUI

DDL: RSAU_APP_STAT_CUI SQL: RSAU_APPSTAT_CUI Type: view
9 Fields 2 Data Sources 1 Associations

SAL - Get CUI Events for Statistic

RSAU_APP_STAT_CUI is a CDS View that provides data about "SAL - Get CUI Events for Statistic" in SAP S/4HANA. It reads from 2 data sources (RSAU_LOG_4_CUI, usobhash) and exposes 9 fields with key fields log_tstmp, slgmand, slguser, object, obj_name. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
RSAU_LOG_4_CUI sal from
usobhash uhash left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] RSAU_APP_STAT_EXCL excl ( excl.type = 'HT' and excl.name = uhash.name )

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName RSAU_APPSTAT_CUI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SAL - Get CUI Events for Statistic view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY log_tstmp RSAU_LOG_4_CUI log_tstmp Time Stamp
KEY slgmand RSAU_LOG_4_CUI slgmand Client
KEY slguser RSAU_LOG_4_CUI slguser User
KEY object RSAU_LOG_4_CUI object TRFM Object
KEY obj_name RSAU_LOG_4_CUI obj_name Object Name
counter RSAU_LOG_4_CUI counter Version
name usobhash name Zone name
type usobhash type Worklist Type
typewhenHTthenXelseendasexcl

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_APP_STAT_CUI.
-- 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: RSAU_APPSTAT_CUI

CREATE VIEW RSAU_APP_STAT_CUI AS
SELECT
  sal.log_tstmp AS log_tstmp,
  sal.slgmand AS slgmand,
  sal.slguser AS slguser,
  sal.object AS object,
  sal.obj_name AS obj_name,
  sal.counter AS counter,
  uhash.name AS name,
  uhash.type AS type,
  case coalesce( excl.type, '' ) when 'HT' then 'X' else '' end as excl AS typewhenHTthenXelseendasexcl
FROM RSAU_LOG_4_CUI AS sal
LEFT OUTER JOIN usobhash AS uhash ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN RSAU_APP_STAT_EXCL AS excl ON ( excl.type = 'HT' AND excl.name = uhash.name )  -- association [0..1]
;

Learn More