topic Re: function module(first name and last name as a parameter with table) in Application Development and Automation Discussions

function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:27:21 GMT

hi,

i just want to know how i match input value in function module with the self created ztable first name and last name as a parameter in function module(import).

regards

Ankur

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:30:07 GMT

hi,

if your ztable contains two fields namely first name and lastname.

then in the function module import param declare two param and give like ztable-fieldname.

regards,

Navneeth.K

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:30:35 GMT

Hi Ankur,

Declare your importing parameters referring to the type as ZTABLE-FIRST_NAME and ZTABLE-LAST_NAME.

Regards,

Ravi

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:32:26 GMT

hi,

in addition to my above post in the import parameter column give like this:

parameter name type associated type

firstname like ztable-firstname

lastname like ztable-lastname

hope it solves your query

regards,

Navneeth.K

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:36:52 GMT

actually in my ztable has three field fname lname or age and in function module i import two parameter first_name and last_name and export in one parameter fullname so i just want to know when i execute the function module i give the input as like wise ram in firstname and kumar is lastname but it is not matching my ztable if ram kumar is does not in table then it should showing error but its showing which i give a and b it showing ab.that's my question?????????

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:36:57 GMT

Hi Ankur,

Is your query resolved.

regards,

Navneeth.K

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:39:24 GMT

hi Ankur,

can you be clear with your query if possible provide an example.

regards,

Navneeth.K

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:40:24 GMT

no i have already did this but no result.

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:43:52 GMT

hi,

can you show the source code of the FM.

regards,

Navneeth.K

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:48:31 GMT

thanks for your help actually i am concatename first_name last_name into full_name

import parameter

FIRST_NAME like ZANKUR-FNAME first name

LAST_NAME like ZANKUR-LNAME last name

export parameter

full_name like zankur full name

excaption

error if name not matched

source code

concatename first_name last_name into full_name

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:51:31 GMT

Hi Ankur,

I dont see any select query in your FM souce code wat you can do is first check the ztable in case there is any record with the provided firstname and last name.

then concatenate else come out without giving a value or raise exception.

regards,

Navneeth.K

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:53:54 GMT

hi Ankur,

u can write in this way

select single firstname

lastname

into ( var1, var2 )

from ztable

where firstname = param_firstname

and lastname = param_lastname.

if sy-subrc eq 0.

--then write concatenate stnmnt.

endif.

regards,

Navneeth.K

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 13:54:23 GMT

please give me code that how can i match in ztable with function module parameter.

thanks

ankur

Re: function module(first name and last name as a parameter with table)

Former Member — Thu, 19 Apr 2007 14:07:55 GMT

Hi,

did the above code work.

regards,

Navneeth.K

Re: function module(first name and last name as a parameter with table)

Former Member — Fri, 20 Apr 2007 04:09:03 GMT

hi,

thanks alot i got answer.

regards

Ankur