01-10-2008 5:21 AM
SELECT LIFNR
ZTERM
WAERS
BSTAT
ZFBDT
FROM BSIK
INTO
TABLE T_DATA1
WHERE BUKRS IN S_BUKRS
AND LIFNR IN S_LIFNR .
I AM USING THIS QUERY BUT I AM NOT GETTING ANY DATA
MOREOVER ITS SSAYING
The IN operator with "S_BUKRS" is followed neither by an internal table
WHY?
01-10-2008 5:24 AM
HI,
SELECT LIFNR
BUKRS ************
ZTERM
WAERS
BSTAT
ZFBDT
FROM BSIK
INTO
TABLE T_DATA1
WHERE BUKRS IN S_BUKRS
AND LIFNR IN S_LIFNR .
TRY THIS CODE
thx
01-10-2008 5:28 AM
Hi,
I am not sure.
1. It may be u have declared S_BUKRS as parameter in selection-screen. Where claue IN stands for only selet-options.
2. Or U can give the table name from where u have declered S_BUKRS in table declaration part.
EX. SELECT-OPTIONS S_BUKRS FOR BSIK-BUKRS .
So for that case u declare
Tables: BSIK
in ur table decleration statement.
If it is helpfull Pls rewards pts.
Regards
Srimanta
01-10-2008 5:31 AM
Hi,
Try this
SELECT BUKRS
LIFNR
ZTERM
WAERS
BSTAT
ZFBDT
FROM BSIK
INTO
TABLE T_DATA1
WHERE BUKRS IN S_BUKRS
AND LIFNR IN S_LIFNR .
01-10-2008 5:32 AM
HI,
SELECT LIFNR
BUKRS ************
ZTERM
WAERS
BSTAT
ZFBDT
FROM BSIK
INTO
TABLE T_DATA1
WHERE BUKRS IN S_BUKRS
AND LIFNR IN S_LIFNR .
TRY THIS CODE
thx
01-10-2008 5:35 AM
Hi ,
Please check if S_BUKRS and S_LIFNR are defined as select-options on your selection screen.
Regards,
Mohaiyuddin
01-10-2008 5:35 AM
Hi Student,
May be we use parameters.If we use parameter u use EQUAL instead on IN operator.If we use select-optons: follow the below syntax:
tables: bsik.
data: begin of itab occurs 0,
LIFNR like bsik-lifnr,
ZTERM like bsik-zterm,
ZAERS like bsik-zaers,
BSTAT like bsik-bstat,
ZFBDT like bsik-zfbdt,
end of itab.
SELECT LIFNR
ZTERM
WAERS
BSTAT
ZFBDT
FROM BSIK
INTO
TABLE T_DATA1
WHERE BUKRS IN S_BUKRS
AND LIFNR IN S_LIFNR .
Then ur query will works fine now.
Award points if helpful.
Kiran Kumar.G
Have a Nice Day..