Mar 29, 2007 at 08:40 AM

# problem while using ranges

18 Views

Hi everyone,

In my report i have to restrict some personal subgroup, say E1,E2,E3,E4 ...M7, CT,CX,CU etc.

So what im doing is im giving it in ranges as

R_PERSK-OPTION = 'NE'.

R_PERSK-SIGN = 'I'.

R_PERSK-LOW = 'E1'.

R_PERSK-HIGH = 'M7'.

APPEND R_PERSK.

CLEAR R_PERSK-HIGH.

• R_PERSK-LOW = 'TM'.

• APPEND R_PERSK.

R_PERSK-LOW = 'TN'.

APPEND R_PERSK.

R_PERSK-LOW = 'TH'.

APPEND R_PERSK.

R_PERSK-LOW = 'CT'.

APPEND R_PERSK.

R_PERSK-LOW = 'CX'.

APPEND R_PERSK.

R_PERSK-LOW = 'CU'.

APPEND R_PERSK.

R_PERSK-LOW = 'TE'.

APPEND R_PERSK.

R_PERSK-LOW = 'TF'.

APPEND R_PERSK.

R_PERSK-LOW = 'TG'.

APPEND R_PERSK.

R_PERSK-LOW = 'TK'.

APPEND R_PERSK.

R_PERSK-LOW = 'TA'.

APPEND R_PERSK.

R_PERSK-LOW = 'Z1'.

APPEND R_PERSK.

CLEAR R_PERSK.

SELECT A~PERNR INTO CORRESPONDING FIELDS OF TABLE IT_DETAIL

FROM ( PA0000 AS A INNER JOIN PA0001 AS B

ON APERNR = BPERNR ) INNER JOIN PA0002 AS C

ON APERNR = CPERNR

WHERE APERNR IN S_PERNR AND BBUKRS = P_BUKRS

AND BWERKS IN S_WERKS AND BBTRTL IN S_BTRTL

AND BPERSK IN R_PERSK AND BORGEH IN S_ORGEH

AND B~ABKRS IN S_ABKRS

AND C~GESCH IN P_GENDER

AND AENDDA = '99991231' AND ASTAT2 = '3'

AND B~ENDDA = '99991231'.

Problem is its picking all the datas that i have assigned to R_PERSK. I have to

restrict all those subgroup while fetching the data.

Its urgent ,Plz