Skip to Content
Author's profile photo Former Member

Useful tips to find out the table for Screen field

************************************************************************************ –>Sometimes when we try to find out the Transparent table related to a screen field we end up in the structure  –>First we try go for F1 help—>Technical Settings , There we can find all the details of that particular field. In most cases we end up with the structure instead of transparent table where the field is stored  –>To checkout in a better way, if we can go for F4 help fof that field first and then  F1 help–>Technical settings on the relevant field there is possibility that we  can get the table name for that field in most of the cases  –>Still if we are  not able to get the correct table with F4 help also, then we can proceed the following way   After we click on F4 help ,  there will be one Information system button(find button) at the bottom of the popup , click on this button and then  F1 help–>Technical settings on the relavent field.  If we look at some examples we can have a better understanding    Check out some of the examples  1. To find out the table where function modules are stored  Goto Se37 image Check the F1 help–>Technical settings We end up in the structure image Now go for F4 help and we get the following screen image Get the F1 help for the field function module name –>Technical settings , again we end up in structure image Now click on the Information system button at the bottom image It will open up a popup with some fields , get F1 help for the function module field—>Technical settings image Now we get the table name TFDIR where the function modules are stored image     One more example  2. Let us take  transaction MM03 and try to find to find out the table name for the screen field Material_no which is displayed on the first screen of MM03     Goto MM03 transaction    image   When we go for F1 help–> Technical settings on the field Material_no, we end up in the structure image   Now go for F4 help where one popup is displayed image   Place the cursor on the field material and go for F1 help–>Technical settings   Here we can get the table/view name where the material numbers for that transaction are stored image    Likewise we can the table names for many screen fields

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Helpful blog -:) That's a problem I face almost everyday...Thanx for the tip -;)

      Greetings,

      Blag.

      Author's profile photo Twan van den Broek
      Twan van den Broek
      Thanks for sharing this very easy, but also very brilliant tip.
      Twan
      Author's profile photo Former Member
      Former Member
      Thanks for this Brilliant Tip.
      Author's profile photo Former Member
      Former Member
      Thanks jagarla, this will best tip to find the table .

      try to update more tips

      Author's profile photo Former Member
      Former Member
      Hello

      Its really very helpful.

      Rashit

      Author's profile photo Former Member
      Former Member
      During the migration process problems have been reported for this blog. The blog content may look corrupt due to not supported HTML code on this platform. Please adjust the blog content manually before moving it to an official community.
      Author's profile photo Former Member
      Former Member
      Thanks for good tip
      Author's profile photo Former Member
      Former Member
      Excellent One Chandra. Simply Amazing !!!
      Author's profile photo Former Member
      Former Member
      Dude,

      This is Great...works well.
      Thanks for sharing.

      Author's profile photo Former Member
      Former Member
      It is pretty excellent.
      Very very helpful.

      Tidji

      Author's profile photo Former Member
      Former Member
      Dear Chandrasekhar,

      I really appreciate your finding.
      However the above is applicable only those field where you have search option (F4).
      However there are many fields which don’t have F4 option.
      Do you have any short cut way like the above how to find the DB table of a field.

      Thanks once again for your post.

      Regards,
      Sp sahu