Ignore field in file content conversion

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Simple, Just map only items to Target Structure , dont map other fields like LAND,

[Former Member · Accepted solution]

I try to solve this issue in file content conversion,

This is possibole?

[Shabarish_Nair · Accepted solution]

>

> I try to solve this issue in file content conversion,
> This is possibole?

unfortunately No.

[Former Member · Accepted solution]

Hi!

The best and easiest and clearest way is to do it in mapping. And your scenario seems to be quite simple.

Regards,

Volker

[Former Member · Accepted solution]

Hello,

Thank you for your answer.

I changed the mapping.

Right now I able to received the file with structure like that:

000000073280004000,4500.00,1,EA,EUR

Only one line

I can't success to returen to all the lines.

Elad

[Former Member · Accepted solution]

Hi!

Then your target structure may have a "cardinality" of "1...1". That is regardless of the amount of elements in your source structure the target structure only contains one element/record.

What you need is "0.. n" or "1...n"

Change your Datatype and/or mapping and it will work.

Hope this helps!

Regards,

Volker

[former_member200962 · Accepted solution]

Only one line 
I can't success to returen to all the lines.

FCC configuration for a similar structure pattern is mentioned in this blog:

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

Regards,

Abhishek.

[Former Member · Accepted solution]

Hello,

The target cardinality is OK

I alredy read the usfaul blog

And I able to create only file with one line.

Any idea?

Elad

[Shabarish_Nair]

target create a structure that doesnt have the LAND field, do your mapping and then easily do the content conversion.