Skip to Content
0
Former Member
Apr 25, 2014 at 05:13 AM

Error in Select query

68 Views

Hi ,

In my select query

SELECT BELNR

VBELN

FKDAT

NETWR

BUKRS

WAERK

GJAHR

from vbrk

INTO TABLE it_vbrk

where vbeln in s_vbeln

and gjahr in s_gjahr

and fkdat in s_fkdat

and bukrs = p_bukrs.

IF not it_vbrk[] is INITIAL.

SELECT vbeln

volum

voleh

matnr

arktx from vbrp

INTO TABLE it_vbrp

FOR ALL ENTRIES IN it_vbrk

where vbeln = it_vbrk-vbeln.

endif.

IF NOT it_vbrk[] is INITIAL.

SELECT BUKRS

BELNR

GJAHR

BLART

BLDAT

XBLNR

from bkpf

INTO TABLE it_bkpf

FOR ALL ENTRIES IN it_vbrk

where bukrs = it_vbrk-bukrs

AND xblnr = it_vbrk-vbeln

and bstat <> 'A'.

ENDIF.


Getting error 'When you use the additional 'FOR ALL ENTRIES IN itab' the fields 'XBLNR'. and the 'IT_VBRK-VBELN' must have same type and same length'.