C_MDNodePropertyAttribute

DDL: C_MDNODEPROPERTYATTRIBUTE SQL: CMDNPRPTYATTR Type: view CONSUMPTION Package: HP_UI
6 Fields 1 Data Sources 1 Associations

Master Data Node Property Attribute

C_MDNodePropertyAttribute is a Consumption CDS View that provides data about "Master Data Node Property Attribute" in SAP S/4HANA. It reads from 1 data source (I_MDNodePropertyAttribute) and exposes 6 fields with key fields MasterDataNodeType, MasterDataNode, MasterDataProperty, MasterDataPropertyAttribute. It has 1 association to related views. Part of development package HP_UI.

Data Sources (1)

SourceAliasJoin Type
I_MDNodePropertyAttribute MDNPA from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_MasterDataNode _MasterDataNode $projection.MasterDataNodeType = _MasterDataNode.MasterDataNodeType and $projection.MasterDataNode = _MasterDataNode.MasterDataNode

Annotations (9)

NameValueLevelField
EndUserText.label Master Data Node Property Attribute view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CMDNPRPTYATTR view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MasterDataNodeType MasterDataNodeType Type
KEY MasterDataNode MasterDataNode Workflow Step
KEY MasterDataProperty MasterDataProperty Element
KEY MasterDataPropertyAttribute MasterDataPropertyAttribute Rnd.Attr. Value
Language
_MasterDataNode _MasterDataNode

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_MDNodePropertyAttribute.
-- 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: CMDNPRPTYATTR

CREATE VIEW C_MDNodePropertyAttribute AS
SELECT
  MasterDataNodeType,
  MasterDataNode,
  MasterDataProperty,
  MasterDataPropertyAttribute,
  cast( $session.system_language as spras ) AS Language
FROM I_MDNodePropertyAttribute AS MDNPA
LEFT OUTER JOIN C_MasterDataNode AS _MasterDataNode ON MasterDataNodeType = _MasterDataNode.MasterDataNodeType AND MasterDataNode = _MasterDataNode.MasterDataNode  -- association [1..1]
;

Learn More