topic Re: regarding query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/regarding-query/m-p/4765922#M1117208 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P> Select matnr " material</P><P> werks "plant</P><P> FROM aufm</P><P> INTO it_aufm</P><P> WHERE matnr IN s_matnr</P><P> werks IN s_werks</P><P> bldate IN s_bldat.</P><P></P><P>declare 3 selection screen options for matnr, werks, bldat reffering to AUFM table.</P><P></P><P>Hope it is useful.</P><P></P><P>Regards,</P><P>Chaitanya</P></BODY></HTML> Thu, 13 Nov 2008 07:12:04 GMT Former Member 2008-11-13T07:12:04Z regarding query https://community.sap.com/t5/application-development-and-automation-discussions/regarding-query/m-p/4765921#M1117207 <HTML><HEAD></HEAD><BODY><P>Hello experts pls help me</P><P></P><P>I want to display applicable materials for an applicable plant in a particular date range</P><P></P><P>they were taken from AUFM</P><P></P><P>please tell me the query that works for it</P></BODY></HTML> Thu, 13 Nov 2008 06:54:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-query/m-p/4765921#M1117207 Former Member 2008-11-13T06:54:11Z Re: regarding query https://community.sap.com/t5/application-development-and-automation-discussions/regarding-query/m-p/4765922#M1117208 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P> Select matnr " material</P><P> werks "plant</P><P> FROM aufm</P><P> INTO it_aufm</P><P> WHERE matnr IN s_matnr</P><P> werks IN s_werks</P><P> bldate IN s_bldat.</P><P></P><P>declare 3 selection screen options for matnr, werks, bldat reffering to AUFM table.</P><P></P><P>Hope it is useful.</P><P></P><P>Regards,</P><P>Chaitanya</P></BODY></HTML> Thu, 13 Nov 2008 07:12:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-query/m-p/4765922#M1117208 Former Member 2008-11-13T07:12:04Z Re: regarding query https://community.sap.com/t5/application-development-and-automation-discussions/regarding-query/m-p/4765923#M1117209 <HTML><HEAD></HEAD><BODY><P>Thanks chaitanya for ur help</P></BODY></HTML> Thu, 13 Nov 2008 07:33:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-query/m-p/4765923#M1117209 Former Member 2008-11-13T07:33:41Z