05-28-2008 7:58 AM
Hi all,
This is the select stmt i have written in the Program lines of Smartform.
SELECT VKORG VBELN FKTYP VTWEG
FROM VBRK
INTO TABLE ITAB
WHERE VBELN BETWEEN '0090022987' AND
'0090023500'.
but i am geting the output like this, even though i have all the records
in the VBRK Table.
VKORG VBELN FKTYP VTWEG
0090022987 1
0090022988 R
0090022989 R
0090022990 R
0090022991 R
But the Actual values of FKTYP are
1000 ,but in the output it is appearing as 1
R300, but in the output it is appearing as R.
and rest of fields(vkorg vtweg) are not displaying.
What could be the cause of Error ?
Even tough i have changed the width of cells in the Table, still i am getting the same .
Thanks in advance
Krupali...
05-28-2008 8:33 AM
Hi KR
Plz try the following
check your ITAB declaration ( the size of the fields)
(ii) SELECT...... INTO CORRESPONDING FIELDS OF TABLE ITAB.
if the problem still persists, plz put your code here (esp. ITAB declaration part).
reward if usefull.
Regards
Prabumanoharan
05-28-2008 8:33 AM
Hi KR
Plz try the following
check your ITAB declaration ( the size of the fields)
(ii) SELECT...... INTO CORRESPONDING FIELDS OF TABLE ITAB.
if the problem still persists, plz put your code here (esp. ITAB declaration part).
reward if usefull.
Regards
Prabumanoharan
05-28-2008 8:41 AM
HI Prabhu,
my isssue hasbeen solved by using into corresponding fields of table itab.
Thank you very much.
Points hasben awarded
05-28-2008 8:38 AM
Hi,
1.Increase the text element declared window size.
2.Then those values will come.
regards,
Shiva KUmar