SEPMRA_C_SH_MainCategory

DDL: SEPMRA_C_SH_MAINCATEGORY Type: view
3 Fields 1 Data Sources 1 Associations

Main Category

SEPMRA_C_SH_MainCategory is a CDS View that provides data about "Main Category" in SAP S/4HANA. It reads from 1 data source (SEPMRA_I_ProductMainCategory) and exposes 3 fields with key field Id. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
SEPMRA_I_ProductMainCategory MainCategory from

Associations (1)

CardinalityTargetAliasCondition
[0..*] SEPMRA_C_SH_Category _SubCategories _SubCategories.MainCategoryId = $projection.Id

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SEPMRACSHMCAT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Main Category view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Id SEPMRA_I_ProductMainCategory MainProductCategory Main Category
Name MainProductCategory Main Category
intheEPMmodel

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 SEPMRA_C_SH_MainCategory.
-- 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 SEPMRA_C_SH_MainCategory AS
SELECT
  MainCategory.MainProductCategory AS Id,
  MainProductCategory AS Name
FROM SEPMRA_I_ProductMainCategory AS MainCategory
LEFT OUTER JOIN SEPMRA_C_SH_Category AS _SubCategories ON _SubCategories.MainCategoryId = Id  -- association [0..*]
;

Learn More