Usage of 2 Ranges in select statement
Hi friends ...
iam encountering a problem like this ......
Iam selecting values from COSS table for a range of projects and a range of cost elements (KSTAR)
My statement is as follows :
*****************************
SELECT OBJNR KSTAR WOG001 WOG002 WOG003 WOG004 WOG005 WOG006
WOG007 WOG008 WOG009 WOG010 WOG011 WOG012
FROM COSS APPENDING TABLE T_COSS
WHERE LEDNR = X_LEDNR
AND OBJNR IN R_OROBJNR_IN_COUNT " -low
AND GJAHR = P_FYEAR
AND WRTTP = X_WRTTP
AND KSTAR IN R_SETLEAF.
******************************************
Here
1. R_OROBJNR_IN_COUNT => contains some 50 data ( all its option = 'EQ'
2. R_SETLEAF => contains cost elements ( one OPTION is 'BT' and all the others are 'EQ'
My Problem is :
This query is not returning the values from COSS for those cost elements which are in 'BT' values
Expecting ur answers;-)
Thanks in advance
Cheers,
R.Kripa.