Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Modify data of a temp table in AMDP

Go to solution
Former Member

‎05-13-2016 9:46 AM

0 Kudos

Hello All

I'm currently looking at a scenario within AMDP where I need to modify the data of a select query within the AMDP method.

For Ex: I select data from tables BKPF and ACDOCA, from the resultant set I would like to modify 3 fields A, B, C with the value in column D.

I have tried to implement various options but could not achieve the desired results, also I was trying to find out if there is a possibility of calling a non AMDP method inside an AMDP method?

Regards
Sachin

1 ACCEPTED SOLUTION

Go to solution
thomasgauweiler
Active Participant

‎05-13-2016 9:55 AM

Your first question seems to be the same as discussed in

You can call any Hana function or stored procedure from an database procedure.

Regards, Thomas

2 REPLIES 2

Go to solution
thomasgauweiler
Active Participant

‎05-13-2016 9:55 AM

Your first question seems to be the same as discussed in

You can call any Hana function or stored procedure from an database procedure.

Regards, Thomas

Go to solution
Former Member
In response to thomasgauweiler

‎05-19-2016 8:19 PM

0 Kudos

Thanks for the insight Thomas. Actually my fields were of char type and no arithmetic operations involved. So I could modify the values by creating a calculated column using case statement.

The reason why I was so keen about other methods inside AMDP was to identify if we could use a method which has Open SQL code and access that within the AMDP. But it wasn't possible.