XML Format

[Former Member]

Hi,

We have got the XML format that is sent from MES to upload the process messages to ERP, I am not able to understand how MII sends this to ERP. I mean MII should convert the xml to ERP understandable format. Below is the XML format.

- <PROCESS_MESS_UPLOAD xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

- <MSEL>

- <item>

<MSID>16</MSID>

<ATNAM>PPPI_PROCESS_ORDER</ATNAM>

<ATWRT>000001000011</ATWRT>

<ATFOR>CHAR</ATFOR>

</item>

- <item>

<MSID>16</MSID>

<ATNAM>PPPI_EVENT_DATE</ATNAM>

<ATWRT>20100916</ATWRT>

<ATFOR>DATE</ATFOR>

</item>

- <item>

<MSID>16</MSID>

<ATNAM>PPPI_EVENT_TIME</ATNAM>

<ATWRT>111355</ATWRT>

<ATFOR>TIME</ATFOR>

</item>

- <item>

<MSID>16</MSID>

<ATNAM>PPPI_OPERATION</ATNAM>

<ATWRT>0100</ATWRT>

<ATFOR>CHAR</ATFOR>

</item>

- <item>

<MSID>16</MSID>

<ATNAM>PPPI_PHASE</ATNAM>

<ATWRT>0260</ATWRT>

<ATFOR>CHAR</ATFOR>

</item>

Any suggestions would be of great help.

Thanks,

Jai

[sidnooradarsh]

Hello Jai,

Yes you should convert XML obtained from MES in the format which is understandable to ECC system, since you have multiple rows, you might need to build a Table input to RFC that is look at Request structure of the BAPI/RFC you are using, generate sample Request XML structure of RFC and then create one similar structure with your MES XML data and then assign your XML to the Request XML of RFC.

You should be able to find some examples in [Batch Manufacturing templates|https://websmp206.sap-ag.de/rds-mii-bm] or [Energy Analysis templates|http://www.sdn.sap.com/irj/sdn/index?rid=/library/uuid/b0536348-a220-2e10-1a95-ed58b57d1e28]

Hope this helps!!

Regards,

Adarsh

[Former Member]

Hello Adarsh,

Thanks for the reply, if I understood you right, you want me to create a table structure in ECC first similar to the XML that I received from MES and then you want me to generate the request XML for the table structure that I created in ECC and then assign the MES XML to the XML I generated?

how about B2MML Schemas, is something that I can use here?

Thanks again,

Jai

[sidnooradarsh]

Hello Jai,

I am sorry you got it wrong may be I was not much clear in my previous post.

You don't need to create anything in ECC, Look at the BAPI/RFC you are calling in MII, say for example you are calling "BAPI_PRODORD_GET_LIST", when you go to Links section of JCo you should be able to see Request, Response structures along with others, now get that sample Request XML by dry run, now create a structure similar to that of Request XML in MII by looping through the records you obtained from MES, then once its ready, map the XML you created with Request XML under Links of JCo action block.

Hope this makes sense for better understanding for what I am suggesting please refer to any sample transactions from templates I mentioned in my previous post in this thread.

Probably this blog might help you

[Calling a BAPI with a Table as an input parameter from xMII|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/6688] [original link is broken] [original link is broken];

Regards,

Adarsh

Edited by: Adarsh Sidnoor on Nov 16, 2011 11:13 AM