Skip to Content
0
Jan 28, 2009 at 11:04 AM

Select-options problem

34 Views

hi guru's,

i m passing 4 values of HKONT in select options and i want to pic some fields from BSIS table.

but problem is that i m getting only 2 HKONT values in itab according to where condition while i need the other 2 HKONT must be there in itab. so i need total 4 rows in ITAB even we dont get values for other 2 from BSIS.

code.

SELECT bukrs hkont gjahr monat shkzg prctr FROM bsis INTO table itab

WHERE hkont in hkont

AND bukrs IN bukrs

AND prctr IN prctr

AND gjahr IN gjahr

AND monat IN monat.

regards Saurabh.