usattriddef_all

DDL: USATTRIDDEF_ALL SQL: USATTRIDDEFALL Type: view Package: SUSR_IDENTITY
5 Fields 5 Data Sources

Benutzerattribute mit Default

usattriddef_all is a CDS View that provides data about "Benutzerattribute mit Default" in SAP S/4HANA. It reads from 5 data sources (usattriddef, usattriddef, USATTRIDDEF_DEFAULT, USATTRIDDEF_DEFAULT, usattriddeft) and exposes 5 fields with key fields attr_type, attr_id, attr_id. Part of development package SUSR_IDENTITY.

Data Sources (5)

SourceAliasJoin Type
usattriddef usattriddef left_outer
usattriddef usattriddef union
USATTRIDDEF_DEFAULT USATTRIDDEF_DEFAULT from
USATTRIDDEF_DEFAULT USATTRIDDEF_DEFAULT left_outer
usattriddeft usattriddeft left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName USATTRIDDEFALL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Benutzerattribute mit Default view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY attr_type USATTRIDDEF_DEFAULT attr_type Type
KEY attr_id USATTRIDDEF_DEFAULT default_attr_id User Attribute
attr_type Type
KEY attr_id usattriddef attr_id User Attribute
attr_text usattriddeft attr_text Short Description

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 usattriddef_all.
-- 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: USATTRIDDEFALL

CREATE VIEW usattriddef_all AS
SELECT
  USATTRIDDEF_DEFAULT.attr_type AS attr_type,
  USATTRIDDEF_DEFAULT.default_attr_id AS attr_id,
  usattriddeft.attr_text AS attr_text
FROM USATTRIDDEF_DEFAULT
LEFT OUTER JOIN usattriddef ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN USATTRIDDEF_DEFAULT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usattriddeft ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): usattriddef
;

Learn More