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.*
Please insert the condition of Period in my query...
Edited by: Rob Burbank on Mar 10, 2010 9:42 AM