Symptom
You have added texts in the Details text box of many Materials and require the Details to be exported using Microsoft Excel or Report.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Product Data work center
- Go to Materials view
- Go to Materials subview
- Query All Materials
- Search any Material ID
- Choose Edit
- You want to export the data from the Details field using Microsoft Excel or Report
Cause
The Export->To Microsoft Excel option which is available on the Materials Object Work List does not export the Details field of the Materials. Further, the reports which are associated with the Materials does not export the Details field of the Materials.
Resolution
You can export the data from the Details field of Materials using the below steps in your system:
- Go to Application and User Management workcenter
- Go to Data Extraction view
- Select New
- Run ID: XXXXX (where XXXXX represents the Run ID of Data Extraction)
- Run Description: YYYYY (where YYYYY represents the Run Description of Data Extraction)
- Select Extraction object: MATERIAL - Materials
- Choose to Save
- Select Activate and Run
- Once the Run is Finished, at the bottom of the screen, in the Extraction Files, select the button Download File
- Download the generated .XML file
- Go to the sheet Detailed Descriptions
- You will be able to see the Details of the Materials
Keywords
Material Details, Detailed Material Description, Data Extraction, Details of Materials , KBA , data source , report , microsoft excel , materials , export , details , details of materials , material details , data extraction , detailed material description , SRD-SRM-PRP , Product Portfolio , How To