Skip to Content
0
Former Member
Apr 15, 2014 at 07:40 AM

Error in joining 3 internal tables

30 Views

Hi,

Getting error while joing 3 internal tables

START-OF-SELECTION.

SELECT belnr

vbeln

fkdat

netwr

bukrs from vbrk

INTO TABLE it_vbrk

* where bukrs in p_bukrs

where vbeln in s_vbeln

and gjahr in s_gjahr

and fkdat in s_fkdat.

IF it_vbrk[] is INITIAL.

SELECT vbeln

volum

* vloeh

matnr

arktx from vbrp

INTO TABLE it_vbrp

FOR ALL ENTRIES IN it_vbrk

where vbeln = it_vbrk-vbeln.

SELECT belnr

bschl

hkont from bseg

FOR ALL ENTRIES IN it_vbrk

WHERE belnr = it_vbrk-belnr.

ENDIF.