CompaniesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - CompaniesMD
Overview
This view provides a comprehensive overview of company code-related information in SAP systems. It includes key details 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 company code-related data
- Integrating with other SAP modules and systems
Query Logic
The view is a simple projection of the t001 table, which contains company code-related information.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FB03 | Display Document |
| FBL3N | Line Item Display |
| FS00 | Create Company Code |
| OB62 | Define Number Ranges for Company Code |
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 |