I need help regarding this start routine code in BI 7.0
Let me explain the scenario:
I need to write code for data load selection criteria in start routine.
The conditions are ZCODE > blank,ZTYPE begins with 'P',ZSTATUS <> '06',
ZSDATE >= new date.
IF source-fields-ZCODE is initial.
If source-fields-ZTYPE cp 'N*'.
If source-fields-Zstatus NE '06'.
select zcode ztype zstatus zsdate zsnum zvnum zfdate from /bic/AZPURDAS00 where ZSADTE >= newdate.
NOTE : new date will be calculated separately.
ZCODE,ZTYPE are attributes of a infobject ZPRNUM in DSO ZPURDAS.Start routine is written while loading data from dso to cube.
Can anyone please correct the code.I am not sure of select stmt in BI 7.0 regarding internal tables.
Thanks in advance!