Skip to Content
0
Former Member
Mar 10, 2010 at 10:58 AM

Select Query Problem

18 Views

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