Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

min exception aggregation

Hi All,

I need to find a solution for a weird requirement. Simply, I need to find the customers whom bought a list of materials (all)

I could find an easy solutions however stuck at a point.

material infoobject
A
B

Sales infocubematerialquantitiy
customer 1A10
customer 1B20
customer 2A30

I made a MP which include Material infoobject and sales infocube.

by making "Access Type for Result Values property to Master Data" for 0material in bEX, I could get the list of the materials which do not have a quantity. (customer 2 material B)

Multiprovidermaterialquantitiy
customer 1A10
customer 1B20
customer 2A30
customer 2B0

Once I define an exception aggregation (MIN) on quantity with 0material object and I was expecting to get below result.

Quey resultminumum quantitiy
customer 110
customer 20

However, I am receving below report output.

Quey resultminumum quantitiy
customer 110
customer 230

Any idea about this ?

thanks

regards

Berna

Not what you were looking for? View more on this topic or Ask a question