How to do SQL like group by in BLS transaction

[Former Member]

Hi All

I am on MII 12.2.I am using different data sources (ECC,SQL) to obtain 3 xml's which i finally merge together to get the desired data something like this :

Plant	Actual Quantity	Planned Quantity
1001	1500	15000
1002	500	1000
1002	10000	15000
1004	0	12000

Now i want to do a group by on plant so that i achieve a total of quantities as per plant like this :

Plant	Actual Quantity	Planned Quantity
1001	1500	15000
1002	15000	16000
1004	0	12000

I want my BLS transaction to return an XML like this.Can some one please guide how to do a group by in a BLS transaction.

[Former Member]

Hi Shweta,

Why dont you create a local MII table with these 3 columns and store data.

So you can anytime do group by on that table data and fetch data?

Regards,

Padma

[Former Member]

Hi All

Its working like a charm with Cross tab,initially i did not know how to use Cross tab  effectively but now its working as desired

[Former Member]

Shweta,

could you let me know how you got the expected result?

[Nikhil_Makhija]

Please check below link :

http://scn.sap.com/thread/3237040

Regards

Nikhil

[Former Member]

thanks Nikhil i already i had this link but i was having issues using the cross tab.