selection screen

[Former Member]

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.

[former_member404244]

Hi,

try like this''

select podate invoicenumber from dbtable

into table itab

where podate in s_podate

and invoicenumber in s_invoicenumber.

regards,

Nagaraj

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

thanks to all point has been gvn