topic Re: selection screen in Application Development and Automation Discussions

selection screen

Former Member — Thu, 31 Jan 2008 10:20:27 GMT

hi,

i want to filter my selection screen . i.e. when i enter data

P.O Creation date then it show all record which was created on that date .

now again i want to filter it by putting invoice number at selection screen so it has to show only data which i fill invoice number.

but it show all record within creation date.

how to filter it. ?

below is my code.

IF pr_vbel2[] IS NOT INITIAL. " Invoice Number select option.

LOOP AT it_final INTO wa_final.

DELETE it_final WHERE VBELN_INV IS INITIAL .

ENDLOOP.

ENDIF.

Re: selection screen

former_member404244 — Thu, 31 Jan 2008 10:25:00 GMT

Hi,

try like this''

select podate invoicenumber from dbtable

into table itab

where podate in s_podate

and invoicenumber in s_invoicenumber.

regards,

Nagaraj

Re: selection screen

Former Member — Thu, 31 Jan 2008 10:30:34 GMT

Hi,

try this

IF pr_vbel2[] IS NOT INITIAL. " Invoice Number select option.

LOOP AT it_final INTO wa_final WHERE VBELN_INV IS INITIAL .

DELETE it_final.

ENDLOOP.

ENDIF.

Cheers,

Will.

Re: selection screen

Former Member — Thu, 31 Jan 2008 10:31:02 GMT

It is better to select only the records based on pr_vbel2[] .

ie,

LOOP AT it_final INTO wa_final where <invoice> in pr_vbel2.

endloop.

Re: selection screen

Former Member — Thu, 31 Jan 2008 11:00:59 GMT

You can filter data while fetching from table itself instead looping

anyway You've already defined SELECT-OPTIONS for PO creation date and Invoice.

For example


SELECT <fld1> <fld2> ... INTO CORRESPONDING FIELDS OF TABLE <itab>
FROM <dbtab>
WHERE <podate>  IN S_DATE AND
      <invnum>  IN S_INVOICE.

Re: selection screen

Former Member — Mon, 04 Feb 2008 16:56:57 GMT

thanks to all point has been gvn