cancel
Showing results for 
Search instead for 
Did you mean: 

How to execute and get data from a function module in a SAP Hana Studio

former_member700692
Discoverer
0 Kudos

Hi,

Generally I am a SQL developer and new to SAP Hana DB. My customer has a FM which i am trying to execute in SAP Hana Studio supported by SQL console.

Below is the syntax of my FM and I need to know how to execute this in as SQL query in SQL console of SAP Hana Studio. Please help

CALL FUNCTION 'VC_I_GET_CONFIGURATION'

EXPORTING
instance = Passing cuobj Value for every Sales Order/Line Item

language = sy-langu
print_sales = 'X'

TABLES
configuration = Table name for Holding the Output

EXCEPTIONS

OTHERS = 4.

jerryjanda
Community Manager
Community Manager
0 Kudos

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and use the "insert code" button to make the question easier to read. The more details you provide, the more likely it is that members will be able to assist you. As it stands, you don't ask a question directly, so members may not completely understand what assistance you require.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Kind regards,

--Jerry

Accepted Solutions (0)

Answers (1)

Answers (1)

pfefferf
Active Contributor
0 Kudos

You cannot execute an ABAP function module from a HANA SQL console or call an ABAP function module from the HANA SQL layer.

former_member700692
Discoverer
0 Kudos

In that case how can i execute the ABAP function module by passing parameters and get the results ?

pfefferf
Active Contributor
0 Kudos

Maybe you want to describe your scenario?