Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
DeepakGDeshpande
Associate
Associate
15,008

Introduction


SAP Cloud Integration version 2.40 supports import of CSV file in Value Mapping. You can import the existing/exported SAP Process Integration (SAP PI) value mapping CSV file into SAP Cloud Integration Value Mapping.

Consider an empty value mapping editor as shown below. Please ensure that you are editing it.



You can now see a new button Import

 

Importing CSV in new value mapping


If you have an exported CSV file from SAP Process Integration (SAP PI), you can import that file in value mapping. Clicking on Import opens a file selection dialog.



 

You can select the CSV file to import. After import, the value mapping shall be created as shown below:


Importing CSV in existing value mapping


You can import a CSV within the existing value mapping. In such case, the newly imported CSV value mapping is merged with the existing mappings. Let’s see how this works.

Here’s a value mapping that already contains some entries.



 

After importing (ex: the same CSV file with airline agency entries), it will be merged with the existing agency-identifier entries.

You can see the new row in Bi-Directional Mapping section.



The import feature will save you a lot of time as you can reuse the CSV files exported from your PI system, if you are using the same value mappings.

 
10 Comments
Very interesting post

 

Is it possible to have the CSV file sample ?

I don't have access to SAP PI, and i am very interested on this file structure.

 

Thank you
DeepakGDeshpande
Associate
Associate
0 Kudos
 

 

Hi Guillaume,

This feature is meant to import the CSV files which were exported by PI.

Nevertheless, kindly check the documentation for more information

 

Thanks

Deepak
SridharRaju
Product and Topic Expert
Product and Topic Expert
former_member708009
Discoverer
0 Kudos
Use this heading

,hitesh|H_h,Mali|M_i
1,Aosta|,AO
2,Chieti|,CH
3,L'Aquila|,AQ
4,Pescara|,PE
5,Teramo|,TE
6,Bari|,BA
7,Barletta-Andria-Trani|,BT
8,Brindisi|,BR
9,Foggia|,FG
10,Lecce|,LE
11,Taranto|,TA
12,Matera|,MT
13,Potenza|,PZ
14,Catanzaro|,CZ
15,Cosenza|,CS
16,Crotone|,KR
17,Reggio Calabria|,RC
18,Vibo Valentia|,VV

 

In front

1,

2,

3,

needed

 

DeepakGDeshpande
Associate
Associate
0 Kudos
Hi Hitesh,

If I understand your requirement correctly, you want to have the entry as 1,Aosta (and so on) in the mapping table cell at left hand column, correct?

Please clarify.

Thanks

Deepak
former_member708009
Discoverer
0 Kudos
No, just trying to help others

These 1 2 ....are only for formatting, they are needed for importing csv i value mapping.
Sebas_Arroyo
Discoverer
0 Kudos

Hi,


 

We tried this but is not working.

Do you know if something change?

 


former_member737541
Discoverer
0 Kudos
Hi, your format is correct though I might ask you to check the file format. Encoding should be Unicode (UTF-8) and file type should be CSV (Comma delimited).

 
wesley_nz
Explorer
0 Kudos
Very useful, thank you
Emileh
Explorer
0 Kudos

We have some target values in valuemapping containing a comma ',' as a character. Is there away to escape the comma in the value in the csv?