|
|
API PRQ10
PRQ10 - Purchase Request - Row Structure Table
Purchase Request OPRQ 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 | Internal Document ID | Int | 11 | OPRQ Purchase Request | SECONDARY | 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 | 1470000113 |
Table relationship map
SELECT statement
SELECT
PRQ10.DocEntry AS 'Internal Document ID',
PRQ10.LineSeq AS 'Row Sequence',
PRQ10.AftLineNum AS 'After Row Number',
PRQ10.OrderNum AS 'Order Number',
PRQ10.LineType AS 'Row Type',
PRQ10.LineText AS 'Row Text',
PRQ10.LogInstanc AS 'Log Instance',
PRQ10.ObjType AS 'Object Type'
FROM PRQ10 AS PRQ10
Related information
Purchase Request OPRQ 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
