topic QUERY in Application Development and Automation Discussions

QUERY

Former Member — Tue, 05 Sep 2006 09:32:36 GMT

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

Re: QUERY

Former Member — Tue, 05 Sep 2006 09:46:46 GMT

Hi,

Can you be more clear?

post the requirement more clearly

Regards,

Sowjanya

Re: QUERY

Former Member — Tue, 05 Sep 2006 09:52:49 GMT

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

Re: QUERY

Former Member — Tue, 05 Sep 2006 10:01:06 GMT

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.

Re: QUERY

Former Member — Tue, 05 Sep 2006 10:07:08 GMT

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