sepm_cds_product

DDL: SEPM_CDS_PRODUCT SQL: SEPMV_PROD Type: view
11 Fields 1 Data Sources 1 Associations

sepm_cds_product is a CDS View in SAP S/4HANA. It reads from 1 data source (snwd_pd) and exposes 11 fields with key field product_key. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
snwd_pd snwd_pd from

Associations (1)

CardinalityTargetAliasCondition
[0..*] sepm_cds_sales_order_item sales_order_items node_key = sales_order_items.product_guid

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName SEPMV_PROD view
AccessControl.authorizationCheck #NOT_REQUIRED view
OData.publish false view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY product_key node_key Tree Model: Node Key
product_id product_id Simulated Product ID
type_code type_code Type Code
category category Violation Category
created_by created_by Version Created By
created_at created_at Uploaded On
changed_by changed_by User Name
changed_at changed_at Timestamp
measure_unit measure_unit Unit of Measure
weight_unit weight_unit Weight Unit
price price RVP f.PricePro.

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_cds_product.
-- 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: SEPMV_PROD

CREATE VIEW sepm_cds_product AS
SELECT
  node_key AS product_key,
  product_id,
  type_code,
  category,
  created_by,
  created_at,
  changed_by,
  changed_at,
  measure_unit,
  weight_unit,
  price
FROM snwd_pd
LEFT OUTER JOIN sepm_cds_sales_order_item AS sales_order_items ON node_key = sales_order_items.product_guid  -- association [0..*]
;

Learn More