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

SAP Knowledge Base Article - Public

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

Symptom

You want to perform Data Extraction in your SAP Business ByDesign system, but the work center view is not available for you.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to the Application and User Management work center
  2. The view Data Extraction is not available

Cause

The Data Extraction view has not been scoped in your system (valid for releases up to 1711), or this view has not been assigned to your business user or role.

Resolution

1.  To scope Data Extraction view in the Application and User Management workcenter, follow the steps below:

  1. Go to the Business Configuration work center
  2. Go to Implementation Projects view
  3. Select relevant project
  4. Select on Edit Project Scope button
  5. Click Next until you reach the step 4 – Questions
  6. Expand Built-in Services and Support
  7. Business Configuration
  8. Data Migration
  9. Tick the checkbox for the question Do you want to use the Data Extraction Work Center View?
  10. Select Next
  11. Choose Finish

Note:

With release 1802 an explicit scoping of the view is not necessary anymore. Therefore the scoping question is not available in this and higher releases.

2.  Further, assign the Data Extraction view to your Business User. 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.

3.  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

 

Note:

1.  If you require Data Extraction of attachments, report an incident to SAP to provide you this information

2.  Extraction Files are generated only in .XML format

3.  If the downloaded files appear corrupt or you are unable to view the contents of the extracted file, change the file name of the downloaded file so that it ends on .zip and then open the file.

For example, if the extracted file is filename.xml you may change the file extension to filename.zip and view the extracted data.

Keywords

Data Extraction, Scoping Data Extraction, Data Extraction Tool , KBA , data extraction , extract data , SRD-CC-MIG-DXT , BYD- Data Extraction Tool , How To

Product

SAP Business ByDesign all versions