logic needed in selection screen

Former Member — Tue, 22 Apr 2008 04:54:00 GMT

hi experts,

in a selection screen i have one field S_budat ( it contains the range ) the user enters the date in it .the problum is we need to check the following condition .

if sy-datum> s_budat+13 months if it is ok we need get the values from the archive db else r/3 data .but in the mean while we have to check residency limit ( for ex: the data is archived till 22-03-2007. but in the selection screen the user entered the range 20-2-2006 to 24-5-2007 this falls in the both .so for this how to write the logic .till 22-03-2007 we have to take the data from the archive DB after thatwe have to take online data )

points will be reworded.

Re: logic needed in selection screen

Former Member — Tue, 22 Apr 2008 05:05:17 GMT

You can check whether the Achive date lies between the range.

If it does, then create 2 records in the select-option table

1) from s_budat-low to arcive date

2) from archive date to s_budat-high.

Now you can do 2 selects 1 on archived tables , other on R/3 data using these 2 date ranges.

For the 2nd select , you can use the "appending" addition in the select statement

topic Re: logic needed in selection screen in Application Development and Automation Discussions

logic needed in selection screen

Re: logic needed in selection screen