topic Re: Finding table names in Application Development and Automation Discussions

Finding table names

Former Member — Fri, 05 Jun 2009 05:41:25 GMT

Hi,

I have one transaction CRM_DNO_MONITOR . In that i have opened one service order transation.

It has three tabs like Fast entry, Item details and transactional data. Each has lot of fields in it . As i wanted to know table names of all those fields through technical information. But every field is fetched from structure .

I wanted to know where the values of all the fields are getting stored in which database table..

PLease help me.

Thanks,

Ahmed.

Re: Finding table names

Former Member — Fri, 05 Jun 2009 05:53:27 GMT

PLease reply.

Re: Finding table names

Former Member — Fri, 05 Jun 2009 05:55:52 GMT

Hi,

There will be some function moudules behind every structure that fills the structure for updating or retreving data from database. So it is better you put break point somewhere near the structuure and check which function module is used behind it. You can even get the table name from which the data is fetched when you expolore the function module.

regards,

Mani

Re: Finding table names

Former Member — Fri, 05 Jun 2009 05:58:28 GMT

Hi,

From the technical informationyou will get the field name. Now goto SE11, put the field name in Data Type, and press (Ctrl + Shift + F3) , in the Pop Up Screen select table fields and press enter. You will get a list of tables where it is used. By reading the text details of a table you can find the relevant table.

Regards,

Kanupriya

Re: Finding table names

Former Member — Fri, 05 Jun 2009 06:08:03 GMT

Thanks for your reply.

But for status and notes block no f1 help is exist .Please tell me how do i get the table names for those two.

Re: Finding table names

Former Member — Fri, 05 Jun 2009 07:18:28 GMT

Hi,

Check whether F4 help exists for these fields. If it exists then in the pop up after F4, press F1 and you will get technical information.

If it does not exist, then goto SE11 -> In data type press F4 -> Select data element -> Press Information system -> In short text give *status* and *notes* -> This will give you data elements for these fields -> Then apply the method described to get the table names where these data elements are used.

Regards,

Kanupriya

Edited by: Kanupriya Madan on Jun 5, 2009 9:22 AM

Edited by: Kanupriya Madan on Jun 5, 2009 9:26 AM

Re: Finding table names

Former Member — Fri, 05 Jun 2009 07:34:21 GMT

Hi Ahmed,

Inside the tcode CRM_DNO_MONITOR , the FM CRM_ORDER_READ fetches all the required data.

Tables: CRMD_ORDERADM_H, CRMD_ORDERADM_I.

Regards,

Raju.

Re: Finding table names

Former Member — Fri, 05 Jun 2009 15:44:21 GMT

Hi,

Try this.

1. Execute your transaction and do whatever you want (entering field values, changing values and so on).

2. Open a new session and execute transaction ST05. Click on activate trace button (don't close this session).

3. Open your session in step 1 and click on save.

4. Open your session in step 2 (ST05) and click deactivate trace button. Click on display trace and execute. Here you can see what all tables are used while saving your transaction in step1.

Hope this helps.

Regards,

Venkat

Re: Finding table names

Former Member — Sun, 07 Jun 2009 06:48:25 GMT

Hi,

From the technical information you will get the field name. Now goto SE15,select ABAP Dictionary and select the fields tab in that double click on table field and put the field name in filedname and execute.

Thanks,

Archana.

Re: Finding table names

Former Member — Mon, 08 Jun 2009 05:45:38 GMT

Hi Ahmed,

Function Module 'CRM_ORDER_READ ' is the one which you need to debug to find out all the tables from where data is fetched.

Thanks,

Sneha.