how to extract data in text field in AS03

[Former Member]

Dear Experts,

During legacy data upload, i had included some data in the long text field in general tab in AS91(during upload). Now i want to extract that data in long text field from AS03 but whenever i click F1 on that field, the message appear 'No Documentation Available'.

Kindly guide me on how to extract that data as i need to create a report from it.

Your quick response on this regard will be highly appreciated.

[former_member205041 · Accepted solution]

Hi,

do you mean ANLA-TXT50 or do you mean the button "Long texts" in the master data right beside ANLA-TXT50.

How do you want to overtake this long texts via AS91?

regards Bernhard

[Former Member · Accepted solution]

Dear Bernhard,

Yes I want to extract the data from the "Long texts" in the master data right beside ANLA-TXT50. I had uploaded this text earlier through AS91. My client now wants the data to be visible as a report as we have around 40,000 Assets and the data related to all these assets are unique which entered in the above mentioned field.

I am unable to extract that data. Kind advice int his regard...

[ryszard_belec · Accepted solution]

Hi,

CALL FUNCTION 'READ_TEXT'

EXPORTING

ID = XLTX_H-TDID

LANGUAGE = SY-LANGU

NAME = XLTX_H-TDNAME

OBJECT = XLTX_H-TDOBJECT

IMPORTING

HEADER = XLTX_H

TABLES

LINES = TMP_OPIS

***

DATA: BEGIN OF XLTX_H.

INCLUDE STRUCTURE THEAD.

DATA: END OF XLTX_H.

DATA: BEGIN OF TMP_OPIS OCCURS 0.

INCLUDE STRUCTURE TLINE.

DATA: END OF TMP_OPIS.

DATA: BEGIN OF GD_TDNAME,

BUKRS LIKE ANLA-BUKRS,

ANLN1 LIKE ANLA-ANLN1,

ANLN2 LIKE ANLA-ANLN2,

VRSLFD(2) TYPE C,

END OF GD_TDNAME.

XLTX_H-TDOBJECT = 'ANLA'

XLTX_H-TDID = 'XLTX'

'XVER' 'XVER' 'XHER' 'XLEA' 'XKAL' 'XTCH' 'XVRS'

XLTX_H-TDSPRAS = SY-LANGU

XLTX_H-TDNAME = GD_TDNAME.

GD_TDNAME-BUKRS = ANLA-BUKRS.

GD_TDNAME-ANLN1 = ANLA-ANLN1.

GD_TDNAME-ANLN2 = ANLA-ANLN2.

hope it's clear.

Ryszard

[Former Member · Accepted solution]

Dear Ryszard,

Your solution solved the Problem.

Thanks and Regards...