From SAP to excel

You can save an Excel worksheet as XML and then see how the schema is constructed.

I have transformed Raw XML to Excel XML with an XSLT that I wrote, but not using Biztalk, however it should be possible.