Skip to Content
0
Apr 05, 2020 at 06:56 AM

Product change ...Delta loads using CPI-DS for IBP

490 Views Last edit May 25, 2020 at 08:18 PM 2 rev

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

https://help.sap.com/viewer/dab65b1584e04026a132a06a711e3f5a/Cloud/en-US/d4f0cefcb7834676997ee5ffe81c5795.html

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.