biuan SAP® BUSINESS ONE SDK
SQL Reports / Query Condition Fields
API QWZ3
QWZ3 - Query Condition Fields Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEQuery CodenVarChar
8
PRIMARYYes
NumeratorInternal NumberInt
11
OpenBracktOpen Brackets CounterInt
11
FileCodeTable NamenVarChar
20
FieldAliasField AliasnVarChar
30
OperationOperationInt
11
CondValCond. Val.nVarChar
127
CondEndValCond. and Val.nVarChar
127
CompareFldCompare FieldsVarChar
Y) Yes
N) No
1
N
UseResUse Res.VarChar
Y) Yes
N) No
1
N
CompTblIdxCompare Table IndexnVarChar
20
CompFldNumCompare Field NumbernVarChar
127
RelatshipRelationshipInt
11
ClosBracktClose Brackets CounterInt
11
Free_TextFree TextText
16

SELECT statement

SELECT QWZ3.Code AS 'Query Code', QWZ3.Numerator AS 'Internal Number', QWZ3.OpenBrackt AS 'Open Brackets Counter', QWZ3.FileCode AS 'Table Name', QWZ3.FieldAlias AS 'Field Alias', QWZ3.Operation AS 'Operation', QWZ3.CondVal AS 'Cond. Val.', QWZ3.CondEndVal AS 'Cond. and Val.', QWZ3.CompareFld AS 'Compare Fields', QWZ3.UseRes AS 'Use Res.', QWZ3.CompTblIdx AS 'Compare Table Index', QWZ3.CompFldNum AS 'Compare Field Number', QWZ3.Relatship AS 'Relationship', QWZ3.ClosBrackt AS 'Close Brackets Counter', QWZ3.Free_Text AS 'Free Text' FROM QWZ3 AS QWZ3

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