GLAccountsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - GLAccountsMD
Overview
This reporting view provides a comprehensive overview of SAP system's general ledger accounts. It combines data from the SKA1 and SKAT tables to provide key information about each account, including its chart of accounts, account number, balance sheet indicator, significant length, group account number, creation date, creator name, account type, account group, sample account number, trading partner company ID, deletion indicator, creation block indicator, posting block indicator, planning block indicator, matchcode search term, functional area, language, short text, long text, and matchcode search term.
Data Sources
| Source Table/View | Description |
|---|---|
| SKA1 | General Ledger Account Master Data |
| SKAT | General Ledger Account Texts |
Key Use Cases
- Analyzing general ledger account data
- Reporting on account balances and transactions
- Identifying accounts for reconciliation and analysis
- Understanding account relationships and hierarchies
- Customizing and extending SAP reporting capabilities
Query Logic
The view joins the SKA1 and SKAT tables on the MANDT, KTOPL, and SAKNR fields to combine account master data with account text data. The resulting view provides a comprehensive dataset for reporting and analysis of general ledger accounts.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FS00 | Create G/L Account |
| FS01 | Change G/L Account |
| FS02 | Display G/L Account |
| FS03 | Delete G/L Account |
| FBL3N | G/L Account Line Item Display |
| FBL5N | G/L Account Balance 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 |