|
|
SQL Reports / E-Tax Web Site
API OTWS
OTWS - E-Tax Web Site Table
OTWS SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | E-Tax Internal ID | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TwsName KEY | E-Tax Web Site Name | nVarChar | 64 | TWSNAME | No | |||
| TwsURL | E-Tax Web Site URL | Text | 16 | |||||
| TwsDescrip | E-Tax Web Site Description | nVarChar | 127 | |||||
| UserSign | User Signature - Create | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OTWS.AbsEntry AS 'E-Tax Internal ID',
OTWS.TwsName AS 'E-Tax Web Site Name',
OTWS.TwsURL AS 'E-Tax Web Site URL',
OTWS.TwsDescrip AS 'E-Tax Web Site Description',
OTWS.UserSign AS 'User Signature - Create',
OTWS.UserSign2 AS 'Updating User'
FROM OTWS AS OTWS
Related information
OTWS SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
