Symptom
You are trying to upload the employee master data through migration templates and getting the error messages 'SCRIPT_CODE_1' is mandatory for City, 'SCRIPT_CODE_1' is mandatory for House Number' , 'SCRIPT_CODE_2' is mandatory for City', 'SCRIPT_CODE_2' is mandatory for House Number.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business configuration work center
- Open Activity List
- Navigate to Integrate and Extend Phase
- Search for the activity "Migration of Employee Data - Non Localized Countries/Regions"
- Now click on "Migrate basic employee data using the migration tool"
- Upload the file and click on Execute Migration Step by Step
Cause
If you are using script code in system, then only you should maintain dependent script data in 'Address Script 1' and 'Address Script 2' else those columns should be blank.
Resolution
Check your Scoping question is the scripting is enabled for textual master data by following below steps:
- Go to Business Configuration work center
- Go to Implementation Project view
- Click on Edit Project Scope
- Navigate to Scoping stage, check the scope of the item under Built-in Services & Support -> Business Environment -> Addresses and Languages
- Go to next stage i.e. Question and check for the scoping question, Built-in Services & Support -> Business Environment -> Addresses and Languages "Do you want to specify textual master data using more than one script?"
If above scoping is enabled you will be able to maintain the script details under activity "Multiple Scripts"
Note: From the list of available scripts, you can select all those which you want to activate or deactivate in your system. By defining multiple scripts, you can specify the script-dependent master data, such as business partner name and address, in several scripts. You must also specify a default script, however, once selected, you cannot change this again.
If it is enabled you will see the script option in the Business Partners view as shown below:
Scenario1: If above settings in place and you want to have the additional textual master data using script, you need to update the Address Script1 details to be filled accordingly in your Migration Template as shown below:
Scenario2: If you are not using any of the script, however you filled details for the Address Script 1 & Script 2 you will get the error messages as mentoined "'SCRIPT_CODE_1' is mandatory for City, 'SCRIPT_CODE_1' is mandatory for House Number' , 'SCRIPT_CODE_2' is mandatory for City', 'SCRIPT_CODE_2' is mandatory for House Number."
For this, please verify your migration file, unhide all the columns from Private Contact Data & Workplace Address and check does Address Script 1 & Address Script 2 Address columns has any of the information, if it has remove those and proceed with the file upload and perform the migration.
Keywords
Address Script 1, Address Script 2, SCRIPT_CODE_1' is mandatory for City, SCRIPT_CODE_1' is mandatory for House Number, SCRIPT_CODE_2' is mandatory for City, SCRIPT_CODE_2' is mandatory for House Number, Employee, Employee Data. , KBA , address script 1 , address script 2 , script_code_1 , script_code_2 , employee data , migration , SRD-CC-MIG-DMC , Migration: Tool , SRD-CC-MIG-CNT , Migration: Content , Problem