topic Update range from a data in a table in Application Development and Automation Discussions

Update range from a data in a table

Former Member — Thu, 15 Oct 2009 11:01:14 GMT

Hi,

I need to update a range with records from a Z table to use in a select statement.

I've this

Ranges: r_lfart for likp-lfart.

*RPimenta(14.10.2009)-actualiza range a partir da ZSD_LFART_TROCAS

SELECT LFART INTO r_lfart from

zsd_lfart_trocas.

move 'I' to r_lfart-sign.

move 'EQ' TO r_lfart-option.

COLLECT r_lfart.

ENDSELECT.

to use at this select statement

SELECT a_{vbeln a}vkorg a_{lfart b}posnr b_{mfrgr b}uecha

INTO CORRESPONDING FIELDS OF TABLE l_itab_1_aux

FROM likp AS a INNER JOIN lips AS b

ON a_{vbeln = b}vbeln

WHERE a~vbeln EQ i_xblnr and

*RPimenta(14.10.2009)-actualiza range a partir da ZSD_LFART_TROCAS

a~lfart in r_lfart.

But i've sure that update for range is wrong.

Can somebody help me ? Thanks...

Re: Update range from a data in a table

Former Member — Thu, 15 Oct 2009 11:08:47 GMT

Hello


SELECT LFART INTO r_lfart-low from " <- must be r_lfart-low instead of r_lfart
zsd_lfart_trocas.
move 'I' to r_lfart-sign.
move 'EQ' TO r_lfart-option.
COLLECT r_lfart.
ENDSELECT.

Re: Update range from a data in a table

Former Member — Thu, 15 Oct 2009 11:10:11 GMT

You could do this with a simple for all entries select query



data: begin of itab occurs 0,
         lfart type zsd_lfart_trocas-lfart,
         end of itab.


select lfart
into table itab
from zsd_lfart_trocas.


if not itab[] is initial.
SELECT a~vbeln a~vkorg a~lfart b~posnr b~mfrgr b~uecha
INTO CORRESPONDING FIELDS OF TABLE l_itab_1_aux
FROM likp AS a INNER JOIN lips AS b
ON a~vbeln = b~vbeln
for all entries in itab
WHERE a~vbeln EQ i_xblnr and
*RPimenta(14.10.2009)-actualiza range a partir da ZSD_LFART_TROCAS
a~lfart = itab-lfart.
endif.

Vikranth