|
|
API OTPA
OTPA - Tax Parameter Attributes Table
OTPA 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 | Attribute Code | nVarChar | 8 | CODE | Yes | |||
| Descr | Description | nVarChar | 30 | |||||
| DataType | Data Type | VarChar | S) Amounts P) Prices Q) Quantities %) Percents I) Integer A) String M) Measures | 1 | S | |||
| FieldId | Field ID in CUFD | Int | 11 | CUFD User Fields - Description | ||||
| Locked | Locked | VarChar | Y) Yes N) Changeable | 1 | N |
Table relationship map
SELECT statement
SELECT
OTPA.AbsId AS 'Internal Number',
OTPA.Code AS 'Attribute Code',
OTPA.Descr AS 'Description',
OTPA.DataType AS 'Data Type',
OTPA.FieldId AS 'Field ID in CUFD',
OTPA.Locked AS 'Locked'
FROM OTPA AS OTPA
Related information
OTPA 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
