DivisionsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - DivisionsMD
Overview
This reporting view provides a list of divisions and their corresponding names in different languages.
Data Sources
| Source Table/View | Description |
|---|---|
| tspa | SAP table containing division information |
| tspat | SAP table containing division names in different languages |
Key Use Cases
- Retrieve division names for a specific client and language
- Generate reports on divisions and their names
Query Logic
The query joins the tspa and tspat tables on the MANDT and SPART fields to retrieve division names for a specific client and language.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| XK03 | Display Division Master Data |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| PurchasingGroup_EKGRP | Purchasing Group | |
| PurchasingGroupText_EKNAM | Purchasing Group Text |