C_MDHierTemplateEdgeFilter

DDL: C_MDHIERTEMPLATEEDGEFILTER SQL: CMDHTMPLEFLTR Type: view CONSUMPTION
10 Fields 1 Data Sources 2 Associations

Master Data Hierarchy Template Edge Filter

C_MDHierTemplateEdgeFilter is a Consumption CDS View that provides data about "Master Data Hierarchy Template Edge Filter" in SAP S/4HANA. It reads from 1 data source (I_MDHierTemplateEdgeFilter) and exposes 10 fields with key fields MDHierTemplate, MDHierTemplateEdgeFilter. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MDHierTemplateEdgeFilter MDHTEF from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_MDHierTemplate _MDHierTemplate $projection.MDHierTemplate = _MDHierTemplate.MDHierTemplate
[0..*] C_MDEdgeTypePrptyAttributeVH _MDEdgeTypePrptyAttributeVH $projection.MasterDataEdgeType = _MDEdgeTypePrptyAttributeVH.MasterDataEdgeType and $projection.MasterDataProperty = _MDEdgeTypePrptyAttributeVH.MasterDataProperty

Annotations (10)

NameValueLevelField
EndUserText.label Master Data Hierarchy Template Edge Filter view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CMDHTMPLEFLTR view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey MDHierTemplateEdgeFilter view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MDHierTemplate MDHierTemplate Template LinkID
KEY MDHierTemplateEdgeFilter MDHierTemplateEdgeFilter Edge Filter
Language
MasterDataEdgeType MasterDataEdgeType Edge Type
MasterDataProperty MasterDataProperty Element
MDHierTmplFilterIsRequired MDHierTmplFilterIsRequired Filter Required
MDHierTmplFilterIsGlobal MDHierTmplFilterIsGlobal Global Filter
MDHierTemplateLevel MDHierTemplateLevel Template Level
_MDHierTemplate _MDHierTemplate
_MDEdgeTypePrptyAttributeVH _MDEdgeTypePrptyAttributeVH

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 C_MDHierTemplateEdgeFilter.
-- 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: CMDHTMPLEFLTR

CREATE VIEW C_MDHierTemplateEdgeFilter AS
SELECT
  MDHierTemplate,
  MDHierTemplateEdgeFilter,
  cast( $session.system_language as spras ) AS Language,
  MasterDataEdgeType,
  MasterDataProperty,
  MDHierTmplFilterIsRequired,
  MDHierTmplFilterIsGlobal,
  MDHierTemplateLevel
FROM I_MDHierTemplateEdgeFilter AS MDHTEF
LEFT OUTER JOIN C_MDHierTemplate AS _MDHierTemplate ON MDHierTemplate = _MDHierTemplate.MDHierTemplate  -- association [1..1]
LEFT OUTER JOIN C_MDEdgeTypePrptyAttributeVH AS _MDEdgeTypePrptyAttributeVH ON MasterDataEdgeType = _MDEdgeTypePrptyAttributeVH.MasterDataEdgeType AND MasterDataProperty = _MDEdgeTypePrptyAttributeVH.MasterDataProperty  -- association [0..*]
;

Learn More