Skip to Content
0
Former Member
Sep 08, 2007 at 03:29 PM

Select based on period

631 Views

Hi all,

I have a select option for period and I need to select all SO document which fall whithin the period on the selection screen.

For example : if user key in period 07, program need to filter and select only for SO with month July.

I write as this :

select * into corresponding fields of table itb

from ekko.

check ekko-bukrs eq p_bukrs and

ekko-bedat+4(2) in s_monat.

append itb.

As there's a lot of data in the table, so it's running slow.

Is there any other way to code ?

How can i write my code for the selection?

Please kindly help me on this.

Thanks in advance.

Pompoug