search condition in SAP

[#1]

how to apply the search condition while fetching the data from SAP .

Whenever i tried with  where condition ,its result give all the fields without data.Please help me to resolve this issue

[er_mohit]

Use like function with where condition.

See below

SQL Select * from tablename

WHERE Fieldname LIKE '%FRGKE%';   //here 's FRGKE is the value.

hope it helps

[its_anandrjs]

Use SAP Script generator template for this and there you customized your SAP scripts.

[#4]

I want to implement incremental load, so want to apply where condition for date field like

date>max(today())

[#5]

SAP Script generator template  won't work

[er_mohit · Accepted solution]

so for SAP date format is YYYYMMDD

so for Calculate the max date from SAP table as alike Qlikview Date format in which you want to convert

do this using

Date(Date#(DateField,'YYYYMMDD'),'DD-MM-YYYY')

[#7]

It works

THANKU SO MUCH