ProfitCenterAmountsHierarchy_SAMPLE
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - 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 |
Flattened cost center hierarchy |
{{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.setheadert |
Set header table containing cost center descriptions |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.ProfitCentersMD |
Master data for profit centers |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.AccountingDocuments |
Accounting document details |
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 with specific descriptions or profit center assignments
Query Logic
The view joins the flattened cost center hierarchy with the set header table to obtain descriptions, then joins with the profit center master data and accounting document tables to enrich the data with profit center details and accounting information. The query filters for English descriptions and a specific set class to ensure relevance.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| KE30 | Maintain Cost Center Hierarchy |
| KS03 | Display Cost Center |
| 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 |