1967846- How to Export the Details Section of Materials?

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