biuan SAP® BUSINESS ONE SDK
API DGP5
DGP5 - Sort By List Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11ODGP
Document Generation Parameter Sets
PRIMARYYes
CondNumCondition NumberInt
11
SortFieldSort FieldnVarChar
-1)
DocNum) Document Number
DocDate) Posting Date
DocDueDate) Due Date
NumAtCard) BP Reference No.
DocTotal) Document Amount
SlpCode) Sales Employee
100
DocNum
SortOrderSort OrderVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates