Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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
Use SAP Script generator template for this and there you customized your SAP scripts.
I want to implement incremental load, so want to apply where condition for date field like
date>max(today())
SAP Script generator template won't work
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')
It works
THANKU SO MUCH