FSVTextsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - FSVTextsMD
Overview
This reporting view provides a snapshot of the hierarchy nodes and their attributes from the SAP HR organizational structure.
Data Sources
| Source Table/View | Description |
|---|---|
| hrrp_nodet | SAP HR organizational structure hierarchy nodes table |
Key Use Cases
- Retrieving hierarchy nodes and their attributes for reporting and analysis
- Understanding the organizational structure and relationships between nodes
- Identifying changes to the organizational structure over time
Query Logic
The view selects all columns from the hrrp_nodet table, which contains information about hierarchy nodes, including their client, hierarchy ID, hierarchy version, language key, node class, hierarchy node, hierarchy parent node, validity period, and hierarchy node description.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| PPOME | Organizational Management: Edit |
| PPOCV_HIRC | Display Organizational Structure |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| HierarchyID_HRYID | Hierarchy ID | |
| HierarchyVersion_HRYVER | Hierarchy Version | |
| LanguageKey_SPRAS | Language Key | |
| NodeClass_NODECLS | Node Class | |
| HierarchyNode_HRYNODE | Hierarchy Node | |
| HierarchyParentNode_PARNODE | Hierarchy Parent Node | |
| ValidTo_HRYVALTO | Valid To | |
| ValidFrom_HRYVALFROM | Valid From | |
| HierarchyNodeDescription_NODETXT | Hierarchy Node Description |