|
|
SQL Banking / Tax Payment Wizard
API OTPW
OTPW - Tax Payment Wizard Table
OTPW SQL Table
Journal Entry OJDT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| WizNumber | Wizard Number | Int | 11 | |||||
| WizName KEY UNIQUE | Wizard Name | nVarChar | 50 | NAME | Yes | |||
| WizStatus | Wizard Status | VarChar | S) Saved E) Executed | 1 | S | |||
| CreateDate | Wizard Creation Date | Date | 8 | |||||
| SaveDate | Wizard Save Date | Date | 8 | |||||
| ExecDate | Wizard Execution Date | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | |||||
| Series | Wizard Series | Int | 6 | |||||
| JETransId | Journal Entry Number | Int | 11 | OJDT Journal Entry | ||||
| WizDate | Wizard Date | Date | 8 | |||||
| RG23APart2 | RG23A Part 2 | Int | 11 | |||||
| RG23CPart2 | RG23C Part 2 | Int | 11 | |||||
| SeqCode | Sequence Code | Int | 6 | |||||
| Serial | Serial Number | Int | 11 | |||||
| SeriesStr | Series String | nVarChar | 3 | |||||
| SubStr | Subseries String | nVarChar | 3 |
Table relationship map
SELECT statement
SELECT
OTPW.AbsEntry AS 'Internal Key',
OTPW.WizNumber AS 'Wizard Number',
OTPW.WizName AS 'Wizard Name',
OTPW.WizStatus AS 'Wizard Status',
OTPW.CreateDate AS 'Wizard Creation Date',
OTPW.SaveDate AS 'Wizard Save Date',
OTPW.ExecDate AS 'Wizard Execution Date',
OTPW.UserSign AS 'User Signature',
OTPW.Series AS 'Wizard Series',
OTPW.JETransId AS 'Journal Entry Number',
OTPW.WizDate AS 'Wizard Date',
OTPW.RG23APart2 AS 'RG23A Part 2',
OTPW.RG23CPart2 AS 'RG23C Part 2',
OTPW.SeqCode AS 'Sequence Code',
OTPW.Serial AS 'Serial Number',
OTPW.SeriesStr AS 'Series String',
OTPW.SubStr AS 'Subseries String'
FROM OTPW AS OTPW
Related information
OTPW SQL Table
Journal Entry OJDT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
