CURRENCY

Currencies (Business/Custom Data)

Definition

The CURRENCY table contains data definitions for the currencies (ISO or non-ISO) that are configured in SAP CC

Description

The CURRENCY table stores all the data definitions for the currencies (ISO-based or custom) that are necessary to be able to configure some SAP Master Data in SAP Convergent Charging:

Data objects (aka pricing elements) in a service pricing catalog
A subscriber account in customer master data

Note

In this table, the Cockpit Database includes data copied from and synchronized with business data in the SAP CC Core Database (used by the CC Core Server system). The Cockpit user interface refreshes this persistent data into its Cockpit Database.

Technical Data

Schema Version	2023.0.2
Tablespace	COCKPIT_DATA
Partitioned	No

Summary

The CURRENCY table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	IX	Used by	Definition
OID	PK_CURRENCY			The unique identifier of the currency. It is generated by the SAP CC Cockpit application.
CODE		IX_CURRENCY_CODE	RATE_PLAN (CURRENCY)	The currency code (ISO or non-ISO)
NAME		IX_CURRENCY_NAME		The legible name for the currency
PRECISION				The currency precision that represents the number of decimal places to keep
ISO_CODE				The ISO 4217 currency code that the currency is based on. Otherwise there is no value when the currency is a non-ISO currency such as the PNT (Point) currency.

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The unique identifier of the currency. It is generated by the SAP CC Cockpit application.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CURRENCY

CODE

Definition	The currency code (ISO or non-ISO)
Type	VARCHAR(5), NULL
Available Index	IX_CURRENCY_CODE

NAME

Definition	The legible name for the currency
Type	VARCHAR(40), NULL
Available Index	IX_CURRENCY_NAME

PRECISION

Definition	The currency precision that represents the number of decimal places to keep
Type	DECIMAL(5), NULL

ISO_CODE

Definition	The ISO 4217 currency code that the currency is based on. Otherwise there is no value when the currency is a non-ISO currency such as the PNT (Point) currency.
Type	VARCHAR(3), NULL

Primary Key Details

See the primary key information:

PK_CURRENCY

Column(s)	OID
Tablespace	COCKPIT_INDX

Index Details

The following database indexes are available in the CURRENCY database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_CURRENCY_NAME

Indexed Column(s)	NAME
Unique	No
Partitioned	No
Tablespace	COCKPIT_INDX

IX_CURRENCY_CODE

Indexed Column(s)	CODE
Unique	No
Partitioned	No
Tablespace	COCKPIT_INDX