Skip to Content
0
Former Member
Apr 21, 2014 at 04:59 AM

Reading data's using 3 internal table

36 Views

Hi,

I am joing 3 internal table......in the looping part iam having a dbt.....is my looping is correct r not..pls suggest me

SORT it_vbrp.

LOOP AT it_vbrk INTO w_vbrk.

READ TABLE it_vbrp INTO w_vbrp WITH KEY vbeln = w_vbrk-vbeln BINARY SEARCH.

w_final-belnr = w_vbrk-belnr.

w_final-vbeln = w_vbrk-vbeln.

w_final-fkdat = w_vbrk-fkdat.

w_final-netwr = w_vbrk-netwr.

w_final-bukrs = w_vbrk-bukrs.

w_final-waerk = w_vbrk-waerk.

w_final-GJAHR = w_vbrk-GJAHR.

w_final-volum = w_vbrp-volum.

w_final-voleh = w_vbrp-voleh.

w_final-matnr = w_vbrp-matnr.

w_final-arktx = w_vbrp-arktx.

APPEND w_final to it_final.

CLEAR w_final.

ENDLOOP.

SORT it_bseg.

LOOP AT it_vbrk INTO w_vbrk.

READ TABLE it_bseg INTO w_bseg WITH KEY belnr = w_vbrk-belnr BINARY SEARCH.

w_final-belnr = w_bseg-belnr.

w_final-bschl = w_bseg-bschl.

w_final-hkont = w_bseg-hkont.

APPEND w_final to it_final.

CLEAR w_final.

ENDLOOP.