GLAccountsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - GLAccountsMD
Overview
This reporting view combines data from the SKA1 and SKAT tables in the SAP ECC system to provide a comprehensive view of GL accounts. It includes key information such as account number, account type, balance sheet indicator, and account status.
Data Sources
| Source Table/View | Description |
|---|---|
| SKA1 | General Ledger Account Master Data |
| SKAT | General Ledger Account Texts |
Key Use Cases
- Financial reporting and analysis
- Account reconciliation
- Chart of accounts management
- Data migration and integration
Query Logic
The view joins the SKA1 and SKAT tables on the MANDT, KTOPL, and SAKNR fields to combine account master data with account texts. It includes all relevant fields from both tables to provide a comprehensive view of GL accounts.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FS00 | Create/Change G/L Account |
| FS10N | Display G/L Account Master Data |
| FBL3N | G/L Account Line Item Display |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| ChartOfAccounts_KTOPL | Chart of Accounts | |
| GlAccountNumber_SAKNR | GL Account Number | |
| Indicator_AccountIsABalanceSheetAccount_XBILK | Indicator: Account is a Balance Sheet Account | |
| GlAccountNumber_SignificantLength_SAKAN | GL Account Number Significant Length | |
| GroupAccountNumber_BILKT | Group Account Number | |
| DateOnWhichTheRecordWasCreated_ERDAT | Date on which the record was created | |
| NameOfPersonWhoCreatedTheObject_ERNAM | Name of person who created the object | |
| PlStatementAccountType_GVTYP | P&L Statement Account Type | |
| GlAccountGroup_KTOKS | GL Account Group | |
| NumberOfTheSampleAccount_MUSTR | Number of the Sample Account | |
| CompanyIdOfTradingPartner_VBUND | Company ID of Trading Partner | |
| Indicator_AccountMarkedForDeletion_XLOEV | Indicator: Account Marked for Deletion | |
| Indicator_AccountIsBlockedForCreation_XSPEA | Indicator: Account is Blocked for Creation | |
| Indicator_IsAccountBlockedForPosting_XSPEB | Indicator: Is Account Blocked for Posting | |
| Indicator_AccountBlockedForPlanning_XSPEP | Indicator: Account Blocked for Planning | |
| SearchTermForUsingMatchcode_MCOD1 | Search Term for Using Matchcode | |
| FunctionalArea_FUNC_AREA | Functional Area | |
| Language_SPRAS | Language | |
| GlAccountShortText_TXT20 | GL Account Short Text | |
| GlAccountLongText_TXT50 | GL Account Long Text | |
| SearchTermForMatchcodeSearch_MCOD1 | Search Term for Matchcode Search |