topic Re: Work Area......... in Application Development and Automation Discussions

Work Area.........

Former Member — Wed, 07 Feb 2007 09:17:02 GMT

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

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:18:45 GMT

use INTO TABLE

select * from ekko

into<b> TABLE</b> t_ekko

where EKGRP<>'SUB'.

Re: Work Area.........

andreas_mann3 — Wed, 07 Feb 2007 09:19:00 GMT

hi,

use t_ekko type ekko

select... into coressponding fileds of t_ekko

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:20:55 GMT

hi somnath,

in u r select query

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

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:21:14 GMT

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

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:21:48 GMT

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

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:25:20 GMT

Hi,

Modify your query as follw,

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

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:25:30 GMT

Hi,

Modify your query as follw,

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

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:26:20 GMT

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

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:30:46 GMT

even then the same message is thrown

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:31:01 GMT

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.

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:32:29 GMT

No ram it didnot work.

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:36:21 GMT

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

Re: Work Area.........

Former Member — Wed, 07 Feb 2007 09:38:02 GMT

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