Skip to Content

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

message mapping

My interface is the sync webserver (soap) -> xi -> (jdbc) database. I am using sql query to select the databse. It work on a simple query when I have one to one mapping between the database request and database request_response but in my query, I also need have the employee last name and supervisor last name valure return but in the database, the last name field is the same for both employee and manager, but in the datatype, it is not allow me to have duplicate fields call LAST_NAME. Any suggestion?

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

- <ns0:MT_EmployeeInfoDatabaseRequest_response xmlns:ns0="urn:test.finance:EmployeeHierarchy">

- <STATEMENT_response>

- <row>

<EMPLID>1230</EMPLID>

<<b>LAST_NAME</b>>Yguen</LAST_NAME>

<FIRST_NAME>Ha</FIRST_NAME>

<N_RACF_ID />

<EMAIL_ADDR />

<GRADE>V</GRADE>

<EMPL_STATUS>A</EMPL_STATUS>

<DEPTNAME>Factory Store</DEPTNAME>

<SUPERVISOR_ID>1239</SUPERVISOR_ID>

<<b>LAST_NAME</b>>Negn</LAST_NAME>

<FIRST_NAME>Diana</FIRST_NAME>

<MIDDLE_NAME />

<GRADE>U</GRADE>

<N_RACF_ID>DNEGRO</N_RACF_ID>

<EMAIL_ADDR></EMAIL_ADDR>

</row>

Former Member
Former Member replied

You can qualify the query with A.LAST_NAME and B.LAST_NAME

In your data type you must create two distinguishable elements to map the above to

0 View this answer in context

Helpful Answer

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