topic drill down reports in Application Development and Automation Discussions

drill down reports

Former Member — Wed, 28 Nov 2007 16:25:18 GMT

Hi experts,

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

Thanks,

Subbu.

Re: drill down reports

Former Member — Wed, 28 Nov 2007 16:28:13 GMT

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.

Re: drill down reports

Former Member — Wed, 28 Nov 2007 16:32:52 GMT

Sunil,

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

Can you please answer my query?

Regards

Aneesh.

Re: drill down reports

Former Member — Mon, 10 Jan 2011 19:41:16 GMT

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

Re: drill down reports

Former Member — Mon, 10 Jan 2011 19:44:00 GMT

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

Rob

Re: drill down reports

Former Member — Mon, 10 Jan 2011 22:02:41 GMT

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.