Which kind of report to use ?

[Former Member]

Hi Friends,

I have a scenario where i need to be able to expand the header so that it displays all the item below that header.

For Eg .

<u><b>Layout 1</b></u>

Place Name Vendor Description Cost1 Cost2 %

USA Tom + 11223 Job1 1000 2000 100

<u><b>Layout 2</b></u>

Place Name Vendor Description Cost1 Cost2 %

USA Tom 11223 job1 1000 2000 100

11223-1 Transport 400 500 25

11223-2 Manufacture 400 1000 50

11223-3 Labor 200 500 25

When the + sign is clicked it should expand to display details under 11223 . If clicked again it should hide the details . Can anyone please give me an example .

Thank you

[former_member181966]

Checkout

http://www.sapgenie.com/abap/drill_down_reports.htm

Thanks

Saquib

[Former Member]

Hari,

Look to program SALV_DEMO_TREE_SIMPLE.

Also do a search on DEMOTREE* - you will find more.

[Former Member]

HI Hari,

Have a look at this program also

<b>RSDEMO_SAP_LIST_TREE</b>

[Former Member]

Hi John ,

Is there a way to do it using without Object oriented programming ?

Thanks

[Former Member]

Hi Hari,

x_keyinfo-header01 = 'VBELN'.

x_keyinfo-item01 = 'VBELN'.

x_keyinfo-header02 = 'MATNR'.

x_keyinfo-item02 = 'MATNR'.

x_keyinfo-header03 = 'DEL_ONCE'.

x_keyinfo-item03 = 'DEL_ONCE'.

x_layout-zebra = 'X'.

<b>

x_layout-EXPAND_FIELDNAME = 'EXPAND'.

x_layout-colwidth_optimize = 'X'.

</b>

I think this will help u if u have any questions plz let me know

Thanks

Vikanth Khimavath

[Former Member]

Hi Vikranth ,

The problem here is that the + sign is in the Fourth column . If i expand the + sign it should display all its sub items and close it when the + sign is clicked again . Do you have a sample code for this ? I would really appreciate your help .

Thanks once again

[Former Member]

hi hari,

<b>u can use alv's using FM's RESUSE_ALV_HIERSEQ_LIST_DISPLAY

REUSE_ALV_HIERSEQ_GRID_DISPLAY OR ALSO ALV TREE.

type balv in se38.

check the demo program BALVHD01_GROUP</b>

Message was edited by: Priya

[ferry_lianto]

Hi Hari,

Please check this drilldown reporting document. Perhaps it may help.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAREP/CAREP.pdf

Regards,

Ferry Lianto

[Former Member]

Hi Hari,

can i have u r e-mail id i will be sending the entire code of that program.

Thanks

Vikranth Khimavath

[Former Member]

Hi Vikranth ,

Thank you for your help . My email id is hari.krishna2608@gmail.com or harigkrishna2002@yahoo.co.in.

Regards,

Hari

[Former Member]

Hi Hari,

I have send the attachment plz check it out...

Thanks

Vikranth Khimavath