Skip to Content
0
Dec 17, 2018 at 06:06 PM

Invalid column index (3) Exception : AMDP

198 Views Last edit Dec 18, 2018 at 06:17 AM 2 rev

Hi All,

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.

Thanks

Rithika