topic select statement for table with workarea and using INTO workarea in Application Development and Automation Discussions

select statement for table with workarea and using INTO workarea

Former Member — Fri, 31 Dec 2010 04:50:31 GMT

Hi Experts,

I have declared a table with workarea. Whenever i do a 'select single' statement, that workarea gets filled. But, i want to avoid this for one scenario. so, when i use 'select single * from <table> into <wa>', will it fill the external work area and will it not disturb the internal workarea of that table ? as, i require to compare the old and new value of same table in a module pool programming.

Thanks,

Gaurav.

Re: select statement for table with workarea and using INTO workarea

Former Member — Fri, 31 Dec 2010 04:57:50 GMT

Hi,

The entries will not be disturbed until you clear them or move some other values into the work area.

Regards,

Srini.

Re: select statement for table with workarea and using INTO workarea

Former Member — Fri, 31 Dec 2010 06:51:30 GMT

Hi Gaurav,

Assume u have an internal table and a separate work area.

data: it_outtab type table of mara with header line,
 wa_outtab type mara.

assume the workarea of it_outtab already has some data you require.

If you use the below code, the table's workarea will be filled with new values.

select single * from mara  into it_outtab.

If you use the below code, the table's workarea will contain the old values and new values will be placed in wa_outtab..

select single * from mara  into wa_outtab.

Regards,

Jovito.

Re: select statement for table with workarea and using INTO workarea

matt — Fri, 31 Dec 2010 08:02:50 GMT

By table with workarea, do you mean a table with a header line? Because tables with headerlines are obsolete, ambiguous and should no longer be used (Exception - some older parts of SAP require them). So you should define your work area seperately, and have an internal table without a header line. Then you won't have confusion over whether the reference is to a table or the workarea.

If your table doesn't have a header line then your question makes no sense to me.

matt