topic Re: CL_SALV_TREE Agregation in Application Development and Automation Discussions

CL_SALV_TREE Agregation

former_member184386 — Thu, 10 Sep 2015 18:47:46 GMT

Hi guys, I have created an hierarchical ALV tree using CL_SALV_TREE but having problem when doing aggregation...

The hierarchy consists of the Org Unit and the Org Units below it, if no aggregation it will look something like this, no problem...

Org. Unit No. of Emloyees

001 10

011 5

012 2

002 5

021 1

022 3

-----

Here's the problem, if aggregation is turned on, it will look something like this, it seems that the top Org Unit is overwritten with the total from the below Org Units and doesn't count the top level.

Org. Unit No. of Emloyees

001 7

011 5

012 2

002 4

021 1

022 3

Any help is greatly appreciated.

Thanks!

Re: CL_SALV_TREE Agregation

former_member184158 — Fri, 11 Sep 2015 05:35:00 GMT

Hi Ricky,

if the Org. Unit as text/char, so it does the agregation 001 ,011,012,013,014 etc.

so I think, it should be numc, or integer .

just try this out to change the date element which has domain numc or integer,

Regrads

Ibr

Re: CL_SALV_TREE Agregation

former_member184386 — Fri, 11 Sep 2015 12:32:05 GMT

Hi LBR, I was only referring to the "no. of employees" sorry for not specifying. I highlighted it in blue. Like what I said it's actually doing the aggregation but with an issue, please refer to the explaination above...Thanks...:)

Re: CL_SALV_TREE Agregation

former_member184386 — Sat, 19 Sep 2015 14:21:02 GMT

Resolved it on my own...

Re: CL_SALV_TREE Agregation

former_member184158 — Sat, 19 Sep 2015 14:53:28 GMT

Hi Ricky,

could you tell us please how?

Re: CL_SALV_TREE Agregation

matt — Sat, 19 Sep 2015 15:55:01 GMT

You posted your question because you wanted the community to help you. Now you have resolved it, it is only fair that you share the answer with the community and help others.

This site is about helping on another - giving and receiving. Not just receiving.

Re: CL_SALV_TREE Agregation

former_member184386 — Mon, 21 Sep 2015 14:49:35 GMT

Ok, sorry guys, I thought nobody has encountered this issue before and I thought the requirement was unique to our company.

Anyways, I sent an OSS message to SAP and explained that this could be bug with the ALV Tree system but they came back and said that it is the standard behavior and therefore not going to do anything, as always.

So what I did to resolve it is to append another record in the hierarchy with the same node and parent, so if the original hierarchy looks like this"

Node	Parent
001
011	001
012	001

The new hierarchy will look like this (notice the new record added to the bottom of the table), but you only do this if the user selected or turn "ON" the aggregation, otherwise the above hierarchy is used:

Header 1	Header 2
001
011	001
012	001
001	001

This method will duplicate the parent node details but you can always control this in your code.

If you have any question just let me know.

Regards,

Ricky Orea

Re: CL_SALV_TREE Agregation

former_member184386 — Mon, 21 Sep 2015 14:51:00 GMT

Hi Ebrahim, I posted my reply on the original post...

Regards,

Ricky

Re: CL_SALV_TREE Agregation

former_member184386 — Mon, 21 Sep 2015 14:51:20 GMT

Hi Matthew I posted my reply on the original post...

Regards,

Ricky