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
thanks in advance,
Stanley