ProfitCenterAmountsHierarchy_SAMPLE
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - ProfitCenterAmountsHierarchy_SAMPLE
Overview
This reporting view provides a hierarchical view of SAP cost centers, along with their descriptions, profit center details, and accounting document information.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_src }}.{{ dataset_reporting_tgt }}.cepc_hier |
A flattened hierarchy of cost centers. |
{{ project_id_src }}.{{ dataset_cdc_processed_s4 }}.setheadert |
Table containing hierarchy descriptions. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.ProfitCentersMD |
Table containing profit center master data. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.AccountingDocuments |
Table containing accounting document data. |
Key Use Cases
- Analyzing cost center hierarchies and their relationships.
- Reporting on profit center and accounting document data within a cost center hierarchy.
- Identifying cost centers and their descriptions for various reporting purposes.
Query Logic
The query joins the cepc_hier view with the setheadert table to obtain hierarchy descriptions. It then joins with the ProfitCentersMD and AccountingDocuments tables to retrieve profit center and accounting document data for each cost center in the hierarchy. The query filters for English descriptions and a specific hierarchy class (setclass = '0106').
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| KS03 | Display Cost Center Hierarchy |
| KA03 | Display Profit Center Master Data |
| FBL3N | Display Line Items: G/L Accounts |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| ParentHierarchy | Parent hierarchy of the cost center | |
| ChildHierarchy | Child hierarchy of the cost center | |
| Description | Description of the cost center hierarchy | |
| ProfitCenter_PRCTR | Profit center code | |
| LongText_LTEXT | Long text for the profit center | |
| AmountInLocalCurrency_DMBTR | Amount in local currency for the accounting document | |
| AmountInDocumentCurrency_WRBTR | Amount in document currency for the accounting document |