Problem in SAP with Where SQL Condition - script

Wed, 03 Jul 2013 23:43:53 GMT

I have the field date call AUDAT in SAP...here like: VBAK~AUDAT.

And I need to put a WHERE condition in this part of the script in QV.

SQL Select VBAP~VBELN VBAP~POSNR VBAP~KWMENG VBAP~VRKME VBAP~PSTYV

VBAK~SPART VBAK~KUNNR VBAK~VKGRP VBAP~MATNR VBKD~BZIRK KNA1~BRSCH

VBAK~KNUMV VBUP~LFGSA VBAK~AUDAT VBAK~ERZET VBAK~CMFRE VBAP~ABGRU VBAK~AUART

VBAP~WAERK VBAP~NETWR VBAP~STCUR VBAP~UMVKN VBAP~LGORT

VBAK~AUGRU VBKD~ZLSCH VBAK~ERNAM VBKD~PLTYP from VBAP

JOIN VBAK ON VBAK~VBELN = VBAP~VBELN

JOIN VBKD ON VBAK~VBELN = VBKD~VBELN

JOIN KNA1 ON KNA1~KUNNR = VBAK~KUNNR

JOIN VBUP ON VBAP~VBELN = VBUP~VBELN AND VBAP~POSNR = VBUP~POSNR

WHERE VBKD~POSNR = '000000';

example:

WHERE DATE([AUDAT]) >= xDATE

WHERE DATE([VBAK~AUDAT]) >= xDATE

but always get an error:

OpenStream failed. Key = SQL_ERROR ( Number:000) for statement:

SQL Select VBAP~VBELN VBAP~POSNR VBAP~KWMENG.....etc.

Re: Problem in SAP with Where SQL Condition - script

Thu, 04 Jul 2013 02:53:08 GMT

I suspect that the Date function is not supported in SAP OpenSQL. Is xDate a QlikView variable? If yes, I suggest that you change format of xDate into the format the used in SAP. This can be done using QlikView function.

topic Re: Problem in SAP with Where SQL Condition - script in QlikView

Problem in SAP with Where SQL Condition - script

Re: Problem in SAP with Where SQL Condition - script