Drill Down in ALV

[Former Member]

Hi All,

We have a Z report with ALV output related to Production Order.We have two quantities required quantity and bin quantity and fields like production order,transfer requirement number,material etc.The requirement is to have the higher quantity row on the top and the remaining rows should be collapsable  inside that row such that when the user clicks on the first row (which should have a plus sign to click on),rest of the rows should appear(same production order and material).

Checked FM RS_TREE_CONSTRUCT  and RS_TREE_CONSTRUCT  but that is only creating tree with 1 field on a particular level.

Can someone please suggest on this.

Regards,

Ruhi

[Former Member]

HI Ruhi,

Check out the standard program BCALV_TREE_DEMO.

Thanks & Regards

Syed

[Former Member]

Hi Syed,

Thanks for your reply.

Is there no way other than OO.

Regards,

Ruhi

[Former Member]

Hi Ruhi,

The demo program is more dynamic while creating no.of nodes.

Alternative is you can also go with FM RS_TREE_CONSTRUCT and RS_TREE_LIST_DISPLAY.

Check out the http://wiki.scn.sap.com/wiki/display/ABAP/Call+FM+to+generate+alv+tree+and+deal+with+user+action

But for your requirement the Demo is best. Just analyse and get the idea and develop your own .

Thanks & Regards

Syed

[Former Member]

Hi All.

The actual requirement is like this ,

we have one report which is copy of LB10 ,

here report show us the quantity associated and required for a production order

there is one field for the Quantity selection which is modifiable in which user enter the quantities to be picked form Bins and create TR for that order within the report.

now business need drill down functionality which will show the line with max stock at top and remaining will be in collapse , so when required user will do the expand and enter the quantities.

here we can use the functional module RS_TREE_CONSTRUCT , but this doesn't allow me to drill down based on multiple fields like production order and material and quantity in each Bin.

So we need the FM to be used for drill down based on multiple fields.

hope the issue is clear , Please help to get this resolved.

Thanks

Ruhi