interactive report

[Former Member]

i want to develop interactive report for blocked invoices

tables are vbuk and vbup.

what are the fields and how to develop it plz help me

[Former Member]

Why dont you start with the requirements given to you, and post threads when u come across errors??

Nayan

[Former Member]

Hi

Please see the below test program regarding hte interactive report.

&******************Reward Point if helpful**************&

*&---------------------------------------------------------------------*
*& Report  Z_PRICLS
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

report  z_pricls.

tables : zmara,zmakt,zmarc.

data: begin of itab1 occurs 0,
      matnr like zmara-matnr,
      maktx like zmakt-maktx,
      werks like  zmarc-werks,
     end of itab1.

*DATA: WA_ITAB LIKE ITAB1 OCCURS 0.

data: v1(15) type c , v2 like zmara-matnr.

*
*
*SELECTION-SCREEN BEGIN OF BLOCK M1 WITH FRAME TITLE TEXT-001.
*
*selection-screen begin of line.
*  PARAMETERS:MAT_NO LIKE ZMARA-MATNR .
*  selection-screen comment 40(30) text-su9 for field MAT_NO.  "su9 = Clerk
*
*selection-screen end of line.
*
*SELECTION-SCREEN END OF BLOCK M1.

selection-screen begin of block m1 with frame title text-001.

select-options mat_no for zmara-matnr.
select-options plant  for zmarc-werks.
parameters:filepath(30) type c.

selection-screen end of block m1.



  select: a~matnr  b~maktx  c~werks from ( zmara as a inner join
          zmakt as b on a~matnr = b~matnr ) inner join zmarc as c on
          a~matnr = c~matnr into table itab1
          where ( c~werks in plant  and a~matnr in
          mat_no ) .

loop at itab1.
 write: itab1-matnr , itab1-maktx , itab1-werks .
endloop.





at line-selection.
break-point.
if sy-lsind = 1.
    get cursor field v1 value v2.
     if sy-subrc = 0 and v1 = 'ITAB1-MATNR'.
     loop at itab1 where matnr = v2 .
*      READ TABLE ITAB1 INTO WA_ITAB WITH KEY MATNR = V2.
      write: itab1-matnr, itab1-maktx.
      endloop.

 endif.
endif.

[Former Member]

can anybody give me an idea as to how develop report for above requirement