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

David Leon, COO at Seidor USA.

Please contact us in case you need further assitance: supportbyd.us@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
We use our own cookies and third party cookies to allow more streamlined and personalized browsing, and for this, we need your express consent. Review our cookie policy for more information about the use of cookies in our website Here.
Accept
X
contact us