topic Help in drill down report in Application Development and Automation Discussions

Help in drill down report

Former Member — Thu, 10 Jul 2008 09:15:49 GMT

Urgent!

May i know any of the sap standard reports to get detail idea on drill down report.

Thanks.

Re: Help in drill down report

Former Member — Thu, 10 Jul 2008 09:18:58 GMT

Hey,

use transaction ABAPDOCU.

Re: Help in drill down report

Former Member — Thu, 10 Jul 2008 09:44:32 GMT

Maybe u can check this program - BCALV_GRID_02

when the user clicks a row its going for next level ALV ( but as a pop up )

Cheers

Kothand

Re: Help in drill down report

Former Member — Thu, 10 Jul 2008 09:51:47 GMT

Hi,

Try this BCALV_TREE_SIMPLE_DEMO.

Also try this code...

TYPES: BEGIN OF t_scarr.

INCLUDE STRUCTURE scarr.

TYPES: expcol TYPE c.

TYPES: END OF t_scarr.

DATA: gr_table TYPE REF TO cl_salv_hierseq_table.

DATA: gr_functions TYPE REF TO cl_salv_functions.

DATA: gr_columns TYPE REF TO cl_salv_columns_hierseq.

DATA: gr_column TYPE REF TO cl_salv_column_hierseq.

DATA: gr_level TYPE REF TO cl_salv_hierseq_level.

DATA: gr_sorts TYPE REF TO cl_salv_sorts.

DATA: iscarr TYPE TABLE OF t_scarr.

DATA: isflight TYPE TABLE OF sflight.

DATA: ibinding TYPE salv_t_hierseq_binding.

DATA: xbinding TYPE salv_s_hierseq_binding.

SELECT * INTO TABLE iscarr FROM scarr.

SELECT * INTO TABLE isflight FROM sflight.

xbinding-master = 'CARRID'.

xbinding-slave = 'CARRID'.

APPEND xbinding TO ibinding.

cl_salv_hierseq_table=>factory(

EXPORTING

t_binding_level1_level2 = ibinding

IMPORTING

r_hierseq = gr_table

CHANGING

t_table_level1 = iscarr t_table_level2 = isflight ).

gr_functions = gr_table->get_functions( ).

gr_functions->set_all( abap_true ).

gr_columns = gr_table->get_columns( level = 1 ).

gr_columns->set_expand_column( 'EXPCOL' ).

gr_level = gr_table->get_level( 1 ).

gr_level->set_items_expanded( ).

gr_sorts = gr_table->get_sorts( level = '2' ).

gr_sorts->add_sort( columnname = 'FLDATE' sequence =

if_salv_c_sort=>sort_down ).

gr_table->display( ).

Thanks.

Edited by: Cnu on Jul 10, 2008 3:21 PM

Re: Help in drill down report

Former Member — Thu, 10 Jul 2008 10:20:19 GMT

Thanks but i need more sub items like upto 4 levels the drill down should take place.Will it be possible with this?

Re: Help in drill down report

Former Member — Thu, 10 Jul 2008 10:22:15 GMT

i think with what cnu has mentioned gr_level = gr_table->get_level( 1 ).

incrementing that can take u to level 4.