config/ecc/annotations/profitcenter_flattened.yaml

name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.profitcenter_flattened"
description: "This table gives detailed information about the profit center hierarchy structure at the granularity of Client (System), setclass, subclass, hierarchy name and node."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Finance"
fields:
  - name: "mandt"
    description: "Client (Mandant), PK"
  - name: "setclass"
    description: "Set class, PK"
  - name: "subclass"
    description: "Organizational unit as set subclass, PK"
  - name: "hiername"
    description: "Hierarchy Name, PK"
  - name: "node"
    description: "Node Id (Includes both Hierarchy Node and profit centers), PK"
  - name: "parent"
    description: "Parent Node ID"
  - name: "level"
    description: "The Level at which a Particular Node exists. Note that Level 1 is root and Level 0 indicates leaf node."
  - name: "isleafnode"
    description: "Indicator: The leaf node in the Profit Center Hierarchy"