Why SQL syntax error is there in Dynamic Database View Capability on Decision Service Management?

[Former Member]

I tried to implement dynamic database view concept provided on below link.

https://www.sap.com/documents/2015/08/78e96820-577c-0010-82c7-eda71af511fa.html

After running the solution, I am getting error. While simulation, I found that I am getting SQL syntax error as below. Kindly help me to understand how shall I resolve this issue as SQL code is getting written by system itself.

Thanks,

[christianlechne]

Hi,

did you check SAP notes if there is one that is linked to such an issue? If there is no note available you have to open a support message to SAP, as this is probably an error in the BRFplus itself.

However, you help the support and maybe narrow down the root cause:

• Can you execute the simulation in interpretation as well as in generation mode? Do both mode show the same error or is just an error in when running the simulation in the interpretation mode?
• If the error occurs in both cases can you try to execute a code generation of your BRFplus function (available on function level) and do a syntax check of the generated code. Maybe it is obvious from the ABAP code itself

Best regards

Christian