Reading LCHR from database

tabraiz_khan — Thu, 07 Jan 2010 19:25:01 GMT

Hi,

I'm reading a LCHR field from my table with a SELECT statement.

The value i get seems to be truncated.

Is there any other way i could use to read the whole data?

Will READ_TEXT work?

Thanks,

Tabraiz

Re: Reading LCHR from database

kesavadas_thekkillath — Thu, 07 Jan 2010 19:34:04 GMT

LCHR is a character string of any length ...

So you can try creating a text object and text id in se75 and try with read_text.

Im not sure about this..

Re: Reading LCHR from database

miguel_silva3 — Thu, 30 Jan 2014 22:05:46 GMT

You have a limitation of 255 characters on every alv that you use to show the results.

So you have to export the data from the database table.

Let's try to explain:

You have a database table with 2 fields (e.g.)

LENT TYPE INT2 (2 Byte Integer (Signed)), this field itis used for save the length of the LCHR field

ERROR_MESSAGE TYPE SMO_1500 LCHR (character 1500), this field it's used for save the string value with 1500 character.

You can't read this data with the TCODE SE16 or SE16N or SE11, because exist a limitation of 255 character on ALV tables.

Create a report like that to export the data to a file:

SELECT *
     FROM zsrm_wlu_004
     INTO TABLE lt_zsrm_wlu_004
    WHERE wi IN s_wi AND
          ano IN s_ano AND
          wi_aagent IN s_agent .

CALL FUNCTION 'GUI_DOWNLOAD'
     EXPORTING
       filename                        = p_file_download
      filetype                        = 'ASC'
     TABLES
       data_tab                        = lt_zsrm_wlu_004

topic Re: Reading LCHR from database in Application Development and Automation Discussions

Reading LCHR from database

Re: Reading LCHR from database

Re: Reading LCHR from database