name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.fsv_flattened"
description: "fsv_flattened gives detailed information about the FSV hierarchy structure, providing mappings for GL accounts and nodes with their parent nodes, along with other details like their node values, levels, etc. at the granularity of Client(System), chart of accounts, hierarchy name and node."
fields:
  - name: "mandt"
    description: "Client (Mandant), PK"
  - name: "chartofaccounts"
    description: "Chart of Accounts, PK"
  - name: "hiername"
    description: "Hierarchy Name, PK"
  - name: "hierarchyversion"
    description: "Hierarchy Version, PK"
  - name: "parent"
    description: "Hierarchy Parent Node"
  - name: "node"
    description: "Node Id (Includes both Hierarchy Node and GL Accounts), PK"
  - name: "nodevalue"
    description: "Financial Statement Item"
  - name: "level"
    description: "Describes the Level at which a Particular Node exists(Level 1 is root)"
  - name: "isleafnode"
    description: "Indicator: The last node in the FSV Hierarchy"
