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
-
Go to the Application and User Management work center.
- The view Data Extraction is not available.
Cause
The Data Extraction view has not been assigned to your business user or role.
Resolution
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:
- Go to the Application and User Management work center
- Go to Business Users view
- Search for your Business User
- Select Edit -> Access Rights
- Go to the tab Work Center and View Assignment
- Expand the work center Application and User Management
- Tick the checkbox for the Data Extraction view
-
Select Save and Close
If you are using Business Roles, follow the steps below:
- Go to the Application and User Management work center
- Go to Business Roles view
- Select the Business Role which you want to assign the Data Extraction work center and click Edit
- Go to the tab Work Center and View Assignment
- Expand the work center Application and User Management
- Tick the checkbox for the Data Extraction view
- Select Save
- 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:
- Go to Application and User Management work center
- Go to Data Extraction view
- Select New
- Enter a Run ID
- Select the Extraction Object which you want to extract
- Select the Package Active checkbox and define Package Size to automatically perform the extraction in packages with each package containing the number instances selected
- Select Export Code Description to show texts/descriptions for the codes
- Choose to Save or Activate and Run
- To view the results, search for runs with status Finished
- Select the run to see a list of files that are extracted
- 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