Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

report problem

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.

Tags:
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question