biuan SAP® BUSINESS ONE SDK
SQL Administration / Expanded Selection Criteria
DTW Financials / Fixed Assets / Capitalization
API DGP2
DGP2 - Expanded Selection Criteria Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11ODGP
Document Generation Parameter Sets		PRIMARYYes
CondNumCondition NumberInt
11
SelFldIDSelection Field IDnVarChar
100
FromStringString Value FromnVarChar
127
FromNumberNumber Value FromInt
11
FromMoneyAmount Value FromNum
20
FromDateDate Value FromDate
8
ToStringString Value TonVarChar
127
ToNumberNumber Value ToInt
11
ToMoneyAmount Value ToNum
20
ToDateDate Value ToDate
8

SELECT statement

SELECT DGP2.AbsEntry AS 'Internal Number', DGP2.CondNum AS 'Condition Number', DGP2.SelFldID AS 'Selection Field ID', DGP2.FromString AS 'String Value From', DGP2.FromNumber AS 'Number Value From', DGP2.FromMoney AS 'Amount Value From', DGP2.FromDate AS 'Date Value From', DGP2.ToString AS 'String Value To', DGP2.ToNumber AS 'Number Value To', DGP2.ToMoney AS 'Amount Value To', DGP2.ToDate AS 'Date Value To' FROM DGP2 AS DGP2

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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates