Filter to return related values
I have a query having multiple filters.
Eg. Filter on Company,Material Category,Material.
Material Category is an attribute of Material.
Case 1 :
In my query I have filter on Company & Material.
In the query filter I select Company "XYZ" . I would then like to select Material. But only those materials should be available for selection which are there in Company "XYZ".
Here the there can be any combination and only the transactional data mainatains this relationship.
Case 2 :
In my query I have filter on Material Category & Material.
In the query filter I select Material Category"Metal" . I would then like to select Material. But only those materials should be available for selection which are of the type Metal.
Here this relationship is maintained in the Masterdata of the InfoObject.
I have not used variables with processin type "Replacement Path" but would both the cases be solved by this or there is another way of doing it.
I am looking forward to a detailed answer.
Thanks & Best Regards,