RSAUPROF_HEAD_SEL

DDL: RSAUPROF_HEAD_SEL SQL: RSAUPROF_HDS Type: view Package: SECU
5 Fields 1 Data Sources

Filter Header Data with resolved User/User Group Intervals

RSAUPROF_HEAD_SEL is a CDS View that provides data about "Filter Header Data with resolved User/User Group Intervals" in SAP S/4HANA. It reads from 1 data source (RSAUPROF_HEAD) and exposes 5 fields with key fields Profname, Slotno. Part of development package SECU.

Data Sources (1)

SourceAliasJoin Type
RSAUPROF_HEAD head from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName RSAUPROF_HDS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Filter Header Data with resolved User/User Group Intervals view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Profname RSAUPROF_HEAD Profname Profile name
KEY Slotno RSAUPROF_HEAD Slotno Audit log: Number of the recording parameter (slot)
sel_sign sel_sign Sign
sel_user1112Zelseendassel_user_to
sel_ugr1112Zelseendassel_ugr_to

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 RSAUPROF_HEAD_SEL.
-- 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: RSAUPROF_HDS

CREATE VIEW RSAUPROF_HEAD_SEL AS
SELECT
  head.Profname AS Profname,
  head.Slotno AS Slotno,
  sel_sign,
  case when head.sel_user = '' then '' when head.sel_user = 'SAP#*' then 'SAP*' when head.sel_opt = 'EQ' then head.sel_user when head.sel_opt = 'CP' and uname_star_pos = 1 then '' when head.sel_opt = 'CP' and uname_star_pos = 2 then rpad( left(head.sel_user, 1 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 3 then rpad( left(head.sel_user, 2 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 4 then rpad( left(head.sel_user, 3 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 5 then rpad( left(head.sel_user, 4 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 6 then rpad( left(head.sel_user, 5 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 7 then rpad( left(head.sel_user, 6 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 8 then rpad( left(head.sel_user, 7 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 9 then rpad( left(head.sel_user, 8 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 10 then rpad( left(head.sel_user, 9 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 11 then rpad( left(head.sel_user, 10 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 12 then rpad( left(head.sel_user, 11 ), 12, 'Z') else '' end as sel_user_to AS sel_user1112Zelseendassel_user_to,
  case when head.sel_ugr = '' then '' when head.sel_opt = 'EQ' then head.sel_ugr when head.sel_opt = 'CP' and uname_star_pos = 2 then rpad( left(head.sel_ugr, 1 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 2 then rpad( left(head.sel_ugr, 1 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 3 then rpad( left(head.sel_ugr, 2 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 4 then rpad( left(head.sel_ugr, 3 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 5 then rpad( left(head.sel_ugr, 4 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 6 then rpad( left(head.sel_ugr, 5 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 7 then rpad( left(head.sel_ugr, 6 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 8 then rpad( left(head.sel_ugr, 7 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 9 then rpad( left(head.sel_ugr, 8 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 10 then rpad( left(head.sel_ugr, 9 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 11 then rpad( left(head.sel_ugr, 10 ), 12, 'Z') when head.sel_opt = 'CP' and uname_star_pos = 12 then rpad( left(head.sel_ugr, 11 ), 12, 'Z') else '' end as sel_ugr_to AS sel_ugr1112Zelseendassel_ugr_to
FROM RSAUPROF_HEAD AS head
;

Learn More