topic Re: input required- urgent in Application Development and Automation Discussions

input required- urgent

Former Member — Mon, 21 May 2007 10:30:42 GMT

hi all,

i am writing one rfc function module it contains only one input parameter i.e name when i am entering sun* as input parameter it showing the data correctly when i am entering the input as SUNX Limited. in debugging it is considering this input as SUNX LIMITED for this input we dont have data input in kna1 table.

i am sending my code below. please tell me where i made a mistake.

ranges : r_siteinfo for kna1-name1.

r_siteinfo-sign = 'I'.

r_siteinfo-option = 'CP'.

r_siteinfo-low = iv_name1.

append r_siteinfo.

clear r_siteinfo.

select kunnr

name1

ort01

pstlz

from kna1

into table et_siteinfor

where name1 in r_siteinfo and "IV_NAME1 AND

katr1 ne '05' and

ktokd = '0001'.

thanks,

maheedhar.t

Re: input required- urgent

Former Member — Mon, 21 May 2007 10:41:28 GMT

anybody can please respond to my post its urgent for me.

thanks in advance.

Maheedhar.T

Re: input required- urgent

former_member225631 — Mon, 21 May 2007 10:43:16 GMT

Declare like this.

select-options r_siteinfo for kna1-name1 lower case no-display.

Re: input required- urgent

Former Member — Mon, 21 May 2007 10:47:18 GMT

Just Try This.......

SELECT-OPTIONS: r_siteinfo FOR kna1-name1 LOWER-CASE.

Reward All Helpfull Answers......

Re: input required- urgent

Former Member — Mon, 21 May 2007 10:47:36 GMT

hi,

i am writing rfc function module how i can write select option statement?

Re: input required- urgent

former_member225631 — Mon, 21 May 2007 11:02:20 GMT

In your sample code where you have written ranges declaration? In same way try with the select-options. Or elabrate the problem.

Re: input required- urgent

Former Member — Mon, 21 May 2007 11:17:03 GMT

use like

Re: input required- urgent

Former Member — Mon, 21 May 2007 11:17:34 GMT

use like instead of in

where name1 like r_siteinfo and "IV_NAME1 AND

Hope this will solve ur problem..

<b><u>Dont forget to reward all the useful replies</u></b>

Sudheer

Re: input required- urgent

Former Member — Mon, 21 May 2007 11:30:24 GMT

i tried like this also same problem is coming....

Re: input required- urgent

athavanraja — Mon, 21 May 2007 11:40:17 GMT

the rfc's import parameter has to use a data type where lower case is marked (you want it to be case sensitive right?)

for example this data element (NAME1_GP) can be referred.

Raja

Re: input required- urgent

Former Member — Mon, 21 May 2007 11:41:38 GMT

HI ALL,

problem is when i am giving input in small letters in debug mode it is considering in capital letters . this is not required in my program. if i am giving input in small letter it has to consider as small letter only. if iam giving capital letters it has to consider as capital letter . this is my requirement.

thanks,

maheedhar.t

Re: input required- urgent

athavanraja — Mon, 21 May 2007 11:47:57 GMT

what is the type of import parameter you have used

Re: input required- urgent

Former Member — Mon, 21 May 2007 11:49:56 GMT

IV_NAME1 TYPE NAME1_GP

eventhough when i declare like char30 or name1 also same problem is coming.

thanks,

maheedhar.t

Re: input required- urgent

Former Member — Mon, 21 May 2007 11:52:20 GMT

if u want u can write this rfc its very small rfc.

inout is name1

based on this inout i am writing select query as follows...

select kunnr

name1

ort01

pstlz

from kna1

into table et_siteinfor

where name1 in r_sitein and "IV_NAME1 AND

katr1 ne '05' and

ktokd = '0001'.

for this i declared ranges as follows...

ranges : r_sitein for kna1-name1.

r_sitein-sign = 'I'.

r_sitein-option = 'CP'.

r_sitein-low = iv_name1.

append r_sitein.

clear r_sitein.

at the beginig of debug mode plz check iv_name1 value is showing in capital letters when we search the entry in master table kna1 there is no entry with that name. this is the problem. my question is why it is considering as capital letters..

Re: input required- urgent

athavanraja — Mon, 21 May 2007 11:58:15 GMT

make sure that the type name1 assigned to inout supports lowercase .

(double click on name1 to navigate to dataelement->then to domain where lower case check box should be checked)

and for ranges change the code as follows.

data: r_sitein type RSELOPTION ,

wa_data type RSDSSELOPT .

wa_data-sign = 'I' .

wa_data-option = 'CP'.

wa_data-low = iv_name1.

append wa_data to r_sitein.

clear wa_data.

this should work fine.

Re: input required- urgent

Former Member — Mon, 21 May 2007 12:03:58 GMT

hi durai raj,

i tried in this way also. problem is when i am going to debug mode at the first when i enter iv_name it is showing input data in capital letter wventhogh when i entet input data in small letters.

and chenbox is checked for the corresponding dataelemets.

thanks,

maheedhar.t

Re: input required- urgent

athavanraja — Mon, 21 May 2007 12:11:50 GMT

surprising. are you sure that the data passed is in mixed case?

Re: input required- urgent

Former Member — Mon, 21 May 2007 12:16:22 GMT

HI ,

Same problem.

in debug mode at the begining of the line iv_name1 is showing in capital letter when i enter the name in small letters. this is the problem onc eit is fixed . then this rfc should work fine. and that checkbox is checked in the data element.

thanks,

maheedhar.t

Re: input required- urgent

Former Member — Mon, 21 May 2007 12:32:05 GMT

my input parameter is : SUNX Limited

in debug it is considering in capital letter where as in KNA1 there is no entry with capital letter. this is the problem.

Maheedhar.T

Re: input required- urgent

former_member378318 — Mon, 21 May 2007 13:32:16 GMT

Hi Maheedhar,

If you are using transaction SE37 to test your the function in debug then any input will always be converted to upper case. On later releases transaction SE37 comes with a checkbox marked "Uppercase/Lowercase" allowing you to test without your input switching to Uppercase.

In your case write a very simple test program that calls your function, run this program in debug mode and no conversion will take place.

Hope it helps