Skip to Content
0
Former Member
Sep 12, 2007 at 10:43 AM

I am getting only 1 output from all the fields.

26 Views

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 .