01-08-2009 1:50 PM
Dear All,
I want to select some data from from table J_1IEXCTAX , and to limit that retrieval I have WHERE clause for fields VALIDFROM and VALIDTO
My select querry is like
SELECT SINGLE RATE ECSRATE
FROM J_1IEXCTAX
INTO (J_1IEXCTAX-RATE,J_1IEXCTAX-ECSRATE)
WHERE J_1ICHID = J_1IMTCHID-J_1ICHID and
( VALIDFROM LE T_GRREC-BUDAT and
VALIDTO GE T_GRREC-BUDAT ).
But the field VALIDFROM and VALIDTO have data (i.e. dates) in different format
So my selection doesnt happen..
these formats can be converted to desired format using CONVERSION EXITs at their domain level...
But that increases coding and worsens performance.....
Could anybody give me some other solution?
Thanks in advance................
Code Formatted by: Alvaro Tejada Galindo on Jan 8, 2009 10:58 AM
01-08-2009 2:02 PM
Hi,
write T_GRREC-BUDAT to gv_date as <specify the format>
now use gv_date in ur seelct query.
Regards,
Nagaraj
01-17-2009 9:04 AM