script error

[#1]

Hello Guys,

Directory;
 trace 'Finding maximum and minimum modify and create times.';
maxtimes:
LOAD
 date(max(CPUDT)) as MAXCPUDT,
 date(max(AEDAT)) as MAXAEDAT
FROM
List.qvd
(qvd);

/*
The code below loads the delta data from Database
*/
Directory;
 trace 'Loading the delta data...';
List:
LOAD Mid(MBLNR, FindOneOf(MBLNR, '123456789AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTyUuVvWwXxYyZz')) as [Material doc],
 MJAHR as [Mat doc year],
 date(CPUDT) as CPUDT,
 date(AEDAT) as AEDAT,
 date(BUDAT) as BUDAT,
 date(BLDAT) as BLDAT
 ;
SQL select MBLNR MJAHR CPUDT AEDAT BUDAT BLDAT from MKPF
WHERE MJAHR >= 2010 and
CPUDT > fieldvalue('MAXCPUDT',1) //gets the incremental data
or AEDAT > fieldvalue('MAXAEDAT',1) //gets the updated data
;

I dont know where I am doing wrong but here

 WHERE MJAHR >= 2010 and
CPUDT > fieldvalue('MAXCPUDT',1) //gets the incremental data
or AEDAT > fieldvalue('MAXAEDAT',1) //gets the updated data
;

I am getting the following error. Can anyone know how to change so that no error comes?

Thanks in advance

sravan

[#2]

Hello,
I'm not sure but can you try this

SQL select MBLNR ,MJAHR ,CPUDT, AEDAT, BUDAT, BLDAT from MKPF
WHERE MJAHR >= 2010 and
CPUDT > fieldvalue('MAXCPUDT',1) //gets the incremental data
or AEDAT > fieldvalue('MAXAEDAT',1) //gets the updated data
;


hope it can helps

[#3]

Hi Yamaz,

This I already tried. It is not working. Thanks anyway..May be somebody has other idea..

Regards

sravan

[#4]

Guys Any Idea? Stuck with this and could not go further!

Thanks in Advance

Sravan