I have seen many documents on the explanation of compounding infoobject/attributes and how to deal with them in BEx Query designer .But what i find in all of these documents is a little bit of information missing on the effect of compounding infoobject on BEx selection screen.
With this document i will show you an example on the effect of a compounding infoobject on the BEx selection screen. And at the end of it some practical scenarios related to it .
Lets begin with an example :
Info object : ZMAT (Material)
Compounding Infoobject : ZPLANT (Plant)
Master Data of ZMAT :
As we can see from the below master data screenshot that material M1,M2,M3 belongs to Plant P1 and M4,M5,M6 belongs to Plant P2.
Infoprovider Data :
BEx Report :
Develop a BEx report and use ZMAT & ZPLANT in rows and also make two user entry variables on ZMAT & ZPLANT.
Your BEx will look like this .
Now execute the report to observe the selection screen :
Observation 1 :
Go to the search help of material to see what material are coming . We can see that all the 6 materials are coming in the search help of ZMAT.
Observation 2 :
Now again go back to the selection screen and enter Plant : P1 in the selection screen and again check the search help of material.
You will find out that this time the search help of material only show three materials which belongs to Plant : P1.
Repeat the same step of observation 2 for Plant : P2.
You will find out that this time the search help of material only show three materials which belongs to Plant : P2.
The above effect shown in the observations is happening because of compounding infoobjects . When we enter the value in ZPLANT which is a superior infoobject for ZMAT infoobject, the system internally goes to the master data of ZMAT and only shows those materials in the search help of the BEx selection screen which belongs to this superior infoobject.
Practical Application :
- Sometimes the end user complaints that when he goes to select material in the search help he sees material from all the plants . The user gets confused. For a better clarity you can instruct him/her to enter plant first and then select materials from the search help .
- Also this shortens the search help.
Hope the above document was informative for you guys.
All comments and suggestion are welcome !!