drill down reports

[Former Member]

Hi experts,

could anyone please let me know the main diff between normal reports and drilldown reports?

Thanks,

Subbu.

[Former Member]

Hi Subbu,

the main diff between normal and drilldown reports is we can generate single list throgh normal report. if we want multiple reports we need to go for drilldown reports in the sence interactive reports.

Through at-line selection and at-user command we will create drill down reports.

Cheers.

[Former Member]

Sunil,

I smell something fishy here. 3 posts and 30 points??

Can you please answer my query?

Regards

Aneesh.

[Former Member]

Hi,

ABAP/4 provides some interactive events on lists such as AT

LINE-SELECTION (double click) or AT USER-COMMAND (pressing a

button). .

Drill down report is nothing but interactive

report only.

Normal report just displaying data

[Former Member]

sekharch - please check your e-mail. I sent you something about responding to old posts.

Rob

[Former Member]

Hi,

Drill down report is nothing but Interactive report only.

You can go through below sample code.

tables: mara,vbap.

data : begin of itab occurs 0,

matnr like mara-matnr,

ernam like mara-ernam,

end of itab.

data : begin of itab1 occurs 0,

matnr like vbap-matnr,

vbeln like vbap-vbeln,

end of itab1.

data: fld(20) type c,val like mara-matnr .

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

select-options: m for mara-matnr obligatory.

selection-screen end of block blk1.

at selection-screen on m.

select single matnr from mara into mara-matnr where matnr = m-low.

if sy-subrc ne 0.

message e000(zz) with 'invalid ' mara-matnr 'in your ' 'selection'.

endif.

start-of-selection.

select matnr ernam into table itab from mara where matnr in m.

select matnr vbeln into table itab1 from vbap for all entries in itab

where matnr = itab-matnr.

end-of-selection.

loop at itab.

write:/30 itab-matnr,60 itab-ernam.

• hide itab-matnr.

clear itab-matnr.

endloop.

set pf-status 'XX2'.

at line-selection.

get cursor field fld value val.

case fld.

when 'ITAB-MATNR'.

write:/ val.

endcase.

case sy-lsind.

when '1'.

set pf-status 'XX2'.

set titlebar 'XX2'.

if itab1[] is initial.

write:/ 'no data found for itab1 in first secondary list'.

endif.

loop at itab1.

write:/30 itab1-matnr,60 itab1-vbeln.

• hide itab1-matnr.

endloop.

when '2'.

set pf-status 'XX2'.

set titlebar 'XX2'.

loop at itab.

write:/30 itab-matnr,60 itab-ernam.

endloop.

endcase.