SUIM_AUTH_LIST

DDL: SUIM_AUTH_LIST SQL: SUIMAUTHLIST Type: view Package: SUSR_IS

SUIM | Authorization Field Attributes List

SUIM_AUTH_LIST is a CDS View that provides data about "SUIM | Authorization Field Attributes List" in SAP S/4HANA. It reads from 1 data source (SUIM_AUTH_LIST_DD) and exposes 47 fields with key field Fieldname. Part of development package SUSR_IS.

Data Sources (1)

SourceAliasJoin Type
SUIM_AUTH_LIST_DD root from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SUIMAUTHLIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SUIM | Authorization Field Attributes List view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY Fieldname SUIM_AUTH_LIST_DD Fieldname UI Group FieldName
ddlanguage
Domname SUIM_AUTH_LIST_DD Domname Domain
Rollname SUIM_AUTH_LIST_DD Rollname Repr. Data Elem
Checktable SUIM_AUTH_LIST_DD Checktable Table Name
Leng SUIM_AUTH_LIST_DD leng No. of Characters
Intlen SUIM_AUTH_LIST_DD intlen Length
Decimals SUIM_AUTH_LIST_DD Decimals Rounding Places
Datatype SUIM_AUTH_LIST_DD Datatype Field Type
Inttype SUIM_AUTH_LIST_DD Inttype Interest Type
Reftable SUIM_AUTH_LIST_DD Reftable Reference table
Reffield SUIM_AUTH_LIST_DD Reffield Reference field
Precfield SUIM_AUTH_LIST_DD Precfield Name of include
Authorid SUIM_AUTH_LIST_DD Authorid
Memoryid SUIM_AUTH_LIST_DD Memoryid Parameter ID
Logflag SUIM_AUTH_LIST_DD Logflag Change document
Mask SUIM_AUTH_LIST_DD Mask Template
Masklen SUIM_AUTH_LIST_DD Masklen Template length
Convexit SUIM_AUTH_LIST_DD Convexit Convers. Rout.
Headlen SUIM_AUTH_LIST_DD Headlen Header
Scrlen1 SUIM_AUTH_LIST_DD Scrlen1 ShortFieldLabelLen
Scrlen2 SUIM_AUTH_LIST_DD Scrlen2 Med.FieldLabelLen.
Scrlen3 SUIM_AUTH_LIST_DD Scrlen3 LongFieldLabelLen.
SCRTEXT_S
SCRTEXT_M
SCRTEXT_L
Keyflag SUIM_AUTH_LIST_DD Keyflag Key field
Lowercase SUIM_AUTH_LIST_DD Lowercase Link
Mac SUIM_AUTH_LIST_DD Mac
Genkey SUIM_AUTH_LIST_DD Genkey
Noforkey SUIM_AUTH_LIST_DD Noforkey
Valexi SUIM_AUTH_LIST_DD Valexi Fixed val. ex.
Noauthch SUIM_AUTH_LIST_DD Noauthch
Sign SUIM_AUTH_LIST_DD Sign Type of SIGN component in row type of a Ranges type
Dynpfld SUIM_AUTH_LIST_DD Dynpfld
F4availabl SUIM_AUTH_LIST_DD F4availabl
Comptype SUIM_AUTH_LIST_DD Comptype Type of a reporting component
Lfieldname SUIM_AUTH_LIST_DD Lfieldname DD: Concatenated Field Name
Ltrflddis SUIM_AUTH_LIST_DD Ltrflddis LTR basic direction
Bidictrlc SUIM_AUTH_LIST_DD Bidictrlc No BIDI Filtering
Outputstyle SUIM_AUTH_LIST_DD Outputstyle Output
Nohistory SUIM_AUTH_LIST_DD Nohistory No History
Ampmformat SUIM_AUTH_LIST_DD Ampmformat AM/PM-Enabled
Modifier SUIM_AUTH_LIST_DD Modifier User Name
Moddate SUIM_AUTH_LIST_DD Moddate Modification date
Modtime SUIM_AUTH_LIST_DD Modtime Time
AbapLanguageVersion SUIM_AUTH_LIST_DD abap_language_version Language Version

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 SUIM_AUTH_LIST.
-- 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: SUIMAUTHLIST

CREATE VIEW SUIM_AUTH_LIST AS
SELECT
  root.Fieldname AS Fieldname,
  coalesce(coalesce( coalesce( dd04_tx.ddlanguage , dd04_txe.ddlanguage ), dd04_txm.ddlanguage ), '' ) AS ddlanguage,
  root.Domname AS Domname,
  root.Rollname AS Rollname,
  root.Checktable AS Checktable,
  root.leng AS Leng,
  root.intlen AS Intlen,
  root.Decimals AS Decimals,
  root.Datatype AS Datatype,
  root.Inttype AS Inttype,
  root.Reftable AS Reftable,
  root.Reffield AS Reffield,
  root.Precfield AS Precfield,
  root.Authorid AS Authorid,
  root.Memoryid AS Memoryid,
  root.Logflag AS Logflag,
  root.Mask AS Mask,
  root.Masklen AS Masklen,
  root.Convexit AS Convexit,
  root.Headlen AS Headlen,
  root.Scrlen1 AS Scrlen1,
  root.Scrlen2 AS Scrlen2,
  root.Scrlen3 AS Scrlen3,
  coalesce(coalesce( dd04_tx.scrtext_s , dd04_txe.scrtext_s ) , dd04_txm.scrtext_s) AS SCRTEXT_S,
  coalesce(coalesce( dd04_tx.scrtext_m , dd04_txe.scrtext_m ) , dd04_txm.scrtext_m ) AS SCRTEXT_M,
  coalesce(coalesce( dd04_tx.scrtext_l , dd04_txe.scrtext_l ) , dd04_txm.scrtext_l ) AS SCRTEXT_L,
  root.Keyflag AS Keyflag,
  root.Lowercase AS Lowercase,
  root.Mac AS Mac,
  root.Genkey AS Genkey,
  root.Noforkey AS Noforkey,
  root.Valexi AS Valexi,
  root.Noauthch AS Noauthch,
  root.Sign AS Sign,
  root.Dynpfld AS Dynpfld,
  root.F4availabl AS F4availabl,
  root.Comptype AS Comptype,
  root.Lfieldname AS Lfieldname,
  root.Ltrflddis AS Ltrflddis,
  root.Bidictrlc AS Bidictrlc,
  root.Outputstyle AS Outputstyle,
  root.Nohistory AS Nohistory,
  root.Ampmformat AS Ampmformat,
  root.Modifier AS Modifier,
  root.Moddate AS Moddate,
  root.Modtime AS Modtime,
  root.abap_language_version AS AbapLanguageVersion
FROM SUIM_AUTH_LIST_DD AS root
;