topic Re: report problem in Application Development and Automation Discussions

report problem

Former Member — Tue, 30 Sep 2008 09:00:08 GMT

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.

Re: report problem

Former Member — Tue, 30 Sep 2008 09:03:26 GMT

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

Re: report problem

Former Member — Tue, 30 Sep 2008 09:03:50 GMT

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

Re: report problem

Former Member — Tue, 30 Sep 2008 09:11:33 GMT

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.