SATC_AC_ATT_FOR_DISPL_ID_DDLV

DDL: SATC_AC_ATT_FOR_DISPL_ID_DDLV Type: view_entity

Attribute names for a given display ID

SATC_AC_ATT_FOR_DISPL_ID_DDLV is a CDS View that provides data about "Attribute names for a given display ID" in SAP S/4HANA. It reads from 9 data sources and exposes 4 fields with key fields display_id, item_id, item_id, attr_ix.

Data Sources (9)

SourceAliasJoin Type
satc_ac_att att inner
satc_ac_att att inner
satc_ac_fnd_v fnd_v inner
satc_ac_fnd_v fnd_v inner
satc_ac_resulth h from
satc_ac_resulth h union_all
sca_attr_ix ix inner
sca_attr_ix ix_desc inner
sca_attr_md md inner

Annotations (3)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Attribute names for a given display ID view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY display_id satc_ac_resulth display_id Display ID
KEY item_id satc_ac_fnd_v item_id Simulation Item ID
KEY item_id satc_ac_fnd_v item_id Simulation Item ID
KEY attr_ix sca_attr_ix attribute_index INT4

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 SATC_AC_ATT_FOR_DISPL_ID_DDLV.
-- 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 SATC_AC_ATT_FOR_DISPL_ID_DDLV AS
SELECT
  h.display_id AS display_id,
  fnd_v.item_id AS item_id,
  ix_desc.attribute_index AS attr_ix
FROM satc_ac_resulth AS h
INNER JOIN satc_ac_fnd_v AS fnd_v ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_att AS att ON /* join condition not captured in parsed metadata */
INNER JOIN sca_attr_ix AS ix ON /* join condition not captured in parsed metadata */
INNER JOIN sca_attr_md AS md ON /* join condition not captured in parsed metadata */
INNER JOIN sca_attr_ix AS ix_desc ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): satc_ac_resulth
;