Data Extraction in SAP Business ByDesign

If your tenant is migrated to a new location, if the contract with your provider comes to an end or if you want to perform data cleansing and migrate these data to a production environment, this functionality will solve many of your troubles.

Only the data objects which are enabled and used in your system tenant are available for data extraction. Therefore, the values to be selected may vary.

All data objects are also migration objects and you can find comprehensive information and documentation in the related migration templates in the Prepare for Data Migration activity in the Business Configuration work center.

Here is How to Enable and Use the Data Extraction Tool in SAP Business ByDesign

The below steps are applicable only if you are not using Business Roles:

1. Go to the Application and User Management work center
2. Go to Business Users view
3. Search for your Business User
4. Select Edit -> Access Rights
5. Go to the tab Work Center and View Assignment
6. Expand the work center Application and User Management
7. Tick the checkbox for the Data Extraction view
8. Select Save and Close

If you are using Business Roles, follow the steps below:

1. Go to the Application and User Management work center
2. Go to Business Roles view
3. Select the Business Role which you want to assign the Data Extraction work center and click Edit
4. Go to the tab Work Center and View Assignment
5. Expand the work center Application and User Management
6. Tick the checkbox for the Data Extraction view
7. Select Save
8. Select Assigned Users -> Update Users

Note: after the above settings, the user should logout of the system, and logon again so that the changes take place.

To extract Master Data:

1. Go to Application and User Management work center
2. Go to Data Extraction view
3. Select New
4. Enter a Run ID
5. Select the Extraction Object which you want to extract
6. Select the Package Active checkbox and define Package Size to automatically perform the extraction in packages with each package containing the number instances selected
7. Select Export Code Description to show texts/descriptions for the codes
8. Choose to Save or Activate and Run
9. To view the results, search for runs with status Finished
10. Select the run to see a list of files that are extracted
11. You can choose to Download the extracted files or Remove them.