topic Re: Pass multiple values to Function Module export parameter? in Application Development and Automation Discussions

Pass multiple values to Function Module export parameter?

Former Member — Tue, 23 Oct 2012 18:17:29 GMT

Is it possible to return multiple items in a FM export parameter?

Scenario:

I need to create an RFC that returns the current totals for each Measurement Point for a piece of Equipment. I am passing Object Number from EQUI Table to get Measurement Points in IMPTT table; then I am passing the POINT field from IMPTT Table to IMRG table-RECDV (which contains the current measurement point total). This is working fine and returning data for the First Measurement Point, but I am not sure how to make this work for all the Measurement Points instead of just one. I tried a 'SELECT - END SELECT' statement, but that just returned the data for the Last Measurement Point. What is the best way to return data for all of the Measurement Point fields?

Here is the code I have:

FUNCTION Z_MEAS_PT_INFO .
*"----------------------------------------------------------------------
*"*"Local Interface:
*" IMPORTING
*"     VALUE(IV_EQUNR) TYPE EQUI-EQUNR
*" EXPORTING
*"     VALUE(EV_OBJNR) TYPE EQUI-OBJNR
*"     VALUE(EV_POINT) TYPE IMPTT-POINT
*"     VALUE(EV_RECDV) TYPE IMRG-RECDV
*"----------------------------------------------------------------------

SELECT SINGLE OBJNR
FROM EQUI
INTO (EV_OBJNR )
WHERE EQUNR = IV_EQUNR.

SELECT SINGLE POINT
   FROM IMPTT
   INTO (EV_POINT )
   WHERE MPOBJ = EV_OBJNR.

SELECT SINGLE RECDV
   FROM IMRG
   INTO (EV_RECDV )
   WHERE POINT = EV_POINT.

ENDFUNCTION.

Re: Pass multiple values to Function Module export parameter?

RaymondGiuseppi — Tue, 23 Oct 2012 18:38:30 GMT

Change the returned parameters type to ddic internal table type, ans change your select to SELECT INTO TABLE, and FOR ALL ENTRIES IN to build the returned internal table parameter.

Regards,

Raymond

Re: Pass multiple values to Function Module export parameter?

Former Member — Tue, 23 Oct 2012 19:58:17 GMT

hello,

the FM has a option of tables. you could define a table and use that to transfer your values.

best regards,

swanand

Re: Pass multiple values to Function Module export parameter?

Former Member — Tue, 23 Oct 2012 20:00:44 GMT

Thanks for responding Raymond. Are you recommending that I create a table in the Data dictionary that contains the fields that I am interested in returning (EQUI-OBJNR, IMPTT-MPOBJ, IMRG-POINT, IMRG-RECDV) and then pass them to an internal table in the function? (For previous tasks I have been creating Database Views that contain the fields I want, but for some reason making a Database View did not work for me for this objective; I think because I have to pass values to get to the field POINT, so I can’t just put them all in a View and SELECT *)

Would my ‘DDIC internal table type’ be a Tables parameter? If you don’t mind can you elaborate? I am a new ABAP Programmer and this capability is a next step for me. Thanks.

Re: Pass multiple values to Function Module export parameter?

Former Member — Tue, 23 Oct 2012 20:13:17 GMT

Eric,

Table type should go under export/import parameters.

Check this FM as an example - LWMS_LIKP_GET

IMPORT TAB:

IV_OBCLS	TYPE	LTRM_OBCLS
IV_VBELN	TYPE	LWMS_VBELN_VL
IT_VBELN	TYPE	TT_VBELN
IV_WHERE	TYPE	XFELD

TT_VBELN is a table type and is used in import paramters.

Thanks,

Re: Pass multiple values to Function Module export parameter?

Former Member — Wed, 24 Oct 2012 03:16:20 GMT

For multiple records, please use table parameter. Export/Import will work for single field value.

Regards,

Deepti

Re: Pass multiple values to Function Module export parameter?

custodio_deoliveira — Wed, 24 Oct 2012 05:12:30 GMT

Not true. You can use Export/Import for multiple values, if you use a table type (as explained by above)

Re: Pass multiple values to Function Module export parameter?

RaymondGiuseppi — Wed, 24 Oct 2012 05:56:21 GMT

And TABLE parameters in FM are now obsolete, allowed but obsolete.

Table parameters are obsolete CHANGING parameters that are typed as standard tables with a header line.

Regards,

Raymond

Re: Pass multiple values to Function Module export parameter?

RaymondGiuseppi — Wed, 24 Oct 2012 06:01:10 GMT

You create table type via SE11 (check "Data Type" and select "Table type" in pop-up window) Here you define the type of line records using a structure or other ddic object , choose a standard table with default values in last two tabs.

Regards,

Raymond

Re: Pass multiple values to Function Module export parameter?

Former Member — Wed, 24 Oct 2012 19:44:14 GMT

Can someone please demonstrate a simple example of passing multiple export variables in a function module using a Data Dictionary Table Type and an internal table? I have not ever created a table type in the data dictionary. Thank you.

Re: Pass multiple values to Function Module export parameter?

Former Member — Fri, 26 Oct 2012 15:24:25 GMT

hello,

please refer below link for creating table type -

http://help.sap.com/saphelp_erp60_sp/helpdata/en/90/8d731fb1af11d194f600a0c929b3c3/content.htm

For help on function module -

http://help.sap.com/abapdocu_702/en/abenfunction.htm

See below screen, once you define the table type under the associated type you put the name of it and use it in the FM. The table in the FM code will be populated with multiple rows for use.

best regards,

swanand

Re: Pass multiple values to Function Module export parameter?

Former Member — Fri, 26 Oct 2012 19:05:20 GMT

In Remote-enabled Function Modules, TABLES is a valid use... this is preferred, in fact, for RFC's. If not remote enabled, then use the table types to pass tables of data, as noted.

Re: Pass multiple values to Function Module export parameter?

RaymondGiuseppi — Sat, 27 Oct 2012 08:51:01 GMT

Only if you don't use basXML is not selected as the RFC protocol. (Protocol available from Release 7.0, EhP2)

Regards,

Raymond