Skip to Content
0
Former Member
Jan 02, 2006 at 08:34 AM

Report at Material level(for all the plants)?

16 Views

Hi Experts,

We have simple query which gives following output.

&Plant&Material No&Creation Date&Issue date&QTY issued&

P1 M1 01/10/2004 01/01/2005 10

P2 M1 01/12/2004 15/12/2004 20

P3 M1 01/01/2005 15/01/2005 30

Actually I want to report at material level ( for all plants in one shot ) , additionaly I want to show the minimum creation date for that material and minimum issue date and sum of all 3 qty issued.

The output should look like

&Material No&Creation Date&Issue date&QTY issued

M1 01/10/2004 15/12/2004 60

Can any body suggest how do i get the date fields with the above condition

Thanks in advance.

Regs,

Mahantesh