Material_Type_Group in BEX

[former_member553099]

Deal all,

Current Output of BEX is below

PLANT    MATERIAL_TYPE         QTY  

XXXX       ROH                              100   

XXXX       HALB                             200

XXXX       VERP                            150

XXXX       FERT                             300

Result                                           750

The requirement is

PLANT  ,MATERIAL_TYPE          QTY

XXXX     ROH                                100

XXXX     HALB                               200

Result                                            300

XXXX     VERP                              150

XXXX     FERT                               300

Result                                            450

Regards,

Linga.

[yasemin_kilinc]

Hi,

You can directly define a hierarchy on material type. This way, you can show the sums as you desire.

Hope it gives an idea

Regards

Yasemin...

[KodandaPani_KV]

HI,

you can use the 0PLANT result rows always -> it will give each line result rows.

for 0PLANT use the sort by ascending for descending order.

do same changes for material type.

-Phani.

[ccc_ccc]

Hi Linganathan,

In ROWs,

1. First place Plant (sort by key), Results rows always display
2. Second material type Results rows always display

In COLUMNs

1. Place Qty.

Try this.

Thank you,

Nanda

[Loed]

Hi,

As Cornelia said above, you should add additional object to your masterdata to differentiate each material type based on their group (which is the object added) so that you will have the desired RESULT..

Regards,

Loed

[cornelia_lezoch]

you need to have a characteristic or a navigation attribut which defines which grous should be added up.

then you need to include this into your query.

regards

Cornelia