Skip to Content
-1
Jun 19, 2018 at 02:46 PM

Pass data from internal table column to IN operator parameters

292 Views

fm.png

Hello everybody,

I try to use data from internal table column for IN operator parameters. Example:

INTERNAL TABLE lt_level0:


KUNNR | HKUNNR

0000003019 | xxxxxxxxxxx

0000006200 | yyyyyyyyyyy

The output should be the same given by:

Select distinct knvh~kunnr knvh~hkunnr from knvh INTO CORRESPONDING FIELDS OF TABLE lt_level1 where knvh~hkunnr in ('0000003019','0000006200').

But I want something like:

Select distinct knvh~kunnr knvh~hkunnr from knvh INTO CORRESPONDING FIELDS OF TABLE lt_level1 where knvh~hkunnr in (lt_level0-kunnr)

Do exist something to achieve this?

Attachments

fm.png (26.8 kB)