|
|
SQL Finance / CPI and FC Rates
API SB Obob / Get Currency Rate
ORTT - CPI and FC Rates Table
Get Currency Rate GetCurrencyRate Method· Table: ORTT
Parent: SB Obob SBObob Object
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | RateDate KEY | Exchange Rate Date | Date | 8 | DATE | No |
|---|---|---|---|---|---|---|---|---|
| Currency | Currency Code | nVarChar | 3 | |||||
| Rate | Currency Rate | Num | 20 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users |
SELECT statement
SELECT
ORTT.RateDate AS 'Exchange Rate Date',
ORTT.Currency AS 'Currency Code',
ORTT.Rate AS 'Currency Rate',
ORTT.DataSource AS 'Data Source',
ORTT.UserSign AS 'User Signature'
FROM ORTT AS ORTT
Related information
Get Currency Rate GetCurrencyRate Method· Table: ORTT
Returns a Recordset object that contains the currency rate for a specified date and currency code.
See Currency sample.
Source table: ORTT.
Parent: SB Obob SBObob ObjectUsers OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates