topic Re: SELECT QUERY in Application Development and Automation Discussions

SELECT QUERY

Former Member — Thu, 10 Jan 2008 05:21:34 GMT

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?

Re: SELECT QUERY

Former Member — Thu, 10 Jan 2008 05:24:34 GMT

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

Re: SELECT QUERY

Former Member — Thu, 10 Jan 2008 05:28:19 GMT

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

Re: SELECT QUERY

Former Member — Thu, 10 Jan 2008 05:31:09 GMT

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 .

Re: SELECT QUERY

Former Member — Thu, 10 Jan 2008 05:32:14 GMT

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

Re: SELECT QUERY

Former Member — Thu, 10 Jan 2008 05:35:02 GMT

Hi ,

Please check if S_BUKRS and S_LIFNR are defined as select-options on your selection screen.

Regards,

Mohaiyuddin

Re: SELECT QUERY

Former Member — Thu, 10 Jan 2008 05:35:15 GMT

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..