09-30-2008 10:00 AM
hi all,
i m making a report but problem is that when i m passing the single value then its also picking the records for others values also. can anyone tell me the exact prob?
code.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS: KUNNR FOR VBAK-KUNNR,
VKBUR FOR VBAK-VKBUR.
SELECTION-SCREEN END OF BLOCK B1.
SELECT VKBUR KUNNR VTWEG CASSD AUFSD LIFSD FAKSD FROM KNVV INTO CORRESPONDING FIELDS OF TABLE ITAB
WHERE KUNNR IN KUNNR AND VKBUR IN VKBUR
AND CASSD = 'X' OR AUFSD NE '' OR AUFSD NE '' OR LIFSD NE ''
OR FAKSD NE ''.
this is the code.
regards saurabh.
09-30-2008 10:03 AM
Hi,
Try using the brackets in the select query.
Eg:
SELECT VKBUR KUNNR VTWEG CASSD AUFSD LIFSD FAKSD FROM KNVV INTO CORRESPONDING FIELDS OF TABLE ITAB
WHERE KUNNR IN KUNNR AND VKBUR IN VKBUR
AND ( CASSD = 'X' OR AUFSD NE '' OR AUFSD NE '' OR LIFSD NE ''
OR FAKSD NE '' ).
Regards,
Surinder
09-30-2008 10:03 AM
Hi,
Try using the brackets in the select query.
Eg:
SELECT VKBUR KUNNR VTWEG CASSD AUFSD LIFSD FAKSD FROM KNVV INTO CORRESPONDING FIELDS OF TABLE ITAB
WHERE KUNNR IN KUNNR AND VKBUR IN VKBUR
AND ( CASSD = 'X' OR AUFSD NE '' OR AUFSD NE '' OR LIFSD NE ''
OR FAKSD NE '' ).
Regards,
Surinder
09-30-2008 10:03 AM
Please check the select-options.
Kindly check if any range is defiined.
the other case in which it will fetch multiple records is when both select-options are empty.
Hope this helps
Raj
09-30-2008 10:11 AM
hai,
it is good to validate select-option in at selection-screen itself.
if select-option range is not in table, then while passing it to select query u will be getting whole record from table.
so try to validate it first.
shan.