I_FinancialStatementItem

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_FinancialStatementItem.
-- 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: IFIFSITM

CREATE VIEW I_FinancialStatementItem AS
SELECT
  fagl_011pc.versn AS FinancialStatementVariant,
  id AS HierarchyNode,
  type AS NodeType,
  ergsl AS FinancialStatementItem,
  parent AS ParentNode,
  child AS ChildNode,
  nextn AS SiblingNode,
  stufe AS FinStatementHierarchyLevelVal,
  aedat AS LastChangeDate,
  usnam AS ResponsiblePerson,
  fagl_011vc.ergs2 AS OffsettingItem
FROM fagl_011pc
LEFT OUTER JOIN fagl_011vc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialStatementItemText AS _Text ON FinancialStatementVariant = _Text.FinancialStatementVariant AND FinancialStatementItem = _Text.FinancialStatementItem  -- association [0..*]
LEFT OUTER JOIN I_FinancialStatementItem AS _OffsettingItem ON FinancialStatementVariant = _OffsettingItem.FinancialStatementVariant AND OffsettingItem = _OffsettingItem.FinancialStatementItem  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementItem AS _ParentItem ON FinancialStatementVariant = _ParentItem.FinancialStatementVariant AND ParentNode = _ParentItem.HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementVersion AS _FinancialStatementVersion ON FinancialStatementVariant = _FinancialStatementVersion.FinancialStatementVariant  -- association [0..1]
;