04-22-2022 7:30 PM
Hi,
In ABAP Report, the CDS View Table function with AMDP class was used to fetch the data from two database tables. The report is working fine. Now, when modified the data in one database table using another report, then the existing report with CDS View is giving Error: AMDP_EXECUTION_FAILED and Exception: CX_SY_OPEN_SQL_DB. Please guide how to resolve this issue.
Thanks & Regards,
Vinod.
04-22-2022 7:47 PM
1. Check the source code location from St22
2. I think you are calling AMDP method and there you are getting the call why not put a TRY CATCH and read the error message.
3. This exception in normal SQL happens with the incorrect query like column name etc. can u check. Also make sure the SELECT projection list is same as in your CDS Table Function DDL field list.
Try and see what happens. Else come back with what you hav edone in that GEtter method
04-22-2022 7:47 PM
1. Check the source code location from St22
2. I think you are calling AMDP method and there you are getting the call why not put a TRY CATCH and read the error message.
3. This exception in normal SQL happens with the incorrect query like column name etc. can u check. Also make sure the SELECT projection list is same as in your CDS Table Function DDL field list.
Try and see what happens. Else come back with what you hav edone in that GEtter method
04-23-2022 4:54 PM
Hi Prasenjit Bist
Thanks for your quick reply. As suggested I debugged the CDS View (with source code location from 'ST22'), found an issue in AMDP select statement, in the declared 'WHEN' statement. The issue has been resolved.
Thanks & Regards,
Vinod.