Understanding Code List Mapping in SAP Cloud for Customer
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 |
||||||||||||||||||||
|
|
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.
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’.
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 |
||||||||||||||||||||||||||||||||||
|
|
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.
Wow - great blog with lots of wonderful information - thanks, Sapna!!
Added an attachment (legend.jpg) that explains the differences between the categories of code lists.
In case you find that after you download the differential mapping in ERP (step 2), the CSV files are empty, please check the following:
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
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
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
Thank you - I will forward this on.
Hi Shiva
We might have to wait for 1411 for this - I realized I did my testing on 1411 - do you know when your upgrade is scheduled?
-ginger
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.
Hi Shiva,
Is this error resolved ?
We are getting similar errors while uploading w.r.t ExchangeRateTypes . Please let me know
BR,
Samarpita
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
Hi Ashish,
Thanks for your reply.So how will the upload to C4C happen? Please guide.
BR,
Samarpita
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
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
Thanks for sharing. It is really useful.
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.
Kindly let me know where i am missing.
Regards
Yangalasetty Sreenivasulu
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
Hi Pragya,
please find pic of code piece actually error occurred.
PF SP of the CRM addon.
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
Hi Ashish,
Thanks for your reply. I will apply the note .
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?
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
Thanks everyone!
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...
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
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.
Yes you should be able to. do so.
BR,
Samarpita
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
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
Hi All,
I have encountered a runtime error during automatic code list mapping configuration in ECC after uploading the .zip file. Could you please give your inputs in below link.
Error in automatic code list mapping configuration
Regards,
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
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
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
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.
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 :
Apart from these errors , we also get Warnings like these :
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
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
Thanks a Lot @ashish Anand..
Your solution helped..
I was able to solve the issues and the errors have gone.
Grateful.
Thanks,
Srivatsan
Hello @
After i uploaded my zip file fromERP To C4C i get this error and don't know how to solve it:-
Please advice
Hi Prihan,
Could you please check if the Currency used in the file 'TPE' is active in C4C ?
If not you can manually edit the row for Country and remove the currency before the upload. The country will be created without the currency and you can add it manually later
Regards,
Ashish
Very useful blog even in 2022. Thanks Sapna
Hi Sapna
I have some questions, is there a way to eliminate several mappings with the upload option? If possible, could you tell me how to do it? In the video I only see that they update a code, but they do not indicate the way to eliminate it.
Thank you
Orlando Monjes
Hi Orlando,
Currently delete is not supported here and has to be performed manually.
Regards,
Ashish