AUTHX_FIELDINFO__DD04LDD01L

DDL: AUTHX_FIELDINFO__DD04LDD01L Type: view_entity Package: SU20
32 Fields 3 Data Sources

Test

AUTHX_FIELDINFO__DD04LDD01L is a CDS View that provides data about "Test" in SAP S/4HANA. It reads from 3 data sources (dd01l, dd04l, dd04l) and exposes 32 fields with key field rollname. Part of development package SU20.

Data Sources (3)

SourceAliasJoin Type
dd01l dd01l inner
dd04l dd04l from
dd04l dd04l union

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Test view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY rollname dd04l rollname Repr. Data Elem
domname dd04l domname Domain
memoryid dd04l memoryid Parameter ID
scrlen1 dd04l scrlen1 ShortFieldLabelLen
scrlen2 dd04l scrlen2 Med.FieldLabelLen.
scrlen3 dd04l scrlen3 LongFieldLabelLen.
dtelmaster dd04l dtelmaster Original Lang.
datatype dd01l datatype Field Type
leng dd01l leng No. of Characters
intleng dd01l leng No. of Characters
outputlen dd01l outputlen Output Length
decimals dd01l decimals Rounding Places
lowercase dd01l lowercase Link
valexi dd01l valexi Fixed val. ex.
convexit dd01l convexit Convers. Rout.
mask dd01l mask Template
domname dd04l domname Domain
memoryid dd04l memoryid Parameter ID
scrlen1 dd04l scrlen1 ShortFieldLabelLen
scrlen2 dd04l scrlen2 Med.FieldLabelLen.
scrlen3 dd04l scrlen3 LongFieldLabelLen.
dtelmaster dd04l dtelmaster Original Lang.
datatype dd04l datatype Field Type
leng dd04l leng No. of Characters
intleng dd04l leng No. of Characters
outputlen dd04l outputlen Output Length
decimals dd04l decimals Rounding Places
lowercase dd04l lowercase Link
valexi dd04l valexi Fixed val. ex.
convexit dd04l convexit Convers. Rout.
mask Template
masklen

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 AUTHX_FIELDINFO__DD04LDD01L.
-- 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.

CREATE VIEW AUTHX_FIELDINFO__DD04LDD01L AS
SELECT
  dd04l.rollname AS rollname,
  dd04l.domname AS domname,
  dd04l.memoryid AS memoryid,
  dd04l.scrlen1 AS scrlen1,
  dd04l.scrlen2 AS scrlen2,
  dd04l.scrlen3 AS scrlen3,
  dd04l.dtelmaster AS dtelmaster,
  dd01l.datatype AS datatype,
  dd01l.leng AS leng,
  dd01l.leng AS intleng,
  dd01l.outputlen AS outputlen,
  dd01l.decimals AS decimals,
  dd01l.lowercase AS lowercase,
  dd01l.valexi AS valexi,
  dd01l.convexit AS convexit,
  dd01l.mask AS mask,
  '0000' AS masklen
FROM dd04l
INNER JOIN dd01l ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): dd04l
;

Learn More