What is I_Nodevh in SAP S/4HANA?

I_Nodevh is a composite CDS view in SAP S/4HANA. Node Name Value Help It contains 8 fields.

What VDM layer is I_Nodevh?

I_Nodevh is classified as a Composite view that combines data from multiple basic views.

I_Nodevh

DDL: I_NODEVH SQL: INODEVH Type: view COMPOSITE

8 Fields 4 Associations

Node Name Value Help

I_Nodevh is a Composite CDS View that provides data about "Node Name Value Help" in SAP S/4HANA. It has 4 associations to related views.

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_NodeText	_NodeText	`$projection.ProductStructureNodeUUID = _NodeText.ProductStructureNodeUUID`
[0..1]	I_LogAccMObjectTypeActive	_LogAccMObjectTypeActive	`_LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPF' or _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPI'`
[0..*]	I_LogAccMObjSecureIDAssgmt	_LogAccMObjSecureIDAssgmt	`$projection.ProductStructureNodeUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID and ( _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPF' or _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPI' )`
[0..*]	I_LogAccMObjectUserAuthzn	_LogAccMObjectUserAuthzn	$projection.ProductStructureNodeUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID and ( _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPF' or _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPI' ) and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPF' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPI' ) and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' and ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user or _LogAccMObjectUserAuthzn.UserID = $session.user )

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	INODEVH	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	I_ProductStructureNodeVH	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.serviceQuality	#C	view
EndUserText.label	Node Name Value Help	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (8)

Key	Field	Source Table	Source Field
KEY	ProductStructureNodeUUID		ProductStructureNodeUUID
	ProductStructureNodeUniqueID		ProductStructureNodeUniqueID
	ProductStructureNodeName		ProductStructureNodeName
	ProductStructureNodeType		ProductStructureNodeType
	ProdStrucNodeDescription	_NodeText	ProdStrucNodeDescription
	_LogAccMObjectTypeActive		_LogAccMObjectTypeActive
	_LogAccMObjSecureIDAssgmt		_LogAccMObjSecureIDAssgmt
	_LogAccMObjectUserAuthzn		_LogAccMObjectUserAuthzn

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 I_Nodevh.
-- 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: INODEVH

CREATE VIEW I_Nodevh AS
SELECT
  ProductStructureNodeUUID,
  ProductStructureNodeUniqueID,
  ProductStructureNodeName,
  ProductStructureNodeType,
  _NodeText.ProdStrucNodeDescription AS ProdStrucNodeDescription
LEFT OUTER JOIN I_NodeText AS _NodeText ON ProductStructureNodeUUID = _NodeText.ProductStructureNodeUUID  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPF' OR _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPI'  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON ProductStructureNodeUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND ( _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPF' OR _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPI' )  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON ProductStructureNodeUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID AND ( _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPF' OR _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPI' ) AND ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPF' OR _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPI' ) AND ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' OR _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user OR _LogAccMObjectUserAuthzn.UserID = $session.user )  -- association [0..*]
;

Depth:

I_Nodevh view