topic Re: Text field - Table Name in Application Development and Automation Discussions

Text field - Table Name

Former Member — Fri, 15 Dec 2006 11:13:58 GMT

When I goto XD03 and in Texts I find a table control which has some values...I have selected one record and gone into its Long text area....

When I goto Header popup, it shows me TEXT NAME & TEXT ID & TEXT OBJECT.....Now I want to find out for a particular customer what are the various TEXT ID been maintained.

Re: Text field - Table Name

Former Member — Fri, 15 Dec 2006 11:19:04 GMT

The best option would be to go to STXH.

Enter Text OBJECT = KNA1

and TEXT NAME = customer number. This will give u list of all the IDs for that customer which are saved in the database.

Re: Text field - Table Name

former_member404244 — Fri, 15 Dec 2006 11:24:32 GMT

Hi,

Use the table STXH.it wil list of ids..

REGARDS,

Nagaraj

Re: Text field - Table Name

Former Member — Fri, 15 Dec 2006 11:26:54 GMT

Use the following to read all the enabled text-ids of customer.

TYPES: BEGIN OF ty_texts,

tdid LIKE stxl-tdid, "Text ID

tdtext LIKE ttxit-tdtext, "Description

END OF ty_texts.

data: l_t_texts TYPE TABLE OF ty_texts.

SELECT tdid tdtext

INTO TABLE l_t_texts

FROM ttxit

WHERE ttxit~tdspras = c_en

AND ttxit~tdobject = 'KNA1'.

IF l_t_texts IS NOT INITIAL.

LOOP AT l_t_texts INTO l_wa_texts.

Call function module to obtain values for Selection and First Line

CALL FUNCTION 'READ_TEXT'

EXPORTING

client = sy-mandt

id = l watexts-tdid

language = c_lang

name = CUSTOMER

object = 'KNA1',

TABLES

lines = l_t_texts2

EXCEPTIONS

id = 1

language = 2

name = 3

not_found = 4

object = 5

reference_check = 6

wrong_access_to_archive = 7

OTHERS = 8.

Re: Text field - Table Name

Former Member — Fri, 15 Dec 2006 14:21:03 GMT

Solveit on my own using Function Modules.