CompaniesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - CompaniesMD
Overview
This reporting view provides a comprehensive overview of company code-related information in SAP systems. It includes key data such as currency code, company code, company text, city name, country, language, chart of accounts, fiscal year variant, company, credit control area, country chart of accounts, and funds management.
Data Sources
| Source Table/View | Description |
|---|---|
| t001 | Company Code Table |
Key Use Cases
- Analyzing company code-specific settings and configurations
- Reporting on financial data by company code
- Identifying company codes associated with specific business units or locations
- Performing data analysis and reconciliation across multiple company codes
Query Logic
The view selects various fields from the t001 table, which contains company code-related information in SAP systems.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FS00 | Maintain Company Code |
| OB62 | Define Number Ranges for Company Codes |
| OB63 | Define Default Values for Company Codes |
| OB64 | Define Additional Data for Company Codes |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| CurrencyCode_WAERS | Currency Code | |
| CompanyCode_BUKRS | Company Code | |
| CompanyText_BUTXT | Company Text | |
| CityName_ORT01 | City Name | |
| Country_LAND1 | Country | |
| Language_SPRAS | Language | |
| ChartOfAccounts_KTOPL | Chart Of Accounts | |
| FiscalyearVariant_PERIV | Fiscalyear Variant | |
| Company_RCOMP | Company | |
| CreditControlArea_KKBER | Credit Control Area | |
| CountryChartofAccounts_KTOP2 | Country Chartof Accounts | |
| FundsManagement_FIKRS | Funds Management |