topic Re: Function module - Urgent in Application Development and Automation Discussions

Function module - Urgent

Former Member — Wed, 28 Nov 2007 16:09:25 GMT

Hi Friends,

I have a statement as below in one function module :

SELECT a~matnr

INTO TABLE t_mast

FROM mast AS a

INNER JOIN stko AS k

ON a_{stlnr EQ k}stlnr

AND a_{stlal EQ k}stlal

WHERE a~werks eq plant

AND a~stlal eq alt

AND k~datuv EQ date .

Import parameters are : Plant , Alt and Date.

Here the problem is while I am executing the f/m it is giving the correct values only if input all the input parameters Plant,Alt and Date.If I give Plant and Alt as blank then it is not giving any values from the table.

Could you please telme the resolution for this.

Regards,

Vishnu.

If I am not

Re: Function module - Urgent

Former Member — Wed, 28 Nov 2007 16:13:35 GMT

Hi,

Check before the select if plant or alt or date is initial and then put in where clause only the informed parameters.

Regards.

Mireia

Re: Function module - Urgent

naimesh_patel — Wed, 28 Nov 2007 16:14:42 GMT

You can overcome from this problem by using the RANGES.

Like:

ranges: r_alt for mast-stlal,
        r_date for stko-datuv,
        r_plant for mast-werks.
        
if not alt is initial.        
r_alt-sign = 'I'.
r_alt-option = 'EQ'.
r_alt-low = alt.
append r_alt.        
endif.

if not date is initial.        
r_date-sign = 'I'.
r_date-option = 'EQ'.
r_date-low = date.
append r_date.        
endif.

if not plant is initial.        
r_plant-sign = 'I'.
r_plant-option = 'EQ'.
r_plant-low = plant.
append r_plant.
endif.

SELECT a~matnr
INTO TABLE t_mast
FROM mast AS a
INNER JOIN stko AS k
ON a~stlnr EQ k~stlnr
AND a~stlal EQ k~stlal
WHERE a~werks in r_plant
AND a~stlal in r_alt
AND k~datuv in r_date.

Regards,

Naimesh Patel

Re: Function module - Urgent

Former Member — Wed, 28 Nov 2007 16:15:53 GMT

Change your code to:

SELECT a~matnr
INTO TABLE t_mast
FROM mast AS a
INNER JOIN stko AS k
ON a~stlnr EQ k~stlnr
AND a~stlal EQ k~stlal
WHERE a~werks IN plant     "Here
AND a~stlal IN alt     "Here
AND k~datuv IN date .     "Here

Regards

Aneesh.

Re: Function module - Urgent

Former Member — Wed, 28 Nov 2007 16:22:37 GMT

Hi Naimesh,

Thanks a lot.But what is the reason for this.Because if i run a report with the same statement it works.But why is not working in a fm.If I am not entereing any value for Plant,Alt or date why it is not getting the data where it is supposed to get the entire data.

Regards,

Vishnu.

Re: Function module - Urgent

Former Member — Wed, 28 Nov 2007 16:25:04 GMT

Hi Aneesh,

My input values Plant,Alt and Date are single values not range of values.Is it possible to give range of values in import parameters.If so please explain me how to declare.

Vishnu

Re: Function module - Urgent

Former Member — Wed, 28 Nov 2007 16:27:46 GMT

Hi again,

Are you sure that in the fm the parameters don't have any value? I mean any space or something?

If the select in the report works, it should also work in the fm....

Mireia

Re: Function module - Urgent

naimesh_patel — Wed, 28 Nov 2007 16:30:11 GMT

Because you don't have any entry with the BLANK plant, alt and date. When you exectue this query without entring any data in these fields system tries to find out the data as BLANK and it could not find it.

System tries to select the data with the BLANK becasuse you have used the EQ operator in the where clause. IF you use the IN caluse than it will work and you can use the IN caluse only with the ranges or select options. So, If you change as per my directions you will get the data even if you don't put any thing.

Regards,

Naimesh Patel

Re: Function module - Urgent

Former Member — Wed, 28 Nov 2007 16:35:50 GMT

Yes it is working Naimesh .But when we use parameters in a report and if we give eq operator it works rite?Also is it the only way to get the data by using ranges in case of function modules or is there any other way? I mean is it the general way to do..

Regards,

Vishnu.

Re: Function module - Urgent

naimesh_patel — Wed, 28 Nov 2007 16:48:42 GMT

It is working in the report because we put OBLIGATORY which forces use to put the values on the selection screen.

You can use some predefined ranges table types in the FM's Import parameter.

Like for

PLNAT you can use RANGE_T_WERKS_D

If it not avalible you can create on your own by SE11. Take the reference as RANGE_T_WERKS_D.

Regards,

Naimesh Patel