Skip to Content
0
Apr 23, 2015 at 05:09 AM

Aggregate qty by plant using Crosstab

18 Views

Hello All,

Could anyone give me more details about using crosstab? I never used crosstab action block in MII workbench.

Here is what I have in my XMLOutput.

Plant Qty MaxQTy

1001 1500 15000

1002 500 1000

1002 10000 15000

1004 0 12000

I need the output like this

Plant Qty MaxQTy

1001 1500 15000

1002 10500 16000

1004 0 12000

In the Crosstab action block I was mentioning Document output in the Document Source and in the Crosstab columns I mentioned Matnr column. How to get the Aggregate Qty and Max Qty by material?

Thanks,

Latha

Attachments

image.png (37.1 kB)