how to find table name for a field which is sho

8/9/2019 How to Find Table Name for a Field Which is Sho..

1/13

01/02/2015 How to find Table name for a Field which is sho... | SCN

scn.sap.com/docs/DOC-51118 1/13

Getting Started Newsletters Store

Products Services & Support About SCN Downloads

Industries Training & Education Partnership Developer Center

Lines of Business University Alliances Events & Webinars Innovation

Log On Join UsHi, Guest Search the Community

Activity Communications Actions

Brow se

3 TweetTweet 4

created by Dibyendu Patraon 13-Jan-2014 06:52, last modified by Dibyendu Patraon 02-Aug-2014 11:31

Hello Friends.

As we know about the tables and fields.

We also know al l information are stored in a table and a particular field. It's very difficult to memorize all tables and all

fields.

We can get this from F1 - Technical Information for table and field.

Thefields names are always shown correct. But for table name, sometime its shows the structure name ins tead of

table name.

For an example

When we press F1 on field Short Text onscreen ME51N. We can see as well the Short Text field name, but in table

portion we can see a structure name not a table name.

As we know the field Short Text (TXZ01) is stored in EBAN table, but we can't find this from F1 screen.

Its shown a structure name as MEREQ3211GRID.

In that situation, we have to find the original table name for this field.

Here I am giving the 3 way to find the original table for any field.

Way 1:

When the above pop-up comes, double click on the "Data Element".

Now you can see a s creen of Display Data Element.

How to find Table name for a Field which isshown structure name on press F1.

ShareShare 395LikeLike

Version 3
http://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361801/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361799/ScreenShot.jpghttp://scn.sap.com/people/dev.patrahttp://scn.sap.com/people/dev.patrahttp://twitter.com/search?q=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-51118https://twitter.com/intent/tweet?hashtags=scn&original_referer=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-51118&text=How%20to%20find%20Table%20name%20for%20a%20Field%20which%20is%20shown%20structure%20name%20on...&tw_p=tweetbutton&url=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-51118&via=SAPCommNethttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/contenthttp://scn.sap.com/actionshttp://scn.sap.com/communicationshttp://scn.sap.com/activityhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/login.jspahttp://scn.sap.com/docs/login.jspahttp://scn.sap.com/community/uachttp://scn.sap.com/community/developer-centerhttp://scn.sap.com/community/downloadshttp://scn.sap.com/welcomehttp://www.sapstore.com/http://scn.sap.com/community/newslettershttp://scn.sap.com/community/getting-started


2/13



Now you can see the data element screen for the field Short Text.

Now Press Where-Used List. This is on application menu barYou can see another pop-up screen will come, which is like below screen.

As we need the table name, so remove the all tick without Table Fields.

Now press enter or continue.

After pressing enter, you will find a lis t.
http://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361810/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361808/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361804/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361803/ScreenShot.jpg


3/13



This list shows you on which table the field is used.

It means in the li sted tables, you can find the field Short Text (TXZ01)

We can see 15 Hits comes on the screen.

It means the field TXZ01 is us ed in 15 tables.

Now we can find the table as per our requirement. We need the table for ME51N (Purchase Requisition).

We can see Purchase requisition is als o listed in the list.

And we can also see the table nam e for Purchase Requis ition.

If you have found a many number of hi ts, then you can search for your table wi th given descrip tion.

Like as if you want to know the table for PR, then you can search as purchase requisition

In that way we can find the original table name for this particular field.

(Note: I know I have given an easy field and table nam e, But I am just sharing the procedure to see the original table

name for a particular field)

Way 2 :

This is a simi lar way as way one.

Just first step is little different.

If you know the field name, then we can enter it directly in SE11 screen and we can get the Table name.

In SE11 screen, on the field Database Table, give the field name (Where usually we give the table name)

Now press display.
http://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361853/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361817/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361815/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361814/ScreenShot.jpg


4/13



You can see the Display Data Element screen.

You can do the further process which we have already discussed in the Way 1 section.

Way 3 :

This is little different way.

Use t-code SE84 or SE15.

You can see an initial screen is appearing for Object Navigator.

Now from here select the option

ABAP Dictionary-Fields -Table Fields .

-

Now Double click on Table Fields.

You can see a screen is will come on right side of the screen.

Here give the field name as TXZ01.
http://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361871/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361863/pastedImage_20.pnghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361862/ScreenShot.jpg


5/13



Average User Rating

(47 ratings)

3 TweetTweet 4

Then Press execute.

Now you will get the all table list for the field TXZ01.

Here you also use the s earch option which I have discussed in way 1.

In these above 3 ways, you can find the original table name for a particular field.

So don't worry when you see a structure name in table field, just use one option from above and you will get the table

original table name.

Thanks and Regards

Dev Patra.

23325 View sProducts: sap_erp_logistics_materials_management Topics: abap, enterprise_resource_planningTags: table, field,

materials_management, mm, purchasing, data_element, se84, se15

ShareShare 39 5LikeLike

75Comments

Like (1)

shiva mc13-Jan-2014 09:04

Good Doc Dev

Like (1)

Jitendra Yadav13-Jan-2014 13:10

Hi Dev,Really good document to find the table.Your way is alway exellent.ThanksJitendra

Like (1)

Gaurav Choudhary13-Jan-2014 13:16

Hi Dev,

The article is awesome as in our day to day activity we suffer this problem while development.Now i got the solution and i dont want to spend my time on searching a table for the fields.:):)Thank u so much Dev:):):)

Dibyendu Patra13-Jan-2014 13:22 (in response to Gaurav Choudhary)
http://scn.sap.com/docs/DOC-51118#comment-444632http://scn.sap.com/docs/DOC-51118#comment-444578http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#comment-444632http://scn.sap.com/people/gaurav4uhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-444592http://scn.sap.com/people/jitendrasdn%40gmail.comhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-444445http://scn.sap.com/people/mache123http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361873/ScreenShot.jpghttp://scn.sap.com/servlet/JiveServlet/showImage/102-51118-3-361872/ScreenShot.jpghttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=se15http://scn.sap.com/community/erp/logistics-mm/tags#/?tags=se84http://scn.sap.com/community/erp/logistics-mm/tags#/?tags=data_elementhttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=purchasinghttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=mmhttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=materials_managementhttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=fieldhttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=tablehttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=enterprise_resource_planninghttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=abaphttp://scn.sap.com/community/erp/logistics-mm/tags#/?tags=sap_erp_logistics_materials_managementhttp://twitter.com/search?q=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-51118https://twitter.com/intent/tweet?hashtags=scn&original_referer=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-51118&text=How%20to%20find%20Table%20name%20for%20a%20Field%20which%20is%20shown%20structure%20name%20on...&tw_p=tweetbutton&url=http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-51118&via=SAPCommNet


6/13



Like (2)

Gaurav ChoudharyI am very very very very happy to hear this comment from you.....I feel very proud for that....Thank you soooooo much.....SCN rocks......

Like (0)

Gaurav Choudhary16-Jan-2014 10:14 (in response to Dibyendu Patra)

hey DEV pleas e dont say thank u to m e dude.. We all wi ll say THANK U to u for urarticle...THANK YOU !!!!!!!!!!!!!!

Like (6)

Jrgen L16-Jan-2014 10:39 (in response to Gaurav Choudhary)

Sorry to interrupt, but this is a professional forum and we should us eproper English language and no SMS speak as it is s tated in rule 4Please avoid slang and SMS Text Speak. of our The SCN Rules ofEngagement

Like (0)

Gaurav Choudhary20-Jan-2014 11:16 (in response to Jrgen L)

Ok Boss.... I will take care hereafter

Thanks for your suggestion to me

Like (1)

Karen Jhonson13-Jan-2014 13:32

Impressive and quite handy. Great jobKJ

Like (1)

Leo Thilak M.S13-Jan-2014 13:37

good job dev

Like (0)

PREETI KASHYAP14-Jan-2014 11:02

Earlier I knew the only one way - first one but now i have three.Thanks.Good Document Sir.

Like (0)

Lakhya Pratim Baruah14-Jan-2014 12:51

Bang!!!! All newbies and experienced who have a tussle with ABAP Consultants to find the TableName by themselves can now be more specific by providing the exact Table Names not Structures

as we do sometimes.

Like (0)

subburam v16-Jan-2014 12:28

Hi Dev,

Excellent post...Keep Rocking..RegardsSubbu.

Like (0)

vinod bokade16-Jan-2014 23:53

Nice document, thanks for sharingRegards,VB

Like (1)

Sagnik Chakravarty20-Jan-2014 13:31

Thanks for sharing this Dev! Very very useful docum ent!

Regards,Sagnik

Ravishankar Venkat Ramanan22-Jan-2014 06:08
http://scn.sap.com/docs/DOC-51118#comment-448111http://scn.sap.com/people/ravishankar.ramananhttp://scn.sap.com/docs/DOC-51118#comment-447298http://scn.sap.com/people/sagnik.desconlimitedhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-446114http://scn.sap.com/people/vinod.bokadehttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-445846http://scn.sap.com/people/subburam.vhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-445053http://scn.sap.com/people/lakhyapratim.baruahhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-444949http://scn.sap.com/people/preeti.kashyaphttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-444675http://scn.sap.com/people/leothilak.mshttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-444545http://scn.sap.com/people/karen.jhonsonhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-445770http://scn.sap.com/docs/DOC-51118#comment-447054http://scn.sap.com/people/gaurav4uhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-18590http://en.wikipedia.org/wiki/SMS_languagehttp://scn.sap.com/docs/DOC-51118#comment-445737http://scn.sap.com/docs/DOC-51118#comment-445770http://scn.sap.com/people/jrgen.linshttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-444578http://scn.sap.com/docs/DOC-51118#comment-445737http://scn.sap.com/people/gaurav4uhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/people/gaurav4uhttp://scn.sap.com/docs/DOC-51118#


7/13



Like (1)

Great work as always Dev :-)

Can't stop saving this doc, the doc is definitely a best practise to be shared among many .

Like (0)

Nisha Sharma03-Feb-2014 08:32

Very Nice docum ent Dibyendu Patra.I will use this in m y team as a best practice.RegardsNisha

Like (1)

manu m03-Feb-2014 09:25

Good one Dev.I almos t forgot this , refreshing feeling

Like (0)

h w d05-Feb-2014 09:23

Great one Dev,Given a good info once again.reg,BHG

Like (0)

Sharan G S05-Feb-2014 10:04

Hi Dev,Thanks for sharing the details. It's really useful.Best Regards,Sharan

Like (0)

Keerthi varman jain M R06-Feb-2014 16:04

Nice document Dev.

Like (0)

Bhanu Chandra09-Feb-2014 10:25

Good document, thanks for sharing

Regards,Bhanu

Like (0)

Sumit Kaushik10-Feb-2014 07:19

Nice Document , thanks for posting such good Articale.RegardsSumit

Like (1)

Devendra F10-Feb-2014 12:36

Hi,This is definitely five star document,Devendra

Like (0)

Ranjit Kumar10-Feb-2014 12:48

Hi Dev,Its a helpful document.Thanks for sharing the tips.Ranjit

Ranu Eugene10-Feb-2014 13:07

Hi Dev,Very nice docum ent and very useful .
http://scn.sap.com/docs/DOC-51118#comment-456485http://scn.sap.com/people/vincent007http://scn.sap.com/docs/DOC-51118#comment-456496http://scn.sap.com/people/ranjit.kumar18http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-456495http://scn.sap.com/people/devendra.fulsundarhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-456266http://scn.sap.com/people/kaushiksumit16http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-455921http://scn.sap.com/people/bhanu.chendrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-454948http://scn.sap.com/people/keerthivarmanhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-454196http://scn.sap.com/people/sharan.gs2http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-454168http://scn.sap.com/people/bhagyaraj.gowdahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-453161http://scn.sap.com/people/manu.m2http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#comment-452920http://scn.sap.com/people/nisha.sharmahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#


8/13



Like (0)

Keep up the good work.

Best of Luck.RegardsEugene

Like (0)

Erwin Leitner10-Feb-2014 22:20

HelloThank you very muchBe erwin

Like (0)

SRS KANNAN17-Feb-2014 05:29

hi, really useful. thanks. at times we are struck at this,,, now refreshed,,regardsSRS Kannan

Like (0)

juan gonzalez17-Feb-2014 16:51

Thank You!!!Good Job!!!!

Like (0)

Mohsin Abbasi17-Feb-2014 20:26

Dear Dev,you shared ni ce info bro.....:D

Best RegardsMohsin Abbasi

Like (1)

Sandy Du20-Feb-2014 08:31

Dear Dev,Your sharing is very useful to me and save time .

Thanks and Best ReagardsSandy

Like (0)

Siva Prasad Vasireddy22-Feb-2014 05:32

Hi,This Helps us a LotThankyou for sharing

Like (0)

Naresh Krishnamoorthy22-Feb-2014 10:23

Very useful one...Many Thanks.

Best Regards,Naresh K.

Like (1)

Ashish Kaple25-Feb-2014 08:50

Hi,Really helpful blog. Keep it up.Regards,

Ashish

Like (1)

Ankita Chhabra28-Feb-2014 08:26

Hi Dev,Thanks for sharing. Good document.Regards,

Ankita
http://scn.sap.com/docs/DOC-51118#comment-465735http://scn.sap.com/people/ankita.chhabrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-463719http://scn.sap.com/people/ashish.kaple2http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-462441http://scn.sap.com/people/naresh.krishnamoorthyhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-462472http://scn.sap.com/people/siva.vasireddy2http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-461392http://scn.sap.com/people/sandy.duhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-459873http://scn.sap.com/people/mohsinabbasi007http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-459783http://scn.sap.com/people/juan.gonzalez3http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-459427http://scn.sap.com/people/srs.kannanhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-456695http://scn.sap.com/people/erwin.leitnerhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#


9/13



Like (1)

Yongyi Cao03-Mar-2014 04:25

Dear DevReally thank u very much.

Best RegardsJason

Like (1)

Abhishek Jain04-Mar-2014 13:41

Good Document

I learned a new thing from this oneThanks

Like (1)

Siva Prasad Vasireddy05-Mar-2014 12:50

Hi,Very Informative

Like (0)

Jaydip Hapliya07-Mar-2014 18:39

Dev,Its really nice informative documents, Thanks for the explanation !!

Like (1)

Siddharth Dharmadhikari10-Mar-2014 07:39

Very nicely written and helpful docum ent, thank you.

Like (1)

KIRAN DAHIWADAKAR11-Mar-2014 11:55

HiReally nice and well documented ...Thanks a lot

Like (1)

padma sai12-Mar-2014 10:21

Hi Dev,Its a very nice document and helpful as well, But I have got some doubts could you please clarify.I opened a purchase order using ME23N and then I pressed F1 key on Delivery date,For the Deliverydate the data element is EEIND ,I tried the three ways but could not able to find the table name for thedelivery date (i .e.EKET).Regards,Sai

Like (0)

Dibyendu Patra12-Mar-2014 10:22 (in res ponse to padma sai)

Because the field is different..When you press F1 in ME23N, you will see the field is EEIND.But in EKET table the field name changed as EINDT.

So it can't find the relation..

Like (0)

Pravat Sahoo20-Mar-2014 11:50

Thanks

Like (0)

Dibyendu Patra20-Mar-2014 13:31 (in response to Pravat Sahoo)

Hi Pravat,Thanksfor why ??you should write your review/feedback on this document..

Mehmet Ozgur Unal21-Mar-2014 21:20 (in response to Dibyendu Patra)

Hi all ;Impressive document , i want to add '' F1 technical data why get different fieldswhere different tcode ?I hope that structure mus t be defined with details.
http://scn.sap.com/docs/DOC-51118#comment-473907http://scn.sap.com/docs/DOC-51118#comment-474415http://scn.sap.com/people/mehmet.unalhttp://scn.sap.com/people/pravat.sahoohttp://scn.sap.com/docs/DOC-51118#comment-473791http://scn.sap.com/docs/DOC-51118#comment-473907http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-473791http://scn.sap.com/people/pravat.sahoohttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-470906http://scn.sap.com/docs/DOC-51118#comment-470867http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-470906http://scn.sap.com/people/sathya.padduhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-470447http://scn.sap.com/people/kiran.dahiwadakarhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-469873http://scn.sap.com/people/siddharth.dharmadhikarihttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-469284http://scn.sap.com/people/jay.patelhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-468162http://scn.sap.com/people/siva.vasireddy2http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-467657http://scn.sap.com/people/abhishekjain181087http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-466682http://scn.sap.com/people/yongyi.caohttp://scn.sap.com/docs/DOC-51118#


10/13



Like (0)

Regards.M.Ozgur Unal

Like (0)

Dibyendu Patra22-Mar-2014 11:34 ( in response to Mehmet Ozgur Unal)

Do you want to say that WERKS for plant in PO.. But the field name isdifferent for different t-code ???

Like (0)

Mehmet Ozgur Unal22-Mar-2014 13:51 (in res ponse to Dibyendu Patra)

Hi;I want to say that there must be a trick between structere andtable. If you go to ME21N after that select material master andrun F1 , you will get details in technical data.Table : MEPO1211Field : EMATNBut, material mas ter in MARA , WRONG PATH

I thought , your document has to inform for the difference.Regards.M.Ozgur Unal

Like (0)

Dibyendu Patra23-Apr -2014 10:22 (in response to MehmetOzgur Unal)

Actually my document represent that, when you find astructure name while press ing F1, then you can findthe original table..

And about your query..If you check EKPO table, then you can also findMATNR, which will also contain the material number..That is for table and if you are asking about table, thenyes, table name is always change for almos t everytransaction (Instead of some integrated transaction)Regards

Dev

Like (0)

Avirat Patel29-May-2014 13:10

Bookmarked

Like (0)

lakshmi p25-Jun-2014 13:20 (in response to A virat Patel)

Hi Dev,You only my first SCN guru still i can remember your words and thanks to u we get such awonderful documents from you keep posting in SCN it helps a lot who eagerly looking forlearning new things like me.ThanksLakshmi

Like (0)

Onur SENTURK03-Jul-2014 09:03

I needed TXZ01 stored table and i found it. Thank you. That's a g reat job.

Like (0)

Sathishkumar Seetharaman02-Aug-2014 14:48

Hi Dev,Thanks for the document which helps to find the Table name from the field Name.Regards,Sathish

Jeyaseelan Singaraja27-Aug-2014 09:11

Hi Dev,Thanks for your useful information.But, I not able to find Picking Quantity table from de livery document(VL02N).I found below info. from F1 help.Structure : LIPSD
http://scn.sap.com/docs/DOC-51118#comment-519482http://scn.sap.com/people/j.singarajahttp://scn.sap.com/docs/DOC-51118#comment-512830http://scn.sap.com/people/satzhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-504259http://scn.sap.com/people/osenturkhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-494389http://scn.sap.com/docs/DOC-51118#comment-501936http://scn.sap.com/people/lakshmi.p8http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-494389http://scn.sap.com/people/avirat.patelhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/community/about/blog/2013/12/12/blog-it-forward-dev-patrahttp://scn.sap.com/docs/DOC-51118#comment-474588http://scn.sap.com/docs/DOC-51118#comment-484285http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-474549http://scn.sap.com/docs/DOC-51118#comment-474588http://scn.sap.com/people/mehmet.unalhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-474415http://scn.sap.com/docs/DOC-51118#comment-474549http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#


11/13



Like (0)

Field : PIKMGPlease teach me any way for finding picking quantity.Regards,Jai

Like (0)

Dibyendu Patra27-Aug-2014 09:32 (in response to Jeyaseelan Singaraja)

The field is not used in any table. It is jus t used in some s tructures and some functionmodules.You will find these by select all option in Used in.

Like (0)

Jeyaseelan Singaraja27-Aug-2014 09:48 (in response to Dibyendu Patra)

Thanks for your quick response.Ok. I understand.So, How can I find picked quantity field and table.

Like (0)

Dibyendu Patra27-Aug-2014 10:00 (in response to Jeyaseelan Singaraja)

I am not able to find the field at table level.You can consult with your SD consultant for more details about that.Have a look into the discuss ion Exact field name and table name forPicking quantity

Like (0)

Jeyaseelan Singaraja27-Aug-2014 10:22 (in response to Dibyendu

Patra)

Thanks for your response.I found picked quantity table name and field name i n below link.

table where picking quantity isThanks for your nice article.

Like (0)

mohamed amar27-Aug-2014 10:37

Thanks for sharing

Like (1)

Vijay Kumar02-Sep-2014 21:13

Informative!!Thanks for Sharing :-)

Like (0)

S Ramaraju28-Oct-2014 04:27

Good Document.

Like (0)

Mayank Vishnoi14-Nov-2014 03:35

Nice Doc.Where step 1 and 3 are working completely fine.But for me step 2 i s not producing desired output.e.g. WERK is a field nam e which is us ed in many tables, but when entering the name in Databasetable field (SE11) it says "WERK does not exist".May be it just works on data element, not all field names.Thanks for your help.Regards,Mayank.

Like (1)

Dibyendu Patra14-Nov-2014 06:22 (in response to Mayank Vishnoi)

Are you sure the field name is WERK ? Is it WERKS (Plant) ?Can you tell me a table which contain the WERK field.

Mayank V ishnoi17-Nov-2014 12:53 (in response to Dibyendu Patra)

I found the WERK field in the table : QALS (3rd row in the image).But the first and third method are working just fine. And I am able to use SQVItcode to find the relations between tables to filter out unwanted tables.Thanks.
http://scn.sap.com/docs/DOC-51118#comment-542484http://scn.sap.com/docs/DOC-51118#comment-543009http://scn.sap.com/people/mayank.kumar.vishnoihttp://scn.sap.com/docs/DOC-51118#comment-542403http://scn.sap.com/docs/DOC-51118#comment-542484http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-542403http://scn.sap.com/people/mayank.kumar.vishnoihttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-537320http://scn.sap.com/people/ramarajushttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-521133http://scn.sap.com/people/sap.user87http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-519471http://scn.sap.com/people/mohamed.amarhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/thread/1292725http://scn.sap.com/docs/DOC-51118#comment-519510http://scn.sap.com/docs/DOC-51118#comment-519484http://scn.sap.com/people/j.singarajahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/thread/841112http://scn.sap.com/docs/DOC-51118#comment-519483http://scn.sap.com/docs/DOC-51118#comment-519510http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-519507http://scn.sap.com/docs/DOC-51118#comment-519483http://scn.sap.com/people/j.singarajahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-519482http://scn.sap.com/docs/DOC-51118#comment-519507http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#


12/13



Like (0)

Like (0)

Dibyendu Patra25-Nov-2014 18:32 (in response to Mayank Vishnoi)

Mayank VishnoiSorry for late reply as I am not able to answer this question. I don't knowwhy SAP makes the field as WERK (instead of WERKS) in this table. Butthe field represent the same field WERKS.

Like (0)

kumar sp14-Nov-2014 06:14

HI,Thank you for sharing this document.....

regards,kumar.

Like (1)

Thangam Perumal14-Nov-2014 14:00

Really helpful... Thanks for this Documents.....

Like (0)

Joseph Brow nfield14-Nov-2014 22:25

Good article, thanks!

Like (0)

Bo Liu15-Nov-2014 08:26

Good share.Thanks. Recall my memory, I made sim ilar article in Chinese when I was a new SAPer.

Like (1)

Sergio De La Pea25-Nov-2014 18:20

Thanks for sharing, good article.

Like (1)

Lakshmi Sama26-Nov-2014 14:49

Hi Dibyendu Patra,This is really a nice document to save our time without wasting for seraching a t code. Thanks forsharing your knowledge and keep sharing.Regards,Lakshmi S

Like (0)

Dibyendu Patra27-Nov-2014 07:07 (in response to Lakshmi Sama)

Thanks Lakshmi.

Yes you can also find the t-code which is associated with a program.A field can't be associated direct to t-code. So you can't find the t-code with regards to afield. You can find t-code with regards to the program from SE38 - Where used list.The where used list is very important to find the relation.RegardsDP
http://scn.sap.com/docs/DOC-51118#comment-546116http://scn.sap.com/docs/DOC-51118#comment-546269http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-546116http://scn.sap.com/people/lakshmisamahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-545687http://scn.sap.com/people/sergio.delapenahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-542820http://scn.sap.com/people/bo.liu2http://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-542816http://scn.sap.com/people/joseph.brownfieldhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-542642http://scn.sap.com/people/thangam.perumalhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-542395http://scn.sap.com/people/kumar.sphttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/people/mayank.kumar.vishnoihttp://scn.sap.com/docs/DOC-51118#comment-543009http://scn.sap.com/docs/DOC-51118#comment-545729http://scn.sap.com/people/dev.patrahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/servlet/JiveServlet/showImage/105-543009-586946/Capture.PNGhttp://scn.sap.com/docs/DOC-51118#


13/13


Follow SCNSite Index Contact Us SAP Help Portal

Privacy Terms of Use Legal Disclosure Copyright

Like (1)

Ishara Weerasinghe27-Nov-2014 11:35

Hi Dibyendu,This makes me to love SCN even more....:)...I have been working in SAP Industry since 2012 but I

have been learning hell of a lot through SCN..:)

Like (0)

Eric Li28-Nov-2014 06:44

thanks, it's helpful.

Like (1)

pranaya ranjan sahu17-Jan-2015 14:11

Good One. Thanks for sharing.Regards,Pranay.

Like (0)

prathamesh lonkar19-Jan-2015 07:29 (in response to pranaya ranjan sahu)

Hi,nice document
http://scn.sap.com/docs/DOC-51118#comment-557961http://scn.sap.com/docs/DOC-51118#comment-558099http://scn.sap.com/people/prathamesh.lonkarhttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-557961http://scn.sap.com/people/pranayahttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-546614http://scn.sap.com/people/yongqianglihttp://scn.sap.com/docs/DOC-51118#http://scn.sap.com/docs/DOC-51118#comment-546418http://scn.sap.com/people/ishara.weerasinghehttp://scn.sap.com/docs/DOC-51118#http://www.sap.com/corporate-en/our-company/legal/copyright/index.epxhttp://www.sap.com/corporate-en/our-company/legal/impressum.epxhttp://www.sdn.sap.com/irj/scn/policyhttp://www.sdn.sap.com/irj/scn/policy?view=PPhttp://help.sap.com/http://scn.sap.com/docs/DOC-18476http://scn.sap.com/docs/DOC-19361http://spr.ly/SCNgoogleplushttp://bit.ly/SCNLnIhttp://bit.ly/SCNyouThttp://bit.ly/SCNFBhttp://bit.ly/SCNTwR