Hi Experts,
Please guide me on how the following:
I have created a Ztable into which i want to upload the Stock in a summary format i.e.
i have got the above values in an internal table. now i want to insert the sum of results into another internal table.
*PLANT MATERIAL BATCH STORAGE QUANTITY MONTH_END_DATE* 0001 ABC-001 12345 RM 500 30.04.2008 0001 ABC-001 12345 RM 1500 30.04.2008 0001 ABC-002 23456 PM 1000 30.04.2008 0002 XYZ-001 12345 RM 500 30.04.2008 0002 XYZ-001 12345 RM 500 30.04.2008 0002 ABC-001 23456 PM 500 30.04.2008 0002 ABC-001 23456 RM 500 30.04.2008
At the end of Plant, Material, Batch & Storage Location system should sum up the quantity and insert into the Internal table. Format is as below
*PLANT MATERIAL BATCH STORAGE QUANTITY MONTH_END_DATE* 0001 ABC-001 12345 RM 2000 30.04.2008 0001 ABC-002 23456 PM 1000 30.04.2008 0002 XYZ-001 12345 RM 1000 30.04.2008 0002 XYZ-001 23456 PM 500 30.04.2008 0002 XYZ-001 23456 RM 500 30.04.2008
I will then insert the above value into a Ztable.
I have tried doing it but i just do not get the summary values.
Please guide on how to achieve it.
I hope i have given you an idea of how i want the data,
Any queries please let me know.
Thank You,
Jitesh