Pull records from SAP with where clause

[Anonymous]

Hi,

I want to only bring the records that have scale quantity 1 (from SAP). The code below is giving me this error message:

Load

   [KNUMH] as [Cond.record no],

   [KSTBM] as Scale_Quantity,

   [KBETR] as [Amount LC1];

SQL Select KBETR KSTBM KNUMH from KONM

where [KSTBM]=1 ;

Writing [KSTBM]='1'  is throwing the following error. Please help.

[sunny_talwar]

Have you tried running the same query outside of QlikView?

[alexpanjhc]

Do not you need comma?

SQL Select KBETR , KSTBM , KNUMH from KONM

where [KSTBM]=1 ;