Wiki

User Tools

Site Tools

Trace: • anonymous_bridges
sap:sap_tables

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
sap:sap_tables [2021/08/11 12:34] – petersap:sap_tables [2021/08/11 12:48] (current) – peter
Line 1: Line 1:
 ====== SAP - SAP Tables ====== ====== 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: 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: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: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: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:SAP-CO: Controlling / Cost center|SAP-CO: Controlling / Cost center]] +
- +
-[[SAP:SAP Tables:SAP Business Address Services|SAP Business Address Services]] +
- +
-[[SAP:SAP Tables:SAP Basis Administration|SAP Basis Administration]] +
- +
-[[SAP:SAP Tables:Transport Requests|Transport Requests]] +
- +
-[[SAP:SAP Tables:Variants (Reports & Jobs)|Variants (Reports & Jobs)]] +
- +
-[[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:General Ledger (=G/L) accounts|General Ledger (=G/L) accounts]]
  
 [[SAP:SAP Tables:House Banks|House Banks]] [[SAP:SAP Tables:House Banks|House Banks]]
Line 55: Line 41:
 [[SAP:SAP Tables:Interest|Interest]] [[SAP:SAP Tables:Interest|Interest]]
  
-[[SAP:SAP Tables:Tax|Tax]]+[[SAP:SAP Tables:Number Ranges|Number Ranges]] 
 + 
 +[[SAP:SAP Tables:Orders (Cost Accounting)|Orders (Cost Accounting)]]
  
 [[SAP:SAP Tables:Payment (= pmnt)|Payment (= pmnt)]] [[SAP:SAP Tables:Payment (= pmnt)|Payment (= pmnt)]]
  
-|Payment (= pmnt) Methods|| +[[SAP:SAP Tables:Tax|Tax]]
-|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:Text / Print / Spool / SAP Documentation|Text / Print / Spool / SAP Documentation]]
  
-===== Tips & Tricks - SAP Tables =====+[[SAP:SAP Tables:Tolerance Groups (TG)|Tolerance Groups (TG)]]
  
-==== Download SAP Tables Cheat Sheet - as PDF ====+[[SAP:SAP Tables:Transport Requests|Transport Requests]]
  
-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:User Administration / Authorizations|User Administration / Authorizations]]
  
-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:Variants (Reports & Jobs)|Variants (Reports & Jobs)]]
  
-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:Vendor / Debtor|Vendor / Debtor]]
  
-{{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)]]
  
-==== Table-Types ====+[[SAP:SAP Tables:SAP-CO: Controlling / Cost center|SAP-CO: Controlling / Cost center]]
  
-There are 4 Table-Types within the SAP System:+[[SAP:SAP Tables:SAP Basis Administration|SAP Basis Administration]]
  
-  - 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 Office / Workflow|SAP Office / Workflow]]
-  - 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.+[[SAP:SAP Tables:SAP Tables - Without Category|SAP Tables - Without Category]]
  
-  
- 
-  
  
 ---- ----
- 
-  
- 
-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> <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> </WRAP>
    
  
sap/sap_tables.1628685273.txt.gz · Last modified: 2021/08/11 12:34 by peter
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki