usr_attr_id_assign_w_default

DDL: USR_ATTR_ID_ASSIGN_W_DEFAULT Type: view_entity
1 Fields 3 Data Sources

Zuordnung Benutzerattribute mit Default

usr_attr_id_assign_w_default is a CDS View that provides data about "Zuordnung Benutzerattribute mit Default" in SAP S/4HANA. It reads from 3 data sources (USATTRIDDEF_DEFAULT, usr_attr_id_assign, usr02) and exposes 1 field with key field bname.

Data Sources (3)

SourceAliasJoin Type
USATTRIDDEF_DEFAULT USATTRIDDEF_DEFAULT left_outer
usr_attr_id_assign usr_attr_id_assign left_outer
usr02 usr02 from

Parameters (1)

NameTypeDefault
p_attr_type suid_attr_type

Annotations (6)

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

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY bname usr02 bname User name

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 usr_attr_id_assign_w_default.
-- 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.
-- Parameters: p_attr_type : suid_attr_type

CREATE VIEW usr_attr_id_assign_w_default AS
SELECT
  usr02.bname AS bname
FROM usr02
LEFT OUTER JOIN usr_attr_id_assign ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN USATTRIDDEF_DEFAULT ON /* join condition not captured in parsed metadata */
;

Learn More