regarding query

Hello experts pls help me in writing query.

For each Material that has been u201Cproducedu201D a weighted average consumption per 1 unit of output must be calculated for all components used in actual production of the good. For each component consumed a corresponding row should be displayed in the report.

Read AUFM for all Order Numbers (AUFM-AUFNR) where the Produced Good (AUFM-MATNR) has at least one record with a Movement Type (AUFM- BWART) equal to u2018101 or 102u2019 AND where Posting Date (AUFM-BUDAT) is within the user defined date range AND where Plant (AUFM-WERKS) is within the user defined range.