CURRENCY
Definition
The CURRENCY table contains business data information about the currencies configured in SAP CC
Description
The CURRENCY table contains business data information about the currencies defined
in the SAP CC Core Server system connected to the back-end database system.
These currencies can correspond to the default currencies defined in SAP CC or to
the currencies retrieved from the implementation of the EIF.
The application administrator of SAP CC manages this data with the SAP CC Core Tool
user interface.
Technical Data
| Schema Version | 4.6.2 | |
| Filegroup | CATALOG_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 | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| CODE | PK_CURRENCY_CODE |
|
The currency unique code | |||
| PRECISION |
|
The currency precision | ||||
| NAME |
|
The currency name | ||||
| ISO_CODE |
|
The code of the associated ISO 4217 currency |
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
CODE
| Definition | The currency unique code |
| Type | NVARCHAR(5), NOT NULL |
| Primary Key | PK_CURRENCY_CODE |
PRECISION
| Definition | The currency precision |
| Type | DECIMAL(3), NOT NULL |
NAME
| Definition | The currency name |
| Type | NVARCHAR(40), NULL |
ISO_CODE
| Definition | The code of the associated ISO 4217 currency |
| Type | NVARCHAR(3), NULL |
Primary Key Details
See the primary key information:
PK_CURRENCY_CODE
| Column(s) | CODE |
| Filegroup | CATALOG_DATA |