3810060 - Cancelled Sales Orders Are Missing in the Sales Order Items Data Source

Cancelled Sales Orders that are in an Inconsistent status are not displayed in the Sales Order Items data source in the Business Analytics work center, although the Sales Orders exist in the system.

When searching for the affected Sales Orders in the data source preview using the Sales Order ID and Sales Organization, no data is displayed.

SAP Business ByDesign 

1. Go to the Business Analytics work center. 
2. Select the Data Sources view. 
3. Search for Sales Order Items data source.
4. Select Preview. 
5. Go to View and add Sales Order and Sales Organization under row fields. 
6. Go to Selection and enter the affected Sales Order ID and Sales Organization.
7. Select Apply

The affected Sales Orders are not displayed in the result.

Sales Orders that are inconsistent due to error messages are not displayed in the Sales Order Items data source. 

The affected Sales Orders may contain different types of error messages that result in an inconsistent Sales Order. For example: 

•  Error 1: Sales Organization/Sales Unit error: "Party with role Sales Unit does not belong to seller company XXXX".
•  Error 2: List Price missing error.

In the reported scenario, the error related to the Sales Organization/Sales Unit assignment occurred after the Sales Orders were cancelled by maintaining a Reason for Rejection. The actual Sales Organization is XXXX, whereas YYYY was being considered for the Sales Organization assignment. (XXXX and YYYY represents the Sales Organization).

Regardless of the specific error, a Sales Order that remains inconsistent is not displayed in the Sales Order Items data source.

To view the cancelled sales orders in sales order items data source resolve all errors in the affected Sales Order to bring the Sales Order back to a consistent state. 

Error-1: Sales Organization/Sales Unit error, proceed as follows:

1. Go to Sales orders work center.
2. Select Sales orders work center view.
3. Choose All orders from drop down in show field.
4. Search with affected Sales order ABC (ABC represents the Sales Order ID).
5. Open the affected Sales Order. 
6. Go to the General tab. 
7. Remove the existing Reason for Rejection and enter it again. 
8. Select Save.
9. The Sales Order status changes from Completed to In Preparation. 
10. Under Organizational Assignment, remove the currently maintained Sales Unit. 
11. Enter the correct Sales Unit XXXX and select Save.
12. The related error messages are cleared.
13. Check the Sales Order for any remaining error messages and resolve them as applicable. 
14. Maintain the required Reason for Rejection again and select Save.
15. The Sales Order status changes back to Completed. 

 Error-2: List price missing, proceed as follows:

1. Go to Sales orders work center.
2. Select Sales orders work center view.
3. Choose All orders from drop down in show field.
4. Search with affected Sales order ABC.
5. Open the affected Sales Order. 
6. Go to the Items tab.  
7. Maintain the list price for the line item.
8. The related error message is cleared. 
9. Save the Sales order.

Once all error messages are resolved and the Sales Order is consistent, the Sales Order can be displayed in the Sales Order Items data source. 

Sales order; Sales Order Items; Data Source; Inconsistent Sales Order; Missing Sales Orders; Business Analytics; Sales Organization; Sales Unit; Cancelled Sales orders , KBA , AP-SLO-SO-ANA , Analytics , Problem