|
|
API TPS1
TPS1 - Tax Parameter Attributes Table
Tax Parameter Attributes OTPA SQL Table
Tax Parameter OTPS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TpsId KEY UNIQUE | Tax Parameter Set | Int | 11 | OTPS Tax Parameter | ORDER | Yes |
|---|---|---|---|---|---|---|---|---|
| DispOrder | Display Order | Int | 11 | |||||
| TpaId | ID of Attributes Mapping | Int | 11 | OTPA Tax Parameter Attributes | ||||
| Mandatory | Mandatory to Input | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
TPS1.TpsId AS 'Tax Parameter Set',
TPS1.DispOrder AS 'Display Order',
TPS1.TpaId AS 'ID of Attributes Mapping',
TPS1.Mandatory AS 'Mandatory to Input'
FROM TPS1 AS TPS1
Related information
Tax Parameter Attributes OTPA SQL Table
Tax Parameter OTPS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
