CUAN_EXP_DEF_ATTRIBUTES

DDL: CUAN_EXP_DEF_ATTRIBUTES Type: view_entity

Attributes of Export Definition

CUAN_EXP_DEF_ATTRIBUTES is a CDS View that provides data about "Attributes of Export Definition" in SAP S/4HANA. It reads from 5 data sources (hpa_d_attribute, hpa_d_ed_root, cds_gseg_ot_ds_at, gseg_profile, hpa_sem_attr_t) and exposes 7 fields with key fields at_ds_alias, at_name, at_as_descr.

Data Sources (5)

SourceAliasJoin Type
hpa_d_attribute at from
hpa_d_ed_root ed inner
cds_gseg_ot_ds_at gs left_outer
gseg_profile pr inner
hpa_sem_attr_t sem left_outer

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Attributes of Export Definition view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY at_ds_alias hpa_d_attribute at_ds_alias
KEY at_name hpa_d_attribute at_name
KEY at_as_descr hpa_d_attribute at_as_descr
at_text cds_gseg_ot_ds_at at_text
at_pos hpa_d_attribute at_pos
at_sort_pos hpa_d_attribute at_sort_pos
at_group_pos hpa_d_attribute at_group_pos

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 CUAN_EXP_DEF_ATTRIBUTES.
-- 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 CUAN_EXP_DEF_ATTRIBUTES AS
SELECT
  at.at_ds_alias AS at_ds_alias,
  at.at_name AS at_name,
  at.at_as_descr AS at_as_descr,
  gs.at_text AS at_text,
  at.at_pos AS at_pos,
  at.at_sort_pos AS at_sort_pos,
  at.at_group_pos AS at_group_pos
FROM hpa_d_attribute AS at
INNER JOIN hpa_d_ed_root AS ed ON /* join condition not captured in parsed metadata */
INNER JOIN gseg_profile AS pr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cds_gseg_ot_ds_at AS gs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hpa_sem_attr_t AS sem ON /* join condition not captured in parsed metadata */
;