Skip to Content
Author's profile photo Former Member

Effect of compounding infoobject on BEx selection screen

AGENDA :

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)

BEX1.jpg

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.

BEX6.jpg

Infoprovider Data :

BEX2.jpg

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 .

BEX3.jpg

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.

BEX5.jpg

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.

BEX7.jpg

BEX8.jpg

Observation 3:

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.

BEX9.jpg

BEX10.jpg

Explanation :

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 !!

Assigned Tags

      44 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice..Thanks for sharing with Screenshots 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Naveen,

      Thanks for the nice comments !!

      Regards,

      Ashutosh

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Great observation Ashutosh..Thanks for sharing this information with proper scenario and screenshot.

      Regards,

      AL

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thx Anshu.

      I appreciate your feedback.

      Author's profile photo M K
      M K

      Hi Ashutosh,

      Even i have the same issue here i have many plants so the user wants to restrict using 0MRP_CONTRL which have only 15 values. But the problem here again is with the combinations there are around 50 values for plants and 15 values for 0MRP_CONTRL.

      So i am getting 50*15=750 values are displayed in the product group which is the naming convention for 0MAT_MRP_CONTRL_0MAT_PLANT.

      The user wanted only 15 values of 0MRP_CONTRL to be displayed instead of 750 values. He dont want to restrict it using 0PLANT as he dont know for which plants he has the production values.

      Could you please help me on this?

      Thanks,

      Manish

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Hi Ashutosh,

      Thanks a lot...just now I want to find a solution for the same.  As we have the same issue with the compounding values for Status and Sub-status values.

      Regards,

      Krishna Chaitanya.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Krishna ,

      I am glad that I could be of help to you.

      I will be posting more such out of the box documents for you guys.

      Regards,

      Ashu

      Author's profile photo Former Member
      Former Member

      Good information ashu. Expecting many good blogs from you.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hey thx kumar for the encouragement.

      I will post more good and interesting blog

      Regards,

      Ashu

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      You always have your documents simple but very informative:) . I liked your other documents too.

      Regards,

      Benedict

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hey Benedict,

      Thank you for the appreciation.

      Yes I like to keep it simple so that the concept becomes clear.

      I will post more documents for you guys focussing on concepts .

      Regards,

      Ashutosh

      Author's profile photo Satendra Mishra
      Satendra Mishra

      nice information....... 😆

      Regards,

      SM

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thx Satendra !!

      Author's profile photo Former Member
      Former Member

      Thanks for sharing valuable information.

      Regards,

      Sushant

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hey Sushant,

      Thx for the valuable comments.

      Regards,

      Ashutosh

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Hi Ashutosh,

      Nice exploration 🙂 It seems u r observing inch by inch in Bex.. 😉 Keep it up..

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Suman,

      Thanks for the appreciation . I will try to bring more such explorations in BEx or other areas too.

      Regards,

      Ashutosh

      Author's profile photo Abdullah Qureshi
      Abdullah Qureshi

      Hi Ashutosh,

      Very nice doc with proper explanation. Thanks for sharing with us.

      Keep it up..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Abdullah,

      Thanks for the appreciation . Will keep posting more interesting documents for you guys .

      Regards,

      Ashu

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Simple and easy to understand.

      Thanks for sharing.

      Regards

      Kamal

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thx kamal for the appreciation.

      Author's profile photo Former Member
      Former Member

      Great Document....

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thx mithun.

      Author's profile photo sree hari
      sree hari

      Small and informative..

      Thx

      Sree

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thx Sree !!

      Author's profile photo Prashanth konduru
      Prashanth konduru

      Informative... Nice document...

      thanks for sharing ...

      Cheers 🙂

      KP

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thx Prashant for the appreciation.

      Author's profile photo Former Member
      Former Member

      Very well observed and  explained.

      To the point document Ashutosh.

      Thanks for sharing.

      Regards,

      Priyanka

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Hi priyanka,  Thx for the appreciation and the feedback.   Regards, Ashu
      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Hi priyanka,  Thx for the appreciation and the feedback.   Regards, Ashu
      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice information Ashu..... 🙂

      Regards,

      SM

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Satendra !!

      Author's profile photo Former Member
      Former Member

      Very well Explored and it shows  ideas about compounding atributes meaningfull.

      Regards,

      karthick

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Karthick !!

      Author's profile photo Phani KV
      Phani KV

      Good document....

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Kodanda.

      Regards,

      Ashu

      Author's profile photo Former Member
      Former Member

      Good document... 🙂

      Author's profile photo Former Member
      Former Member

      Very good observation with a nice explanation; simple and worthy. Thank you for sharing 🙂

      Regards

      Yasemin...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hey,

      Thanks Yasemin ..  🙂 !!

      Regards,

      Ashutosh

      Author's profile photo Wasem Hassan
      Wasem Hassan

      its too good doc.

      Thanks for sharing..

      Keep it up.. 🙂 🙂

      Regards

      Wasem

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi,

      Its very good observation thanks for sharing 🙂 .

      Author's profile photo Anand K
      Anand K

      Nice document Ashutosh 🙂 Really informative

      Author's profile photo Former Member
      Former Member

      Really Informative 🙂

      Thanks,

      Purushotham.

      Author's profile photo Vijay Chandra.R
      Vijay Chandra.R

      Helpful Document.