|
|
API ATX1
ATX1 - Tax Invoice - History - Rows Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BaseEntry KEY UNIQUE | Base Document Internal ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| DocType | Document Type | VarChar | I) Invoice P) Payment J) Journal Entry C) Correction Invoice L) Landed Cost | 1 | I | |||
| RefEntry1 | Ref.1 Document Key | Int | 11 | |||||
| RefEntry2 | Ref.1 Document Key | Int | 11 | |||||
| ObjType | Object Type | Int | 6 | ADP1 Object Settings - History | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| RefType | Ref. Object Type | Int | -1) 13) A/R Invoice 18) A/P Invoice 30) Journal Entry 24) Incoming Payment 204) A/P Down Payment 165) A/R Correction Invoice 163) A/P Correction Invoice 69) Landed Cost | 11 | -1 |
SELECT statement
SELECT
ATX1.BaseEntry AS 'Base Document Internal ID',
ATX1.LineNum AS 'Row Number',
ATX1.Canceled AS 'Canceled',
ATX1.DocType AS 'Document Type',
ATX1.RefEntry1 AS 'Ref.1 Document Key',
ATX1.RefEntry2 AS 'Ref.1 Document Key',
ATX1.ObjType AS 'Object Type',
ATX1.LogInstanc AS 'Log Instance',
ATX1.RefType AS 'Ref. Object Type'
FROM ATX1 AS ATX1
Related information
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