I_IncgFrmtCustNode

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_IncgFrmtCustNode.
-- 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.

CREATE VIEW I_IncgFrmtCustNode AS
SELECT
  HierarchyTreeType,
  HierarchyTree,
  HierarchyTreeVersion,
  ItemType,
  HierarchyNode,
  cast(hierarchynodestatus as ifme_hierarchynodestatus preserving type) AS HierarchyNodeStatus,
  HierarchyNodeShortText,
  ParentNode,
  SiblingNode,
  ChildNode,
  NodeName,
  cast(nodetype as ifme_nodetype preserving type) AS NodeType,
  HierarchyNodeIsDeactivated,
  IsObligatory,
  ConditionText,
  HierarchyNodeDetailedText
FROM ifmcnode
LEFT OUTER JOIN I_IncgFrmtCustNodeField AS _NodeField ON _NodeField.HierarchyTreeType = HierarchyTreeType AND _NodeField.HierarchyTree = HierarchyTree AND _NodeField.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeField.ItemType = ItemType AND _NodeField.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeFieldGroup AS _NodeFieldGroup ON _NodeFieldGroup.HierarchyTreeType = HierarchyTreeType AND _NodeFieldGroup.HierarchyTree = HierarchyTree AND _NodeFieldGroup.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeFieldGroup.ItemType = ItemType AND _NodeFieldGroup.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeRecord AS _NodeRecord ON _NodeRecord.HierarchyTreeType = HierarchyTreeType AND _NodeRecord.HierarchyTree = HierarchyTree AND _NodeRecord.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeRecord.ItemType = ItemType AND _NodeRecord.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeRecordGrp AS _NodeRecordGrp ON _NodeRecordGrp.HierarchyTreeType = HierarchyTreeType AND _NodeRecordGrp.HierarchyTree = HierarchyTree AND _NodeRecordGrp.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeRecordGrp.ItemType = ItemType AND _NodeRecordGrp.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeActn AS _NodeAction ON _NodeAction.HierarchyTreeType = HierarchyTreeType AND _NodeAction.HierarchyTree = HierarchyTree AND _NodeAction.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeAction.ItemType = ItemType AND _NodeAction.HierarchyNode = HierarchyNode  -- association [0..*]
LEFT OUTER JOIN I_IncgFrmtCustNodeElement AS _NodeElement ON _NodeElement.HierarchyTreeType = HierarchyTreeType AND _NodeElement.HierarchyTree = HierarchyTree AND _NodeElement.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeElement.ItemType = ItemType AND _NodeElement.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeAttribute AS _NodeAttribute ON _NodeAttribute.HierarchyTreeType = HierarchyTreeType AND _NodeAttribute.HierarchyTree = HierarchyTree AND _NodeAttribute.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeAttribute.ItemType = ItemType AND _NodeAttribute.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeChoice AS _NodeChoice ON _NodeChoice.HierarchyTreeType = HierarchyTreeType AND _NodeChoice.HierarchyTree = HierarchyTree AND _NodeChoice.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeChoice.ItemType = ItemType AND _NodeChoice.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeSequence AS _NodeSequence ON _NodeSequence.HierarchyTreeType = HierarchyTreeType AND _NodeSequence.HierarchyTree = HierarchyTree AND _NodeSequence.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeSequence.ItemType = ItemType AND _NodeSequence.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_IncgFrmtCustNodeRstrcn AS _NodeRestriction ON _NodeRestriction.HierarchyTreeType = HierarchyTreeType AND _NodeRestriction.HierarchyTree = HierarchyTree AND _NodeRestriction.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeRestriction.ItemType = ItemType AND _NodeRestriction.HierarchyNode = HierarchyNode  -- association [0..1]
;