Group same material text

[Former Member]

Hi all,

How can I group same material text(regardless of same material no.) into one row instead of 3 rows?

Thanks.

[http://www.markpeak.com/temp/0material.jpg]

[Former Member · Accepted solution]

This can not be done, you can't aggregate on description. An alternative is to add the text field as an attribute to your infoObject. Fill it with an ABAP when loading and set the attribute as navigational. You can then report on it and records will be aggregated.

Kind regards,

Alex

[Former Member · Accepted solution]

Hi Alex,

Thanks for your help. It works now.

Edited by: Raymond Lam on Dec 29, 2009 5:55 AM

[Former Member · Accepted solution]

Hi Alex,

One more question. I added the text 0txtmd as attribute to the infoobject, but how can I fill it with ABAP ?

It is not allowed to set as navigational as well.

Alternatively, I created ztxtmd but I cannot see in text transfer rule.

[http://www.markpeak.com/temp/0material2.jpg]

Can you give me some hints, thanks.

[Former Member]

Hi.

You can set in material display properties "Text" only without key.

This should group in one row.

Regards.

[Former Member]

Raymond,

Have you considered using structures or hierarchies instead? If you have large numbers of materials the overhead on maintaining these elements maybe too much.

Regards

Gill

[Former Member]

Hi Andrey,

I tried to display text, but it still separate in 3 rows.

[Former Member]

Hi Gill,

Actually i need to combine them instead of grouping.

Thanks.