Skip to Content
Product Information
Author's profile photo Deepak G Deshpande

SAP Cloud Integration – CSV Import in Value Mapping

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.

 

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Guillaume COURREGES
      Guillaume COURREGES

      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

      Author's profile photo Deepak G Deshpande
      Deepak G Deshpande
      Blog Post Author

       

       

      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

      Author's profile photo Sridhar Raju Mahali
      Sridhar Raju Mahali

      Please refer this thread response

      https://answers.sap.com/questions/655048/valuemapping-csv-import.html

      Author's profile photo Hitesh Mali
      Hitesh Mali

      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

       

      Author's profile photo Deepak G Deshpande
      Deepak G Deshpande
      Blog Post Author

      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

      Author's profile photo Hitesh Mali
      Hitesh Mali

      No, just trying to help others

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

      Author's profile photo Sebastian Arroyo
      Sebastian Arroyo

      Hi,

       

      We tried this but is not working.

      Do you know if something change?

       

      Author's profile photo Camille Pascual
      Camille Pascual

      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).