SAP CC Tier Table

light111Convergent Charging Tier Table


A tier table is a table used for mapping an input field that contains a value range  to a set of output columns(sting/number). Tier Table can be queried from the price plan of the charge.

The below post shows a simple use case of Tier Table(s).


We have the CIT class that passes Duration as one of the attribute.

1

Let’s create a tier table.

2

Provide a name and description. The output column is Price with Computation type as Single Linear. Go to the Table Instance Tab.

3

Create 3 entries.

4

Double click on each range and provide values as below.

5

68910

Now for each row provide a price.

11

Our first tire table is ready which is Single Linear.

12


Create a similar table but with computation type as Cumulative Linear.

1314


Create a similar table but with computation type as Single Non-Linear.

43

44


Create a similar table but with computation type as Cumulative Non-Linear.

45

46


Now we have 4 Tier Tables with different computation mode.

Let’s create a charge and price plan which uses this tier table.

Now in below charge the Tier Table- SL_TT (Single Linear)  is used.

15

The Usage rate contains a linear function.

16


Now test the price plan.

17


The input Duration is 20 secs. So it falls in the first range of the Tier Table.

As the computation is linear. So the amount= 20 * .25 = 5 EUR.

20

The input Duration is 30 secs. So it falls in the first range of the Tier Table.

As the computation is linear. So the amount= 30 * .25 = 7.5 EUR.

21

The input Duration is 40 secs. So it falls in the Second range of the Tier Table.

As the computation is linear. So the amount=   .35 *( 40-30) = 3.5 EUR

22

The input Duration is 50 secs. So it falls in the Second range of the Tier Table.

As the computation is linear. So the amount=   .35 *( 50-30) = 7EUR

23

The input Duration is 70 secs. So it falls in the Third range of the Tier Table.

As the computation is linear. So the amount=   .5 *( 70-60) = 5 EUR

24

The input Duration is 90 secs. So it falls in the Third range of the Tier Table.

As the computation is linear. So the amount=   .5 *( 90-60) = 15 EUR

25


Now lets assign the tier table: SN_TT ( Single Non-Linear) to the price plan and test.

26

27

The input Duration is 20 secs. So it falls in the First range of the Tier Table.

As the computation is non-linear. Amount= .25 EUR

28

The input Duration is 30 secs. So it falls in the First range of the Tier Table.

As the computation is non-linear. Amount= .25 EUR

29

The input Duration is 40 secs. So it falls in the Second range of the Tier Table.

As the computation is non-linear. Amount= .35 EUR

30

The input Duration is 50 secs. So it falls in the Second range of the Tier Table.

As the computation is non-linear. Amount= .35 EUR

31

The input Duration is 70 secs. So it falls in the Third range of the Tier Table.

As the computation is non-linear. Amount= .5 EUR

32

The input Duration is 90 secs. So it falls in the Third range of the Tier Table.

As the computation is non-linear. Amount= .5 EUR


Now assign Cumulative Linear Tier Table and test the price plan.

33

The input Duration is 20 secs. So it falls in the First range of the Tier Table.

As the computation is  Cumulative linear. Amount= 20 * .25 = 5 EUR

34

The input Duration is 30 secs. So it falls in the First range of the Tier Table.

As the computation is Cumulative linear. Amount= 30 * .25 = 7.5 EUR

35

The input Duration is 40 secs. So it falls in the Second range of the Tier Table.

As the computation is Cumulative linear.

Amount=  [ 30 * .25 ] +  [ (40-30) * .35] = 7.5 + 3.5 = 11 EUR

36

The input Duration is 50 secs. So it falls in the Second range of the Tier Table.

As the computation is Cumulative linear.

Amount=  [ 30 * .25 ] +  [ (50-30) * .35] = 7.5 + 7 = 14.5 EUR

37

The input Duration is 90 secs. So it falls in the Third range of the Tier Table.

As the computation is Cumulative linear.

Amount=  [ 30 * .25 ] +  [ (90-60) * .35]  + [ (90-60) * .5]  = 7.5 + 10.5 + 15= 33 EUR


Now lets assign the Cumulative Non-Linear tier table in the price plan and test the price plan.

38

39

The input Duration is 20 secs. So it falls in the first range of the Tier Table.

As the computation is Cumulative non-linear. Amount=  .25 EUR

40

The input Duration is 30 secs. So it falls in the first range of the Tier Table.

As the computation is Cumulative non-linear. Amount=  .25 EUR

41

The input Duration is 55 secs. So it falls in the second range of the Tier Table.

As the computation is Cumulative non-linear. Amount=  .25 + .35 = .6 EUR

42

The input Duration is 80 secs. So it falls in the third range of the Tier Table.

As the computation is Cumulative non-linear. Amount=  .25 + .35 + .5 = 1.1 EUR


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s