Selection Parameter in Reort not working

[Former Member]

hi all,

i have created a report in smart forms.When im going to execute it with my SELECTION PARAMETERS,it will give me all records.

This is my coding for report:

<<Moderator Message: Please post only relevant portions of the code rather than dupinf the entire program>>

coding continued from next post...

Edited by: kishan P on Sep 1, 2010 11:22 AM

[Former Member]

hi all,

i have created a report in smart forms.When im going to execute it with my SELECTION PARAMETERS,it will give me all records.

This is my coding for report:

<<Moderator Message: Please post only relevant portions of the code rather than dupinf the entire program>>

coding continued from next post...

Edited by: kishan P on Sep 1, 2010 11:22 AM

[Former Member]

coding continued from here...

Post only relevant portions of the code

Edited by: kishan P on Sep 1, 2010 11:23 AM

[Former Member]

Hi,

Look at the highlighted ones ... gi_reqdate

FORM f_get_data .

IF sy-subrc EQ 0.

SELECT ematn txz01 menge netpr anfnr banfn

INTO CORRESPONDING FIELDS OF TABLE gi_rfq

FROM ekpo

WHERE matnr IN s_matnr

AND ebeln IN s_ebeln.

SELECT DISTINCT submi BSTYP ebeln lfa1_{name1 ekko}lifnr

FROM ekko

INNER JOIN lfa1 ON ekko_{lifnr = lfa1}lifnr

INTO CORRESPONDING FIELDS OF TABLE gi_ekko

WHERE ekorg eq p_ekorg

AND ebeln IN s_ebeln

AND ekko~lifnr IN s_lifnr

AND submi in s_submi

AND ekko~spras = 'E'.

SELECT bedat badat

FROM eban

INTO CORRESPONDING FIELDS OF TABLE gi_reqdate

WHERE banfn EQ gi_reqdate-banfn <-- Check this one ... gi_reqdate is still not filled and will be empty ...

AND ekorg eq p_ekorg

AND spras = 'E'.

endif.

endform.

Regards,

Srini.