Where are Texts stored in CRM database

[former_member265997]

     I'm trying to isolate which database table(s) in CRM 7.0 hold the business activity text when one is entered under the Decription.  I've looked at the CRMD_ORDERADM_H and can find the business activity in that table but I can't seem to isolate what table the actual text for the description tab are stored.  I would like be able to pull this data out of CRM into BW.  I've included and image below, the words starting with 'FA GOAL' are what I'm trying to find.  Thanks.

[kakshat · Accepted solution]

Hi Gary,

You can check this thread - https://scn.sap.com/thread/1984801.

Table STXH should be the one.

Regards,

Akshat

[former_member13738]

Hi Gary,

Refer http://scn.sap.com/message/13987718 on how to access the text from STXH table using the GUID from CRMD_ORDERADM_H table.

Give TDOBJECT = 'CRM_ORDERH' and TDNAME = CRMD_ORDERADM_H-GUID (document GUID)

Thanks & Best Regards,

Leon