Work Area.........

[Former Member]

Hello

while trying to resolve my removal of sub contract cell ,the piece of code given below:-

data: begin of t_ekko occurs 0 ,

ekorg like ekko-ekorg, "Purchasing organization

ekgrp like ekko-ekgrp, "Purchasing group

bedat like ekko-bedat, "Purchasing document date

lifnr like ekko-lifnr, "Vendor

date like ekko-bedat, "PO date.

eknam like t024-eknam, "Description of pur. group

end of t_ekko.

select * from ekko

into t_ekko

where EKGRP<>'SUB'.

I am getting an error:-

The work area ''T_EKKO" is not large enough.Need help as to how about go about it .

Regards

Somnath

[Former Member]

use INTO TABLE

select * from ekko

into<b> TABLE</b> t_ekko

where EKGRP<>'SUB'.

[Former Member]

even then the same message is thrown

[andreas_mann3]

hi,

use t_ekko type ekko

or

select... into coressponding fileds of t_ekko

A.

[Former Member]

hi somnath,

in u r select query

write select * from ekko into corresponding fields of table t_eeko where.....

[Former Member]

Change your select according to this code:

select ekko~ekorg

ekko~ekgrp

ekko~bedat

ekko~lifnr

ekko~bedat

t024~eknam

from ekko

inner join t024 on ekko_{ekgrp = t024}ekgrp

into table t_ekko

where EKKO~EKGRP<>'SUB'.

Regards,

Ravi

[Former Member]

Hi,

Use the statement like

select * from ekko

into <b>table</b> t_ekko

where EKGRP<>'SUB'.

Regards,

Ram

Pls reward all the helpful answers

[Former Member]

No ram it didnot work.

[Former Member]

Hi,

Modify your query as follw,

select * from ekko into TABLE t_ekko where EKGRP<>'SUB'.

[Former Member]

Hi,

Modify your query as follw,

select * from ekko into TABLE t_ekko where EKGRP<>'SUB'.

[Former Member]

Hi,

data: begin of t_ekko occurs 0 ,
ekorg like ekko-ekorg, "Purchasing organization
ekgrp like ekko-ekgrp, "Purchasing group
bedat like ekko-bedat, "Purchasing document date
lifnr like ekko-lifnr, "Vendor
date like ekko-bedat, "PO date.
eknam like t024-eknam, "Description of pur. group
end of t_ekko.

select ekorg
       ekgrp
       bedat
       lifnr
       date
      eknam
      from ekko
into TABLE t_ekko
where EKGRP<>'SUB'.

TBALE is missing.

Also dont use * instead select the fields as above.

Use NE 'SUB' instead of <>. Also specify key field EBELN in the where condtion.

Please reward points and close the theread if ur problem got solved.

Message was edited by:

Judith Jessie Selvi

[Former Member]

Hi,

As you are trying to select all the fields(select *) into t_ekko,you are getting that error.Please check this select statement.

DATA: BEGIN OF t_ekko OCCURS 0 ,

ekorg LIKE ekko-ekorg, "Purchasing organization

ekgrp LIKE ekko-ekgrp, "Purchasing group

bedat LIKE ekko-bedat, "Purchasing document date

lifnr LIKE ekko-lifnr, "Vendor

END OF t_ekko.

SELECT SINGLE ekorg ekgrp bedat lifnr FROM ekko

INTO (t_ekko-ekorg,t_ekko-ekgrp,t_ekko-bedat,t_ekko-lifnr)

WHERE ekgrp <> 'SUB'.

You can try with a similar select statement with all the required fields.

reagrds,

Priya.

[Former Member]

hi try this code.

types:begin of gs_ekko,

ekorg type ekko-ekorg, "Purchasing organization

ekgrp type ekko-ekgrp, "Purchasing group

bedat type ekko-bedat, "Purchasing document date

lifnr type ekko-lifnr, "Vendor

date type ekko-bedat, "PO date.

eknam type t024-eknam, "Description of pur. group

end of gs_ekko.

data: t_ekko type table of gs_ekko.

select * from ekko into corresponding fields of table t_ekko where.......

[Former Member]

Hi Somnath,

If t_ekko is a work area , then u should use

select single * into corresponding fields

if t_ekko is an internal table u should use

select * from ekko into corresponding fields of table

Perfomance wise it is better to specify the field names in the select query and avoid into corresponding fields statement