10-09-2007 2:03 PM
I am doing some inventory report .
In that i am fetching data from database table mkpf to internal table it_mkpf .my select statement is
SELECT MBLNR BLART BUDAT FROM MKPF
INTO TABLE IT_MKPF
WHERE BUDAT IN R6 .
-
r6 is ranges
the problem is i am getting all records.means it's not checking that budat condition.
can anybody tell me what is the problem in my statement?
Regards
Lalitha.
10-09-2007 2:09 PM
Hi,
Can u paste ur code , in particular ranges R6 and internal table structure.
Rvert back.
Regards,
naveen
10-09-2007 2:09 PM
Hi
Check the declartiopn of the Range and move the value to low high option if you multiple then BT single value EQ and sign as I
append it
Regards
Shiva
10-09-2007 2:09 PM
Hi,
Can u paste ur code , in particular ranges R6 and internal table structure.
Rvert back.
Regards,
naveen
10-09-2007 2:19 PM
PARAMETERS:KEYDATE LIKE SY-DATUM.
-
DATA:BEGIN OF IT_MKPF OCCURS 0,
MBLNR LIKE MKPF-MBLNR,
BLART LIKE MKPF-BLART,
BUDAT LIKE MKPF-BUDAT,
END OF IT_MKPF.
-
RANGES: R1 FOR SY-DATUM,
R2 FOR SY-DATUM,
R3 FOR SY-DATUM,
R4 FOR SY-DATUM,
R5 FOR SY-DATUM,
R6 FOR SY-DATUM.
-
R6-SIGN = 'I'.
R6-OPTION = 'BT'.
R6-LOW = R5-HIGH.
R6-HIGH = KEYDATE.
-
thank you.
Lalitha.
10-09-2007 2:25 PM
Hi,
Code seems to be ok, but i think you are not appending it.
PARAMETERS:KEYDATE LIKE SY-DATUM.
----------------
DATA:BEGIN OF IT_MKPF OCCURS 0,
MBLNR LIKE MKPF-MBLNR,
BLART LIKE MKPF-BLART,
BUDAT LIKE MKPF-BUDAT,
END OF IT_MKPF.
---------------------
RANGES: R1 FOR SY-DATUM,
R2 FOR SY-DATUM,
R3 FOR SY-DATUM,
R4 FOR SY-DATUM,
R5 FOR SY-DATUM,
R6 FOR SY-DATUM.
--------------------------------
R6-SIGN = 'I'.
R6-OPTION = 'BT'.
R6-LOW = R5-HIGH.
R6-HIGH = KEYDATE.
APPEND R6.
-------------------
Thanks,
Sriram Ponna.
10-09-2007 2:37 PM
10-09-2007 2:20 PM
Hi,
Keep a break point and debug the program, check whether are there any entries in the R6?
Please provide your code so that we can suggest you some solution.
Thanks,
Sriram Ponna.