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

Data Extraction in SAP Business ByDesign

SAP ByDesign Data extraction will allow you to extract your data from the test or production tenant system. 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. 
dataextraction_on_SAPBusinessByDesign_1
dataextraction_on_SAPBusinessByDesign_3
dataextraction_on_SAPBusinessByDesign_2

Want to discuss further? Contact Brittanie Ryan, Customer Engagement Specialist at Seidor: brittanie.ryan@seidor.com

Seidor is an SAP Platinum Partner for SAP Business ByDesign.

We sell, install, implement, train and support on this solution from our offices in Houston, Detroit, Miami, New Jersey and California.

Evaluating a Cloud ERP Solution?

Cookie use
SEIDOR uses its own and third-party cookies in order to know and measure activity on the web, create user navigation profiles and detect improvements. Therefore, we ask for your express permission. You can access more information about the use and configuration of cookies in our cookies policy by clicking Here.
Accept Reject
X
contact us