Skip to Content
0
Former Member
Jan 08, 2009 at 01:50 PM

How to make SELECT querry to work for CONVERSION EXIT

313 Views

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