Differences

This shows you the differences between two versions of the page.

--- sap:sap_tables [2021/08/11 12:36] – peter
+++ sap:sap_tables [2021/08/11 12:48] (current) – peter
@@ Line 1: / Line 1: @@
 ====== SAP - SAP Tables ======
+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 ...).
+  * Tables for application data, which contain business transactions and master data and are processed using SAP programs.
 The most important SAP tables (functional and technical), including:
@@ Line 17: / Line 25: @@
 [[SAP:SAP Tables:ABAP & SAP Data Dictionary Tables|ABAP & SAP Data Dictionary Tables]]
-[[SAP:SAP Tables:Text / Print / Spool / SAP Documentation|Text / Print / Spool / SAP Documentation]]
+[[SAP:SAP Tables:Address|Address]]
-[[SAP:SAP Tables:Number ranges|Number ranges]]
 [[SAP:SAP Tables:ALV (ABAP List Viewer) Layouts / Table Controls|ALV (ABAP List Viewer) Layouts / Table Controls]]
-[[SAP:SAP Tables:User Administration / Authorizations|User Administration / Authorizations]]
+[[SAP:SAP Tables:Calendar|Calendar]]
-[[SAP:SAP Tables:General ledger (=G/L) accounts|General ledger (=G/L) accounts]]
-[[SAP:SAP Tables:Orders (Cost Accounting)|Orders (Cost Accounting)]]
 [[SAP:SAP Tables:Customer / Creditor|Customer / Creditor]]
-[[SAP:SAP Tables:Vendor / Debtor|Vendor / Debtor]]
+[[SAP:SAP Tables:Enterprise structure / SAP FI Basis Customizing|Enterprise structure / SAP FI Basis Customizing]]
-[[SAP:SAP Tables:SAP-FI: Accounting documents (postings)|SAP-FI: Accounting documents (postings)]]
+[[SAP:SAP Tables:General Ledger (=G/L) accounts|General Ledger (=G/L) accounts]]
-[[SAP:SAP Tables:SAP-CO: Controlling / Cost center|SAP-CO: Controlling / Cost center]]
+[[SAP:SAP Tables:House Banks|House Banks]]
-[[SAP:SAP Tables:SAP Business Address Services|SAP Business Address Services]]
+[[SAP:SAP Tables:Interest|Interest]]
-[[SAP:SAP Tables:SAP Basis Administration|SAP Basis Administration]]
+[[SAP:SAP Tables:Number Ranges|Number Ranges]]
-[[SAP:SAP Tables:Transport Requests|Transport Requests]]
+[[SAP:SAP Tables:Orders (Cost Accounting)|Orders (Cost Accounting)]]
-[[SAP:SAP Tables:Variants (Reports & Jobs)|Variants (Reports & Jobs)]]
+[[SAP:SAP Tables:Payment (= pmnt)|Payment (= pmnt)]]
-[[SAP:SAP Tables:SAP Office / Workflow|SAP Office / Workflow]]
-[[SAP:SAP Tables:SAP Tables - Without Category|SAP Tables - Without Category]]
-[[SAP:SAP Tables:Calendar Functions|Calendar Functions]]
-[[SAP:SAP Tables:House Banks|House Banks]]
-[[SAP:SAP Tables:Interest|Interest]]
 [[SAP:SAP Tables:Tax|Tax]]
-[[SAP:SAP Tables:Payment (= pmnt)|Payment (= pmnt)]]
+[[SAP:SAP Tables:Text / Print / Spool / SAP Documentation|Text / Print / Spool / SAP Documentation]]
 [[SAP:SAP Tables:Tolerance Groups (TG)|Tolerance Groups (TG)]]
-|Enterprise structure / SAP FI Basis Customizing||
+[[SAP:SAP Tables:Transport Requests|Transport Requests]]
-|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|
+[[SAP:SAP Tables:User Administration / Authorizations|User Administration / Authorizations]]
-===== Tips & Tricks - SAP Tables =====
+[[SAP:SAP Tables:Variants (Reports & Jobs)|Variants (Reports & Jobs)]]
-==== Download SAP Tables Cheat Sheet - as PDF ====
+[[SAP:SAP Tables:Vendor / Debtor|Vendor / Debtor]]
-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.).
+[[SAP:SAP Tables:SAP-FI: Accounting documents (postings)|SAP-FI: Accounting documents (postings)]]
-Below is a screenshot of the pdf, to show an overview of the structure (the list contains both customizing and operational tables):
+[[SAP:SAP Tables:SAP-CO: Controlling / Cost center|SAP-CO: Controlling / Cost center]]
-{{tables-fi-co.jpg|SAP - Overview of SAP Tables (Basis, SAP-FI, SAP-CO}}Please feel free to download the corresponding 2 page cheat sheet » [[tables-list|List of important SAP Tables]] as PDF (approx. 100 KB).
+[[SAP:SAP Tables:SAP Basis Administration|SAP Basis Administration]]
+[[SAP:SAP Tables:SAP Office / Workflow|SAP Office / Workflow]]
-==== Table-Types ====
+[[SAP:SAP Tables:SAP Tables - Without Category|SAP Tables - Without Category]]
-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 [[transaction-codes|SAP Transaction Codes - Tips & Tricks]] to maintain them, are provided on the linked pages.
 ----
-The work-life-balance: [[http://www.smart-jokes.org/klingon-software.html|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 [[http://www.smart-jokes.org/if-architects-had-to-work-like-programmers.html|If Architects Had To Work Like Programmers]] — and be aware of the subtle differences.
 <WRAP info>
-**NOTE:**  The usual SAP terminology create, read, update and delete (CRUD) is abbreviated here as referred to as change or maintain.
+**NOTE:**  The usual SAP terminology Create, Read, Update and Delete (CRUD) is abbreviated here and referred to as change or maintain.
 </WRAP>