topic Re: internal table error in Application Development and Automation Discussions

internal table error

Former Member — Tue, 21 Oct 2008 04:31:44 GMT

first i populated internal table itab-vbak where p_vbeln is a select option

SELECT vbeln

vkorg

vtweg

spart

erdat

kunnr

into corresponding fields of TABLE itab_vbak

FROM vbak

WHERE vbeln IN p_vbeln.

and then itab-kna1

SELECT kunnr

name1

ort01

land1

pstlz

INTO corresponding fields of TABLE itab_kna1

FROM kna1

FOR ALL ENTRIES IN itab_vbak

WHERE kunnr IN itab_vbak-kunnr.

but while activating i am getting error

the IN operator with itab_vbak-kunnr is follwoed neither by an internal table nor by a value list.

Re: internal table error

Former Member — Tue, 21 Oct 2008 04:33:41 GMT

hi,

SELECT kunnr

name1

ort01

land1

pstlz

INTO corresponding fields of TABLE itab_kna1

FROM kna1

FOR ALL ENTRIES IN itab_vbak

WHERE kunnr = itab_vbak-kunnr.

Make the above change . It will work fine..

Rgds.,

subash

Re: internal table error

Former Member — Tue, 21 Oct 2008 04:33:49 GMT

you can't use in clause for for all entries

replace in with =

mukesh aggarwal

Re: internal table error

Former Member — Tue, 21 Oct 2008 04:35:57 GMT

Hi,

The itab_vbak-kunnr denotes a single KUNNR value whereas it should actually be a range or an internal table containing number of KUNNR values. Thats why its throwing the error.

You need to take all the kunnr values from you table populate it in a range and then use it after IN operator.

Thanks

Vasudha

Re: internal table error

Former Member — Tue, 21 Oct 2008 04:38:40 GMT

Hi,


WHERE kunnr = itab_vbak-kunnr.

Try it..

Re: internal table error

Former Member — Tue, 21 Oct 2008 04:40:18 GMT

Hi,

Find the corrected code below.

SELECT vbeln

vkorg

vtweg

spart

erdat

kunnr

into corresponding fields of TABLE itab_vbak

FROM vbak

WHERE vbeln IN p_vbeln.

if not itab_vbak is initial.

SELECT kunnr

name1

ort01

land1

pstlz

INTO corresponding fields of TABLE itab_kna1

FROM kna1

FOR ALL ENTRIES IN itab_vbak

WHERE kunnr IN itab_vbak-kunnr.

endif.

This should work

Re: internal table error

Former Member — Tue, 21 Oct 2008 04:45:45 GMT

Hi Vishal,

Use the code.


SELECT kunnr
name1
ort01
land1
pstlz
INTO corresponding fields of TABLE itab_kna1
FROM kna1
FOR ALL ENTRIES IN itab_vbak
WHERE kunnr IN kunnr.

Thanks,

Chidanand

Re: internal table error

Former Member — Tue, 21 Oct 2008 04:48:17 GMT

Hi,

In operator can be used when you are populating the internal table with reference to Select-options

When you are populating the internal table with reference to other internal table variable ' = ' operator should be used

Re: internal table error

Former Member — Tue, 21 Oct 2008 04:52:27 GMT

thanks

Re: internal table error

Former Member — Tue, 21 Oct 2008 05:02:05 GMT

Hi,

U can make a small change in query as :

SELECT kunnr

name1

ort01

land1

pstlz

INTO corresponding fields of TABLE it_kna1

FROM kna1

FOR ALL ENTRIES IN it_vbak

WHERE kunnr = it_vbak-kunnr.

Because for all entries will take all the data and will iterate till all the data is visisted.