|
|
API VPM8
VPM8 - Outgoing Payment - TDS Entries Table
Outgoing Payments OVPM SQL Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocNum KEY UNIQUE | Document Number | Int | 11 | OVPM Outgoing Payments | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| InvType KEY | Invoice Category | nVarChar | -1) All Transactions 204) A/P Down Payment 18) A/P Invoice 19) A/P Credit Memo 10000079) TDS Adjustment | 20 | -1 | INVOICE | No | |
| DocEntry | Invoice Internal ID | Int | 11 | |||||
| DocLine | Invoice Row Number | Int | 11 | |||||
| ObjectType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 46 | |||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
VPM8.DocNum AS 'Document Number',
VPM8.LineNum AS 'Row Number',
VPM8.InvType AS 'Invoice Category',
VPM8.DocEntry AS 'Invoice Internal ID',
VPM8.DocLine AS 'Invoice Row Number',
VPM8.ObjectType AS 'Object Type',
VPM8.LogInstanc AS 'Log Instance'
FROM VPM8 AS VPM8
Related information
Outgoing Payments OVPM SQL Table
Object Settings - History ADP1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
