Skip to Content
0
Former Member
Dec 12, 2006 at 01:02 PM

Incentives calculation in BEX

22 Views

Hi,

Requirement as follows

TARGET

SALE

SALE RETD

NET SALE

%OF ACHIEVEMENT

RATE OF INCENTIVE

Sale is a restricted Keyfigure which is defined as follows

0DOC_CATEG(Sales document category) restricted to Debit memo

0NETVAL_INV(Net value of billing item)(Table VBRP Field NETWR)

Sales returns is another restricted keyfigure defined as follows

0DOC_CATEG(Sales document category) restricted to Creditmemo

0NETVAL_INV(Net value of billing item)

· Net sales = Sale - Sales returns

%Of Achievement = Netsales % Target

Rate of incentive is calculated based upon the following conditions

If 100 % achieved 2.% incentive

I f 80-99.99% achieved 1.% incentive

If over and above 100% achieved 1%incentive

This incentives data is not stored any where so how can I build the formula for this

Regards

priya

So please send me the formula for Rate of incentive calculation