09-10-2007 7:35 AM
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
09-10-2007 7:39 AM
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
09-10-2007 7:44 AM
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
09-10-2007 7:41 AM
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
09-10-2007 7:42 AM
hi,
yoU NEED TO WRITH THE SELECT STATEMENT FOR FETCHING DATA IN
START-OF-SELECTION.
REWARDS IF USEFUL,
REGARDS,
NAZEER
09-10-2007 7:45 AM
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