topic Interactive Classical Report in Application Development and Automation Discussions

Interactive Classical Report

Former Member — Mon, 09 Jun 2008 21:08:23 GMT

Hi SAP gurus,

My requirement is to add a button on the Output of a Classical report. When any line is selected on the report and the changes have been made in the detail, after coming back to the main list, I should be able to refresh the data by clicking the refresh button.

I used PF-status to put the refresh button on the report but I am not able to drill down into the lines.

Could you help me with this.

Thanks,

Reeta.

Re: Interactive Classical Report

Former Member — Mon, 09 Jun 2008 23:51:54 GMT

Hello,

There is no need of refresh button in the first screen. Once you make changes in the details screen, then transfer those new data into the internal table from the work area and use that table in PBO of first screen.

You can use field command / chain-endchain in PAI of details screen and check what data is changed. Accordingly you can set some flag to update the ITAB.

Rgds,

Anand

Re: Interactive Classical Report

p291102 — Tue, 10 Jun 2008 03:19:38 GMT

Go through the sample report.

REPORT  YMS_INTERACTIVETEST LINE-SIZE 50 NO STANDARD PAGE HEADING.

TABLES: VBAP,KNA1,VBAK.

SELECT-OPTIONS: CUST FOR KNA1-KUNNR.

DATA: BEGIN OF ITAB OCCURS 0,
        KUNNR LIKE KNA1-KUNNR,
        NAME1 LIKE KNA1-NAME1,
        VBELN LIKE VBAK-VBELN,
        AUDAT LIKE VBAK-AUDAT,
        AUART LIKE VBAK-AUART,
        POSNR LIKE VBAP-POSNR,
        POSAR LIKE VBAP-POSAR,
      END OF ITAB.

DATA: ITAB1 LIKE ITAB OCCURS 0 WITH HEADER LINE.

INITIALIZATION.

START-OF-SELECTION.

  SELECT KNA1~KUNNR KNA1~NAME1 INTO CORRESPONDING FIELDS OF TABLE ITAB1
          FROM KNA1 WHERE KNA1~KUNNR IN CUST.

  LOOP AT ITAB1.
    WRITE:/10 ITAB1-KUNNR HOTSPOT, 30 ITAB1-NAME1.
    HIDE: ITAB1-KUNNR.
  ENDLOOP.


AT LINE-SELECTION.

  CASE SY-LSIND.
    WHEN '1'.
      SELECT KNA1~KUNNR VBAK~VBELN VBAK~AUDAT VBAK~ERDAT INTO CORRESPONDING FIELDS OF TABLE ITAB1
      FROM KNA1 INNER JOIN VBAK ON KNA1~KUNNR = VBAK~KUNNR.

      LOOP AT ITAB1.
        WRITE:/ ITAB1-VBELN HOTSPOT, ITAB1-AUDAT, ITAB1-AUART.
        HIDE: ITAB1-VBELN, ITAB1-AUDAT, ITAB1-AUART.
      ENDLOOP.

    WHEN '2'.
      SELECT VBAK~VBELN VBAP~POSNR VBAP~POSAR
      INTO CORRESPONDING FIELDS OF TABLE ITAB1 FROM VBAK INNER JOIN VBAP ON VBAK~VBELN = VBAP~VBELN.
      LOOP AT ITAB1.
        WRITE:/ ITAB1-POSNR, ITAB1-POSAR.
      ENDLOOP.
  ENDCASE.


TOP-OF-PAGE.
  WRITE:/ SY-VLINE,TEXT-001 COLOR COL_NEGATIVE.
  ULINE.

Re: Interactive Classical Report

Former Member — Wed, 11 Jun 2008 13:28:48 GMT

Hi Anand,

Thanks for your response. Basically, from the main list, I am calling SAP transactions. When user, makes any changes to the documents and comes back to the main screen, he should be able to use the refresh button to see the changed information ( the changes made in the details). So I am running the report again when the refresh button is selected. But using PF-status is not letting me get into the details( transactions).

Can anyone help.

Thanks

Reeta.

Re: Interactive Classical Report

Former Member — Thu, 12 Jun 2008 14:03:32 GMT

This issue is resolved. I have added the pick option on the pf-status screen. Now the report works as desired.