2 ranges of date to be retrieved in one output.

[Former Member]

Hi ALL,

I want to take 2 ranges of sales order date in selection screen.

ex .

sodate1----

---

TO -

---

sodate2----

---

TO -

---

Here if i give 2 ranges of date for example.

ex .

20.07.06 12.08.07

sodate1----

---

TO -

---

06.09.08 10.10.09

sodate2----

---

TO -

---

I want these 2 ranges of sales order date value to be retrieved in 1 coloumn as SO .

Here if i give single range for either one of these sodate1 or sosate2 im getting the output in coloumn SO .

But if i give both the range togather i am not getting the output in SO.

Please suggest me any sample codeing or what to do ????????

(For all salesorder date im using vbak-erdat.)

Provide me some steps to do.

Thanks&Regards,

R.Vinoth.

[hymavathi_oruganti]

hi vinoth,

pls explain clearly , u need the o/p of the two select-options to be displayed in a single column?? or u need them to be displayed together in a single column as a single entry??

u need

20.07.06 12.08.07

06.09.08 10.10.09

like above

or

20.07.06 12.08.07 06.09.08 10.10.09

like above?

[Former Member]

I need the o/p of the two select-options to be displayed in a single column??

EX : sodat1 1.10.2006 TO 20.10.2007

-

---

-

---

sodat2 1.12.2008 TO 20.10.2009

-

---

-

---

I need these dates to be displayed in a single coloumn under SO.

SO (SALES ORDER)

-

---

1.10.2006

2.10.2006

3.10.2006 .

.

.

20.10.2007 AND continuously next range of sodat2 LIKE

1.12.2008

2.12.2008

3.12.2008 .

.

.

.

19.12.2009

20.10.2009

Suggest me some steps to do or any sample codeing.

Thanks&Regards,

R.Vinoth.

[Former Member]

hi

pls check out this

loop at itab where s_date in ( 20.07.06,12,08.07) OR in ( 06.09.08,10.10.09)

write:/

endloop.

[Former Member]

I need the o/p of the two select-options to be displayed in a single column??

EX : sodat1 1.10.2006 TO 20.10.2007

-

---

-

---

sodat2 1.12.2008 TO 20.10.2009

-

---

-

---

I need these dates to be displayed in a single coloumn under SO.

SO (SALES ORDER)

-

---

1.10.2006

2.10.2006

3.10.2006 .

.

.

20.10.2007 AND continuously next range of sodat2 LIKE

1.12.2008

2.12.2008

3.12.2008 .

.

.

.

19.12.2009

20.10.2009

Suggest me some steps to do or any sample codeing.

Thanks&Regards,

R.Vinoth.

[former_member188827]

use da follwing in where clause of ur slect statement

select..... from vbak into ...

where erdat ge sodate1-low and erdat le sodate2-high.

plz reward points if dis helps

[Former Member]

select-options : s_date for sy-datum.

data : date1 like sy-datum, date2 like sy-datum, date3 like sy-datum, date4 like sy-datum.

date1 = '20040101'.

date2 = '20050101'.

date3 = '20070101'.

date4 = '20080101'.

s_date=sign = 'I'.

s_date-option = 'BT'.

s_date-low = date1.

s_date-high = date2.

append s_date.

s_date=sign = 'I'.

s_date-option = 'BT'.

s_date-low = date3.

s_date-high = date4.

append s_date.

Now u get 2 ranges of dates from

date1 to date2 & date3 to date4.

Now u can directly use....

select.....where date in s_date.

Regards

Vasu

[Former Member]

Hi ,

I need the o/p of the two select-options to be displayed in a single column??

EX : sodat1 1.10.2006 TO 20.10.2007

-

---

-

---

sodat2 1.12.2008 TO 20.10.2009

-

---

-

---

I need these dates to be displayed in a single coloumn under SO.

SO (SALES ORDER)

-

---

1.10.2006

2.10.2006

3.10.2006 .

.

.

20.10.2007 AND continuously next range of sodat2 LIKE

1.12.2008

2.12.2008

3.12.2008 .

.

.

.

19.12.2009

20.10.2009

Suggest me some steps to do or any sample codeing.

Thanks&Regards,

R.Vinoth.