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

[jhew1234]

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? 

[H_Julian]

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'

[jhew1234]

Hi Julian, 

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