Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

REPORTS

Former Member
0 Likes
535

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.

4 REPLIES 4
Read only

Former Member
0 Likes
511

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

Read only

Former Member
0 Likes
511

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***************&

Read only

Former Member
0 Likes
511

Thanks

Read only

Former Member
0 Likes
511

select <filed> from kotd902 into itab where between <st date > and <end date >

it will work for you ..