pls do the needful

[Former Member]

hi

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

[Former Member]

hi

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

[former_member404244]

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

[Former Member]

hi

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

[Former Member]

HI

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

[Former Member]

hi,

yoU NEED TO WRITH THE SELECT STATEMENT FOR FETCHING DATA IN

START-OF-SELECTION.

REWARDS IF USEFUL,

REGARDS,

NAZEER

[Former Member]

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