CostCenterAmountsHierarchy_SAMPLE
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - CostCenterAmountsHierarchy_SAMPLE
Overview
This reporting view provides a hierarchical view of cost centers and their associated accounting documents. It combines data from the SAP tables csks_hier, setheadert, CostCentersMD, and AccountingDocuments to create a comprehensive view of cost center hierarchy, descriptions, and financial transactions.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_src }}.{{ dataset_reporting_tgt }}.csks_hier |
SAP table containing the cost center hierarchy. |
{{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.setheadert |
SAP table containing the cost center hierarchy descriptions. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CostCentersMD |
SAP table containing the cost center master data. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.AccountingDocuments |
SAP table containing the accounting documents. |
Key Use Cases
- Analyzing cost center hierarchy and relationships.
- Reporting on cost center descriptions and financial transactions.
- Identifying cost centers with high or low financial activity.
Query Logic
The query joins the four source tables using the mandt, kostl, child_org, child, setname, and langu fields to create a hierarchical view of cost centers and their associated data. The {{ language }} parameter is used to filter the results based on the specified language.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| KS03 | Display Cost Center Hierarchy |
| KA03 | Display Cost Center Master Data |
| FBL3N | Display Line Items |
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 | |
| CostCenter_KOSTL | Cost center code | |
| Description_LTEXT | Description of the cost center | |
| AmountInLocalCurrency_DMBTR | Amount in local currency | |
| AmountInDocumentCurrency_WRBTR | Amount in document currency |