Hi ALL ,
Below is my program, while executing the program i am getting only 1 output from all the fields . what step is needed to be added here . If anything wrong in my loop or program steps correct me.
SELECT vbeln erdat ernam auart kunnr ps_psp_pnr INTO CORRESPONDING FIELDS OF TABLE i_vbak FROM vbak WHERE erdat IN Creation AND auart IN Order AND
kunnr IN customer AND
ps_psp_pnr IN Project.
if not i_vbak[] is initial.
select vbeln kdgrp from vbkd into table i_vbkd for all entries in i_vbak
where vbeln = i_vbak-vbeln
AND kdgrp IN Group.
select PSTLZ kunnr from kna1 into table i_kna1 for all entries in i_vbak
where kunnr = i_vbak-kunnr.
select vbeln zssidc from zzvbak into table i_zzvbak for all entries in i_vbak
where vbeln = i_vbak-vbeln
AND zssidc IN SSID .
endif .
Loop at i_vbak.
loop at i_vbkd where vbeln = i_vbak-vbeln.
loop at i_kna1 where kunnr = i_vbak-kunnr.
loop at i_zzvbak where vbeln = i_vbak-vbeln.
MOVE i_vbak-erdat TO i_data-erdat.
MOVE i_vbak-ernam TO i_data-ernam .
MOVE i_vbak-auart TO i_data-auart.
MOVE i_vbak-kunnr TO i_data-kunnr.
MOVE i_vbak-ps_psp_pnr TO i_data-ps_psp_pnr.
MOVE i_vbkd-KDGRP TO i_data-KDGRP.
MOVE i_zzvbak-zssidc TO i_data-zssidc.
MOVE i_kna1-PSTLZ TO i_data-PSTLZ .
APPEND i_data.
ENDLOOP.
ENDLOOP.
ENDLOOP.
ENDLOOP.
write:/ i_data-erdat, i_data-ernam, i_data-auart, i_data-kunnr, i_data-ps_psp_pnr, i_data-KDGRP, i_data-zssidc, i_data-PSTLZ .