Skip to Content
0
Former Member
Oct 15, 2009 at 11:01 AM

Update range from a data in a table

472 Views

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 avbeln avkorg alfart bposnr bmfrgr buecha

INTO CORRESPONDING FIELDS OF TABLE l_itab_1_aux

FROM likp AS a INNER JOIN lips AS b

ON avbeln = bvbeln

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