XML format to IDOC's

[Former Member]

Hello expert:

I have the following scene:

SAPR/3 <--

---

XI <--

---

ORACLE

(To process Idoc) (CREATE IDOC) (Table 1 INNER JOIN TABLE 2).

Example - Squence XML:

Table 1: FI Docto 1 Header

Table 2: FI Docto 1 Detail 1.

Table 2: FI Docto 1 Detail 2.

Table 1: FI Docto 2 Header

Table 2: FI Docto 2 Detail 1.

Table 2: FI Docto 2 Detail 2.

I'm alreday recover registers from data base oracle , usisng an inner join, whom retrive

me a simple XML format document with all the registers inside , the problem is that I don't

know how to create the IDOC for each FI document finding in order to send for the R/3

In hope for you help, thanks.

Hello expert:

I have the following scene:

SAPR/3 <--

---

XI <--

---

ORACLE

(To process Idoc) (CREATE IDOC) (Table 1 INNER JOIN TABLE 2).

Example - Squence XML:

Table 1: FI Docto 1 Header

Table 2: FI Docto 1 Detail 1.

Table 2: FI Docto 1 Detail 2.

Table 1: FI Docto 2 Header

Table 2: FI Docto 2 Detail 1.

Table 2: FI Docto 2 Detail 2.

iam alreday recover registers from data base oracle , usisng an inner join, whom retrive

me a simple XML format document with all the registers inside , the problem is that i don't

know how to create the idoc for each fi document finding in order to send for the R/3

In hope for you help, thanks.

Regards,

[justin_santhanam · Accepted solution]

Raul,

Could you give the outbound structure of your payload( from JDBC)

raj.

[Former Member · Accepted solution]

My problem is of XI to SAPR/3, because not like creating the IDOC, in such a way that by each recovered document of Oracle a IDOC can be ganerar.

Only: SAP R/3 <------- XI

Edited by: Raul Alvarado on Feb 28, 2008 9:52 PM

Edited by: Raul Alvarado on Feb 28, 2008 9:52 PM

[Former Member · Accepted solution]

Hi Rahul,

As per my understanding you are loking for creating the IDOC per FI document.

So if in case the multiple rows have retrived from Oracle Join query then Multiple IDOCs to be created. Per row one IDOC.

You can do this just by changing the Occurance of IDOC

Export the XSD structure of imported IDOC from IR and modify the occurance of IDOC field as below example

<xsd:element name="IDOC" type="ZTEST_IDOC.ZIDOC" maxOccurs="unbounded" />

Then Import the xsd file as external defination and use it directly in mapping.

It will create the multiple idocs with mapping Row field of Oracle structure to IDOC field

Thanks

Swarup