Skip to Content

Update: Check out the many videos embedded in the blog

                  A new blog available on frequently asked questions too.

Basic information

Code list is a user defined list of values, for a list element on a screen. For example, for the UI element, Occupation, here are the possible values maintained in different systems.
Code list for Occupation
  in SAP Cloud for Customer
Code list for Occupation
  in SAP CRM
Value   Description
1   Student
  2   Professional
  3   Entrepreneur
  4   Unemployed
  Value   Description
  1   Student
  2   Entrepreneur
  3   Professional
  4   Unemployed
As you see in the example above, the code list values in SAP Cloud for Customer and SAP CRM systems do not mean the same. For example, value 3 in Cloud system means Entrepreneur, whereas in the CRM system value 3 is Professional. If during transfer of data from Cloud to ERP/CRM, a Cloud code list value is not converted to the corresponding ERP/CRM value, this might lead to wrong results. Hence, we need to map these values during Customizing in SAP Cloud for Customer.

Video: Introduction to code list maping



Ways in which you can map code lists

There are two ways in which you can map the code lists: manual and automatic.
Note
SAP recommends using the automatic configuration during initial load and manual maintenance during updates. This is valid only until 1411. Starting 1502, you can use automatic configuration for both initial and delta load.
You can map the code lists:
  • Manually in the fine tuning activity Code List Mapping for Integration with External Application and Solutions, as explained in detail in the integration guides on Service Marketplace.
  • Automatically during Customizing. It comprises the following steps:
a.    Download the available code lists and any existing mapping from SAP Cloud for Customer into an archive file.
b.  Using the downloaded archive file, retrieve the differential mapping information from the SAP on-premise system.
c.    Review and adjust the mappings in the .CSV file as per your requirement.
Caution
SAP recommends that you edit the .CSV file in an editor, which does not automatically apply any formatting. For example, if you open a .CSV file containing a value ‘02-10’ in Microsoft Excel®, it will automatically convert the value to ‘10-Feb’.

d.    Upload the reviewed archive file in SAP Cloud for Customer.
Once you initiate the upload of code lists, a job is scheduled in the background, and an application log is created. An Application Log displays the status of the upload, and lists all log messages that were generated during each upload. In case of errors, make further correction to the code lists in the .CSV files, and upload the archive file again.

Check the status of code list upload in the Application Log

To view the status or messages:
1.    Go to Business Configuration à Upload Code Listà Application Log.
2.    Click on the required Application Log ID.
The log displays information in the following tabs:
    • General: Displays a high-level summary and administrative data for the job
    • Settings: Displays settings selected during an upload
    • Results: Displays the detailed results of the job including a list of detailed message descriptions, and the nature of the message.
You can also export the information on the tabs to Microsoft Excel®. To do this, click Export to Microsoft Excel, and select the tab from which you want to export the data.

Important information on automatic configuration

Before you decide to use automatic configuration, please note the following points:
  • Not all code lists can automatically be configured in ERP and in CRM. For a few code lists, you need to manually maintain the mapping in the fine tuning activity.
    For a list of all the code lists supported in CRM and ERP, go to Service Marketplace, and click INTEGRATION: Supported CRM ERP Code Lists.

    Note:

For the code lists CashDiscountTermsCode and BusinessPartnerRelationshipCategoryCode, not all the values are transferred to Cloud. Hence, if you use either of these two code lists, review and adjust the values and mappings manually directly in the fine tuning activity.

  • If code lists are deleted in the on-premise system, the corresponding code list and the mapping are not automatically deleted in the Cloud system during upload.
  • While downloading the differential changes from the on-premise system, the system may propose changes in mapping. If in the SAP Cloud system, the rule type for a code list is set to Local and remote are equal, and a differential mapping is proposed for this code list, then these changes are overwritten during upload into Cloud system. In other words, if a different mapping is proposed by the system in the .CSV file than the one maintained in the Cloud system, the value Local and remote are equal will be changed to Map individual codes for the corresponding code list during an upload in the Cloud system.
·        Hence, it is important that you review all the suggested values in the .CSV files before you upload the archive file in the Cloud solution.
Example use case: Automatic configuration during initial load
Now, let us take a scenario where you are performing an initial load, and rule type for the code lists are set to Local and remote are equal in the Cloud system. Here is a snapshot of the code list Academic Title and the corresponding values in the Cloud and CRM systems. Let us discuss what happens during each step of automatic configuration.
Code list for Academic Title
  in SAP Cloud for Customer
Code list for Academic Title
  in SAP CRM
           

Value
Description
  0001   Dr
  0002   Professor
  0003   Professor Doctor
  0004   Bachelor of Arts
  0005   Master of Business Administration
  0006   Doctor of Philosophy
  0007   Mr.
                   

Value
Description
  0001   Professor
  0002   Dr.
  0003   Professor Doctor
  0004   Bachelor of Arts
  0005   Master of Business Administration
  0006   Doctor of Philosophy
  0008   Mrs.
  0009   Mr.
As you see:
·        The values do not match; 0001 in Cloud is Dr, whereas it is Professor in CRM.
·        There are additional values in each of the systems; 0007 in Cloud, and 0008/0009 in CRM.
Step 1: Download code list from SAP Cloud for Customer
When you download code list in the Cloud system under Business Configuration à Download Code List, the system will download two .CSV files in a .ZIP file:
  • The CodeList.CSVfile will contain all the code list values from 0001 to 0007. This is the list of values you can find in the Cloud system under Business Configuration à fine tuning activity General Business Partners à Academic Titles.
  • The CodeMapping.CSVfile will contain the code list mapping that is currently maintained in the fine tuning activity Code List Mapping for Integration with External Application and Solutionsfor the code list Academic Title. Since it is an initial load, and by default the rule type is Local and remote are equal, 0001 in Cloud will map to 0001 in CRM.
Note: There is also a flag in the .CSV file that tells if a code list mapping entry has the rule type Local and remote are equal.
Step 2: Download the differential mapping information from SAP ERP/CRM
Download the mapping information from the SAP on-premise system using the report, CRMPCD_CUST_EXCHANGE for CRM or the report CODD_CODE_LIST_MAPPING for ERP.
The archive file will contain two new .CSV files in the new .ZIP file. Now, in this example, the:
  • The new CodeList.CSVfile will contain the following code list values:
Value
Description
Reason
Z002
Dr.
Since these code values are not available in the Cloud system,
a  corresponding code value is proposed.
Z008
Mrs.
  • The new CodeMapping.CSVfile will contain the following mappings:

                    

C4C Code
C4C Description
External Code
External Description
Reason
Value in Cloud system
Description in
Cloud system
Value in SAP on-premise system
Value in SAP on-premise system
Explanation on why system
proposed the mapping
0002
Professor
0001
Professor
Since an identical description
is found, a mapping is proposed
Z002
Dr.
0002
Dr.
Dr. and Dr are not identical. Hence,
value 0002 in CRM is not  mapped
to value 0001 in Cloud.
Instead a new value Z002 is proposed.
If you want Dr. to be mapped to Dr,
you can delete the code value in
CodeList.CSV, and manually change
the mapping in CodeMapping.CSV
before  you upload.
0003
Professor Doctor
0003
Professor Doctor
A match in description is found,
hence the corresponding values 
are proposed.
0004
Bachelor of Arts
0004
Bachelor of Arts
0005
Master of
Business
Administration
0005
Master of Business Administration
0006
Doctor of
Philosophy
0006
Doctor of Philosophy
Z008
Mrs.
0008
Mrs.
The value and description are not
present in Cloud, and a code  value
and the mapping are proposed.
0007
Mr.
0009
Mr.
A match in description is found,
hence the corresponding
value  is proposed.
Step 3: Review the downloaded files
You should review the .CSV files thoroughly and make any required changes. The merge report proposes some codes as inbound / outbound default when more than one code is mapped to same code. You should review the defaults before uploading to C4C system in case you want a particular code to be used as a default.
For example, a new code list Z002 Dr. (in Cloud) has been proposed to be mapped with 0002 (in CRM). However, you may want to map 0001 Dr (in Cloud) to 0002 Dr. (in CRM). You can change it manually in the .CSV file.
Step 4: Upload the reviewed code lists to SAP Cloud for Customer
After you review and save your changes to the .CSV files, you can upload the .ZIP file under Business Configuration à Upload Code List.
An application log is created to monitor the status and messages generated during the upload. If the status in the application log is finished and there are no errors, then the corresponding code lists and mappings are successfully uploaded in the SAP Cloud for Customer system. If there are any errors, you can manually correct them in the .CSV files and upload the .ZIP file again.
If you have any questions/clarifications, feel free to add them as comments.
To report this post you need to login first.

37 Comments

You must be Logged on to comment or reply to a post.

  1. Sapna Ramaiah Post author

    In case you find that after you download the differential mapping in ERP (step 2), the CSV files are empty, please check the following:

    • The Software Component version in ERP is “COD_ERP_INT 6.00 SP0013”, and for Cloud for Customer, you have HFC03 applied.
    • Check table “CODD_OBJECT” in ERP and see if column “MAP_TYPES” is populated.
    (0) 
    1. Shiva Nag

      Hi Sapna,

      We have the Software Component version in ERP is “COD_ERP_INT 6.00 SP0013”, in ERP and for Cloud for Customer, how do we know or where do we check if HFC03 is applied?


      In ERP, i Checked table “CODD_OBJECT” in ERP and column “MAP_TYPES” is not populated.


      What do i do next?


      Regards

      Shiva

      (0) 
      1. Ginger Gatling

        hi Shiva

        When was the last time you downloaded the codelist mapping from C4C?  Could you do it again today? 

        This week:

        * Do the download from C4C

        * Execute the report in ERP

        * Look at the files created, if they are blank, post back here and create an incident – we will need the external id after you send it to SAP. 

        -ginger

        (0) 
        1. Shiva Nag

          Hi Ginger,

          I downloaded the codelist today and tried mapping from ERP. Still the files are blank. I have an incident with external ID:- 3500197475.

          Regards

          Shiva

          (0) 
        1. Shiva Nag

                        Hi Ginger, Thank you. I have applied the manual corrections mentioned in the Note 2084679 proposed by SAP folks. I am able to the get the Code-lists into the excel. Thats great. But while uploading the code list back to C4C. I am getting the error  <    >. I tried manitaining the Local code manually in C4C and uppload again, but the error repeats, seems like this is a BUG in C4C now. can i get this resolved? Please see the screen shot. error.PNG

          (0) 
            1. Ashish Anand

              Hi Samarpita,

              We do not support ExchangeRateTypeCode in the current version. This will be included in next release. As you could see in the note 2084679 we have mentioned to maintain Not Applicable for row with Object ‘TCURV’ which is for ExchangeRateTypeCode.

              Regards,

              Ashish

              (0) 
  2. Pragati Bhardwaj

    Hi Sapna,

    Is it possible to extend the code list assigned to data type ‘DocumentTypeCode’?

    Or the description for certain code values can be changed? like code value ‘10017’

    description ‘Business Card’ changed to ‘Resident ID’??

    Regards

    Pragati

    (0) 
    1. Ashish Anand

      Hi Pragati,

      DocumentTypeCode could not be supported since it can not be enhanced in C4C. We will be supporting the mapping for ‘BusinessTransactionDocumentProcessingTypeCode’ from next version.

      There is a way to change the description for the codes you are trying to upload. You can manually change the merged file using a notepad and change the description field in both code.csv and codeMapping.csv and then zip and upload.

      Regards,

      Ashish

      (0) 
  3. Y SREENIVASALU

    Hi Sapna/Ginger,

    I have downloaded the Code list mapping into  .ZIP file from C4C. After that i have excuted  the CRMPCD_CUST_EXCHANGE program in SAP OnPremise, but i am getting the runtime dump. Is there any prerequisites before using the CRMPCD_CUST_EXCHNAGE program.

    PF runtime error  screen shot below.

    Capture.JPG

    Kindly let me know where i am missing.

    Regards

    Yangalasetty Sreenivasulu

    (0) 
    1. Pragya Pande

      Hello Sreenivasulu,

      Please provide pic of the code piece where the error had occurred from the dump. Also specify the SP of the ERP addon.

      Best Regards,

      Pragya

      (0) 
        1. Ashish Anand

          Hi Sreenivasalu,

          For CRM you will have to apply SAP Note : 2091243 to be able to use the functionality. Could you check if the manual corrections mentioned is applied to the tenant.

          Regards,
          Ashish

          (0) 
  4. Molly Miller

    Hello,

    Does fine tuning need to be completed prior to downloading and uploading the code list?  As I understood, we needed to complete the fine tuning activities that are impacted by code list mapping prior to downloading the file.  However, someone else has explained that you can simply download the file, run it through on prem and upload it – which will add the fields needed in the cloud, as well as add those new values in the fine tune activities.

    Can you explain how this works please?

    (0) 
    1. Ginger Gatling

      Hi Molly – we just got this response from development:  Code List upload/download functionality creates both entries in the fine tuning and mapping.

      So – that’s good news!

      -ginger

      (0) 
  5. Ritesh Nasikkar

    HI All,

    Is there any code list mapping required for Payment terms when we have integration beween C4C and ECC..

    I do no see any code list Local data type code for paymentterms in C4C.

    Please guide…

    (0) 
    1. Samarpita Ghosh

      Hi Ritesh,

      First you have to maintain the payment terms in Fine-tuning activity under activity name Accounts.

      Once you have done that navigate to code list mapping in Fine-tuning activity and maintain the mapping in the local data type -> CashDiscountTermsCode.


      It should work

      BR,

      Samarpita

      (0) 
      1. Ritesh Nasikkar

        HI Samarpita,

        Thanks for response!

        I have further question now.

        SAP says we can do delta upload to code list mapping after 1502, right now we are on 1505.

        For payment terms can I do Delta upload in C4C just for payment terms. When I initially downloaded code list and code list .csv files from CSV, it includes all.

        For the time being I just want to match payment terms in ECC to cloud solution. Can I only upload the missing payment terms in C4C using above downloaded .CSV file after deleting other code lists and code list mapping.

        In short I just want to keep code list and code list mapping in this .csv file and then try uploading this file in C4C.

        Please let me know your response….

        Regards

        Ritesh Nasikkar.

        (0) 
  6. Stefan Katschewitz

    Hi all,

    we were just wondering why it is the case that the CodeMapping.csv which is generated by the Report is much smaller (approx. 1300 compared to 4800 rows) that the original file downloaded from C4C.

    Does the Report file only consider differences?

    BR;
    Stefan

    (0) 
    1. Pragya Pande

      Hello Stefan,

      It depends on what is selected on the report parameter screen. If provided settings are not ignored then only differences will be downloaded. Check the documentation for the report. Also check the excel in smp for supported codelists. Download from c4c downloads everything but report downloads only the ones which can be uploaded to c4c.

      Best Regards,

      Pragya

      (0) 
    1. Ginger Gatling

      Hell Maddy,

      Please create an incident for this – I’m running into similar errors and I’ve heard of other folks having errors as well.  I think people are just not using it as much, but if we all create incidents, then our developer will be able to solve it.  You can post your incident number back here to help us track it – remember we can only see the number that starts with a ‘3’ after you have forwarded it to the provider.

      -ginger

      (0) 
  7. Ric GA

    Hi Sapna

    Do you know if there is someting required to activate code list mapping?

    We already have integrated C4C – ERP, but as I can see at Payload when I create an account the role is CRM000 and is not changed to DNGL account group, for the same the account cant be replicated, there is an error in the Idoc.

    The communication arrangenment has the SAP on premise integration Code List Mapping, at test tenant the replication is working fine, but in this tenant is not.

    regards

    (0) 
    1. Chandan Bankar

      Hello Ric,

      Search in All Activities, under the Fine Tune Activity for Code List Mapping. Add it under the project if it is not yet added and map the relevant codes for BusinessPartnerRoleCode.

      Regards,

      Chandan

      (0) 
      1. Ric GA

        Hi Chandan,

        I already do that, don’t know why is not changing the value, seems that the arrangenment is not taking the code list maping, I already created the communication arrangenment again.

        Thanks for your help.

        (0) 
  8. Srivatsan V

    1. I have downloaded the CodeList Group 03 – SAP on ONPREMISE Integration , with the delimiter as comma.

    2. Using the downloaded archive file, I retrieved the differential mapping information from the SAP on-premise system as another .zip file.

    3. Finally when I uploaded the .zip file after giving the same group code and delimiter, I get the following Error in Application Log :

    SNAG-0024.jpg

    Apart from these errors , we also get Warnings like these :

    SNAG-0025.jpg

    Can You please Help us on WHY this error occurs?

    It would be grateful if you could please guide us on how to rectify the issue.

    Thanks in advance,

    Srivatsan V

    (0) 
    1. Ashish Anand

      Hi Srivatsan,

      The error with the ISO codes can be rectified by appling the following SAP Note :2277842 (ERP) or 2269166 (CRM). Additionally the warnings you see are there because not all codes which are available in Cloud for Customer were found in CRM and hence few of them are unmapped. These warnings you will also see when you maintain the code list mappings manually.

      Regards,
      Ashish

      (0) 
      1. Srivatsan V

        Thanks a Lot @ashish Anand..
        Your solution helped..

        I was able to solve the issues and the errors have gone.

        Grateful.

        Thanks,

        Srivatsan

        (0) 

Leave a Reply