Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Load from SAP, use field BUDAT to load records from certian date, what is the correct sytax?

I'm trying to load table MKPF, however I want to limt the number of records based off of the posting date (Field BUDAT in Sap). I want to do this dynamically eventally, but to beign with I am trying to achieve a sucessful load through hard coding the date. 

The format of the field text is YYYYMMDD. Within my load statment I have written the following: 

```

LOAD MANDT as [client],
MBLNR as [Material Document],
MJAHR as [Material Doc. Year],
BLART as [Document Type],
BLDAT as [Document Date],
BUDAT as [Posting Date] ,
CPUDT as [Entry Date],
CPUTM as [Time of Entry]

where BUDAT >= '20200801'
;

```

When I go to load the data,  0 records are found. 

Is there a problem with the syntax? 

 

 

 

 

 

 

Labels (4)
2 Replies
Highlighted
Contributor III
Contributor III

The SAP Connector uses the Syntax "I GE"(is greater equal), you cannot use symbols within the Connector expression.

">="  equals "I GE"

"<="  equals "I LE"

e.g.

LOAD MANDT as [client],
MBLNR as [Material Document],
MJAHR as [Material Doc. Year],
BLART as [Document Type],
BLDAT as [Document Date],
BUDAT as [Posting Date] ,
CPUDT as [Entry Date],
CPUTM as [Time of Entry]

where BUDAT I GE '20200801'

 

Highlighted
Contributor II
Contributor II

Hi Julian, 

Thanks for the response. This doesn't seem to work either it shows a red line under it?

 

Annotation 2020-08-20 162344.png