Skip to Content

Introduction:

This document focuses in explaining the difference between the “Percentage Share” and “Percentage Share with the Signed base value” operands present in the Business Explorer and to how to use it in BEX.

Definition:

Percentage Share (%A):    <operand 1> %A <operand 2>

This gives the percentage share of operand 1 and operand 2. It is identical to formula  (<operand 1> / abs(<operand 2>) )*100

Percentage share with Signed base value (%_A):    <operand 1> %_A <operand 2>

This gives the percentage share of operand 1 and operand 2. It is identical to formula ( <operand 1> / <operand 2> )*100

This is available under Percentage Functions in Query Designer:

Percentage.jpg

How to Apply:

Formula with %A:

Definition1.JPG

This is percentage share between JAN Budget data to Actual data.

Formula with %_A:

Definition2.JPG

Output from the BEX with %A and %_A:

Output.JPG

Where ever the actual amount is negative, %A is giving the data in Positive due to the ABS function usage where as %_A is giving the result without ABS. Developer has to choose depending on the requirement from the Customer. Few customers are interested to use the %A to show the result in Positive always when the denominator is in Negative.

Backend Tables:

The operators are maintained in the table RSZOPRATOR and RSZOPRATXT.

RSZOPRATOR.JPG

RSZOPRATXT is used to maintain the text information of the operator.

Activating %_A:

To activate this operator, use transaction SE16, select the %_A operator in the RSZOPRATOR table, go to ‘Table entry  and then Create with template’ and replace the Object version entry from X with an A.

With this the %_A is available in the frontend layer and can be used in BEX for calculations.

If the operator %_A is not present in table RSZOPRATOR then use %A entry as template and then make an entry for %_A and version with A and define a text for %_A in the table – RSZOPRATXT to display the text in front end.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply