Text Tables

[Former Member]

Hi Experts,

I wanted to know what are the tables for text types i.e. when we enter the text in transactions where the data will be saved.

Actually I'm working for a Data model in SAP CRM so can u pls let me know the tables for text types.

Regards

Vinod

[rene_markytan · Accepted solution]

Hello Vinod,

there is also a table called STXH (header) beside STXL (line). However not all texts are saved on database, because the log itself is determined dynamically by the system. See also note 910735 where it is explained.

Furthermore if you search for a text in the table you have to use a wildcard with the guid to get all texts. The reason is that the guids are stored with a timestamp.

Example:

table STXH

TDOBJECT CRM_ORDERH

TDNAME 0707EED508984BD9AE1B8ACF7A87D9D6* <<< wildcard

result:

TDOBJECT TDNAME TDID TDSPRAS

CRM_ORDERH 0707EED508984BD9AE1B8ACF7A87D9D6 20070910131607663 S001 R

CRM_ORDERH 0707EED508984BD9AE1B8ACF7A87D9D6 20070910131718459 S002 R

CRM_ORDERH 0707EED508984BD9AE1B8ACF7A87D9D6 20070924111551104 S001 E

CRM_ORDERH 0707EED508984BD9AE1B8ACF7A87D9D6 20070924111551105 S002 M

CRM_ORDERH 0707EED508984BD9AE1B8ACF7A87D9D6 20070925060755175 S002 6

Regards

Rene

[Maggie]

Hello Viond,

The text table is STXL.

You can get the text value with IDNAME=GUID for a business transaction.

Best regards,

Maggie

[Former Member]

Hi Maggie,

Thanks for the prompt response, I went to the table STXL with TDNAME = GUID from CRMD_ORDERADM_H so it displayed the list of text types and also in the field CLUSTR and CLUSTD. In the Field CLISTD there is long text but it is displayed in the form of a hexa decimal value.

How to get the exact text values from the hexadecimal values.

When I went into the table I'm able to see the below hexa decimal values.

FF0602010202800034313033000000005F100000121F9D02D25E15E4340C03C1A9281207045FC899031CB8714508214101C107DC2494A8695235A1155F428217

FF06020102028000343130330000000063010000121F9D027BCC7C0C0C0C8C3C40828195010B0861F061F064F0637065580B51B90A2CCC02A61839D64104F741

FF06020102028000343130330000000063010000121F9D026D665C5210068220FA0623B810CF909DE011DCB9702188AB5C20E880A226329920C991043D819FAB

Pls help.

Thanks in advance,

Regards

vinod

Edited by: Vinod Reddy on Jun 29, 2011 7:48 AM

[Former Member]

Hi Vinod,

You would need to us the FM "READ_TEXT" to read the values of the text in this table STXL.

Hope this helps.

rgrds,

Randhir