Skip to Content
Author's profile photo Rohit Singh

How to find SAP tables related to a functional area (Sub Module)

We all struggle to find the correct table for a particular functionality in SAP. It’s not easy to remember all the tables pertaining to a particular module or sub module. I would rather say it is practically impossible keep track of the tables all the time.

This document will help you find all relevant SAP tables, for a particular area, in a single page.

Although, it’s not something very technical but this will help you find tables in a hassle-free way.

Let’s start with a basic concept that SAP tables are ABAP objects and they are clustered under a package. Standard tables are grouped under standard packages and Z -tables under custom packages. Once you know the package you are working on, you can easily find out all the tables under that package.

This is very much handy to functional consultant working on standard / custom object and want to find out all relevant tables in that particular area. There are multiple ways to find them, I have listed few ways

For example, you want to know the tables used in KANBAN.

Go to SE11 / SE16N

pic 1.PNG

Enter Package for KANBAN (MD05) and press enter

Pic 2.png

You will get the list of ABAP tables related to KANBAN.This list is not only restricted to transparent tables but also to Customizing tables.

Pic 3.PNG

Packages differ from Module to Module and remembering these packages is not an easy task so in that case you can find it by using ABAP transaction SE93

Let’s say you have to find out tables related to MRP and the transaction used to run requirement planning MD01 / MD02 etc…

Go to SE93

Enter transaction code > Click Display

Pic 4.PNG

You will get the desired package:

pic 5.PNG

Now Enter this package in SE11 > F4 > Package Field

pic 6.PNG

You will have list of MRP relevant tables:

Pic 7.PNG

You can also use package MD03 for get list of other MRP / LTP / MPS related tables:

Pic 8.PNG

If you do not want have to use SE93 or you do not have access to ABAP transactions or you want to explore all the packages under a module or sub module then use following path:

Go to SE11 > Press F4 (in Database table) and chose the option of “SAP Application”

pic 9.PNG

Navigate up to desired package and you will get the list of tables. Below example shows the list of tables related to Work centers.

pic 10.PNG

You can also go to SE80 – Object navigator – Repository Browser – Package – Package Name

pic 11.PNG

All packages are stored in TDEVC tables. Here you can get the list of all packages in SAP (all modules) Just for the information, I have listed few (not all) of the packages in PP modules.

PP Functional Area


Material BOM


Production Version


Standard Routing


Engineering Change Management


Work center


Production Resources & tools






Demand Management (Planned Orders)


Demand Management (PIR)




Production Orders


Process Orders


Info structure – SOP


Product group – SOP




Capacity Planning


Capacity Scheduling


Capacity Levelling




Information System




Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Khetsiwe Khumalo
      Khetsiwe Khumalo

      helped thank you.

      Author's profile photo amarjeet kumar
      amarjeet kumar

      Awesome thanks

      Author's profile photo Oceans Blue
      Oceans Blue


      If i follow your steps :

      "Go to SE11 > Press F4 (in Database table) and chose the option of “SAP Application”


      I don't get to view the "SAP Application" button   The understated is what i get after i click on F4 at the Database Table field.


      Please advise.


      Author's profile photo Balakrishna KS
      Balakrishna KS

      Hi, can i get this info in database tables.

      basically last 3 snaps info which you posted.



      I need an physical table in SAP where it stores an Application module to Table level relation so i can easily query all the table under any application.

      for EX: FI-CO will have faglflexa, faglflext , bkpf .. so on ... where i can get all financial ones.

      Can someone tell me in which table i can get this info like DD03L will get Table and column relation


      also posted question in below