here is the program add some more fields for LIPS table as you want ...and in the select query also
REPORT zSAMPLE.
TYPES: BEGIN OF t_output,
salesdoc TYPE vbak-vbeln,
item1 TYPE vbap-posnr,
deldoc TYPE likp-vbeln,
item2 TYPE lips-posnr,
billdoc TYPE vbrk-vbeln,
item3 TYPE vbrp-posnr,
END OF t_output.
DATA: gt_output TYPE STANDARD TABLE OF t_output,
wa_output LIKE LINE OF gt_output.
START-OF-SELECTION.
SELECT vbak~vbeln vbap~posnr likp~vbeln lips~posnr vbrk~vbeln vbrp~posnr
FROM vbak
INNER JOIN vbap
ON vbak~vbeln = vbap~vbeln
INNER JOIN lips
ON lips~vgbel = vbak~vbeln
AND lips~vgpos = vbap~posnr
INNER JOIN likp
ON likp~vbeln = lips~vbeln
INNER JOIN vbrp
ON vbrp~aubel = vbak~vbeln
AND vbrp~aupos = vbap~posnr
INNER JOIN vbrk
ON vbrk~vbeln = vbrp~vbeln
INTO TABLE gt_output.
END-OF-SELECTION.
IF NOT gt_output[] IS INITIAL.
LOOP AT gt_output INTO wa_output.
WRITE: / wa_output-salesdoc,
wa_output-item1,
wa_output-deldoc,
wa_output-item2,
wa_output-billdoc,
wa_output-item3.
ENDLOOP.
ENDIF.
reward points if it is usefull ...
Girish
Bluesky
