Skip to Content

Preface

As a functional, its always important to know the tables in SAP. Specifically when it comes to support projects, it becomes more challenging to find the exact table where your transaction data gets stored. There is an excellent document by Maria on this topic.How to find ABAP Tables and Fields

Through this blog, I would like to share one simple way to know the tables which get populated when you perform any transaction in SAP.

What do you need to know?

You just need to know Archiving objects in SAP PM/EAM. I have listed them as below

PM_EQUI Equipment
PM_IBASE IBase
PM_IFLOT Functional Locations
PM_IMRG Measurement Documents
PM_MPLAN Maintenance Plans
PM_NET Object links, master data
PM_OBJLIST Serial Number History
PM_ORDER Service and Maintenance Orders
PM_PLAN Routings
PM_QMEL Maintenance Notifications

Scenario

For analysis on some issue, you want to know all CO tables which are updated once you do Time confirmation OR perform goods issue against an order?

Lets find it using SARA

1) Execute T-code SARA

SARA1.PNG

2) Enter Archiving object PM_ORDER. Press Enter & Click on Database tables.

SARA2.PNG

3) As shown in above screen, you will see two radio buttons Tables with deletion & All tables.Check & Browse the list of tables for relevant information based on table descriptions. In our example scenario, we need to know CO tables. Following screenshot shows some of the CO tables. LIkewise you can scroll down for more list of tables. & check these tables in another session by accesing SE16N transaction.

SARA3.PNG

Advantages of using SARA for finding the tables

1) As a functional, you can troubleshoot any process related issues, by checking its relevant tables from the complete list using SARA

2) If you are writing a Functional Specs, you can get detailed information on table & articulate your FS in order to have effective & time saving communication

3) Easy way to find object linked tables when it comes to cross-modules integration.

4) As shown in above screenshot, you can take a backup for these list of tables for your future reference.

Hope you find it useful for your day to day activities in your SAP projects.

Good Luck.

Best Regards,

Amol

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply