|
|
SQL Finance / Journal Vouchers List
API OBTD / Journal Vouchers
OBTD - Journal Vouchers List Table
Journal Vouchers JournalVouchers Object· Table: OBTD
OBTD SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BatchNum KEY UNIQUE | Journal Voucher No. | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Status KEY | Open/Closed Document | VarChar | O) Open C) Closed | 1 | O | STATUS | No | |
| NumOfTrans | No. of Transactions | Int | 6 | |||||
| DateID | Posting Date | Date | 8 | |||||
| LocTotal | Total (LC) | Num | 20 | |||||
| FcTotal | Total (FC) | Num | 20 | |||||
| SysTotal | Total (SC) | Num | 20 | |||||
| MemoID | Details | nVarChar | 50 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Remarks | Journal Voucher Remarks Field | nVarChar | 50 |
Table relationship map
SELECT statement
SELECT
OBTD.BatchNum AS 'Journal Voucher No.',
OBTD.Status AS 'Open/Closed Document',
OBTD.NumOfTrans AS 'No. of Transactions',
OBTD.DateID AS 'Posting Date',
OBTD.LocTotal AS 'Total (LC)',
OBTD.FcTotal AS 'Total (FC)',
OBTD.SysTotal AS 'Total (SC)',
OBTD.MemoID AS 'Details',
OBTD.UserSign AS 'User Signature',
OBTD.Remarks AS 'Journal Voucher Remarks Field'
FROM OBTD AS OBTD
Related information
Journal Vouchers JournalVouchers Object· Table: OBTD
JournalVouchers is a business object that represents the journal vouchers in the Finance module.
Use the JournalVouchers object as a draft for journal entries. That is, no values are created in the general ledger. The properties of the journal...
OBTD 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
