Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

SAP CONNECTOR - EVALUATING TODAY'S DATE IN WHERE CLAUSE

I am trying to create a simple incremental load from SAP CDHDR table.  For the initial load using UDATE = 10/01/2017 worked fine.  I’ve tried several different ideas for the incremental load (see below).  What is the best way to get SAP date field(UDATE in this case) = Today’s date in a where clause for an incremental load?  THANKS!!!


Let vToday = Date(Today(), 'MM/DD/YYYY');

LIB CONNECT TO 'SAP'

[DAILY_HEADER]:

LOAD OBJECTCLAS,

OBJECTID,

CHANGENR,

USERNAME,

UDATE,

TCODE,

CHANGE_IND;

SELECT OBJECTCLAS,

OBJECTID,

CHANGENR,

USERNAME,

UDATE,

TCODE,

CHANGE_IND

   

FROM CDHDR

WHERE OBJECTCLAS = 'VERKBELEG' AND UDATE  = '$(vToday)';


or

[DAILY_HEADER]:

LOAD OBJECTCLAS,

OBJECTID,

CHANGENR,

USERNAME,

UDATE,

TCODE,

CHANGE_IND;

SELECT OBJECTCLAS,

OBJECTID,

CHANGENR,

USERNAME,

UDATE,

TCODE,

CHANGE_IND

   

FROM CDHDR

WHERE OBJECTCLAS = 'VERKBELEG' AND UDATE  = sy-datum;

1 Solution

Accepted Solutions
Not applicable

Re: SAP CONNECTOR - EVALUATING TODAY'S DATE IN WHERE CLAUSE

A friend helped me out.  SAP stores that date as YYYYMMDD  so this worked:


Let vToday = Date(Today(), ' YYYYMMDD ');

2 Replies
shraddha_g
Honored Contributor III

Re: SAP CONNECTOR - EVALUATING TODAY'S DATE IN WHERE CLAUSE

What is the format of date in UDATE Field?

Not applicable

Re: SAP CONNECTOR - EVALUATING TODAY'S DATE IN WHERE CLAUSE

A friend helped me out.  SAP stores that date as YYYYMMDD  so this worked:


Let vToday = Date(Today(), ' YYYYMMDD ');

Community Browser