Join statement with for all entries

[Former Member]

Hi

Can I write a Inner join with for all entires of some X itab?

Thanks

Kiran

[Former Member]

Hi

Can I write a Inner join with for all entires of some X itab?

Thanks

Kiran

[Former Member]

Yes

[Former Member]

My Local Kunnr itab structure:

TYPES: BEGIN OF l_t_kunnr,

kunnr TYPE kna1-kunnr,

END OF l_t_kunnr,

My normal kunnr tab structure:

TYPES: BEGIN OF t_kna1, " Customer Master data

kunnr TYPE kna1-kunnr,

adrnr TYPE kna1-adrnr,

ktokd TYPE kna1-ktokd,

loevm TYPE kna1-loevm,

cstat TYPE knkk-crblb,

END OF t_kna1,

My Join Stmt:

SELECT a~kunnr " Customer no

a~adrnr " Address no

a~ktokd " Customer type

a~loevm " deletion key

FROM kna1 as a inner join knvv as b

on a_{kunnr eq b}kunnr

INTO TABLE i_kna1

for all entries in l_i_kunnr[]

WHERE a~kunnr IN l_i_kunnr

and b~vkorg in s_vkorg.

It gives me an error that line structure of my local kunnr itab is incorrect.

Pl lemme know

Thanks

Kiran

[Former Member]

hi,

Change your code ... as shown below

SELECT a~kunnr " Customer no

a~adrnr " Address no

a~ktokd " Customer type

a~loevm " deletion key

FROM kna1 as a inner join knvv as b

on a_{kunnr eq b}kunnr

INTO TABLE i_kna1

for all entries in l_i_kunnr

WHERE a~kunnr = l_i_kunnr-kunnr

and b~vkorg in s_vkorg.

[Former Member]

hi,

Also check if the table is empty or not statement ...

if not i_kna1[] is initial.

SELECT a~kunnr " Customer no

a~adrnr " Address no

a~ktokd " Customer type

a~loevm " deletion key

FROM kna1 as a inner join knvv as b

on a_{kunnr eq b}kunnr

INTO TABLE i_kna1

for all entries in l_i_kunnr

WHERE a~kunnr = l_i_kunnr-kunnr

and b~vkorg in s_vkorg.

endif.

[Former Member]

yes it is possible, you can combine joins and for all entries together. make sure when you are using the for all entries , you check the table initial condition, and also take temp table , assign all value to it. delete the duplicates and use this in for all entries.