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 assigned to your business user or role.

Resolution

Strongly Recommend:

When opening a case for data extraction, it is highly recommended to do so through SAP for Me. This ensures accessibility, as data extraction may take time to complete, and if the SAP contract terminates in the meantime, the tenant will become inaccessible, preventing updates from being visible in cases linked to the tenant.

With release 1802 an explicit scoping of the view Data Extraction is not necessary anymore.

To 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 case to SAP to provide you this information.

Note: Such process might take a few weeks as this process is performed manually by the operations team and, it will depend on the amount of attachments available in the system.

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, Attachment, Output Files. , KBA , data extraction , extract data , data extraction scope , data extraction scoping , SRD-CC-MIG-DXT , BYD- Data Extraction Tool , How To

Product

SAP Business ByDesign all versions