07-08-2009 10:01 AM
hi sap,
i have query that in TCODE IW23 the user enters a long text which may 1000 character or 10000.
am not able to fectch everything because in se11 i can give character up to 255.
so what can i do to get the unlimited data that which is entered for the long text.
your help is much appriciated.
regards,
laya.
07-08-2009 10:32 AM
hi
there are two ways.
1. use string type in ur table
2. strore the data using text objects(reg text objects please search in the forum)
regards
Sajid
Edited by: shaik sajid on Jul 8, 2009 11:32 AM
Edited by: shaik sajid on Jul 8, 2009 11:33 AM
07-08-2009 10:34 AM
hi munna,
in this case conform the maximumlength for example 10000.
if the no of char required is 10000 then create another three frelds with char 255 while saving in to the database split the string 255 char and save first 255 char in first field and secone 255 char in second filed as such for all the 4 fields.
while fetching the data concatenate all the four fileds and display as one.
reply for further Query .
regards,
venkat.
07-08-2009 10:42 AM
hi venkat,
thank you for the reply,
for eg : zlongtext is the field which i have so i have declared in the table as 255char.
so in your case where should i declare? am using it in FM.
how can i declare can you be little more clearer pls this is is my code.
DATA : vm_textlines type string.
data : ltext TYPE string.
select QMNUM
TPLNR
QMDAT
EQUNR
STRMN
LTRMN
PRIOK
MSAUS
QMTXT
from viqmel into CORRESPONDING FIELDS OF TABLE ZNOTIFI_DET "ZIOMS_SAP
where qmnum = zQmnum.
loop at ZNOTIFI_DET.
MOVE: ZNOTIFI_DET-qmnum TO tname.
endloop.
endif.
REFRESH textlines.
CALL FUNCTION 'READ_TEXT'
EXPORTING
name = tname
language = sy-langu
object = 'QMEL'
id = 'LTXT'
IMPORTING
header = textheader
TABLES
lines = textlines
EXCEPTIONS
OTHERS = 1.
CONCATENATE LINES OF textlines INTO vm_textlines.
loop at ZNOTIFI_DET.
ZNOTIFI_DET-ZLONGTEXT = vm_textlines.
modify ZNOTIFI_DET.
endloop.
07-08-2009 10:38 AM
other wise change the data type of the field to string.
regards,
venkat.
07-20-2009 8:08 AM