topic Re: UPDATE INTERNAL TABLE in Application Development and Automation Discussions

UPDATE INTERNAL TABLE

Former Member — Tue, 27 Dec 2005 20:26:25 GMT

Hello,

Is it possible to update an internal table during selection? What I mean is:

If I´m selecting data like this:

SELECT l_{mcod1 l}lifnr l_{stcdt f}bankn f_{bkont f}bankl

INTO CORRESPONDING FIELDS OF TABLE tab_interna

FROM lfa1 AS l INNER JOIN lfbk AS f

ON l_{lifnr = f}lifnr

WHERE l~lifnr IN doc.

I want that if 'l~stdc' is 'CC' saves '1' into the table instead of 'CC', saves '2' instead of 'NN', is it possible to do it in one step?

Thanks for your help,

Greetings

Gabriel P.

Re: UPDATE INTERNAL TABLE

Former Member — Tue, 27 Dec 2005 20:27:53 GMT

Simple answer is 'No'.

Re: UPDATE INTERNAL TABLE

Former Member — Tue, 27 Dec 2005 20:29:59 GMT

But what you can do is add a couple more statements as follows to achieve it.

clear tab_interna-stdc.

tab_interna-stdc = '1'.

modify tab_interna transporting stdc where stdc = 'CC'.

Repeat this for NN also.

Srinivas

Re: UPDATE INTERNAL TABLE

suresh_datti — Tue, 27 Dec 2005 20:30:20 GMT

Hi Gabriel,

in one step NO...

You have to MODIFY the ITAB contents from a work area for each 'l~stdc'.

Regards,

Suresh Datti

Re: UPDATE INTERNAL TABLE

Former Member — Tue, 27 Dec 2005 20:32:37 GMT

Use SELECT ....UP TO 1 ROWS

do your changes here..

APPEND ITAB.

ENDSELECT.

You cannot update while selecting when you use the select statement the way you used in your posting.

Re: UPDATE INTERNAL TABLE

Former Member — Tue, 27 Dec 2005 20:33:11 GMT

No! It's not possible to do that during a select with INTO TABLE option.

But you could do this:

SELECT l_{mcod1 l}lifnr l_{stcdt f}bankn f_{bkont f}bankl

INTO CORRESPONDING FIELDS OF TABLE tab_interna

FROM lfa1 AS l INNER JOIN lfbk AS f

ON l_{lifnr = f}lifnr

WHERE l~lifnr IN doc.

tab_interna-stcdt = '1'.

modify tab_interna transporting stcdt where stcdt = 'CC'.

tab_interna-stcdt = '2'.

modify tab_interna transporting stcdt where stcdt = 'NN'.

Max

Re: UPDATE INTERNAL TABLE

Former Member — Wed, 04 Jan 2006 15:00:59 GMT

You could define a transparent conversion table, let's say zconv.

In our example, zconv would contain two rows:

row 1: in='CC' out='1'

row 2: in='NN' out='2'

SELECT l_{mcod1 l}lifnr c_{out as stcdt f}bankn f_{bkont f}bankl

INTO CORRESPONDING FIELDS OF TABLE tab_interna

FROM lfa1 AS l INNER JOIN lfbk AS f

INNER JOIN zconv as c

ON l_{lifnr = f}lifnr and

c_{in = l}stcdt

WHERE l~lifnr IN doc.

However, you must pay attention to performance issues - if the selection result contains many rows, the additional table in the join would affect the performance.