sepm_sddl_stock

DDL: SEPM_SDDL_STOCK SQL: SEPM_SDDL_STCK_T Type: view Package: S_EPM_CDS
5 Fields 1 Data Sources 2 Associations

EPM: DDL View for Stock

sepm_sddl_stock is a CDS View that provides data about "EPM: DDL View for Stock" in SAP S/4HANA. It reads from 1 data source (snwd_stock) and exposes 5 fields. It has 2 associations to related views. Part of development package S_EPM_CDS.

Data Sources (1)

SourceAliasJoin Type
snwd_stock snwd_stock from

Associations (2)

CardinalityTargetAliasCondition
[1] sepm_sddl_product product $projection.product_key = product.product_key
[1] sepm_sddl_depts department $projection.department_key = department.department_key

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName SEPM_SDDL_STCK_T view

Fields (5)

KeyFieldSource TableSource FieldDescription
product_key product_guid Product
quantity quantity Value
lot_size lot_size Lot Size
product product Product Sold
department department Department

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 sepm_sddl_stock.
-- 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: SEPM_SDDL_STCK_T

CREATE VIEW sepm_sddl_stock AS
SELECT
  product_guid AS product_key,
  quantity,
  lot_size,
  product,
  department
FROM snwd_stock
LEFT OUTER JOIN sepm_sddl_product AS product ON product_key = product.product_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_depts AS department ON department_key = department.department_key  -- association [1]
;

Learn More