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