topic Re: REPORTS in Application Development and Automation Discussions

REPORTS

Former Member — Tue, 17 Jun 2008 13:49:18 GMT

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.

Re: REPORTS

Former Member — Tue, 17 Jun 2008 14:00:34 GMT

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

Re: REPORTS

Former Member — Tue, 17 Jun 2008 14:00:45 GMT

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

Re: REPORTS

Former Member — Fri, 13 Feb 2009 07:25:54 GMT

Thanks

Re: REPORTS

Former Member — Fri, 13 Feb 2009 07:28:26 GMT

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

it will work for you ..