Skip to Content
Technical Articles
Author's profile photo arghadip kar

How to Find SAP Table by just knowing nothing about SAP? Its True

Introduction

After working with SAP for more than 15 years and travelling across the Globe for SAP Projects one issue I always use to have how can I keep track of all the SAP Tables associated with different Modules. If you are working as a SAP ABAP Consultant you need to keep the name of tables in your Fingertips. Sometimes this you know from other Experts and sometimes you have to dig it out. After exploring I found a very easy way to dig out the SAP tables associated with a Business Process Area. Just check this blog and conquer the SAP world.

SAP is just like an ocean and every droplet is like one SAP Table. How to find the relevant SAP Tables for a process without knowing anything.

 

Solution

Go To  Transaction Code SE16T and execute for Find Table option as highlighted below

Now you get the below screen

Now enter the Business Process Name. In my case I want to know Table name for Cost Center

We got all the relevant table so easily.

 

 

For the video version please check link below.

 

 

 

 

 

Conclusion

Using this Tutorial anyone can find the tables related with any process. Sky is the Limit My Friends

Assigned Tags

      34 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Muhammad Hasan Mufid
      Muhammad Hasan Mufid

      Nice articles Mr. Arghadip, keep it up ?

       

      Regards,

      Muhammad Hasan Mufid

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Glad you all liked it. You can also check Blog for Transaction Code

      https://blogs.sap.com/2020/07/15/how-to-find-the-transaction-code-behind-any-process-area-very-easily/

      Author's profile photo sujith prasad
      sujith prasad

      Hi Arghadip,

       

      Amazing articles.

      I tried to execute SE16T and ended up getting the below message.

      Error "Transaction SE16T is unknown - Message no. 00031"

      Tried the program *SAPLSE16T* , still no go

      Program SAPLSE16T does not exist

       

      Appreciate your inputs.

       

      Sincerely,

      Sujith

       

      Author's profile photo Mohammad Javed Khan
      Mohammad Javed Khan

      I am not sure if this is valid in EWM as well...Could you please let me know how should I track this in EWM system.

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Yes you can thanks to Praveen yadav

       

      Author's profile photo Ahmed Abdallah
      Ahmed Abdallah

      Many thanks for this great tip

      Author's profile photo Sreedhar Tumuluri
      Sreedhar Tumuluri

      Nice article Arghadip..Very informative..thanks for sharing..

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Glad you all liked it. You can also check Blog for Transaction Code

      https://blogs.sap.com/2020/07/15/how-to-find-the-transaction-code-behind-any-process-area-very-easily/

      Author's profile photo CHANDRA GANGADHARAN Gangadharan
      CHANDRA GANGADHARAN Gangadharan

      The Obsession with Transaction codes based implementation methodology means that we have sacrificed a Process oriented iimplementation to a TC code
      Hammering" of he Process down the throat of the client leading to so many failed implementations.

      New SAP consultants think that SAP is all about TC and not its traditional integration and process orientation -sad situation indeed

      Author's profile photo Aaron Benner
      Aaron Benner

      In other news, there was a great blog about SE16T!

      Author's profile photo Ajay Singh
      Ajay Singh

      That's great. That will help a lot for finding related table.

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Glad you all liked it. You can also check Blog for Transaction Code

      https://blogs.sap.com/2020/07/15/how-to-find-the-transaction-code-behind-any-process-area-very-easily/

      Author's profile photo Shivika Aggarwal
      Shivika Aggarwal

      Wow its really helpful video .Can we see customize table also ?

      Author's profile photo David Nazarov
      David Nazarov

      By using this method, you'll will get the view. Using se11 you can see which tables it's made from.

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Sky is the Limit. Look T001. You can click and go directly

      Author's profile photo Mahesh Patel
      Mahesh Patel

      Now you got a functional guy intrigued! I don't have access to SE16T, can someone please post the program name for it? I can perhaps bypass the access restrictions using SE38/SA38. Thanks in advance! Nice article, thank you!

      Author's profile photo Ram Mohapatra
      Ram Mohapatra

      The program is – SAPLSE16T

      Nice article Arghadip, thank you.

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Glad you all liked it. You can also check Blog for Transaction Code

      https://blogs.sap.com/2020/07/15/how-to-find-the-transaction-code-behind-any-process-area-very-easily/

      Author's profile photo venu gopal
      venu gopal

      Good

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Glad you all liked it. You can also check Blog for Transaction Code

      https://blogs.sap.com/2020/07/15/how-to-find-the-transaction-code-behind-any-process-area-very-easily/

      Author's profile photo Durgesh Kadam
      Durgesh Kadam

      Nice Articles Arghadip...

       

      Author's profile photo Adam Trickett
      Adam Trickett

      That's very useful, but it clearly doesn't exist on older boxes. I can see it on a S4/Hana 1610 system but not our older ECC systems, even relatively recent ones.

      When and where did the tcode arrive?

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      I have this in ECC also below is my version

      SAP_BASIS 740 0019 SAPKB74019
      SAP_ABA 740 0019 SAPKA74019
      SAP_GWFND 740 0019 SAPK-74019INSAPGWFND

      You might want to check the below blogs also

      https://blogs.sap.com/2020/07/15/how-to-find-the-transaction-code-behind-any-process-area-very-easily/

      https://blogs.sap.com/2020/07/15/in-sap-how-to-find-a-table-behind-a-transaction-code/

      https://blogs.sap.com/2020/08/06/how-to-do-a-search-on-any-sap-field-based-on-the-value-in-sap-s-4hana/comment-page-1/#

      Author's profile photo Hasibur Rahman
      Hasibur Rahman

      Very Handy. Thanks for the article.

      Author's profile photo Catherine Robinson
      Catherine Robinson

      WOW this as helped me tremendously!!!  Thank You Arghadip Kar !!!   You're My Hero!.. well, for the Day...

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Thanks Glad you like it .

      Also check below blog which might be helpful

       

      https://blogs.sap.com/2020/07/15/how-to-find-the-transaction-code-behind-any-process-area-very-easily/

       

      https://blogs.sap.com/2020/07/15/in-sap-how-to-find-a-table-behind-a-transaction-code/

       

      https://blogs.sap.com/2020/08/08/how-to-get-all-the-custom-enhancementsbadis-user-exits-bte-implemented-for-any-transaction-code-in-sap/

       

      Author's profile photo mauricio alonso jaramillo alvarez
      mauricio alonso jaramillo alvarez

      Thanks you very much! Arghadip Kar, very good explanation.

      Author's profile photo Ethan Tew
      Ethan Tew

      This is helpful. It Will definitely saves development type by looking into just the details in a smarter way. I believed there are many SAP tools that are helpful but not being explored or being share about their capabilities in optimizing our daily work. thanks for sharing.

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Thanks a lot to hear it is helpful.

       

      Also check below blog which might be helpful

       

      https://blogs.sap.com/2020/07/15/how-to-find-the-transaction-code-behind-any-process-area-very-easily/

       

      https://blogs.sap.com/2020/07/15/in-sap-how-to-find-a-table-behind-a-transaction-code/

       

      https://blogs.sap.com/2020/08/08/how-to-get-all-the-custom-enhancementsbadis-user-exits-bte-implemented-for-any-transaction-code-in-sap/

      Author's profile photo Pavithrra Narayanan
      Pavithrra Narayanan

      Nice one to know. Could you please post more in VIM side as well. Thanks

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Sure will try

      Author's profile photo Manoj Jain
      Manoj Jain

      Nice article bro

      Author's profile photo RAJESH SHARMA
      RAJESH SHARMA

      your way of explanation is good realy nice information it is usefull

      Author's profile photo Jozsef Szikszai
      Jozsef Szikszai

      All this is doing, you enter some text (like "cost center") and then it lists all tables, where the table name contains the text "cost center". You can do the same in SE11.

      I just tried with "debitor" (customer in German) and it did NOT list any of the KN* tables, because their name is "Kundenstamm..." 🙂