topic report help 3 in Application Development and Automation Discussions

report help 3

Former Member — Mon, 18 Jun 2007 11:10:44 GMT

a report which lists the delivery no, delivery qty, customer no, material no, material description for the given shipping points.

Re: report help 3

Former Member — Mon, 18 Jun 2007 11:21:37 GMT

Use the Delivery tables LIKP and LIPS and take the required fields and develop

Its easy, since the data is from two tables

write a single join and fetch the data into Int table and display

Reward points for useful Answers

Regards

Anji

Re: report help 3

Former Member — Mon, 18 Jun 2007 11:40:39 GMT

Please go though the link for the sap script with example of all the Attribute ,elements .

Header

pages

windows

page windows

paragraph formats

character formats

Documentation

<a href="http://">http://www.thespot4sap.com/Articles/SAPscript_example_layout%20set.asp</a>

reward points if it is usefull ...

Girish

Re: report help 3

Former Member — Mon, 18 Jun 2007 11:42:09 GMT

sorry by misake i posted another forums answer.

Girish

Re: report help 3

Former Member — Mon, 18 Jun 2007 11:47:49 GMT

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