09-05-2006 10:32 AM
hi friends,
i nedd to calculate MTD QTY oRDERED.
based on the below description plz help me
SO FOR THAT sum all order quantity(kwmeng) and grouping based on "ship-to- number''(kunnr) and material number(matnr)
regards,
divya
09-05-2006 11:07 AM
If you are using query (SQ01 transaction) with ALV GRID style, you have the option at the end of your query run to change the column order (with drag and drop them by their header), to sort the colomns, and make the TOTALS and SUB-TOTALS by the relevant button.
And if you are finished just save the layout as a layout-variant.
Regards
09-05-2006 10:46 AM
Hi,
Can you be more clear?
post the requirement more clearly
Regards,
Sowjanya
09-05-2006 10:52 AM
hi,
already i calculated kwmeng(order quantity) so i need to sum all calculated order quantity(kwmeng) and grouping based on ship to number(kunnr) and matnr
regards,
divya
09-05-2006 11:01 AM
As you said that you have already collected the order qty in an internal table.
Let say you have the table as itab.
itab-structure=>
kunnr
matnr
kwmeng
sort itab.
loop at itab.
write : / itab-kunnr, itab-matnr, itab-kwmeng.
at end of matnr.
sum.
write : / 'Material Total :', itab-kwmeng.
endat.
at end of kunnr.
sum.
write : / 'Ship to Party Total :', itab-kwmeng.
endat.
endloop.
09-05-2006 11:07 AM
If you are using query (SQ01 transaction) with ALV GRID style, you have the option at the end of your query run to change the column order (with drag and drop them by their header), to sort the colomns, and make the TOTALS and SUB-TOTALS by the relevant button.
And if you are finished just save the layout as a layout-variant.
Regards