BEX Cell restrictions

Posted by on




Cell restrictions


       Cell definition is a useful functionality of BEx Query Designer which helps us to uniquely define each cell that is present at the intersection of two structures. Hence, this feature becomes enabled in Query Designer only when we are using two structures in the report. By Default, key figures are always displayed in a Report as part of a structure. To activate cell definitions, we use one more structure and then explore the functionalities of Cell definitions.





In rows we have materials for every year and in columns we have prive , quantity and net value...




This is how report will appear...

Now we want to apply restrictions on individual cells.. like...


1) we want to see Value field of material 2010 as Blank..

2) In price field we want to see only price for a particular date...

like this we can restrict values of each field...


For doing cell restrictions we need at least 2 structures...







to set value field for material 2010 as Blank..




Save query

Now in report..





To give restrictions on price cells...














Now save query 





This is how cell restrictions are done...


Want to learn SAP from Experts? - Archon Solutions

Comments

  1. AnonymousApril 4, 2014 at 6:15 AM

    Very Useful info with clear information...Keep posted

    ReplyDelete
  2. AnonymousMay 22, 2014 at 1:10 AM

    can u please share with realtime examples

    ReplyDelete
  3. GaurishJune 4, 2014 at 7:19 AM

    Hi Aslam,
    thanks for posting this wonderful information.
    Can you please post the article on Bex Query & Reporting with Hierarchy.

    Thanks,
    Gaurish

    ReplyDelete
  4. AnonymousFebruary 1, 2015 at 3:28 AM

    Thank you so much for sharing your knowledge.

    ReplyDelete
  5. AnonymousSeptember 7, 2015 at 7:38 AM

    have you came across scenarios where help cells get disappers? do you know reason and how to corect it?

    ReplyDelete
  6. UnknownMay 11, 2016 at 11:00 AM

    Really nice document.. Thanks

    ReplyDelete
  7. UnknownMarch 7, 2019 at 9:00 PM

    excellent.....

    ReplyDelete
  8. UnknownMarch 7, 2019 at 9:01 PM

    excellent sir ji....left bdi offie ?

    ReplyDelete
  9. UnknownOctober 4, 2021 at 10:31 PM

    Very nice :)

    ReplyDelete

Post a Comment