Question:
I have a couple of queries filter by 0MATERIAL, 0MATERIAL__0MATL_TYPE, 0MATERIAL__0DEL_FLAG.
Since some of them are navigational attribute I´m not able to create an aggregate for the whole selection and I´m not getting the query to use an aggregate.
Is there a way of using an aggregate for 0MATERIAL and also all the navigational attributes?
Best Regards,
Teresa.
Answer:
Switch to Expert mode and it will allow you to use navigation attributes.
regards
phemrajani
Answer:
Thanks a lot for your help!!!
Answer:
...
Is there a way of using an aggregate for 0MATERIAL and also all the navigational attributes?
Best Regards,
Teresa.
Just a tip: 0MATERIAL is the most granular master data characterisitc in the entire SAP system. It has a 1-to-many relation with all other characteristics. Aggregating on such a characterisitc is not going to help, as it will have to create a table at the most granular level.
_________________
Keep smiling