on 12-12-2011 11:35 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please go through below blogs,
http://wiki.sdn.sap.com/wiki/display/XI/FileLookupin+UDF
http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=25460933
regards,
ganesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.