C_MDHierTemplateNodeFilter

DDL: C_MDHIERTEMPLATENODEFILTER SQL: CMDHTMPLNFLTR Type: view CONSUMPTION
10 Fields 1 Data Sources 2 Associations

Master Data Hierarchy Template Node Filter

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

Data Sources (1)

SourceAliasJoin Type
I_MDHierTemplateNodeFilter MDHTNF from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_MDHierTemplate _MDHierTemplate $projection.MDHierTemplate = _MDHierTemplate.MDHierTemplate
[0..*] C_MDNodeTypePrptyAttributeVH _MDNodeTypePrptyAttributeVH $projection.MasterDataNodeType = _MDNodeTypePrptyAttributeVH.MasterDataNodeType and $projection.MasterDataProperty = _MDNodeTypePrptyAttributeVH.MasterDataProperty

Annotations (10)

NameValueLevelField
EndUserText.label Master Data Hierarchy Template Node Filter view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CMDHTMPLNFLTR view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey MDHierTemplateNodeFilter 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 MDHierTemplateNodeFilter MDHierTemplateNodeFilter Node Filter
Language
MasterDataNodeType MasterDataNodeType Type
MasterDataProperty MasterDataProperty Element
MDHierTmplFilterIsRequired MDHierTmplFilterIsRequired Filter Required
MDHierTmplFilterIsGlobal MDHierTmplFilterIsGlobal Global Filter
MDHierTemplateLevel MDHierTemplateLevel Template Level
_MDHierTemplate _MDHierTemplate
_MDNodeTypePrptyAttributeVH _MDNodeTypePrptyAttributeVH

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_MDHierTemplateNodeFilter.
-- 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: CMDHTMPLNFLTR

CREATE VIEW C_MDHierTemplateNodeFilter AS
SELECT
  MDHierTemplate,
  MDHierTemplateNodeFilter,
  cast( $session.system_language as spras ) AS Language,
  MasterDataNodeType,
  MasterDataProperty,
  MDHierTmplFilterIsRequired,
  MDHierTmplFilterIsGlobal,
  MDHierTemplateLevel
FROM I_MDHierTemplateNodeFilter AS MDHTNF
LEFT OUTER JOIN C_MDHierTemplate AS _MDHierTemplate ON MDHierTemplate = _MDHierTemplate.MDHierTemplate  -- association [1..1]
LEFT OUTER JOIN C_MDNodeTypePrptyAttributeVH AS _MDNodeTypePrptyAttributeVH ON MasterDataNodeType = _MDNodeTypePrptyAttributeVH.MasterDataNodeType AND MasterDataProperty = _MDNodeTypePrptyAttributeVH.MasterDataProperty  -- association [0..*]
;

Learn More