‎2008 Jun 17 2:49 PM
Hi
I have a simple question. i have one selection screen with plant, material and date.
if i select material and multiple dates in selection screen it must fetch all the records from kotd902 table in which material is valid in that date. it must display material and its valid dates.
If any one give answer i will give u max points
thanks
alka.
‎2008 Jun 17 3:00 PM
in selection screen you should have
p_from date parameter and p_to date parameter.
select *
from kotd902
into table it_kotd902
where matwa eq p_mat
and DATBI le p_to
and datab ge p_from.
may be this works
‎2008 Jun 17 3:00 PM
Hi Alka,
What is the actual problem.. you want the actual logic to implement this fucntionality.
As far as my understanding what I have understood is
Put the SELECT Query in the Table and in the where clause pass like this
where matnr in S_matnr
and werks in s_werks
and date in s_dates.
like this.....
&*************** Reward Point if helpful***************&
‎2009 Feb 13 7:25 AM
‎2009 Feb 13 7:28 AM
select <filed> from kotd902 into itab where between <st date > and <end date >
it will work for you ..