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:
By default, the database table includes some predefined business data: the installation
tool sets up few ISO-based currencies.
Depending on the Implementation Phase, the table may also include some non-ISO currency definitions.
Note
These currencies can correspond to the default currencies defined in SAP CC or
to the currencies retrieved from the implementation of the EIF
in an intergrated SAP Solution scenario with SAP Convergent Invoicing.
Tip
The application administrator for SAP Convergent Charging
manages this business and custom data
with the SAP CC Core Tool user interface:
See also: ISO_4217 database table
| Schema Version | 2022.0.2 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
The CURRENCY table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| CODE | PK_CURRENCY_CODE |
|
The unique identifier for a currency defined in the SAP CC system and its back-end database | |||
| PRECISION |
|
The currency precision that represents the number of decimal places to keep | ||||
| NAME |
|
The legible name for the currency | ||||
| ISO_CODE | ISO_4217 (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. |
SAP Convergent Charging manages ISO and non-ISO based currency definitions.
SAP CC assigns a currency to each computed amount (dynamic price) with a personalized
precision level.
You can process prices with up to six decimal places.
Currencies are part of the business data configured in the complete SAP CC system.
SAP CC handles a proprietary definition for country or custom currencies.
An application administrator manages this business data in close cooperation with
the SAP CC pricing specialists.
The data maintenance depends on various reasons.
Note
In an integrated SAP Solution (with SAP S/4HANA or SAP Business Suite), the currency definitions are configured in the SAP S/4HANA or SAP ERP reference
system first.
The reference system replicates the currency definitions with their number of decimal
places to SAP Convergent Charging
when requested by an SAP CC user.
If your deployment scenario is not based on this SAP Solution, each SAP currency must be configured and maintained in the SAP CC system.
The SAP CC Core Server system stores the currency definitions in the
CURRENCY database table.
In SAP Convergent Charging, you do not configure currencies to manage currency conversion
for the pricing configuration.
An SAP Currency is identified by an alphanumeric code (max. five digits).
This identification code is a three-letter code
when you configure an SAP currency that represents an original country currency
and that is based on the international ISO 4217 standard.
To manage amounts with more decimal places than an original currency, you define some
secondary currencies.
Use a four-digit code to configure some secondary currencies that are based on the
original one but with
some different precision.
Use a personalized code to configure some non-ISO currencies such as the
PNT (Point) currency for example. PNT is defined with no decimal precision.
The currency is defined by:
Examples
You configure an SAP CC system with the following currencies:
Based on these currencies, you can model and design some pricing logic for your marketable
end-customer services.
For example:
SAP Convergent Charging manages some definitions for the IS0 4217 currency codes
to facilitate the configuration of ISO-based country currencies.
In SAP CC, you configure the necessary ISO currency codes (three-letter code, numeric
code, minor currency unit, and ratio).
The international ISO 4217 standard is the reference from the International Standards
Organization (ISO).
An application administrator manages this business data in close cooperation with
the SAP CC pricing specialists.
The data maintenance depends on various reasons.
Note
The SAP CC Core Server system stores the ISO currency code definitions in the
ISO_4217 database table.
With an integrated SAP Solution (based on SAP S/4HANA or SAP Business Suite):
Currencies and Custom Currencies
SAP Currency
Precision
Legible Name
Based on ISO Code
PNT
Zero decimal places
Point
N/A
EUR
Two decimal places
European Euro
EUR (978)
EUR4
Four decimal places
European Euro (4 Dec. Places)
EUR6
Six decimal places
European Euro (6 Dec. Places)
USD
Two decimal places
United States Dollar
USD (840)
USDN
Five decimal places
(Internal) United States Dollar (5 Decimal Places)
USD6
Six decimal places
(Internal) United States Dollar (6 Decimal Places)
See also:
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier for a currency defined in the SAP CC system and its back-end database |
| Type | NVARCHAR(5), NOT NULL |
| Primary Key | PK_CURRENCY_CODE |
| Definition | The currency precision that represents the number of decimal places to keep |
| Type | DECIMAL(3), NOT NULL |
| Definition | The legible name for the currency |
| Type | NVARCHAR(40), NULL |
| 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 | NVARCHAR(3), NULL |
See the primary key information:
| Column(s) | CODE |
| Filegroup | CATALOG_DATA |
