The ISO_4217 table stores all the data definitions for the ISO 4217 currency codes
that must be known by the SAP CC Core Server system.
When you design and configure some ISO-based currencies,
the definitions for these ISO 4217 currency codes are required first.
By default, the database table includes some predefined business data.
See also: CURRENCY database table
| Schema Version | 2022.0.2 | |
| Filegroup | CATALOG_DATA | |
| Partitioned | No | |
The ISO_4217 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_ISO_4217_CODE |
|
The ISO 4217 currency code (three-letter key) as defined by the International Standards Organization (ISO). It is unique in the SAP CC system and in the back-end database. | |||
| NUMERIC_CODE |
|
The numeric code for the ISO 4217 currency code as defined by the International Standards Organization (ISO) | ||||
| RATIO_FRACTION |
|
The unit of the whole part of a currency definition based on this ISO currency code | ||||
| SMALLEST_UNIT_FRACTION |
|
The smallest multiples of sub-unit in use for scriptural payment for a currency definition based on this ISO currency code |
Concepts (SAP CC)
ISO 4217 currency codes are some business data that is configured in SAP Convergent Charging
in order to define the necessary ISO-based country currencies that are associated
to computed amounts (dynamic prices).
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.
An ISO currency code is identified by a three-letter code such as EUR, USD, or JPY.
The code is defined by the international ISO 4217 and ISO 3166 standards.
The currency code is defined by:
The first two letters of the ISO 4217 code are the same as the code for the country
name (see the ISO 3166 standard).
The third letter may relate to the first letter of the currency name.
Examples
You configure an SAP CC system with the following ISO 4217 currency codes:
You can design your necessary country currencies based on these ISO codes or
define custom or non-ISO currencies such as the PNT (Point) currency.
ISO 4217 Currency Codes in SAP CC
ISO Currency Code
Numeric Code
Ratio of Fraction
Smallest Unit As Fraction
EUR
978
100
1
JPY
392
100
100
USD
840
100
1
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The ISO 4217 currency code (three-letter key) as defined by the International Standards Organization (ISO). It is unique in the SAP CC system and in the back-end database. |
| Description |
CODE is reused to configure ISO-based currencies in the database and SAP CC system.
|
| Type | NVARCHAR(3), NOT NULL |
| Primary Key | PK_ISO_4217_CODE |
| Definition | The numeric code for the ISO 4217 currency code as defined by the International Standards Organization (ISO) |
| Type | DECIMAL(3), NOT NULL |
| Definition | The unit of the whole part of a currency definition based on this ISO currency code |
| Type | DECIMAL(28), NOT NULL |
| Definition | The smallest multiples of sub-unit in use for scriptural payment for a currency definition based on this ISO currency code |
| Type | DECIMAL(28), NOT NULL |
See the primary key information:
| Column(s) | CODE |
| Filegroup | CATALOG_DATA |
