biuan SAP® BUSINESS ONE SDK
SQL Reports / Query Tables
API QWZ1
QWZ1 - Query Tables Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEQuery CodenVarChar
8
PRIMARYYes
NumeratorInternal NumberInt
11
FileCodeTable NamenVarChar
20
IsTempIs TempVarChar
Y) Yes
N) No
1
N
DoJoinDo JoinVarChar
Y) Yes
N) No
1
N
JoinToTblJoined to TableInt
11
NumOfCondsNo. of Conds.Int
11
OuterJoinOuter JoinVarChar
Y) Yes
N) No
1
N
RightJoinRight JoinVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT QWZ1.Code AS 'Query Code', QWZ1.Numerator AS 'Internal Number', QWZ1.FileCode AS 'Table Name', QWZ1.IsTemp AS 'Is Temp', QWZ1.DoJoin AS 'Do Join', QWZ1.JoinToTbl AS 'Joined to Table', QWZ1.NumOfConds AS 'No. of Conds.', QWZ1.OuterJoin AS 'Outer Join', QWZ1.RightJoin AS 'Right Join' FROM QWZ1 AS QWZ1

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