CRM tables

[Former Member]

hi

I do the abap devlop for CRM,but I can not find the field any more time. so hope someone can give me the tables document of CRM.

Regards&Thanks!

[Former Member]

hi

I do the abap devlop for CRM,but I can not find the field any more time. so hope someone can give me the tables document of CRM.

Regards&Thanks!

[FredericGirod]

Hi Zagory,

you just need to use the transaction ST05 : SQL Trace.

Prepare the transaction.

Open ST05 in other screen: Activate trace

Display data into the transaction

ST05 -> Desactivate trace -> Display trace.

You will have the list of the tables read by SAP, with the key, with the number of result, the code where SAP made this selects ........

Rgd

Frédéric

[Former Member]

hi

I have the strange affair,I can not find the field infomation from the screen in st05.

can you give me the further help.

Regards&Thanks!

[Former Member]

Hi Zagory,

Refer the link

<a href="http://help.sap.com/saphelp_erp2005/helpdata/en/d1/801f89454211d189710000e8322d00/frameset.htm">SQL Trace Analysis</a>

Hope it helps...

Lokesh

pls. reward appropriate points

[FredericGirod]

Hi again,

that I remember in CRM, there is the same table that in R/3 but with two different prefix.

For example KNA1 -> xxxKNA1

the key is a stupid key (sorry SAP dev ) and the field of the standard KNA1 is always here.

don't know what kind of info you try to find but ... good luck

Frederic

[Former Member]

Hi Zagory,

Say inorder to Find the field inf. you can use SQL trace (ST05) .

Steps for the same:

• Go to ST05 --> Activate Trace.

• Run the trasaction , make some changes to the field for which you want to have the table name then SAVE.

• Go again to ST05 ---> Deactive Trace

• List trace

• Then search for the chaged value which u had done on that transaction.

• With this you will be able to see the table name in the Obj. name column.

For CRM material do send me your mail id , i have got some docs. on the same , i will mail you.

Cheers

Sunny

Reward points, if found helpful

Message was edited by: Sunny

[Former Member]

Hi,Sunny:

At first hanks for ur message,and my mail ad: [email protected], pls send the doc to this id.

Regards&Thanks

[Former Member]

Hi,

Can u please send the documents to me.

My email id is [email protected]

Thanks

Meena