SalesOrganizationsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesOrganizationsMD
Overview
This reporting view provides a consolidated view of sales organization data from the SAP ECC system. It combines information from the TVKO, T001, and TVKOT tables to provide a comprehensive dataset for reporting and analysis purposes.
Data Sources
| Source Table/View | Description |
|---|---|
| TVKO | Sales Order Header Table |
| T001 | Company Code Table |
| TVKOT | Sales Organization Text Table |
Key Use Cases
- Sales organization analysis
- Customer relationship management
- Financial reporting
- Data integration with other systems
Query Logic
The query joins the TVKO, T001, and TVKOT tables on the MANDT and VKORG fields to retrieve data from all three tables. The LEFT OUTER JOIN with T001 allows for the inclusion of company code-specific information, while the INNER JOIN with TVKOT ensures that only sales organizations with valid text descriptions are included in the results.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VA03 | Display Sales Order |
| FBL1N | Display Line Items: G/L Account |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| SalesOrg_VKORG | Sales Organization | |
| SalesOrgCurrency_WAERS | Sales Organization Currency | |
| SalesOrgCustomer_KUNNR | Sales Organization Customer | |
| CompanyCode_BUKRS | Company Code | |
| Country_LAND1 | Country | |
| CoCoCurrency_WAERS | Company Code Currency | |
| FiscalYrVariant_PERIV | Fiscal Year Variant | |
| Company_BUTXT | Company Name | |
| SalesOrgName_VTEXT | Sales Organization Name | |
| Language_SPRAS | Language |