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?