SalesOrganizationsMD

Source SQL File - Google Cloud Cortex Data Foundation

Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesOrganizationsMD

Overview

This reporting view provides a consolidated view of sales organization data from SAP systems. It combines information from the TVKO, T001, and TVKOT tables to provide insights into sales organization structure, currency, customer relationships, and company details.

Data Sources

Source Table/View	Description
TVKO	Sales Organization Header Data
T001	Company Code Data
TVKOT	Sales Organization Texts

Key Use Cases

Analyzing sales organization structure and hierarchy
Understanding sales organization currency and customer relationships
Gaining insights into company details and fiscal year variants
Reporting on sales organization performance and trends

Query Logic

The query joins the TVKO, T001, and TVKOT tables on the MANDT and VKORG fields to retrieve relevant data. It includes fields such as sales organization client, sales organization, sales organization currency, sales organization customer, company code, country, company currency, fiscal year variant, company name, sales organization name, and language.

Possible relation with SAP Transactions

Transaction Code	Transaction Description
XD01	Create Customer Master Data
VK11	Create Sales Organization
OB08	Maintain Company Code Currency
OB62	Maintain Fiscal Year Variant

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