sepm_sddl_product_categories

DDL: SEPM_SDDL_PRODUCT_CATEGORIES SQL: SEPM_SDDL_V_PRC Type: view
1 Fields 1 Data Sources 1 Associations

sepm_sddl_product_categories is a CDS View in SAP S/4HANA. It reads from 1 data source (snwd_pd_catgos) and exposes 1 field with key field category. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
snwd_pd_catgos snwd_pd_catgos from

Associations (1)

CardinalityTargetAliasCondition
[0..*] sepm_sddl_product products_of_category snwd_pd_catgos.category = products_of_category.category

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName SEPM_SDDL_V_PRC view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY category category Violation Category

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_product_categories.
-- 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_V_PRC

CREATE VIEW sepm_sddl_product_categories AS
SELECT
  category
FROM snwd_pd_catgos
LEFT OUTER JOIN sepm_sddl_product AS products_of_category ON snwd_pd_catgos.category = products_of_category.category  -- association [0..*]
;

Learn More