Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ALV hierarchy report

0 Kudos

Hi,

I am trying to create ALV report using FM: REUSE_ALV_HIERSEQ_LIST_DISPLAY

My Report format is as follows:

Shipto1 <Level 1>

Shipping plant1 <Level 2>

VBELN POSNR <Level 3>

VBELN POSNR <Level 3>

VBELN POSNR <Level 3>

Shipping plant2 <Level 2>

VBELN POSNR <Level 3>

VBELN POSNR <Level 3>

VBELN POSNR <Level 3>

Shipto2 <Level 1>

Shipping plant1 <Level 2>

VBELN POSNR <Level 3>

VBELN POSNR <Level 3>

VBELN POSNR <Level 3>

Shipping plant2 <Level 2>

VBELN POSNR <Level 3>

VBELN POSNR <Level 3>

VBELN POSNR <Level 3>

But I am not able to get 3 levels.

Is it possible to get this format using this function module?

Please advice.

Thanks in advance.

Regards,

Umesh Patil

11 REPLIES 11

Former Member
0 Kudos

Umesh,

The documentation clearly says:

This module outputs two internal tables as a formated hierarchical-sequential list.

Principle:

Pass an internal table containing the set of header information to be output.

Pass an internal table containing the set of item information to be output.

Pass a structure containing the general list layout details

So u can have only 2 levels.

But you cando this. Call REUSE_ALV_LIST_DISPALY on double click of the Ship to..

After the First Hierarchical display, in the usercommand subroutine, if the double clicked item is a ship plant, then select all vbelns corresponding to this ship plant and pass it to resue_alv_display.

The onl problem is this new list will be displayed in a different screen.

Im trying out, will get back again/

0 Kudos

Hi umesh,

Check this program, it may help.

BALVHD01_GROUP

Former Member
0 Kudos

Hi

No you can't do it.

You should try to use the FM RS_TREE_LIST_DISPLAY for example.

Max

former_member186741
Active Contributor
0 Kudos

as others have pointed out you can't do it - how about a compromise combining shipto and shipping plant as level 1?

See Digesh's suggestion for an expansion of this idea.

Message was edited by: Neil Woodruff

Former Member
0 Kudos

Umesh did you try out Matrix list option I think this can help you. Sample program is ERGP2505.

Former Member
0 Kudos

Hi Umesh,

Please transfer your Report format to as:

Shipto1 <Level 1> Shipping plant1 <Level 1>

VBELN POSNR <Level 2>

VBELN POSNR <Level 2>

VBELN POSNR <Level 2>

Shipto1 <Level 1> Shipping plant2 <Level 1>

VBELN POSNR <Level 2>

VBELN POSNR <Level 2>

VBELN POSNR <Level 3>

Shipto2 <Level 1> Shipping plant1 <Level 1>

VBELN POSNR <Level 2>

VBELN POSNR <Level 2>

VBELN POSNR <Level 2>

Shipto2 <Level 1> Shipping plant2 <Level 1>

VBELN POSNR <Level 2>

VBELN POSNR <Level 2>

VBELN POSNR <Level 2>

Now u r able to use FM: REUSE_ALV_HIERSEQ_LIST_DISPLAY

Above format also able to help u in making Header and Detail Internal Table.

Regards,

Digesh.P

0 Kudos

Hi Umesh,

I am having the same problem.

Can you please provide the solution you did for your problem.

Thanks,

Sid

0 Kudos

Hi Sid,

FM: REUSE_ALV_HIERSEQ_LIST_DISPLAY does not allow more than 2 levels.

Shipto1 <Level 1>

Shipping plant1 <Level 2>

If you need more levels then you need to use ALV Tree .

Regards,

Umesh

0 Kudos

hi Umesh,

Do i need to use RS_TREE_LIST_DISPLAY FM for the display?

Please provide me the sample code if you are having any?

Thanks,

Sid

0 Kudos

HI,

Check this program: BCALV_TREE_DEMO, BCALV_TREE_SIMPLE_DEMO

Regards,

Umesh

0 Kudos

hi Umesh,

Thanks for the information.

Can we download the tree list to an Excel sheet with same format?

Thanks,

Sid