RFC to XI File - can NEVER EVER get more than one record in Output file.

[Former Member]

Hi guys

This might be related to my other post on File conversion but whatever I do I just can't seem to get more than one record in the output file

the payload from R3==> XI seems fine

for example

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

- <rfc:Z_XI_005_RFC xmlns:rfc="urn:sap-com:document:sap:rfc:functions">

- <IP_CUSTOMER_HEADER>

- <item>

<CUSTOMERID>1000001</CUSTOMERID>

<COMPANY>One-time ship-to</COMPANY>

<SHORT_NAME>ONE-TIME</SHORT_NAME>

<STREET />

<STREET2 />

<STREET3 />

<STREET4 />

...... more data

</item>

then next customer master data and so on

- <item>

<CUSTOMERID>1000005</CUSTOMERID>

<COMPANY>ddfask</COMPANY>

<SHORT_NAME>;LK;L</SHORT_NAME>

<STREET />

<STREET2 />

<STREET3 />

<STREET4/>

etc etc until

<HKUNNR>60000</HKUNNR>

<SALES_REGION />

</item>

</IP_CUSTOMER_HEADER>

</rfc:Z_XI_005_RFC>

All I get on the Output target file

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

- <ns1:MT_customer_header xmlns:ns1="http://avenue.com/xi/test">

<CustomerId>1000001</CustomerId>

<company>One-time ship-to</company>

<shortname>ONE-TIME</shortname>

.... more data

</ns1:MT_customer_header>

the <item> and subsequent records all seem to have vanished.

I must be doing something PARTICULARLY stupid as nobody else ever seems to have this problem -- I've tried almost every possible combination but still to no avail

The function module is passing a table to XI in the correct structure and the payload seems to be fine so what on earth is broken here !!!,.

Cheers

Jimbo

[Former Member · Accepted solution]

Hi,

The target structure you have created is with 0...unbounded Occurance and major things is check if the Root node of the Target side.

In your case the Root node is missing on the target side...SO check the occurance of all fields.

As well check the mapping of <item> -

---

> <item>

Thanks

Swarup

[Former Member]

Thanks everybody -- it's working now

RFC call was passing data correctly

function z_xi_005_rfc.

*"----

---

""Local interface:

*" TABLES

*" IP_CUSTOMER_HEADER STRUCTURE ZAP_CUSTOMER_INFO_2

*"----

---

endfunction.

in debug mode table data was fine -- in this instance 3 records were being passed.

3 errors in mapping etc fixed (with help from SDN - thanks)

1) missing the ITEM level in the Data type (hence mapping)

2) needed 0:unbounded in the occurrence

3) also mapping Item====>Item was missing (sub fields were ok)

Points awarded

final file output ok output now ok (with 3 fields only for testing)

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

- <ns1:MT_customer_header xmlns:ns1="http://avenue.com/xi/test">

- <item>

<Customerid>1000001</Customerid>

<company>One-time ship-to</company>

<shortname>ONE-TIME</shortname>

</item>

- <item>

<Customerid>1000005</Customerid>

<company>ddfask</company>

<shortname>;LK;L</shortname>

</item>

- <item>

<Customerid>1000010</Customerid>

<company>One Time Customer Test</company>

<shortname>SADFIWQEFG</shortname>

</item>

</ns1:MT_customer_header>

Now only the final problem to make file content conversion work.

Once again thanks --sometimes what seem trivial or simple problems take AGES to fix until someone else gives you a clue --that's why boards like SDN are great value.

Cheers

Jimbo

[Former Member]

Hi Jimbo,

Can you please let us know what output you are able to see at XI side,just check for SXMB_MONI at XI and also check the same at R3 side.

Thanks

Sudharshan

[former_member190389]

Hi

In the target structure you need a node (similar to item in source i.e 0..unbounded occurences)

which is missing in target.

Map that item node to the one which you will create now

[Former Member]

Hi james hawthorne ,

It seems that RFC is sending only one record at a a time, thats the problem in receiving multiple record.

Regards,

Jayasimha Jangam