SAP CC Translation Table
In SAP CC ( Convergent Charging), translation table is used to store data that helps in rating/charging. It is used in Price Plan and can be used across multiple charges. This table is not visible to SAP CRM .
Below post shows once of the simple use case of translation table which used in the price plan of the charge.
The network provides the details to the SAP CC system in format of CITs and the fields may include what is the call duration in minutes and the mobile prefix number and other details. With the help of translation table from Prefix Number will determine the Geographical Region and from Region will determine the call rate per minute using another translation table. Once we get the region call rate per minute then the price plan can calculate the total price for the duration.
Let’s create a simple Chargeable Item Class.
Below screen appears.
Provide a name and description and create to properties like Duration and NumPrefix as shown below.
Now we are ready with our CIT class to be used later in the process.
Here we need two translation table , one from user number prefix will get the geographical region and second from geographical region to get the call rate per minute.
Let’s create the first translation table.
Under tab- Table Schema provide the name and description.
Create input and output columns with data type as shown. Go to the tab Table Instance.
Create entries here.
Below few entries created and finally Save it.
Create another translation table as above with input and output columns and entries and save it.
So we have two translation tables ready.
Let’s create a charge.
Below Screen appears.
provide name and a description and choose Parameters tab.
Create a parameter as NumPrefix with type and initial value as 00.
In the charge plan add an internal reference parameter.
Provide name as Ref.
Add a Reference component.
Below screen appears.
Provide a name and assign the internal reference parameter.
Select the Price Plan.
Provide price plan name and description.
Add component- whether its a recurring or onc-shot or usage. Here choose Usage Rate.
It asks for the CIT class and choose R001 cit class .
For the Usage Rate, add Translation Table Introducer as a operator.
Provide a name and description and choose the translation table.
provide comparison operator as Starts with and Reference Date.
The translation table contains input field as NumPrefix and it has to be mapped.
The associated cit class R001 contains attribute as NumPrefix . Choose this.
The output generated property name is ‘Region’.
lets add one more Translation Table Introducer to the Usage Rate.
Provide a name and Description.
Choose the translation table, comparison operator and the reference date.
This translation table has input field called as Region and now map this field to the Region field of the previous translation table introducer output property.
Now add a linear function to the usage rate.
Provide a name and description.
Choose Property name as Duration which is the CIT class property.
Provide Scaled amount as CRM which is the second translation table output.
Provide Fixed amount as 0.
Save the charge.
Trial run the Price Plan.
The test screen appears.
Provide the duration and the number prefix and select the Run button.
The output appears.
Execute the test with different input and watch the result.