RegionsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - RegionsMD
Overview
This reporting view provides data from the SAP table T005S, which contains information about countries, regions, provincial tax codes, and states of manufacture.
Data Sources
| Source Table/View | Description |
|---|---|
| T005S | SAP table containing country, region, provincial tax code, and state of manufacture data. |
Key Use Cases
- Retrieving country-specific information for reporting and analysis.
- Identifying regions and provincial tax codes for tax calculations.
- Determining the state of manufacture for products.
Query Logic
The query simply selects all columns from the T005S table, providing a straightforward way to access the data.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| CountryKey_LAND1 | Country Key | |
| Region_BLAND | Region | |
| ProvincialTaxCode_FPRCD | Provincial Tax Code | |
| StateOfManufacture_HERBL | State of Manufacture |