|
|
API OTPR
OTPR - Tax Return Values Table
OTPR SQL Table
User Fields - Description CUFD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Code KEY UNIQUE | Return Value Code | nVarChar | 7 | CODE | Yes | |||
| Descr | Description | nVarChar | 30 | |||||
| Display | Display | VarChar | Y) Yes N) No | 1 | Y | |||
| FieldID | Field ID in CUFD | Int | 11 | CUFD User Fields - Description | ||||
| Locked | Locked | VarChar | Y) Yes N) Changeable | 1 | N | |||
| DataType | Data Type | VarChar | T) Tax Amounts S) Amounts P) Prices Q) Quantities %) Percents I) Integer A) String M) Measures | 1 | S |
Table relationship map
SELECT statement
SELECT
OTPR.AbsId AS 'Internal Number',
OTPR.Code AS 'Return Value Code',
OTPR.Descr AS 'Description',
OTPR.Display AS 'Display',
OTPR.FieldID AS 'Field ID in CUFD',
OTPR.Locked AS 'Locked',
OTPR.DataType AS 'Data Type'
FROM OTPR AS OTPR
Related information
OTPR SQL Table
User Fields - Description CUFD SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
