Community
Application Development and Automation 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: 
Read only

Parameterize schema name in AMDP for accesing different SLT replicated schemas

Former Member

‎2015 Jan 29 1:08 AM

0 Likes
1,173

Hi All,

We need to create an AMDP for accessing tables from different schemas with SLT replicas of different ERP instances.

Does someone know if it's possible to parameterize schema name on AMDP so it's possible to use the same stored procedure for accessing the same tables on differen schemas on the same HANA DB instance?

Best regards

Fernando Alvarez

Hi All,

We need to create an AMDP for accessing tables from different schemas with SLT replicas of different ERP instances.

Does someone know if it's possible to parameterize schema name on AMDP so it's possible to use the same stored procedure for accessing the same tables on differen schemas on the same HANA DB instance?

Best regards

Fernando Alvarez

Reply
3 REPLIES 3
Read only

sundaresan_k
Product and Topic Expert
Product and Topic Expert

‎2015 Jan 29 4:01 AM

0 Likes
902

Dear Fernando Alvarez,

Does your use case require access to multiple schemas during the same call to the AMDP method at runtime or is it the case that during a method call you would access only one specific schema?

If later is the case you might want to check the possibility of using secondary database connections from AMDP. From NW AS ABAP 7.4 SP08 onwards AMDP methods support the usage of secondary database connections(maintained from DBACOCKPIT). 

You can find more information from this help documentation.

Additionally you can refer to the following blog as well.

Please let us know if this information is helpful to identify the right solution for your use case.

Best regards

Sundar


Read only

amol_samte
Contributor
In response to sundaresan_k

‎2015 Jan 29 5:12 AM

0 Likes
902

Hi Sunder,

We have 7.4 SP 09 BW on HANA parallelly we have maintained different schemas in HANA Studio.

How do I access differnt schemas table inside ABDP?

Regards,

Amol

Read only

Former Member
In response to sundaresan_k

‎2015 Jan 29 2:30 PM

0 Likes
902

Thank you Sundar,

I know that documentation and had already tried secondary connection, the problem is the only type of secondary connection which is supported is a service connection to the same Netweaver database, this is used only for executing the stored procedure in a different LUW than the Netweaver transaction.

If you create a secondary connection on DBCON and pass the connection name to connection parameter you get an error, if you pass "R/3*connectionName" there's no error but queries return no data from tables present in the schema of the user declared for connectionName on DBCON.

In my use case I don't need to access more than one schema during the same execution of the stored procedure but on different executions of it.

Thank you

Best regards