Problem in Read_text function Module

[Former Member]

Hi,

I tried to retrieve the text by using READ_TEXT function module, it reads garbage values with the text value.

In read text iam passing textid, object, name and Language

Regards,

Sreedhar.T

[jayanthi_jayaraman]

Hi,

Check the sample code here.

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/read_text-function-1271397

[Former Member]

Hi,

Now i found exactly where this garbage value is coming, it is available in database level itself.

My Question is " i need the text 'test' in the field tdline but iam getting "test ####&^*()77' like this.

any code is available for removing this garbage values and one more point is iam not sure how much length they are using to define the text, it may be 3 chars or 30 chars.

Please advice on this. it is possible or not?

Regards,

Sreedhar

[Former Member]

Hello,

Check the STXH table for the entries you passed to the FM.

If u get data for that entry in the table then defienetly the FM will return the coreect text.

If useful reward.

Vasanth

[Former Member]

Hi,

Now i found exactly where this garbage value is coming, it is available in database level itself.

My Question is " i need the text 'test' in the field tdline but iam getting "test ####&^*()77' like this.

any code is available for removing this garbage values and one more point is iam not sure how much length they are using to define the text, it may be 3 chars or 30 chars.

Please advice on this. it is possible or not?

Regards,

Sreedhar

[Former Member]

hi

good

go through this

TABLES: PBIM.

• stxh, stxl, stxb - trans tables for text

• ttxit - text on text-ids

• ttxot - Short texts on text objects

• Transaction MD63

SELECT-OPTIONS: S_MATNR FOR PBIM-MATNR,

S_WERKS FOR PBIM-WERKS.

DATA: BEGIN OF HTEXT.

INCLUDE STRUCTURE THEAD.

DATA: END OF HTEXT.

DATA: BEGIN OF LTEXT OCCURS 50.

INCLUDE STRUCTURE TLINE.

DATA: END OF LTEXT.

DATA: BEGIN OF DTEXT OCCURS 50.

DATA: MATNR LIKE PBIM-MATNR.

INCLUDE STRUCTURE TLINE.

DATA: END OF DTEXT.

DATA: TNAME LIKE THEAD-TDNAME.

SELECT * FROM PBIM WHERE WERKS IN S_WERKS.

MOVE PBIM-BDZEI TO TNAME.

CALL FUNCTION 'READ_TEXT'

EXPORTING

• CLIENT = SY-MANDT

ID = 'PB'

LANGUAGE = 'E'

NAME = TNAME

OBJECT = 'PBPT'

• ARCHIVE_HANDLE = 0

IMPORTING

HEADER = HTEXT

TABLES

LINES = LTEXT

EXCEPTIONS

ID = 1

LANGUAGE = 2

NAME = 3

NOT_FOUND = 4

OBJECT = 5

REFERENCE_CHECK = 6

WRONG_ACCESS_TO_ARCHIVE = 7

OTHERS = 8.

LOOP AT LTEXT.

IF LTEXT-TDLINE NE ''.

MOVE LTEXT-TDLINE TO DTEXT-TDLINE.

MOVE PBIM-MATNR TO DTEXT-MATNR.

APPEND DTEXT.

ENDIF.

ENDLOOP.

ENDSELECT.

LOOP AT DTEXT.

WRITE:/ DTEXT-MATNR, DTEXT-TDLINE.

ENDLOOP.

thanks

mrutyun^

[Former Member]

Hi,

Now i found exactly where this garbage value is coming, it is available in database level itself.

My Question is " i need the text 'test' in the field tdline but iam getting "test ####&^*()77' like this.

any code is available for removing this garbage values and one more point is iam not sure how much length they are using to define the text, it may be 3 chars or 30 chars.

Please advice on this. it is possible or not?

Regards,

Sreedhar

[Former Member]

Hi Sreedhar

I guess the problem is due to some exceptional characters which can not be identified by the code page you are using.

Please check the same...

Kind Regards

Eswar