C_NodeList

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_NodeList.
-- 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: CNODELIST

CREATE VIEW C_NodeList AS
SELECT
  ProductStructureNodeUUID,
  _Variant_Intf.ProductStructureVariantUUID AS ProductStructureVariantUUID,
  _Variant_Intf.ProdStrucVariantChgStateIntID AS ProdStrucVariantChgStateIntID,
  ProductStructureNodeUniqueID,
  ProductStructureNodeName,
  ClassInternalID,
  ClassType,
  Class,
  ClassName,
  _NodeGeneralData.ProductStructureNodeType AS ProductStructureNodeType,
  _NodeType.ProdStrucNodeTypeDescription AS ProdStrucNodeTypeDescription,
  ProductStructureCreationDate,
  ProductStructureCreatedByUser,
  ProductStrucLastChangedDate,
  ProductStrucLastChangedByUser,
  _NodeText.Language AS Language,
  _NodeText.ProdStrucNodeDescription AS ProdStrucNodeDescription,
  _Variant_Intf.ProductStructureVariantName AS ProductStructureVariantName,
  _Variant_Intf.ProductStructureVariantType AS ProductStructureVariantType,
  _Variant_Intf.Material AS Material,
  _Variant_Intf.MaterialName AS MaterialName,
  _Variant_Intf.ProdStrucVariantChangeNumber AS ProdStrucVariantChangeNumber,
  _Variant_Intf.ProdStrucVarChgNmbrDescription AS ProdStrucVarChgNmbrDescription
FROM I_NodeGeneralData AS _NodeGeneralData
LEFT OUTER JOIN I_NodeText AS _NodeText ON ProductStructureNodeUUID = _NodeText.ProductStructureNodeUUID  -- association [0..1]
LEFT OUTER JOIN C_NodeType AS _NodeType ON ProductStructureNodeType = _NodeType.ProductStructureNodeType  -- association [0..1]
LEFT OUTER JOIN I_Variant_Intf AS _Variant_Intf ON ProductStructureNodeUUID = _Variant_Intf.ProdStructureVariantParentUUID  -- association [0..*]
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..*]
;