SAP PO message mapping issue - unable to see fields (Tabular Tree View) in the xml imported.

[arnab_mondal2]

Hi Experts,

I got an xml extract from C4C system. Path as follows:

Business Configuration -> Implementation Project -> Prepare -> Prepare for Data Migration.

The extract from this path is an xml file . This is a data migration template. This xml file can also be opened in ms excel and there we can see multiple tabs and each tab having a set of rows and columns . These columns have different field names and below we need to populate data. The requirement is to upload the xml in message mapping target side and map necessary inputs with these fields and fill them with data . So that the output is a filled up template .

The issue I am facing is though I am able to import the xml in message mapping of PO but though I can see the fields in Source Text View BUT not visible in Tabular Tree View. Because of this I cant do mapping with source fields .

I need help to understand why and how it can be handled?

Thanks and Regards,

Arnab Mondal.

[former_member216164]

Hi Arnab,

If I understand correctly, you are trying to import XML message in message mapping. You cant do that. You can import XSD instead.

Do this.

1. First convert your xml message in to xsd. You can do this with any XML to XSD converter available. Following link is an example converter online
https://www.freeformatter.com/xsd-generator.html#ad-output

2. Create an external definition in ESR and import this xsd.

3. Use this external definition in your message mapping.

Then you can be able to see your xml structure in message mapping.

Thanks & Regards,

Avinash Bandela

[arnab_mondal2]

Have tried this earlier . I believe this is due to several levels of nested fields .But will try again though.