Skip to Content
0
Former Member
Nov 17, 2004 at 12:56 PM

Is XI Mapping dependent on the Adapter Type ??? JDBC versus File Adapter

26 Views

Gretings,

I am setting a scenario JDBC (Access) -> XI -> Idoc ->R3.

First I set up the scenarion File ->XI ->IDOC. Everything worked fine, and the I tried to use JDBC adapter instead of the File Adapter. The JDBC adapter is able to retrieve the data from the Access Database but I got a mapping problem only the Idoc control record was filled, the data segment are empty.

This mapping was working fine in the case of a File adapter !!!

Here is the XML File in a case of File Adapter :

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

- http://aramco.com/XI/POS_OIL">

<DATE>11/17/2004</DATE>

<TIME>08:25:03</TIME>

<TRANS_CODE>01</TRANS_CODE>

<CUSTOMER>1235</CUSTOMER>

<AMOUNT>105</AMOUNT>

<POS_ID>1000</POS_ID>

</ns:POS_TRANSACTION>

And then The XML file in a case of JDBC adapter :

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

- http://aramco.com/XI/POS_OIL">

- <row>

<DATE>11/17/2004</DATE>

<TIME>00:00:07</TIME>

<TRANS_CODE>01</TRANS_CODE>

<CUSTOMER>23456</CUSTOMER>

<AMOUNT>1456</AMOUNT>

<POS_ID>1000</POS_ID>

</row>

</ns:POS_TRANSACTION>

what is really strange is SAP XI mapping process should be adapter independent ! why am I having this problem ?

Any help is more than welcome.

Regards,

Mustapha