2568586 - In Data Extraction, the Selection Criteria for Status of Sales Orders is not Available

SAP Knowledge Base Article - Public

2568586 - In Data Extraction, the Selection Criteria for Status of Sales Orders is not Available

Symptom

Your requirement is to extract the Sales Orders based on the Status using the Data Extraction in Application and User Management. In the Selection Criteria, we do not have a Parameter Name for Status.

Reproducing the Issue

  1. Go to Application and User Management work center;
  2. Go to Data Extraction view;
  3. Select New;
  4. Fill the required fields below:
  5. Run ID: XXXXX
  6. Run Description: YYYYY
  7. Extraction object: SALES_ORDERS - Open Sales Orders
  8. In the Selection Criteria, select Add Row;
  9. In the drop-down list for Parameter Name, we do not see an option for Sales Order status.

Resolution

This is a standard behavior that the Data Extractor fetches all the Sales Orders present in the system. The extraction of Open Sales Orders is not supported in Data Extraction.

To have a Selection Criteria for Status of the Sales Orders in the Data Extraction is a new requirement and this functionality will be available in one of the future releases.

You may extract the Open Sales Orders from Sales Orders OWL using the below steps:

  1. Go to Sales work center;
  2. Go to Sales Orders view;
  3. Select the Show Advanced Filter icon;
  4. Choose the Status from the drop-down;
  5. At the top right corner of the screen, select Export to Microsoft Excel;
  6. Select the Language from the drop-down;
  7. Select Download.

Keywords

SALES_ORDERS - Open Sales Orders, Open Sales Orders, data, extraction , KBA , open sales orders , sales_orders - open sales orders , sales order status , AP-SLO-SO , Sales Order , Problem

Product

SAP Business ByDesign all versions