Skip to Content
0
Former Member
Jun 04, 2009 at 08:43 AM

Ignore field in file content conversion

30 Views

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