Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Source XML to Target XML - Mismatch of Data

Hi,

My scenario involves picking an xml file from legacy and mapping it to a MDM business content (imported an XSD thro' external definition) and after transformation parking the output as xml in the target system.

My source xml file contains:

<?xml version="1.0" encoding="UTF-8"?>

<Import>

<Row>

<PNALT>10000001</PNALT>

<NACHN>Nick</NACHN>

<VORNA>Fernand</VORNA>

<USRTY>Mail</USRTY>

<USRID>abc@asdf.de</USRID>

<USRTY>Tel</USRTY>

<USRTY>Fax</USRTY>

<USRID>0992 / 21-999</USRID>

</Row>

</Import>

The target output xml appears as mentioned hereunder:-

<?xml version="1.0" encoding="UTF-8" ?>

<EmployeeMsg>

<Records>

<Record>

<PersonnelNumber>10000001</PersonnelNumber>

<LastName>Fahrmehrsie</LastName>

<FirstName>Guntera</FirstName>

<CommunicationData>

<CommunicationType>Mail</CommunicationType>

</CommunicationData>

<CommunicationData>

<CommunicationType>Tel</CommunicationType>

<CommunicationIDNumber>abc@asdf.de</CommunicationIDNumber>

</CommunicationData>

<CommunicationData>

<CommunicationType>Fax</CommunicationType>

<CommunicationIDNumber>0993 / 21-999</CommunicationIDNumber>

</CommunicationData>

</Record>

</Records>

</EmployeeMsg>

I am getting a data mismatch in the target output. The mail id is coming under 'Tel'. How will I make the Mail Id to get it displayed under 'Mail'. I have set the <USERID> and <USRTY> to 0... Unbounded and <CommunicationType> and <CommuniationIDNumber> also to 0... Unbounded. I think I have gone wrong in the Mapping.

Can anyone suggest how to fix this issue. Thanks in advance.

Regards.

Praveen

Not what you were looking for? View more on this topic or Ask a question