This is an old revision of the document!
Table of Contents
SAP - SAP Tables
The most important SAP tables (functional and technical), including:
- SAP-FI: Currency, bank data, payment methods, calendar, taxes, accounting documents,
- SAP-CO: Cost center, cost elements, profit center,
- ABAP: The Data Dictionary, User and System Administration, SAP Workflow, Number Ranges and some other SAP basis tables.
TIP: Via the SAP data model, (using transaction code SE11), the SAP table structure (list of table fields) can be viewed.
List of SAP Tables
ABAP & SAP Data Dictionary Tables
Text / Print / Spool / SAP Documentation
ALV (ABAP List Viewer) Layouts / Table Controls
User Administration / Authorizations
General ledger (=G/L) accounts
SAP-FI: Accounting documents (postings)
SAP-CO: Controlling / Cost center
| House Banks | |
| T012-T | House Banks |
| T012A / B | Allocation pmnt methods → Bank transfer |
| T012C | Terms for bank transactions |
| T012D | Parameter for DMEs and foreign PM |
| T012E | EDI-compatible house banks / PM |
| T012K | House Bank Accounts |
| T012O | ORBIAN Detail: Bank Accounts, . |
| BNKA | Bank Master |
| TIBAN | IBAN (International Bank Account Number) |
| Interests | |
| T056 | Interest settlement |
| T056G | Interest calculation rules |
| T056R | Interest reference definition |
| T056S | Interest scale interest terms |
| T056Z | Interest Rates |
| T5DCX | Calculation for Contribution Reimbursement |
| Taxes | |
| T059A/B | Type of Recipient for Vendors |
| T059C/D | . per Withholding Tax Type |
| T059E/G | Income Types |
| T059F | Formulas for Calc. Withholding Tax |
| T059K | Withholding tax code; process. key |
| T059P/Z | Withholding tax types / tax code; enhanced |
| T007A/S | Tax Keys |
| T007B | Tax Processing in Accounting |
| Payment (= pmnt) Methods | |
| T042 | Parameters for payment transactions |
| T042A | Bank selection for payment program |
| T042B | Details on the company codes that pay |
| T042C | Technical Settings: payment program |
| T042D | Available amounts for payment program |
| T042E | Company code-specific: payment methods |
| T042F / H | Payment method supplements |
| T042G | Groups of company codes (payment program) |
| T042I | Account determination for payment program |
| T042J | Bank charges determination |
| T042K | Accounts for bank charges |
| T042N / L | Bank transaction codes |
| T042S | Charges/expenses for automatic pmnt transactions |
| T042V | Value date for automatic payments |
| T042W | Permitted currency keys for payment method |
| T042Z | Payment method for automatic payment |
| T008 | Blocking reasons for automatic pmnt transactions |
| Tolerance Groups (TG) | |
| T043-T | Assign Accounting Clerks > Tolerance Groups |
| T043G-T | TG of Customers / Vendors |
| T043I | TG for persons proc. Inventory Differences |
| T043K | Control of Payment Notices to C/V |
| T043S-T | Tolerances for Groups of G/L Accounts |
| T043U | Negative grace period |
| Enterprise structure / SAP FI Basis Customizing | |
| T000/1 | Clients / Company Codes (= CC) |
| T880 | Global Company Data |
| T003-T | Document Types |
| T004 | Directory of Charts of Accounts |
| T077S | G/L account groups |
| T009 | Fiscal Year Variants |
| T014 | Credit control areas |
| T010O/P | Posting period variant |
| T001B | Permitted Posting Periods |
| T002 | Language Keys |
| T005-T | Countries |
| T006 | Units of Measurement |
| TGSB-T | Business Areas |
Tips & Tricks - SAP Tables
Download SAP Tables Cheat Sheet - as PDF
Please be invited to use this list and/or leave some suggestions for enhancement. However, out of experience, allow me to make one stipulation: although this cheat sheet is freely available, please refrain from uploading it to other servers.
The list starts with the most useful tables and the items are categorized: ABAP, Data Dictionary, FI, CO, Spool, Cost Center, Vendors (Creditor), Customers (Debitor), Banks, Taxes, Clients, Accounting, Payment methods etc.).
Below is a screenshot of the pdf, to show an overview of the structure (the list contains both customizing and operational tables):
Please feel free to download the corresponding 2 page cheat sheet » List of important SAP Tables as PDF (approx. 100 KB).
Table-Types
There are 4 Table-Types within the SAP System:
- Tables which have technical control functions within the SAP system. They are maintained either by SAP or by users with special authorization.
- Other tables contain basic commercial data (bank data, currency …).
- Tables for the organization of a company (company codes, customer data …).
- And last but not least there are tables for application data, which contain business transactions and master data and are processed using SAP programs.
An overview of the most important SAP Tables for all these categories, as well as the necessary SAP Transaction Codes - Tips & Tricks to maintain them, are provided on the linked pages.
The work-life-balance: Klingon Programmers with more global approach and a variety of international team members.
Specifying and developing software is more often than not (and despite all efforts to regulate it), a process, which easily gets out of control, see If Architects Had To Work Like Programmers — and be aware of the subtle differences.
NOTE: The usual SAP terminology create, read, update and delete (CRUD) is abbreviated here as referred to as change or maintain.