I am posting this after unsuccessful searching of various posts. I am using below statement in my AMDP method.
SELECT VALUE INTO lv_value FROM ZBCP WHERE ZZPARID = ‘SIMU’ AND ZZPARGR = ‘END_DATE’;
In the above query am trying to get a value into the scalar variable lv_value in the field VALUE from the table ZBCP.
I will be using this variable in join conditions of a query which will be coming after this.
But the thing is am getting exception “Invalid column index(3)” on the above query. When doing the analysis I found that there no data for the above query for the given condition. So ideally variable should get a blank value when is there is no data maintained in above parameter table which is expected but it is throwing exception.
I tried using EXIT HANDLER with NO DATA error code also but no luck.
Please let me know how to solve this issue.