Range Table

Business Object (WS)

Definition

A range table is a table of business data for mapping an input set of values and a range (a positive number) to a set of output values. The output values are string or numbers that represent prices, unit prices, or other credits. This master data is part of the pricing catalog owned by a service provider and is used to configure the pricing logic in SAP CC.

Technical Data

Software Product and Version SAP Convergent Charging 2020
Technical Details Data Types
Version 3
Application Area IS-CC

Business Context and Use

In SAP CC, the range table is recommended to design and configure the pricing logic that includes tiered pricing.

Note

If the tiered pricing is based on customer data you must use subscriber range tables belonging to a subscriber account.

Product Modeling

Your CRM application or another provisioning system manages master data related to the modeling of commercial products. SAP CC extends this master data with pricing information to dynamically compute price amounts related to the usage of a customer service. This information is stored in a pricing catalog owned by the service provider.

CRM retrieves pricing information stored in SAP CC to combine charge plans in the definition of a commercial product. CRM can maintain or replicate some pricing data stored in SAP CC in a pricing catalog of the service provider: mapping tables and range tables .

By default the range tables are manually configured with the SAP CC Core Tool user interface as master data part of the pricing catalog owned by the service provider. You can implement in your CRM the management of range tables to enrich this pricing catalog.

Related Operations

You can use the following operations to perform actions on range tables related to a catalog:

Features

A range table is a table of business data that consists of a set of 0 to 5 input columns and a set of range. Each range contains 1 to 15 output columns and a value to which corresponds a set of values in the related output columns. Each output column is associated to a type that you define at the range table class level. The range table allows you to map ranges of positive numbers to a set of output string or number value that represent prices, unit prices, or credit. You can also apply combinatorial rules to output columns to compute supplementary values. You must however configure the pricing logic that defines the computation of final values.

A range table can be assigned to:

Range tables attached to a catalog can be used for pricing and charging the service usage of several end customers of the service provider. Subscriber range tables contain customer specific data and can be shared by the charging contracts related to the same subscriber account.

Structure

The structure of a range table is specified by a range table class from the pricing catalog of the service provider. Use SAP CC Core Tool to manually configure this master data.

A range table or a subscriber range table is defined by:

  • An identifier which is unique in the SAP CC system
  • The identifier of the related range table class which refers to an existing range table class
  • A text description which contains a human readable definition of the charging logic implemented
  • Additional information which enables to store information used by an external system but not by SAP CC internal processes.
  • A set of different versions (see revisions) of the business data of the range table (validity period, definition of the ranges, sets of output values)

Additionally, a range table may have an agreement ID.

Data Life Cycle and Revisions

A range table includes several revisions that define the business data for a specific period of time. SAP CC features change and revision management functions for the master data created via the Web Services. See the operations Create or change a range table, Create or change range sets in a range table and Cancel range sets in a range table.

Each revision is defined by:

  • A validity period, defined by a start date and an end date

    Notes

    • The start date of the first revision must not be set
    • The end date of the last revision must not be set
    • The very first revision has no validity period set as it is unique
  • A set of range sets containing the input values, the range and the corresponding output values

Each range set contains:

  • A range set key consists of input columns which have a name and a value each. The number of input columns and their names must be the same as those defined in the range table class. The maximum number of input columns is 5.
  • One or more ranges containing:
    • An upper bound value or the attribute "unbounded"
    • Output columns defined by:
      • A name (as provided in the range table class)
      • A string or a number value
    The maximum number of output columns is 15.

See the technical details extracted from the WSDL.

Note

A range table belongs to a pricing catalog whose name is the owner of the range table. The service provider owns the pricing catalog.

Prerequisites

A range table class must be configured in the pricing catalog of the service provider. Use SAP CC Core Tool to configure this master data.

Integration

There is no specific integration information.

Constraints and Integrity Conditions

There is no specific constraint.

Notes on SAP CC Implementation

You must have installed and configured the SAP CC Core Server system.

Configuration

Consult the SAP CC Configuration and Implementation Guide to know the necessary configuration or Customizing of the SAP CC system.

Before implementing SAP Convergent Charging in your SAP system landscape, you must configure the systems and the data (master data, business data).