|
|
DTW A/R Invoice - Row Structure
API Documents / Document Special Lines
INV10 - A/R Invoice - Row Structure Table
Document Special Lines Document_SpecialLines Object· Table: INV10
Parent: Documents Documents Object· Table: OIGE OIGN
A/R Invoice OINV SQL Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | OINV A/R Invoice | SECONDERY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineSeq | Row Sequence | Int | 11 | |||||
| AftLineNum | After Row Number | Int | 11 | |||||
| OrderNum | Order Number | Int | 11 | |||||
| LineType | Row Type | VarChar | T) Text S) Subtotal | 1 | ||||
| LineText | Row Text | Text | 16 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 13 |
Table relationship map
SELECT statement
SELECT
INV10.DocEntry AS 'Document Internal ID',
INV10.LineSeq AS 'Row Sequence',
INV10.AftLineNum AS 'After Row Number',
INV10.OrderNum AS 'Order Number',
INV10.LineType AS 'Row Type',
INV10.LineText AS 'Row Text',
INV10.LogInstanc AS 'Log Instance',
INV10.ObjType AS 'Object Type'
FROM INV10 AS INV10
Related information
Document Special Lines Document_SpecialLines Object· Table: INV10
This object represents text and subtotal lines in marketing documents.
Source table: INV10 and IN10V (a virtual table for storing calculated values).
Parent: Documents Documents Object· Table: OIGE OIGN A/R Invoice OINV 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
