Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Selection Parameter in Reort not working

Former Member
0 Likes
489

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
455

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 lfa1name1 ekkolifnr

FROM ekko

INNER JOIN lfa1 ON ekkolifnr = lfa1lifnr

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.

2 REPLIES 2
Read only

Former Member
0 Likes
455

coding continued from here...

Post only relevant portions of the code

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

Read only

Former Member
0 Likes
456

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 lfa1name1 ekkolifnr

FROM ekko

INNER JOIN lfa1 ON ekkolifnr = lfa1lifnr

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.