Finding table names

[Former Member]

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.

[Former Member]

PLease reply.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.