You are responsible for migrating bank data into the SAP S/4HANA Cloud Public Edition system. You have determined the best method is Migrate Data Using Staging Tables, as you only have a couple banks to migrate.
In the task below, always replace ###### with the last 6 digits of your group number.
Make sure to use the EXACT names/values/spaces as they are listed in the task. Even forgetting a space or a number will cause the validation of the task to fail and be marked as incorrect.
Migrate the bank data listed below.
AnswerA
ExplanationObjective
The purpose of this task is to migrate two bank master records into SAP S/4HANA Cloud Public Edition using the Migrate Data Using Staging Tables approach.
This task is performed inside the migration project created earlier:
Migration Project Name: Bank Data ######
Migration Object: Bank
The bank master data must be entered exactly as provided in the task tables.
Business Scenario Explanation
In this scenario, you are responsible for loading a small number of bank records into the system. Because there are only two banks to migrate, the selected migration method is:
Migrate Data Using Staging Tables
This method requires you to:
open the existing migration project,
download the Bank templates,
populate the required CSV file with the bank data,
upload the files,
validate the data,
transfer the data to staging tables,
complete any required mapping tasks,
migrate the bank instances,
verify the migrated banks in the target app.
Important Notes
Always replace ###### with the last 6 digits of your group number.
Use the values exactly as shown in the task.
Keep names, spaces, and numbers exactly correct.
During your execution, mappings may be required for:
Country/Region Key
Language Key (ISO)
Regional Code
Bank Key
If regional text values like Pennsylvania or Georgia are rejected, mapping may be needed to:
PA
GA
Example
If the suffix is 000013, the values become:
Bank 1
Bank Country/Region = US
Bank Key = A000013
Bank Name = Bank of A000013
Street = West Chester Pike
House Number = 3999
City = Newtown Square
Postal Code = 19073
Country/Region = US
Language = EN
Location = Pennsylvania
Bank 2
Bank Country/Region = US
Bank Key = Z000013
Bank Name = Bank of Z000013
Street = Lenox Road
House Number = 3580
City = Atlanta
Postal Code = 30326
Country/Region = US
Language = EN
Location = Georgia
Detailed Step-by-Step Procedure
Step 1: Open the app ''Migrate Your Data''
From the SAP S/4HANA Cloud launchpad:
Log in to SAP S/4HANA Cloud.
Search for:
Migrate Your Data
or
Migration Projects
Open the app.
Explanation
This app is the migration cockpit where the project and Bank migration object are maintained.
Step 2: Open the migration project
In the migration projects list:
Search for your project:
Bank Data ######
Open the project.
Example
If your suffix is 000013, open:
Bank Data 000013
Explanation
This is the migration project created in the previous task and it contains the migration object Bank.
Step 3: Open the Bank migration object
Inside the migration project:
Locate the migration object:
Bank
Open it.
Explanation
The Bank migration object is where the templates, uploads, mapping tasks, and migration instances are handled.
Step 4: Download the template files
On the Bank migration object screen:
Click:
Download Template
This provides the CSV template files needed for migration.
Explanation
For the Bank migration object, the main files typically include:
S_BNKA#FreeText_Mandatory.csv
S_SCRIPT_ADRC#FreeText.csv
The mandatory file contains the bank master structure; the second file is optional for international address versions.
Step 5: Populate the mandatory Bank CSV file
Open the mandatory CSV file:
S_BNKA#FreeText_Mandatory.csv
Enter the two bank records exactly as required from the task tables.
Explanation
This file must contain the bank master data that will be loaded into the staging tables.
The data must match the required values exactly.
Step 6: Use the correct values in the Bank CSV
Populate the mandatory file with the two records.
Bank 1
Bank Country/Region = US
Bank Key = A######
Bank Name = Bank of A######
Street = West Chester Pike
House Number = 3999
City = Newtown Square
Postal Code = 19073
Country/Region = US
Language = EN
Location = Pennsylvania
Bank 2
Bank Country/Region = US
Bank Key = Z######
Bank Name = Bank of Z######
Street = Lenox Road
House Number = 3580
City = Atlanta
Postal Code = 30326
Country/Region = US
Language = EN
Location = Georgia
Explanation
These values create two bank master records, one beginning with key A###### and the other with key Z######.
Step 7: Keep the optional international address file empty if not needed
For the file:
S_SCRIPT_ADRC#FreeText.csv
leave it with header only if no separate international address version data is required.
Explanation
During your execution, the optional file was not required and the Bank migration still proceeded because only the mandatory Bank Master structure had to be populated.
Step 8: Open Upload Files
In the Bank migration object:
Go to:
Upload Files
Explanation
This is where the CSV folder is created and the files are uploaded to the migration cockpit.
Step 9: Create a CSV Folder
Click:
Create CSV Folder
Explanation
When using CSV with staging tables, SAP groups the upload into a CSV folder structure.
Step 10: Upload the CSV files
Upload:
S_BNKA#FreeText_Mandatory.csv
S_SCRIPT_ADRC#FreeText.csv (optional / empty if not used)
Explanation
The mandatory file is required.
The optional file may remain empty or not provided depending on the migration object's structure.
Step 11: Validate the data
After upload:
Click:
Validate Data
Explanation
This checks:
file readability,
required columns,
correct structure,
duplicate keys,
and data consistency.
Step 12: Correct any file or format errors if needed
During execution, common issues included:
wrong file mapping,
UTF-8 / CSV reading problems,
missing mandatory fields,
duplicate key values,
region value mismatches.
Explanation
You must resolve validation errors before continuing to staging tables.
Examples from your run:
duplicate key values had to be corrected,
file structure mapping had to be adjusted,
CSV encoding had to be corrected.
Step 13: Transfer data to staging tables
After validation is successful, click:
Transfer Data to Staging Tables
Explanation
This moves the validated CSV data into SAP's staging tables so the Bank migration object can create migration instances.
Step 14: Go to Mapping Tasks if required
If the system shows mapping tasks, open:
Mapping Tasks
Explanation
For your run, the following mappings had to be confirmed:
Country/Region Key
Language Key (ISO)
Regional Code
Bank Key
Step 15: Maintain mapping values
If mappings appear, confirm or maintain them as follows:
Country/Region Key
source US target US
Language Key (ISO)
source EN target EN
Regional Code
If text values are shown:
source Pennsylvania target PA
source Georgia target GA
Bank Key
Confirm the system-generated source values to the correct target values for:
A######
Z######
Explanation
These mappings are required when the migration object needs target-system value confirmation before posting the records.
Step 16: Confirm the mapping tasks
After maintaining the mappings:
Click:
Confirm
Explanation
All mapping task statuses should change to Confirmed before running migration again.
Step 17: Open the Bank instances
Return to the Bank migration object and open:
Instances
Explanation
This screen shows the individual bank records created from the staging-table data.
Step 18: Select the bank instances
Select both bank records.
Expected rows:
US / A######
US / Z######
Explanation
Both bank records must be selected so they can be migrated into the target system.
Step 19: Click Migrate
Click:
Migrate
Explanation
This starts the actual creation of bank master records in the target SAP S/4HANA Cloud system.
Step 20: Resolve authorization issue if it appears
During your execution, migration initially failed with:
You are not authorized to create bank data for country/region US
The fix was to assign the additional business role:
Master Data Specialist - Bank Data
SAP_BR_MD_SPECIALIST_BNK
Explanation
The migration cockpit role alone is not always enough.
Bank creation also requires bank master data authorization.
Step 21: Refresh and check migration status
After migration:
Refresh the screen.
Check the status of both bank instances.
Expected final result:
Success
Success
Explanation
Both bank rows must finish successfully for the task to be considered complete.
Step 22: Verify in ''Manage Banks - Master Data''
Open:
Manage Banks - Master Data
Search for:
US / A######
US / Z######
Explanation
This is the final business verification step that proves the bank master records were created successfully in the system.
Expected Result
After this task is completed successfully:
both bank records are loaded through staging tables,
all mapping tasks are confirmed,
both migration instances complete successfully,
the two banks are visible in Manage Banks - Master Data.
MENU
