e_sddlx_mdata_pm

DDL: SDDLX_MDATA_PM SQL: SDDLX_MDATA_PM Type: view

Parameterized DDLX Metadata

e_sddlx_mdata_pm is a CDS View that provides data about "Parameterized DDLX Metadata" in SAP S/4HANA. It reads from 1 data source (e_sddlx_mdata_raw) and exposes 11 fields.

Data Sources (1)

SourceAliasJoin Type
e_sddlx_mdata_raw raw_data from

Parameters (2)

NameTypeDefault
p_entity ddlx_extended_artifact
p_variant ddlx_variant

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SDDLX_MDATA_PM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Parameterized DDLX Metadata view

Fields (11)

KeyFieldSource TableSource FieldDescription
anno_id e_sddlx_mdata_raw anno_id
element e_sddlx_mdata_raw element Target identifier
name e_sddlx_mdata_raw name Zone name
layer e_sddlx_mdata_raw layer TC Layer
value e_sddlx_mdata_raw value Value from table
element_type e_sddlx_mdata_raw element_type Element Type
uuid e_sddlx_mdata_raw uuid Waste Partner UUID
ddlxname e_sddlx_mdata_raw ddlxname Name of DDLX Source
variant e_sddlx_mdata_raw variant Variant Saved
disabled e_sddlx_mdata_raw disabled Std Delivery Status
entity e_sddlx_mdata_raw entity Supply Chain Unit

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 e_sddlx_mdata_pm.
-- 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: SDDLX_MDATA_PM
-- Parameters: p_entity : ddlx_extended_artifact, p_variant : ddlx_variant

CREATE VIEW e_sddlx_mdata_pm AS
SELECT
  raw_data.anno_id AS anno_id,
  raw_data.element AS element,
  raw_data.name AS name,
  raw_data.layer AS layer,
  raw_data.value AS value,
  raw_data.element_type AS element_type,
  raw_data.uuid AS uuid,
  raw_data.ddlxname AS ddlxname,
  raw_data.variant AS variant,
  raw_data.disabled AS disabled,
  raw_data.entity AS entity
FROM e_sddlx_mdata_raw AS raw_data
;