biuan SAP® BUSINESS ONE SDK
SQL Reports / Query Result Fields
API QWZ2
QWZ2 - Query Result Fields Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEQuery CodenVarChar
8
PRIMARYYes
NumeratorInternal NumberInt
11
FileCodeTable NamenVarChar
20
FieldAliasField AliasnVarChar
10
TitleField TitlenVarChar
30
SortOrderSort OrderInt
11
SortTypeSort TypeVarChar
Y) Yes
N) No
1
N
GroupByGroup ByVarChar
Y) Yes
N) No
1
N
AgregTypeAgreggate FunctionInt
11
CalcFieldCalculation FieldnVarChar
127
IsCalcIs CalculationVarChar
Y) Yes
N) No
1
N
TmpAliasNew Alias in Res. TablenVarChar
11
TmpDescrNew Description in Res. TablenVarChar
30
Fld2AliasField 2 NumbernVarChar
10
FileCode2Field 2 Table NamenVarChar
20
Agreg2TypeField 2 Aggregate FunctionInt
11
FldOpFormula OperationInt
11
FldCnstValField Const. Val.nVarChar
127
Fld2CnsValField 2 Const. Val.nVarChar
127

SELECT statement

SELECT QWZ2.Code AS 'Query Code', QWZ2.Numerator AS 'Internal Number', QWZ2.FileCode AS 'Table Name', QWZ2.FieldAlias AS 'Field Alias', QWZ2.Title AS 'Field Title', QWZ2.SortOrder AS 'Sort Order', QWZ2.SortType AS 'Sort Type', QWZ2.GroupBy AS 'Group By', QWZ2.AgregType AS 'Agreggate Function', QWZ2.CalcField AS 'Calculation Field', QWZ2.IsCalc AS 'Is Calculation', QWZ2.TmpAlias AS 'New Alias in Res. Table', QWZ2.TmpDescr AS 'New Description in Res. Table', QWZ2.Fld2Alias AS 'Field 2 Number', QWZ2.FileCode2 AS 'Field 2 Table Name', QWZ2.Agreg2Type AS 'Field 2 Aggregate Function', QWZ2.FldOp AS 'Formula Operation', QWZ2.FldCnstVal AS 'Field Const. Val.', QWZ2.Fld2CnsVal AS 'Field 2 Const. Val.' FROM QWZ2 AS QWZ2

Related information
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