topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Wed, 07 Nov 2007 04:18:17 GMT

Hi gurus,

I have used following select statemenet and I ma getting this error, The work area "IT_T158B" is not long enough .can you please tell me what is the problem :

data : begin of it_t158b occurs 0,

tcode like t158b-tcode,

bwart like t158b-bwart,

end of it_t158b.

SELECT single * FROM T158B

into it_t158b WHERE TCODE = MIGO

AND BWART = 261.

Re: Select statement

Former Member — Wed, 07 Nov 2007 04:19:45 GMT

It should be

U should declare a work area not internal table like

data : it_t158b like T158B.

SELECT single * FROM T158B

into it_t158b WHERE TCODE = MIGO

AND BWART = 261.

Thanks

Vasudha

Message was edited by:

Vasudha L

Message was edited by:

Vasudha L

Re: Select statement

Former Member — Wed, 07 Nov 2007 04:20:49 GMT

structure miss match

data : begin of it_t158b occurs 0,

tcode like t158b-tcode,

bwart like t158b-bwart,

end of it_t158b.

this correct one

SELECT single tcode bwart FROM T158B

into it_t158b WHERE TCODE = MIGO

AND BWART = 261.

Re: Select statement

gopi_narendra — Wed, 07 Nov 2007 04:21:37 GMT

If you are using single * you can not use into table


data : IS_T158B type T158B.
SELECT single * FROM T158B
into IS_t158b WHERE TCODE = MIGO
AND BWART = 261.

Regards

Gopi

Re: Select statement

Former Member — Wed, 07 Nov 2007 04:22:50 GMT

HI thanks for the reply but now i am getting this error:

Field "TABLE" is unknown. It is neither in one of the specified tables

Thanks

Rajeev

Re: Select statement

Former Member — Wed, 07 Nov 2007 04:24:11 GMT

Declare it as a work area as i have edited and in the declaration part of ur prgram add this:

TABLES: T158B.

Thanks

Vasudha

Reward points if found useful.

Message was edited by:

Vasudha L

Re: Select statement

Former Member — Wed, 07 Nov 2007 04:42:06 GMT

Hi Rajeev,

Try this code and I hope it will work 4 u...

reward points if helpful....

data : begin of it_t158b occurs 0,

tcode like t158b-tcode,

bwart like t158b-bwart,

end of it_t158b.

SELECT single tcode bwart FROM T158B

into it_t158b WHERE TCODE = MIGO

AND BWART = 261.

Thanks,

Ashish

Re: Select statement

Former Member — Wed, 07 Nov 2007 05:01:59 GMT

Hi Rajeev,

Delete the occurs 0 statement from data declaration

Change the code to the following:

data : begin of wa_t158b,

tcode type t158b-tcode,

bwart type t158b-bwart,

end of wa_t158b.

SELECT SINGLE tcode bwart

FROM T158B

INTO wa_t158b

WHERE TCODE = MIGO

AND BWART = 261.

The first error occurs because you use "*" in the select clause, it will cause all fields to be selected, while the structure you defined only containes two fields which is TCODE and BWART. The structure and what is selected must match.

The second error, since you are using select single, which is only going to result in one record, you cannot put the result in a table, simply put it in a structure by omitting the "TABLE" from your select statement.