Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

regarding query

Go to solution
Former Member

‎2008 Nov 13 6:54 AM

0 Likes
332

Hello experts pls help me

I want to display applicable materials for an applicable plant in a particular date range

they were taken from AUFM

please tell me the query that works for it

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2008 Nov 13 7:12 AM

0 Likes
311

Hi ,

Select matnr " material

werks "plant

FROM aufm

INTO it_aufm

WHERE matnr IN s_matnr

werks IN s_werks

bldate IN s_bldat.

declare 3 selection screen options for matnr, werks, bldat reffering to AUFM table.

Hope it is useful.

Regards,

Chaitanya

2 REPLIES 2
Read only

Go to solution
Former Member

‎2008 Nov 13 7:12 AM

0 Likes
312

Hi ,

Select matnr " material

werks "plant

FROM aufm

INTO it_aufm

WHERE matnr IN s_matnr

werks IN s_werks

bldate IN s_bldat.

declare 3 selection screen options for matnr, werks, bldat reffering to AUFM table.

Hope it is useful.

Regards,

Chaitanya

Read only

Go to solution
Former Member
In response to Former Member

‎2008 Nov 13 7:33 AM

0 Likes
311

Thanks chaitanya for ur help