|
|
API OIRT
OIRT - Interest Prices Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Numerator KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| EffectDate | Expiration Date | Date | 8 | |||||
| AnlIntrst | Annual Interest 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
OIRT.Numerator AS 'Internal Number',
OIRT.EffectDate AS 'Expiration Date',
OIRT.AnlIntrst AS 'Annual Interest Rate',
OIRT.DataSource AS 'Data Source',
OIRT.UserSign AS 'User Signature'
FROM OIRT AS OIRT
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
