|
|
SQL 
Finance / 
VAT Reposting Wizard
API OVRW
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| RunName | Wizard Run Name | nVarChar | 100 | |||||
| RunDate | Wizard Run Date | Date | 8 | |||||
| Status | Status | VarChar | E) Executed S) Saved D) Draft C) Canceled | 1 | E | |||
| UserSign | User Signature | Int | 11 | OUSR Users | ||||
| LedgerType | Ledger Type | VarChar | S) Sales P) Purchase | 1 | S | |||
| DebitAcc | Debit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PostDate | Posting Date | Date | 8 | |||||
| JESeries | Journal Entry Series | nVarChar | 6 | 0 | ||||
| APTISeries | A/P Tax Invoice Series | nVarChar | 6 | 0 | ||||
| DateType | Date Type | VarChar | R) Posting Date D) Due Date T) Document Date | 1 | R | |||
| DateFrom | Date From | Date | 8 | |||||
| DateTo | Date To | Date | 8 | |||||
| IncCorAlt | Include Corr. and Alter. | VarChar | Y) Yes N) No | 1 | N | |||
| BPLId | Active Branch | Int | 11 | OBPL Business Place |
Table relationship map
SELECT statement
SELECT
OVRW.AbsEntry AS 'Internal Number',
OVRW.RunName AS 'Wizard Run Name',
OVRW.RunDate AS 'Wizard Run Date',
OVRW.Status AS 'Status',
OVRW.UserSign AS 'User Signature',
OVRW.LedgerType AS 'Ledger Type',
OVRW.DebitAcc AS 'Debit Account',
OVRW.PostDate AS 'Posting Date',
OVRW.JESeries AS 'Journal Entry Series',
OVRW.APTISeries AS 'A/P Tax Invoice Series',
OVRW.DateType AS 'Date Type',
OVRW.DateFrom AS 'Date From',
OVRW.DateTo AS 'Date To',
OVRW.IncCorAlt AS 'Include Corr. and Alter.',
OVRW.BPLId AS 'Active Branch'
FROM OVRW AS OVRW
Related information
Business Place OBPL SQL Table
G/L Accounts OACT 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