|
|
SQL Administration / Sort By List
API DGP5
DGP5 - Sort By List Table
Document Generation Parameter Sets ODGP SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | ODGP Document Generation Parameter Sets | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CondNum | Condition Number | Int | 11 | |||||
| SortField | Sort Field | nVarChar | -1) DocNum) Document Number DocDate) Posting Date DocDueDate) Due Date NumAtCard) BP Reference No. DocTotal) Document Amount SlpCode) Sales Employee | 100 | DocNum | |||
| SortOrder | Sort Order | VarChar | A) Ascending D) Descending | 1 | A |
SELECT statement
SELECT
DGP5.AbsEntry AS 'Internal Number',
DGP5.CondNum AS 'Condition Number',
DGP5.SortField AS 'Sort Field',
DGP5.SortOrder AS 'Sort Order'
FROM DGP5 AS DGP5
Related information
Document Generation Parameter Sets ODGP SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
