topic Select Query Problem in Application Development and Automation Discussions

Select Query Problem

Former Member — Wed, 10 Mar 2010 10:58:22 GMT

Hi,

I want to pick the Rate of Excise Duty against Chapter Id from Table j_1iexctax.

We have a problem in picking the Rate because our select query not picking the Rate with right period (means according to Valid From - Valid To)..

Please amend my query...

*SELECT rate FROM j_1iexctax INTO itab6-rate

WHERE j_1ichid = itab5-j_1ichid

AND j_1iexcind = itabc-j_1iexcicu.*

ENDSELECT.

Please insert the condition of Period in my query...

Thanks...

Edited by: Rob Burbank on Mar 10, 2010 9:42 AM

Re: Select Query Problem

venkat_o — Wed, 10 Mar 2010 11:02:10 GMT

Hi, <li>Try this way


  SELECT rate
    FROM j_1iexctax
    INTO itab6-rate
    WHERE j_1ichid = itab5-j_1ichid
    AND j_1iexcind = itabc-j_1iexcicu
    AND validfrom LE sy-datum
    AND validto   GE sy-datum.
  ENDSELECT.

Thanks Venkat.O

Re: Select Query Problem

Former Member — Wed, 10 Mar 2010 11:14:02 GMT

After insertion of this code, debugger not going on this query...

Re: Select Query Problem

Former Member — Wed, 10 Mar 2010 11:44:22 GMT

hi,

use for all enteries on the table.

otherwise yuo have to loop at itab5 and itabc.

and then use the select statement.

SELECT rate FROM j_1iexctax INTO itab6-rate
   WHERE j_1ichid = i*tab5-j_1ichid
  * AND j_1iexcind = *itabc-j_1iexcicu*.
endselect.

Edited by: Rob Burbank on Mar 10, 2010 9:43 AM

Re: Select Query Problem

Former Member — Wed, 10 Mar 2010 12:09:37 GMT

what is the problem in this query..

SELECT rate FROM j_1iexctax INTO itab6-rate

WHERE j_1ichid = itab5-j_1ichid

AND j_1iexcind = itabc-j_1iexcicu AND validfrom LE sy-datum AND validto GE sy-datum.

ENDSELECT.

plz guide.

Edited by: Rob Burbank on Mar 10, 2010 9:43 AM

Re: Select Query Problem

kesavadas_thekkillath — Wed, 10 Mar 2010 16:32:42 GMT

Hi,

You can check this.

The data type of validfrom and validto is of inverted date.

convert the sy-datum to inverted format and try passing in the query.

data:datc type char08.

data:date type sy-datum.

date = sy-datum.

CONVERT DATE date INTO INVERTED-DATE datc.

Re: Select Query Problem

Former Member — Wed, 10 Mar 2010 20:09:21 GMT

It could be an issue with date formats mm/dd/yyyy and dd/mm/yyyy