Thursday, August 23, 2007

Find out table source in SAP


Find out where the data is stored in SAP is a very challenging task. In some cases, we can find it easily in few minutes, but in another case it takes more then one day to find it.

I will try to give tips to find it out step by step.

1. Technical Information.
Put cursor in screen field, press F1, it will show description about this field. Then press "Technical Information" button, you can get field name and table / structure / view. If you get a table / view field, check the data in table / view, you may find it there. But, if you get structure field, go to next step.

Example of table field: tcode VA03 (display sales order), screen field order (VBAK-VBELN)
Example of stucture field: tcode IE03 (display equipment), screen field equipment (RM63E-EQUNR).

2. Exploring Search help (display available list to help input value by pressing F4 in screen field).
Sometimes field with search help can be found be displaying field in its search help. Example, tcode XD03 (display customer) field Customer (RF02D-KUNNR). It is a stucture field, to find the table, place cursor in screen field, press F4 (display search help), run search help until it show available list. In this list, place cursor in field customer, then press F1 to display technical info. You will get table/view field for this.

3. SQL Trace
Open your transaction , before type anything in screen, open transaction ST05 (SQL trace) in another session, start SQL trace by pressing "Trace on". SQL trace is a tools to record database request. Make sure you don't run other program beside transaction you want to trace. After starting SQL trace then go back to your transaction, run it until you get field to search shown in screen. Then go to SQL trace session, end SQL trace by pressing "Trace off". Then click "List trace", here you will get all table requested while SQL trace on. Explore table listed there, usually stucture field and table field having same field name.

4. Explore based on SAP module.
Go to SE16. Click F4, then click "SAP Application". Here you got table tree groupped in SAP module.

5. Find it in source code.
Well... you already finished up to step 4, but didn't find the table source yet. It's time to take a harder step. Click F1 then technical information to get program name and field name. Then go to SE38, open the program, then find field name. May be your detective instinct can help out there.

6. Debugging abap program.
Debugging abap could be a sweating task. "Watchpoints" will help you very much in debugging. Considering it could be more than one day to accomplish this task, don't forget to capture and create documentation while debugging when you reached an interesting point. I always do that, when I saw good point, I capture it by "print screen", paste it into Microsoft word, then give a remark on it.

Here is another tips that could help you.

1. Adjacent table will have similar prefix:
sample in sales order, prefik ( V / VB ) : VBAK, VBAP, VBPA...
sample in material management ( M ) : MKPF, MSEG, MARD, MARC,..

2. Almost all SAP Table have a view
To find related table, goto SE11, click where-used list, choose Views.

3. Another tools to find table field:
Goto SE15, Choose: ABAP Dictionary -> Field -> Table Fields.

18 comments:

Anonymous said...

Hey Dude,

Thanks for this imp. upload.

But the image is too small to read and zooming makes it blurred.

Can u plz upload a better resolution image file?

Thanks again.

girlfriday said...

Wow thanx!

No 2 really helped me just now!

prakashlu said...

Hey Alionzo, How you doing. By seeing these tips i really became a big fan of you.
Thanks and please share if you have more..Thank you very much.

avinash said...

It has been a great help..

Thanks

Anonymous said...

Hey Thanks, helped me alot....

Anonymous said...

Hi Dude

Thanks.. its really great help for the people who are searching for tables

Thanks & Regards,
Rajesh

balu said...

Hi Dude very gud imformation u provided. really i appreciate ur talent in SAP.

Anonymous said...

Hi How are you going on? Thank for your shared good idea.but if you know how all the table in sap link each other, please tell me too.
my email: pengleng_por@yahoo.com.

seventyros said...

For a Excellent Online Resource for SAP EP and SAP Web Dynpro ABAP, Visit Learn SAP Online

RAJA said...

sir,
can u plz tell me how to find a table using only the short description of field name

sajid said...

thanks alot man,i certainly wana study ABAP

Anonymous said...

tanku tanku

google said...

Excellent Online Resource for SAP EP and SAP Web Dynpro ABAP. Visit Learn SAP Online for Free

SAP Enterprise Portal Application in NWDS
SAP and Their Produstcs - SMB Customer - SAP Business One
What is SAP ?
Architecture of SAP Business One Application
Navigation in SAP Business One
SMB Portal and its Functionality
Netweaver Administrator Day to Day Work
SAP Business Intelligence
Business Partners in SAP Business One
Continuous Stock System in SAP business one
How to make WDJ Component available on SAP EP

And Many Morte Topics

Anonymous said...

hi,
I am new to SAP. We are using business one 8.8 at work. I wanted to know how do I get info on a table who's name seems to be there in sap but I can't retreive any info fields from it and it desn't seem to be in sql server also. I needed to pull info on certain people and the authorizations they had so I could limit them to the peole who should be using them. The problem is that the table which stores such info i cant find it in sql server and when i try to write table name sql query it doesn't recognize the table although sap seems to give the name. I hope you can give some insight into it

chennai said...

land marvel construction pvt limitedDeveloping and co-promoting real estate projects on joint venture basis properties

kiraniluri said...

really good piece of information, I had come to know about your site from my friend shubodh, kolkatta,i have read atleast nine posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards, sap

Anonymous said...

Hi this is so helpful.Can you please eloberate little bit in finding the Tables.I have Table structures and need the Original tables associated with them.
For ex: P0001 is the table structure for PA0001 .
I would like to know where I can find the actual tables if I type the table structures.Which T-Code/where to go from the beginning.It would be so helpful.

Thank You Again
-S

Divya Dheen said...

Thanks for sharing this Information, Got to learn new things from your Blog on sap abap training in chennai