List of All Tables in SAP (2023)

Posted by previous_toolbox_user 2011-01-07T07:55:00Z


From where can I get the list of tables exist in SAP for all the modules? Are there any like SE11 which will list down all SAP tables that exist with structure?

List of All Tables in SAP (2)


(Video) Table to find the list of tables in SAP || How to find the list of all SAP tables in SAP

3 Replies


(Video) SAP SD | Tables in Sales and Distribution | All Tables

This topic has been locked by an administrator and is no longer open for commenting.

To continue this discussion, please ask a new question.


How many SAP tables are there? ›

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.

Where can I see tables in SAP? ›

Tables can be displayed and edited using transactions SM30 and SM31. Maintenance dialogs can be used in "View Cluster Maintenance" (transaction SM34).

How do I find table names in SAP? ›

Go to SE11 T-code enter the structure name click on display, set the cursor on the structure name and then click on where used list , a list will come where u can search(Program,TAble etc) then execute.

How do I find all Z tables in SAP? ›

In transaction SE11, in database table write Z* and press F4, you can find all the ZTABLES existing.

What are the 25 modules in SAP? ›

Functional SAP ERP Modules:
  • Human Resource Management (SAP HRM), also known as Human Resource (HR)
  • Production Planning (SAP PP)
  • Material Management (SAP MM)
  • Financial Supply Chain Management (SAP FSCM)
  • Sales and Distribution (SAP SD)
  • Project System (SAP PS)
  • Financial Accounting and Controlling (SAP FICO)

How do I find Top 20 tables in SAP? ›

First of all, login to your the target SAP system and launch SAP transaction DB02. On the left pane for SAP HANA Database Administration, double click on Large Tables under System Information node.

How can I get a list of all tables? ›

How to display all the tables from a database in SQL
  2. -- This returns all the tables in the database system. ...
  3. -- Lists all the tables in all databases SELECT table_name FROM information_schema.

How can I see all tables in user? ›

SELECT table_name FROM user_tables; This query returns the following list of tables that contain all the tables owned by the user in the entire database.

What is the TCode for table in SAP? ›

Go to Transaction Code ST05 and activate Trace for your SAP User Id. Now suppose the requirement is to get the Table that stores the Field of all Standard Tables.

What are the tables in SAP? ›

Tables in SAP are a storage space in SAP Database that segments and stores data module-wise. Say, for example, we enter any data like Configuration Data, Master data, and Transaction data. Here SAP Tables in SAP FICO store them properly and in order in the SAP Database.

What is DD03L? ›

DD03L is a standard Activation Program, Conversion Program, DB Utility, MC, SPDD Transparent Table in SAP Basis application, which stores Table Fields data.

What is t005 table in SAP? ›

Values that are used to check entries are defined in the country key. Length of postal code or bank account number. The two-character ISO code proposed by SAP is normally used as the country key.

How do I view z table? ›

First, look at the left side column of the z-table to find the value corresponding to one decimal place of the z-score (e.g. whole number and the first digit after the decimal point). In this case it is 1.0. Then, we look up a remaining number across the table (on the top) which is 0.09 in our example.

What are z tables in SAP? ›

Any that starts with Z in SAP is customized as per the requirements and is not standard i.e. not developed by SAP. So when you say Z table the table which is customized and is not a standard table. As table is in general dealt by ABAP Developer, so Z table will also be dealt by them.

What are the 3 types of data in SAP? ›

Data types can be divided into elementary, reference, and complex types.

What are types of SAP? ›

Types of SAP modules
  • SAP financial accounting (FI)
  • SAP financial supply chain management (FSCM)
  • SAP controlling (CO)
  • SAP materials management (MM)
  • SAP sales and distribution (SD)
  • SAP logistics execution (LE)
  • SAP production planning (PP)
  • SAP quality management (QM)
1 Nov 2021

How do I find the top 10 tables in SAP? ›

It will prompt New window Memory Mgmt for table and indices. Step 2:- Put * in Object Name, Tablespace and object type . Step 3:- Click on Right Tick button Wait for some time it will display the all tables. Step 4: -Then sort on table size you will get the top 10 table.

What is SU01D TCode in SAP? ›

SU01D is a transaction code in SAP Basis application with the description — User Display. On this page, you will find similar/related TCodes to SU01D, Tables feeding data for this TCode, links to SAP documentation, Wiki and Help pages, discussion threads, and other resources.

How to check large tables in db02? ›

Go to tcode DB02OLD, click on “Detailed Analysis“, and fill the fields as follows: “Object type: TABLE” and “Size / kbyte: 1000000”.

Which command is used to list all the tables? ›

Now use the MySQL SHOW TABLES command to list the tables in the chosen database. mysql> SHOW TABLES; This command returns a list of all the tables in the chosen database.

How do I get a list of tables in a query? ›

The easiest way to find all tables in SQL is to query the INFORMATION_SCHEMA views. You do this by specifying the information schema, then the “tables” view. Here's an example. SELECT table_name, table_schema, table_type FROM information_schema.

How do I generate a list of tables automatically? ›

Automatic Lists of Figures, Tables and Equations

Place your cursor where you want your list to be. On the References Ribbon, in the Captions Group, click the Insert Table of Figures icon (even for lists of tables and equations).

Which view will list all tables in the database? ›

ALL_TABLES describes the relational tables accessible to the current user. To gather statistics for this view, use the ANALYZE SQL statement. DBA_TABLES describes all relational tables in the database. USER_TABLES describes the relational tables owned by the current user.

How do I get a list of tables in SAP HANA? ›

When you add a HANA system in HANA Studio, you can see different tabs under system pane. Each pane has different object types of HANA system. To see the list of all schema and tables, you need to navigate to Catalog tab.

What is a list of tables in a report? ›

What is a list of figures and tables? A list of figures and tables compiles all of the figures and tables that you used in your thesis or dissertation and displays them with the page number where they can be found.

Which table can be used to get list of users in SAP? ›

For example, if you want to retrieve the SAP username, use the table ADRP.

How do I highlight all tables? ›

You can also click anywhere in the table, and then press CTRL+A to select the table data in the entire table, or you can click the top-left most cell in the table, and then press CTRL+SHIFT+END. Press CTRL+A twice to select the entire table, including the table headers.

How do you find all tables used in a stored procedure? ›

Using below mentioned important T-SQL query, we can get the list of the tables used in the stored procedure.
  1. SELECT.
  2. NAME as 'List Of Tables'
  7. WHERE SO. NAME = 'Sp_ListTables' —-name of stored procedures.
  8. AND SD.ID = SO.ID.

What is Fb03 in SAP? ›

Business process– Fb03 is used to display a document. It is one of the most commonly used transaction codes. FB03 is used to display finance documents only. Suggestion– Add this tcode to your favorites. Menu Path- Accounting-Financial Accounting-General Ledger-Document-Fb03 Document Display.

What is SE16 table in SAP? ›

SE16 allows you to view data stored in different fields in tables. SE16 is a data browser, and it is used to view the contents of the table, and we cannot change or append new fields to the existing structure of the table as we cannot see the structure level display using the SE16. SE16 is a standard SAP transaction.

What is OB08 TCode in SAP? ›

OB08 is a transaction code in SAP Basis application with the description — C FI Maintain table TCURR. On this page, you will find similar/related TCodes to OB08, Tables feeding data for this TCode, links to SAP documentation, Wiki and Help pages, discussion threads, and other resources.

What are the 3 types of tables? ›

The most common types are work tables, dining room tables, living room or bedroom tables, office tables, gaming tables, and decorative or pedestal tables.

How many types of tables are there? ›

There are 34 distinct types of tables.

How do I search a table in SAP? ›

There are different methods to find the tables like F4 Help in SE11,SE12 SE16, SE16H and SE16N etc… with relevant term in tables name or description.

What is T001 table in SAP? ›

T001 is a standard Financial Accounting Transparent Table in SAP FI application, which stores Company Codes data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for T001.

What is T006A table in SAP? ›

T006A (Assign Internal to Language-Dependent Unit) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue. Additionally we provide an overview of foreign key relationships, if any, that link T006A to other SAP tables.

What is AGR_1251 table in SAP? ›

AGR_1251 is a standard ABAP Authorization and Role Management Transparent Table in SAP Basis application, which stores Authorization data for the activity group data.

What is the T table? ›

Revised on October 17, 2022. Student's t table is a reference table that lists critical values of t. Student's t table is also known as the t table, t-distribution table, t-score table, t-value table, or t-test table.

What is the difference between z table and T table? ›

What's the key difference between the t- and z-distributions? The standard normal or z-distribution assumes that you know the population standard deviation. The t-distribution is based on the sample standard deviation.

Where do we use t table and z table? ›

When you know the population standard deviation you should use the z-test, when you estimate the sample standard deviation you should use the t-test. Usually, we don't have the population standard deviation, so we use the t-test.

Why are there two types of z tables? ›

Why Are There at least Two z-tables? Simply, it's to make life easier. Sometimes you'll want to know the area between the mean and some positive value. That's when you'll use the right-hand z-table.

Why z is used in SAP? ›

We recommend that you use the Z prefix when defining a name. This prefix is reserved for external use, and will not conflict with any SAP naming conventions. Using the Z prefix will also prevent any interference with standard SAP functionality or conflicts with standard SAP terminology.

Are there different types of z tables? ›

What are the Types of Z Score Table? There are two z-score tables which are: Positive Z Score Table: It means that the observed value is above the mean of total values. Negative Z Score Table: It means that the observed value is below the mean of total values.

How do I find the number of tables in SAP? ›

In your current release, you can find this by checking the total number of table in DD02L <b>MINUS</b> Number of tables in customer name space.

What are the SAP standard tables? ›

LIST of Important Tables in SAP
  • Material Management. Name Description. MARA Inventory Master. MARC Plant Data. ...
  • Purchasing. Name Description. EINA Purchasing inforecord. ...
  • Service Management. Name Description. CAUFV Service order header. ...
  • System tables. Name Description. DD02T Table texts.

How do I list all tables in a schema? ›

The easiest way to find all tables in SQL is to query the INFORMATION_SCHEMA views. You do this by specifying the information schema, then the “tables” view. Here's an example. SELECT table_name, table_schema, table_type FROM information_schema.

What are the types of SAP tables? ›

What are the different types of tables and Structures in in SAP?
  • Transparent table: There is a physical table on the database for each transparent table. ...
  • Pooled Table: ...
  • Cluster Table: ...
  • Structure: ...
  • Append Structure: ...
  • Generated view Structure:
21 Mar 2019

What are the 7 types of data? ›

And there you have the 7 Data Types.
  • Useless.
  • Nominal.
  • Binary.
  • Ordinal.
  • Count.
  • Time.
  • Interval.
29 Aug 2018

What are the 5 basic components of table? ›

Main components of table are:1:Table number 2:Title 3:Head note 4:Stub head 5:Stub entries 6:Column heading 7:Body of the table 8:Footnote 9:Source. Was this answer helpful?


1. Tips to remember and practice the Tables in SAP || SE16N || SE16 || SAP FREE Knowledge on YouTube
(Ganesh SAP MM/WM)
2. SAP SD:How to Find every Tables/Transaction Code/Function Module for Process Area?
(arghadip kar)
3. SAP: Tcode SE16N overview | Tables | FIELDS | Download Bulk Reports | Controls |Table Maintenance|
(Neutral Minds)
4. SQVI- How to list the SAP Transaction By the Module
(Selva Kumar)
(Ankur Das)
6. SAP ABAP: How to get a list of the Fields,Length and Check Table for Tables in SAP? S_PH0_48000138
(arghadip kar)
Top Articles
Latest Posts
Article information

Author: Corie Satterfield

Last Updated: 03/08/2023

Views: 5735

Rating: 4.1 / 5 (62 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Corie Satterfield

Birthday: 1992-08-19

Address: 850 Benjamin Bridge, Dickinsonchester, CO 68572-0542

Phone: +26813599986666

Job: Sales Manager

Hobby: Table tennis, Soapmaking, Flower arranging, amateur radio, Rock climbing, scrapbook, Horseback riding

Introduction: My name is Corie Satterfield, I am a fancy, perfect, spotless, quaint, fantastic, funny, lucky person who loves writing and wants to share my knowledge and understanding with you.