SAP table SI_SKA1 (G/L Account Master Record (Chart of Accounts))
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BILKT | Group Account Number | CHAR | 10 | 0 | SKA1 | BILKT | |||||||||||
| ERDAT | Date on which the Record Was Created | DATS | 8 | 0 | ERDAT_RF | ||||||||||||
| ERNAM | Name of Person who Created the Object | CHAR | 12 | 0 | ERNAM_RF | ||||||||||||
| GVTYP | P&L statement account type | CHAR | 2 | 0 | GVTYP | ||||||||||||
| KTOKS | G/L Account Group | CHAR | 4 | 0 | T077S | KTOKS | |||||||||||
| MUSTR | Number of the Sample Account | CHAR | 10 | 0 | SKM1 | MUSTR | |||||||||||
| VBUND | Company ID of Trading Partner | CHAR | 6 | 0 | T880 | RASSC | |||||||||||
| XLOEV | Indicator: Account Marked for Deletion? | CHAR | 1 | 0 | XLOEV | ||||||||||||
| XSPEA | Indicator: Account Is Blocked for Creation ? | CHAR | 1 | 0 | XSPEA | ||||||||||||
| XSPEB | Indicator: Is Account Blocked for Posting? | CHAR | 1 | 0 | XSPEB | ||||||||||||
| XSPEP | Indicator: Account Blocked for Planning ? | CHAR | 1 | 0 | XSPEP | ||||||||||||
| MCOD1 | Search Term for Using Matchcode | CHAR | 25 | 0 | MCODF | ||||||||||||
| FUNC_AREA | Functional Area | CHAR | 16 | 0 | TFKB | FKBER | |||||||||||
| GLACCOUNT_TYPE | Type of a General Ledger Account | CHAR | 1 | 0 | GLACCOUNT_TYPE |
|
|||||||||||
| GLACCOUNT_SUBTYPE | Subtype of a GL Account | CHAR | 1 | 0 | FINS_GLACC_SUBTY | GLACCOUNT_SUBTYPE | |||||||||||
| MAIN_SAKNR | Bank Reconciliation Account | CHAR | 10 | 0 | SKA1 | FINS_MAIN_SAKNR | |||||||||||
| LAST_CHANGED_TS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP |
SI_SKA1 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 SI_SKA1 | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 SI_SKA1 | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 SI_SKA1 | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 SI_SKA1 | FUNC_AREA | TFKB | Functional areas | FKBER |
| 0 SI_SKA1 | GLACCOUNT_SUBTYPE | FINS_GLACC_SUBTY | GL Account Subtype | GLACCOUNT_TYPE |
| 0 SI_SKA1 | GLACCOUNT_SUBTYPE | FINS_GLACC_SUBTY | GL Account Subtype | GLACCOUNT_SUBTYPE |
| 1 SI_SKA1 | KTOKS | T077S | G/L account groups | MANDT |
| 1 SI_SKA1 | KTOKS | T077S | G/L account groups | KTOPL |
| 0 SI_SKA1 | MAIN_SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 SI_SKA1 | MAIN_SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 SI_SKA1 | MAIN_SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 SI_SKA1 | MUSTR | SKM1 | Sample G/L accounts | MANDT |
| 1 SI_SKA1 | MUSTR | SKM1 | Sample G/L accounts | KTOPL |
| 1 SI_SKA1 | MUSTR | SKM1 | Sample G/L accounts | MUSTR |
| 0 SI_SKA1 | VBUND | T880 | Global Company Data (for KONS Ledger) | MANDT |
| 0 SI_SKA1 | VBUND | T880 | Global Company Data (for KONS Ledger) | RCOMP |