Hello,
I have scenario from RFC to CSV file
The RFC Structure is:
<?xml version="1.0" encoding="UTF-8" ?>
- <rfc:Z_PORTAL_PRICING_PURCH_PRICE xmlns:rfc="urn:sap-com:document:sap:rfc:functions">
<LAND>NL</LAND>
- <PURCH_PRICE>
- <item>
<MATNR>000000073280004000</MATNR>
<NETPR>4500.00</NETPR>
<PEINH>1</PEINH>
<MEINS>EA</MEINS>
<WAERS>EUR</WAERS>
</item>
- <item>
<MATNR>000000073280004600</MATNR>
<NETPR>70.00</NETPR>
<PEINH>1</PEINH>
<MEINS>EA</MEINS>
<WAERS>EUR</WAERS>
</item>
- <item>
<MATNR>000000073280004700</MATNR>
<NETPR>140.00</NETPR>
<PEINH>1</PEINH>
<MEINS>EA</MEINS>
<WAERS>EUR</WAERS>
</item>
- <item>
<MATNR>000000073280004750</MATNR>
<NETPR>4750.00</NETPR>
<PEINH>1</PEINH>
<MEINS>EA</MEINS>
<WAERS>EUR</WAERS>
</item>
</PURCH_PRICE>
</rfc:Z_PORTAL_PRICING_PURCH_PRICE>
I want to create file like this:
000000073280004000,4500.00,1,EA,EUR
000000073280004600,70.00,1EA,EUR
000000073280004700,140.00,1,EA,EUR
000000073280004750,4750,1,EA,EUR
How can I ignore from the field "LAND"?
How can I return the items?
Thank you
Elad