SAP-tabelreferentie
SKB1
G/L account master (company code)Bekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
SAP table SKB1 is part of the General Ledger Accounting module and stores G/L account master data specific to individual company codes. It contains information that controls how a G/L account is managed and processed within a particular company code, such as account currency, tax-related settings, reconciliation accounts, and other configuration data. This table ensures that G/L accounts are aligned with the financial requirements of each company code in SAP. More general, chart of accounts level configuration, can be found in SAP table SKA1 (G/L Account Master (Chart of Accounts)).
SAP-tabel SKB1 heeft 3 primaire sleutelvelden: MANDT,BUKRS,SAKNR.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
SKB1 velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| Sleutel BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |||||||||
| Sleutel SAKNR | G/L Account Number | CHAR | 10 | 0 | SKA1 | SAKNR | |||||||||
| BEGRU | Authorization Group | CHAR | 4 | 0 | BRGRU | ||||||||||
| BUSAB | Accounting Clerk Abbreviation | CHAR | 2 | 0 | T001S | BUSAB | |||||||||
| DATLZ | Date of Last Interest Calculation Run | DATS | 8 | 0 | DATLZ | ||||||||||
| 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 | ||||||||||
| FDGRV | Planning Group | CHAR | 10 | 0 | T035 | FDGRV | |||||||||
| FDLEV | Planning Level | CHAR | 2 | 0 | T036 | FDLEV | |||||||||
| FIPLS | Financial Budget Item | NUMC | 3 | 0 | FIPLS | ||||||||||
| FSTAG | Field status group | CHAR | 4 | 0 | T004F | FSTAG | |||||||||
| HBKID | Short Key for a House Bank | CHAR | 5 | 0 | T012 | HBKID | |||||||||
| HKTID | ID for Account Details | CHAR | 5 | 0 | T012K | HKTID | |||||||||
| KDFSL | Key for Exchange Rate Differences in Foreign Currency Accts | CHAR | 4 | 0 | T030S | KDFSL | |||||||||
| MITKZ | Account is Reconciliation Account | CHAR | 1 | 0 | MITKZ | ||||||||||
| |||||||||||||||
| MWSKZ | Tax Category in Account Master Record | CHAR | 2 | 0 | SMWSK | ||||||||||
| STEXT | G/L Account Additional Text | CHAR | 50 | 0 | STEXT_SKB1 | ||||||||||
| VZSKZ | Interest Indicator | CHAR | 2 | 0 | T056 | VZSKZ | |||||||||
| WAERS | Account Currency | CUKY | 5 | 0 | TCURC | WAERS_SKB1 | |||||||||
| WMETH | Indicator: Account Managed in External System | CHAR | 2 | 0 | WMETH | ||||||||||
| |||||||||||||||
| XGKON | Cash Receipt Account / Cash Disbursement Account | CHAR | 1 | 0 | XGKON | ||||||||||
| XINTB | Indicator: Is Account only Posted to Automatically? | CHAR | 1 | 0 | XINTB | ||||||||||
| XKRES | Indicator: Can Line Items Be Displayed by Account? | CHAR | 1 | 0 | XKRES | ||||||||||
| XLOEB | Indicator: Account Marked for Deletion? | CHAR | 1 | 0 | XLOEV | ||||||||||
| XNKON | Indicator: Supplement for Automatic Postings ? | CHAR | 1 | 0 | XNKON | ||||||||||
| XOPVW | Indicator: Open Item Management? | CHAR | 1 | 0 | XOPVW | ||||||||||
| XSPEB | Indicator: Is Account Blocked for Posting? | CHAR | 1 | 0 | XSPEB | ||||||||||
| ZINDT | Key Date of Last Interest Calculation | DATS | 8 | 0 | DZINDT | ||||||||||
| ZINRT | Interest Calculation Frequency in Months | NUMC | 2 | 0 | DZINRT | ||||||||||
| ZUAWA | Key for sorting according to assignment numbers | CHAR | 3 | 0 | TZUN | DZUAWA | |||||||||
| ALTKT | Alternative Account Number in Company Code | CHAR | 10 | 0 | ALTKT_SKB1 | ||||||||||
| XMITK | Indicator: Reconcil.Acct Ready for Input at Time of Posting? | CHAR | 1 | 0 | XMITK | ||||||||||
| RECID | Recovery Indicator | CHAR | 2 | 0 | T8JJ | JV_RECIND | |||||||||
| FIPOS | Commitment Item | CHAR | 14 | 0 | FIPOS | ||||||||||
| XMWNO | Indicator: Tax code is not a required field | CHAR | 1 | 0 | XMWNO | ||||||||||
| XSALH | Manage Balances in Local Currency Only (Indicator) | CHAR | 1 | 0 | XSALH | ||||||||||
| BEWGP | Valuation Group | CHAR | 10 | 0 | BEWGP | ||||||||||
| INFKY | Inflation Key | CHAR | 8 | 0 | J_1AINFSKS | J_1AIFSKS | |||||||||
| TOGRU | Tolerance Group for G/L Accounts | CHAR | 4 | 0 | T043S | TOGRU_S | |||||||||
| XLGCLR | Open Item Management by Ledger Group | CHAR | 1 | 0 | XLGCLR | ||||||||||
| X_UJ_CLR | Extended Open Item Management | CHAR | 1 | 0 | X_UJ_CLR | ||||||||||
| MCAKEY | MCA Key | CHAR | 5 | 0 | GLE_MCA_TMCAKEY | GLE_DTE_MCA_MCAKEY | |||||||||
| COCHANGED | Controlling area data changed | CHAR | 1 | 0 | FINS_SKB1_COCHANGED | ||||||||||
| LAST_CHANGED_TS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||||||||||
/ Relaties
SKB1 relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| SKB1 | BUKRS | T001 | Company Codes | BUKRS |
| SKB1 | BUSAB | T001S | Accounting Clerks | MANDT |
| SKB1 | BUSAB | T001S | Accounting Clerks | BUKRS |
| SKB1 | BUSAB | T001S | Accounting Clerks | BUSAB |
| SKB1 | FDGRV | T035 | Planning groups | GRUPP |
| SKB1 | FDLEV | T036 | Planning levels | EBENE |
| SKB1 | FSTAG | T004F | Field status definition groups | MANDT |
| SKB1 | FSTAG | T004F | Field status definition groups | BUKRS |
| SKB1 | HBKID | T012 | House Banks | BUKRS |
| SKB1 | HKTID | T012K | House Bank Accounts | MANDT |
| SKB1 | HKTID | T012K | House Bank Accounts | BUKRS |
| SKB1 | HKTID | T012K | House Bank Accounts | HBKID |
| SKB1 | HKTID | T012K | House Bank Accounts | HKTID |
| SKB1 | INFKY | J_1AINFSKS | Inflation Keys - G/L Account | MANDT |
| SKB1 | INFKY | J_1AINFSKS | Inflation Keys - G/L Account | LAND1 |
| SKB1 | KDFSL | T030S | Accts for Foreign Currency Assets Exchange Rate Differences | KTOPL |
| SKB1 | KDFSL | T030S | Accts for Foreign Currency Assets Exchange Rate Differences | CURTP |
| SKB1 | MCAKEY | GLE_MCA_TMCAKEY | Key for assigning MCA relevant attributs to SKB1 accounts | .INCLUDE |
| SKB1 | MCAKEY | GLE_MCA_TMCAKEY | Key for assigning MCA relevant attributs to SKB1 accounts | MANDT |
| SKB1 | RECID | T8JJ | Recovery Indicator | MANDT |
| SKB1 | RECID | T8JJ | Recovery Indicator | BUKRS |
| SKB1 | SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| SKB1 | SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| SKB1 | SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| SKB1 | TOGRU | T043S | Tolerances for Groups of G/L Accounts | MANDT |
| SKB1 | TOGRU | T043S | Tolerances for Groups of G/L Accounts | BUKRS |
| SKB1 | TOGRU | T043S | Tolerances for Groups of G/L Accounts | TOGRU |
| SKB1 | VZSKZ | T056 | Interest Indicator | MANDT |
| SKB1 | VZSKZ | T056 | Interest Indicator | VZSKZ |
| SKB1 | WAERS | TCURC | Currency Codes | MANDT |
| SKB1 | WAERS | TCURC | Currency Codes | WAERS |