Import Data in CSV Format into a Range Table

Service Operation (WS)

Definition

To import data in CSV format into a range table.

Technical Data

Software Product and Version	SAP Convergent Charging 2025
Technical Details	rangeTableDataCSVImport
Namespace	http://catalog.v4.ws.highdeal.com/
Proxy Instance in SAP CC System	Updater
Service Operation Version	4
User Operation Auditing	Yes
Audit Domain	CATALOG
Application Area	IS-CC
Direction	inbound
Mode	synchronous
Idempotency	false

Business Context and Use

This service operation is used in the catalog building context, generally by a Customer Relationship Management (CRM) process component. This operation is used to import CSV-formatted data into a range table, and can optionally create this table automatically. By default, the system merges the range sets specified in the operation request with the ones already defined in the range table.

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 .

Related Operations

You can use the following operations to maintain or cancel range sets in a range table:

• Create or change range sets in a range table (rangeTableRangeSetMaintain)
• Cancel range sets in a range table (rangeTableRangeSetCancel)

You can use the following operation to export range table data related to a catalog:

• Export data from a range table to CSV format

You can use the following operation to find range tables and agreement tables based on specified criteria:

• Find range tables

Features

This service operation imports CSV-formatted data into a range table. In an integrated SAP Solution scenario, the operation supports agreement tables.

To import the data, the identifier of the existing range table and the CSV string containing the data must be provided.

The CSV format can be customized by specifying the field separator and the number format (decimal separator and thousand separator).

Two import modes are available (see the csvImportMode element):

• Merge (default):

  The merge mode lets you update an existing range table:

  • Either by updating the range sets already defined in the table with those specified in the operation request
  • Or by adding the range sets specified in the operation request to the table if they are not already defined in the table.
  The merge mode operates only at the range set level. You can import any number of range sets, each with its own period, while preserving other range sets not specified in your operation request.

  A range set is defined by its input values. It consists of at least one range with a unique combination of input values.
  In merge mode, each range set specified in the operation request:

  • Is inserted into the range table for the specified chronology of contiguous periods. If any part of that period overlaps with an existing definition for the same range set, then only the overlapping portion is updated with new data. The overlapping portion may be split into multiple periods to match existing periods in the range table's chronology. The rest of the previous definition remains unchanged.
  • Is considered separately. If more than one range set applies to the same period, then they coexist within that period but do not affect each other.

  Important

  When using the merge mode, the system manages dates as follows:

  • For every range set specified in the operation request, the system records the exact periods (the final one in chronological order does not have an end date and therefore continues indefinitely). If a previous chronology exists for the same range set, its entire end is overwritten by the new input: only those portions strictly earlier than the newly imported periods are retained, meaning the first overwritten period may be divided if there is no exact date match. To overwrite a specific time slot while keeping subsequent data intact, it is necessary to re-specify these later periods explicitly (for the same range set).
  • If the periods of your range set revisions don't match exactly, then all their dates are preserved in the resulting chronology. This results in forming shorter time slots, causing the periods to be split to align with these changes. As a result, some revisions may be distributed over several consecutive slots, although they continue to contain identical information and cover precisely the requested period. This enables the system to create revisions sharing matching start and end dates.
    

    Updating a range table multiple times with different period definitions can lead to an accumulation of dates, resulting in brief periods with the same data. To reorganize or combine fragmented periods, you can use the rangeTableRangeSetMaintain or rangeTableRangeSetCancel operation.

  At the end of the process, the whole chronology is broken down so that a distinct period begins for every start date that was ever imported into the table (which may repeat the same data on consecutive periods).

• ClearAndReplace:

  With this import mode, the system clears all existing data from the range table and replaces it with the data specified in the operation request.

  Caution

  After an import has been completed using the clear and replace mode, the previous data of the range table is permanently deleted.

Option: Creation of the Range Table

An optional tableCreationAttributes element enables the creation of the range table if it does not exist yet (so that you do not have to make sure the table exists before the import).

When present, this element must contain the attributes of the range table to create: identifier of its range table class, agreement identifier if applicable and, optionally, a description and/or additional information.

If the range table already exists, then SAP CC completely ignores all these attributes (your SOAP envelope only needs to pass the XML validation).

Authorizations

To know the role that is expected in the user profile of the SAP CC user specified in your request messages, refer to the SAP CC Security Guide of SAP Convergent Charging.

Error Handling

The SAP CC system may return an error classified into a category and an error stack detailing the issue and its cause.

Categories and Treatments to Implement

Consider the following error categories to design and implement the appropriate behavior of your connected application or system:

Error Category	Description	Error Handling
Already Exists	The data has to be created but another data already exists in the connected SAP CC system with the same type and the same identifier.	Not applicable for this service operation
Does Not Exist	The data to be modified or deleted does not exist in the connected SAP CC system.	Not applicable for this service operation
Invalid	The request or the data is invalid.	Applicable for this service operation:
Incompatible Configuration	The configuration of the connected SAP CC system is not compatible with the data specified in the operation request and the scope of the request. Creating or correcting the prerequisite configuration data (master data, business data) has to be done in the SAP CC system with the Core Tool user interface or within your connected application or system.	Applicable for this service operation:
Prerequisite Missing	Another data mandatory for the operation is not available or is not compatible with the data specified in the operation request. Create a prerequisite for the data.	Not applicable for this service operation
Illegal State	The operation request is valid but was rejected because of the current state of the data in the connected SAP CC system which prevents the execution of the request. The current state of the complete system can be also the origin of the error.	Applicable for this service operation: The request will not succeed without a required manual correction or change in the SAP CC system. You implement error logging and manual retry mechanisms.
Temporary Illegal State	The valid request was rejected because of the temporary illegal state of the data in the connected SAP CC system. The data state may automatically change without any further notification. This is a subcategory of the Illegal State category. The state of a data is temporary illegal but the operation request can be sent again after a waiting period. The current state of the complete system can be also the origin of the error.	Applicable for this service operation: You can implement an automated resend function.

Troubleshooting

Refer to the SAP CC Error Code Reference for more information about a returned error code and the corrective actions necessary for troubleshooting your implementation project.

Message Types

Consult the structures of the message types related to this service operation of SAP CC:

• rangeTableDataCSVImportRequest
• rangeTableDataCSVImportResponse

Prerequisites

There is no prerequisite.

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).