Differences

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

--- sap:sap_tables [2021/08/11 12:33] – 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]]
-|Taxes||
+[[SAP:SAP Tables:Text / Print / Spool / SAP Documentation|Text / Print / Spool / SAP Documentation]]
-|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|
+[[SAP:SAP Tables:Tolerance Groups (TG)|Tolerance Groups (TG)]]
-===== Tips & Tricks - SAP Tables =====
+[[SAP:SAP Tables:Transport Requests|Transport Requests]]
-==== Download SAP Tables Cheat Sheet - as PDF ====
+[[SAP:SAP Tables:User Administration / Authorizations|User Administration / Authorizations]]
-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.
+[[SAP:SAP Tables:Variants (Reports & Jobs)|Variants (Reports & Jobs)]]
-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:Vendor / Debtor|Vendor / Debtor]]
-Below is a screenshot of the pdf, to show an overview of the structure (the list contains both customizing and operational tables):
-{{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-FI: Accounting documents (postings)|SAP-FI: Accounting documents (postings)]]
+[[SAP:SAP Tables:SAP-CO: Controlling / Cost center|SAP-CO: Controlling / Cost center]]
-==== Table-Types ====
+[[SAP:SAP Tables:SAP Basis Administration|SAP Basis Administration]]
-There are 4 Table-Types within the SAP System:
+[[SAP:SAP Tables:SAP Office / Workflow|SAP Office / Workflow]]
-  - Tables which have technical control functions within the SAP system. They are maintained either by SAP or by users with special authorization.
+[[SAP:SAP Tables:SAP Tables - Without Category|SAP Tables - Without Category]]
-  - 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>