cancel
Showing results for 
Search instead for 
Did you mean: 

Look up

Former Member
0 Kudos

Hello every one, i work on EDI and in our organization we are started using PI recently, i have been trained on it but never really worked on it, now i am building a interface by my self i am almost done with ESR part but got one fileld yet to be mapped in Message Mapping.

The interface aim is to convert CSV file to XML. I am using File to File scenario using FCC.

The map requirement is like this i have been given a CSV file with columns ABCDEFGHIJKL I HAVE TO Lookup Column A on 'Cross-Ref' tab and Map Vendor Code ( column A is FRE).

The below is the Cross-Ref tab

Site Vendor Code

FRE 7TW7006

WC 7TW7005

WC2 7TW7008

Can any one help me with this please.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

If your requirement is like Convert file from CSV to XML, then you can directly achieve this using Sender FCC.

You can find many blogs related to that, one of it is [|]

But can you throw some more information on what lookup you are looking for?

Regards

Ramesh

Answers (2)

Answers (2)

Former Member
0 Kudos
Former Member
0 Kudos

Chandrika,

can you tell us

Like how are you accessing the Cross ref tab? Is it another file?

What is your source file then?

Regards

Ramesh

Former Member
0 Kudos

Yes it is another CSV file, My source file is also CSV with columns ABCDEFGHIJK as i have told, A column is FRE

The requirement is i have to look up column A in the Cross ref tab and map it to vendor code in the

I mean if PARTNRID is the target feild, i have to look up column A in the Cross ref tab and map it to vendor code

Site Vendor Code

FRE 7TW7006

WC 7TW7005

WC2 7TW7008

Here column A is FRE and and vendor code paralell to it is 7TW7006, then target XML should be like this <PARTNRID>7TW7006</PARTNRID>

Regards

Chandrika

Former Member
0 Kudos

Ok,

You requirement is CSV File Lookup in file to file scenario.

For this you need to develop/write a UDF to make this look up work. As replied by Ganesh in previous post you can go through the link [http://wiki.sdn.sap.com/wiki/display/XI/FileLookupinUDF|http://wiki.sdn.sap.com/wiki/display/XI/FileLookupinUDF]

Regards

Ramesh

Former Member
0 Kudos

Hi,

instead of using file lookup ,you can use fix value and value mapping you can achieve this,

Mapping:

SITE-> fixvalue-> PARTNRID (or) SITE-> Valuemapping -> PARTNRID

for fix value you can define in message mapping only.

if you want to use value mapping you have define value mapping in ID and you have to use that value mapping in ESR.

please go through below blog,

http://www.riyaz.net/sap/xipi-value-mapping-using-graphical-editor/382/

regards,

ganesh.