Workaround while Restricting Compounding Attributes at BEx
Here is the blog which drives to write this blog Restricting a Characteristic With Its Compounding Characteristic.. Thanks Yasemin ULUTURK
Above blog has greatly explained an approach how to overcome issue which arise while restricting characteristic which is compounded with another characteristic.
To do above approach we need to do modelling changes by writing routine at Transformation level and enable navigational attribute at Infocube level. Then transporting whole flow to production system. It may difficult some times to transports in big clients.
Here I am providing another additional approach to get same results.
Let’s see the approach
Here I am considering Storage location and Plant as Scenario to explain method.
Find the data for our scenario:
Here user wants to exclude Storage location of 0088 of plant 1000. If I simply exclude storage location 0088, then I will lose data of storage location 0088 belongs to plant 1001 also. This shouldn’t happen.
To overcome this issue , I am providing another approach which can achieve directly at BEx level without doing modelling changes. All we need do some workaround at BEx level by creating Selections and formulas logically.
I restricted Closing stock with Storage location 0088 of plant 1000. (KF2)
Then created another KF with restricting Closing Stock KF with only Plant 1000.(KF1)
Then create formula by subtracting KF2 from KF1.
Finally we got closing stock of plant 1000, after deducting stock belongs to Storage location 0088 of plant 1000.
Here find stock of plant 1001 and user doesn’t want to exclude any storage location. So simply restricted Stock with plant 1001.
Thanks for reading this article and hope it helps you.