topic drill down report in Application Development and Automation Discussions

drill down report

spandana_babu — Tue, 05 Aug 2008 10:53:15 GMT

hi..

can any body send sample drill down custom report.

Regards

Spanadana

Re: drill down report

Former Member — Tue, 05 Aug 2008 11:49:52 GMT

hi Spandana..

do u mean going from generalizaion to specialization...

then

drill down repot = interactive report..

we can achieve interactive report using

HIDE in loop .. endloop. of basic list.

GET CURSOR. in AT LINE-SELECTION

reward if useful.

Regards

Raju Mummidi

Re: drill down report

Former Member — Tue, 05 Aug 2008 11:59:29 GMT

Hi Spandana,

Check this

The lines of basic list of a drilldown report when clicked, will take the user to the corresponding (standard) object's display.

For eg: Suppose your report's primary component is purchase requisition, (assume you are printing PR details), and the basic list displays details of many PRs.

Eg: when clicked on a particular line of the PR basic list, it takes you to std t-code me53 (display of purchase requisition). This is the 'Drill-down' functionality.

For this, in the at-line selection of your program, as per the above ex: you'll set the parameter ID of PR number BAN (that you can get from Data element) in memory (using set parameter id) and then calling the corresponding transaction (usually skipping initial screen of the std t-code).

Likewise, if it's Material Number (Matnr), you'll be displaying MM03 transaction w.r.t. the line's matnr.

Mohinder

Re: drill down report

Former Member — Tue, 05 Aug 2008 12:00:06 GMT

Spandana,

Have a look at the demo programs,

DEMO_LIST_INTERACTIVE_1

DEMO_LIST_INTERACTIVE_2

DEMO_LIST_INTERACTIVE_3

DEMO_LIST_INTERACTIVE_4

DEMO_LIST_HIDE

Re: drill down report

Former Member — Wed, 06 Aug 2008 05:07:41 GMT

Hi Spandana.

I would like to suggest a couple of references,

[SDN Wiki Code Gallery - Standard Reference for Detailed Drill Down Report|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/detailed%2bdrill%2bdown%2breport]

[SDN Wiki Code Gallery - Standard Reference for alv drilled down for purchase order|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/alv%2bdrilled%2bdown%2bfor%2bpurchase%2border]

[SDN - Reference - Custom drill down report|;

Hope that's usefull.

Good Luck & Regards.

Harsh Dave

Re: drill down report

Mohamed_Mukhtar — Thu, 07 Aug 2008 12:55:38 GMT

check these below links...

Here there is a lot of of informattion about interactive reports..