2007 Oct 01 5:29 AM
Hi,
I am using,
SELECT SINGLE * FROM ska1 WHERE
ktopl = 'TIPF'
AND saknr = gs_line_item-newko.
IF sy-subrc = 0.
...
endif.
here sy subrc always gives 4. But when i check from databse....the particular entry is present.
2007 Oct 01 5:31 AM
Hi Anurodh,
It can't happen.
There must be some wrong in the data you provided.
Just hard code the value of SAKNR also and try.
Regards,
Atish
Use SAKNR as '0000030010'.
2007 Oct 01 5:33 AM
i have done that also...but no change....still sy-subrc = 0.
my saknr is 30010.
2007 Oct 01 5:35 AM
have u done the READ or FOR ALL ENTRIES?
2007 Oct 01 5:37 AM
thanks atish...its done.
2007 Oct 01 5:38 AM
You need to use FM 'CONVERSION_EXIT_ALPHA_INPUT'.
Pass the SAKNR as importing as well as exporting parameter to this FM.
Then use that in your select query.
2007 Oct 01 5:32 AM
<b>if not gs_line_item is initial.</b>
SELECT SINGLE * FROM ska1
<b>for all entries in gs_line_item</b>
WHERE
Anu,
Try this...
<b>READ TABLE gs_line_item."</b> WITH KEY newko = specify key if needed
if sy-subrc = 0.
reward if helpful,
Karthik
2007 Oct 01 5:40 AM
Just UNPACK the value of saknr before select,
i.e. UNPACK gs_line_item-newko INTO gs_line_item-newko.
Since saknr is of length 10, your value of saknr should be of length 10 during selection.
UNPACK would fill leading spaces with zero.
Raghavendra
Bluesky
