RSAU_APP_STAT_EXCL

DDL: RSAU_APP_STAT_EXCL SQL: RSAU_APPSTAT_EX Type: view

SAL Application Statistic - Excluded Applications

RSAU_APP_STAT_EXCL is a CDS View that provides data about "SAL Application Statistic - Excluded Applications" in SAP S/4HANA. It reads from 8 data sources and exposes 3 fields with key fields type, typeastype.

Data Sources (8)

SourceAliasJoin Type
agr_1250 s_service from
agr_1250 s_start union
agr_1251 t1251_na inner
agr_1251 t1251_na inner
agr_1251 t1251_ty inner
agr_1251 t1251_ty inner
agr_1251 tran union
usobhash uhash inner

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName RSAU_APPSTAT_EX view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label SAL Application Statistic - Excluded Applications view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY type agr_1251 low Value from
KEY typeastype
name agr_1251 low Value from

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_EXCL.
-- 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_EX

CREATE VIEW RSAU_APP_STAT_EXCL AS
SELECT
  t1251_ty.low AS type,
  t1251_na.low as name AS typeastype,
  tran.low AS name
FROM agr_1250 AS s_service
INNER JOIN agr_1251 AS t1251_ty ON /* join condition not captured in parsed metadata */
INNER JOIN agr_1251 AS t1251_na ON /* join condition not captured in parsed metadata */
INNER JOIN usobhash AS uhash ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): agr_1250, agr_1251
;