topic Re: pls do the needful in Application Development and Automation Discussions

pls do the needful

Former Member — Mon, 10 Sep 2007 06:35:58 GMT

i have threee input parametres

parametesr: p_matnr LIKE mara-matnr OBLIGATORY ,

p_charg LIKE mchb-charg OBLIGATORY,

p_werks LIKE marc-werks OBLIGATORY,

in input selection i am entering the values.

say matnr qm002

batch f4005

plant 1101

now what happens is

i am declare

at selection screen on value request for p_matnr.

now i am fetching the query and populating the data to internal table

while fetching the data

SELECT * FROM lips INTO CORRESPONDING FIELDS OF TABLE p_it_values

where werks = p_werks

AND matnr = p_matnr

AND charg = p_charg.

here the entries of p_matnr and p_charg and p_werks shows no entries .

whiole i am giving input selection screen

how to solver that one

pls let me know it's urgent

regards

suma

Re: pls do the needful

former_member404244 — Mon, 10 Sep 2007 06:39:41 GMT

Hi,

remove the following statement.

(at selection screen on value request for p_matnr.)

Now write only the below code.

SELECT * FROM lips INTO CORRESPONDING FIELDS OF TABLE p_it_values

where werks = p_werks

AND matnr = p_matnr

AND charg = p_charg.

Regards,

nagaraj

Re: pls do the needful

Former Member — Mon, 10 Sep 2007 06:41:22 GMT

p_matnr

p_charg and

p_werks

are 3 values and not range...now when you give 3 values and use the 3 values in select statement USING AND OPERATOR THEN THIS MEANS THAT THE RECORD WITH THE 3 FIELDS EQUAL TO THE INPUT WILL ONLY GET SELECTED maybe the entered combination has no values in lips.

have you checked the dbtab with the following values?

thanks

vivekanand

Re: pls do the needful

Former Member — Mon, 10 Sep 2007 06:42:05 GMT

hi,

yoU NEED TO WRITH THE SELECT STATEMENT FOR FETCHING DATA IN

START-OF-SELECTION.

REWARDS IF USEFUL,

REGARDS,

NAZEER

Re: pls do the needful

Former Member — Mon, 10 Sep 2007 06:44:07 GMT

use this

SELECT * FROM lips INTO CORRESPONDING FIELDS OF TABLE p_it_values

where werks in p_werks

AND matnr in p_matnr

AND charg in p_charg.

regards

prajwala.k

Re: pls do the needful

Former Member — Mon, 10 Sep 2007 06:45:01 GMT

Hi Suma,

I think you are not clear with this "at selection screen on value request for p_matnr" - this event is used to provide f4 help for the parameter p_matnr only.

If you want to populate some internal tables based on your parameters, then you have to write those code in the event "START-OF-SELECTION".

So write the internal table filling code in the start-of-selection event.

Regards,

Sheron