Can anyone create a query which lookups the following wherein the Goods Issue is the base document:
1. Document No.
2. Item No.
3. Item Type (this is a UDF in the Item Master Data - OITM, UDF Name: U_ItmTyp)
4. Item Class (this is a UDF in the Item Master Data - OITM, UDF Name: U_ItmClass)
5. Item Group
8. Gross Amount (is equal to Quantity * Price)
The Parameters are:
1. Customer (this is a UDF in the Goods Issue Document-OIGE, UDF Name: U_BPCode)
2. Date Range (from and to dates)
Your inputs would be highly appreciated.
Edited by: Jennifer Tinagan on Jun 17, 2009 7:24 AM