Skip to Content
0
Former Member
Dec 03, 2008 at 06:35 AM

Inserting summary value in a ZTABLE

32 Views

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