flat file conversion - mapping & content conversion help

[former_member183906]

Hi All,

Need your help in it.

Its a file to file scenario using FCC. I am picking a flat file (TXT) format.

The file contains identifiers for each field which start with 'ZZ'.The field lengths of ZZFIELD1,ZZFIELD2 and ZZFIELD3 is not fixed.

The Input/Source File (Test1.txt)  looks like this :

ZZFIELD1:Price

ZZFIELD2:200

ZZFIELD3:INR

ZZFIELD1:Price

ZZFIELD2:400

ZZFIELD3:GBP

This file has to be picked up and Output file (Test2.txt) should be -

ZZFIELD1:Price

ZZFIELD2:4

ZZFIELD3:USD

ZZFIELD1:Price

ZZFIELD2:8

ZZFIELD3:USD

How this can be achieved through file content conversion.

I need your help in content conversion parameters mainly.

Regards

Message was edited by: SAP PI

[Former Member · Accepted solution]

Regarding the sender part:

define your message type and communication channel like this:

The receiver should have a similar message type and the following CC

You will need to use the message mapping to add the ZZFIELD<x>: part along with the conversion (from 400 GBP to 8 USD or something like that)

if you need more parameters - refer to SAP HELP:

http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/frameset.htm

Good luck,

Imanuel Rahamim.