Hi Folks,
I am trying to a delta load for the material extract from SAP BW to IBP using CPI-DS. and I followed SAP help for the same
I am having issue with syntax error as follows, please provide some feedback.
Syntax error at line <143>: <if (get_data('SAPBW_TO_SAPIBP_PRODUCT') = " or $G_RESET = 'Y')>: near <job_checkpoint_enabled> found <identifier> expecting <')', AND, OR>. D:\ProgramData\SAP\DataServicesAgent\log\W5FMC3QKhli_Zzuz7e_M0x20200330_2446422_25.atl - 1 error(s), 0 warning(s)Check and fix the syntax and retry the operation.
Here is my complete pre load script
# Start date
if (get_data('SAPBW_TO_SAPIBP_PRODUCT_GLOBAL_copy') = " or $G_RESET = 'Y')
$G_STARTDATE = to_date('1900-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss');
else
$G_STARTDATE = to_date(get_data('SAPBW_TO_SAPIBP_PRODUCT'),'yyyy-mm-dd hh24:mi:ss');
# End date
if ($G_ENDDATE is null)
$G_ENDDATE = sysutcdate();
print('Using query period from [$G_STARTDATE] to [$G_ENDDATE]');
# Set Global Variables used by S&OP stored procedure call
# ----------------------------------------------------------
# Planning Area - Default is SAPMODEL1
$G_PLAN_AREA = nvl($G_PLAN_AREA, '');
print('INFO - $G_PLAN_AREA set to: '|| $G_PLAN_AREA );
# Batch command processing. Indicates if S&OP should process batch as
# 'INSERT_UPDATE' or 'DELETE'
$G_BATCH_COMMAND = nvl($G_BATCH_COMMAND, 'INSERT_UPDATE');
print('INFO - $G_BATCH_COMMAND set to: '|| $G_BATCH_COMMAND
<br>
Regards
Kalyan.