SUIM_USER_ATTR_TEXTS_X

DDL: SUIM_USER_ATTR_TEXTS_X Type: view_entity Package: SUSR_IS_UI

SUIM|User Attributes Description

SUIM_USER_ATTR_TEXTS_X is a CDS View that provides data about "SUIM|User Attributes Description" in SAP S/4HANA. Part of development package SUSR_IS_UI.

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SUIM|User Attributes Description view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY tabname
KEY fname
KEY tech_val
KEY attr_id attr_s attr_id User Attribute
text_val
attr_text
tech_val_ext

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_USER_ATTR_TEXTS_X.
-- 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 SUIM_USER_ATTR_TEXTS_X AS
SELECT
  cast( 'USR_ATTR_ID' as tabname ) AS tabname,
  cast( 'ATTR_ID' as fieldname ) AS fname,
  cast( x.tech_val as cdfldvalo ) AS tech_val,
  attr_s.attr_id AS attr_id,
  concat( cast( x.tx_val as xutext ) , ':' ) AS text_val,
  coalesce( coalesce( attr_s.attr_text, attr_e.attr_text ), attr_d.attr_text ) AS attr_text,
  concat( x.tech_val, ':' ) AS tech_val_ext
;