CostCenterAmountsHierarchy_SAMPLE
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - 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 data.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_src }}.{{ dataset_reporting_tgt }}.csks_hier |
SAP hierarchy table containing cost center hierarchy information. |
{{ project_id_src }}.{{ dataset_cdc_processed_s4 }}.setheadert |
SAP table containing cost center header information, including descriptions. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CostCentersMD |
Target table containing cost center master data, including descriptions in different languages. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.AccountingDocuments |
Target table containing accounting document data, including amounts in local and document currencies. |
Key Use Cases
- Analyzing cost center hierarchy and relationships.
- Reporting on cost center descriptions and financial data.
- Identifying cost centers associated with specific accounting documents.
Query Logic
The query joins the csks_hier table with the setheadert table to obtain cost center hierarchy and description information. It then joins the resulting table with the CostCentersMD table to add cost center master data, including descriptions in the specified language. Finally, it joins with the AccountingDocuments table to include accounting document data for the cost centers.
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 |