Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question