SAP Knowledge Base Article - Public

2917834 - Sales Orders and Accounts are missing in Sales Order Item Data Source


Data Source Sales Order Item is missing a specific account and the corresponding sales orders when logged in as user XX(XX is the ID of the user who is facing the issue)


SAP Business Bydesign

Reproducing the Issue

  1. Login with the User ID XX((XXX is the ID of the user who is facing the issue).
  2. Go to Business Analytics work center.
  3. Go to Data Sources View .
  4. Search for Data Source Sales Order Item.
  5. Preview the data source.
  6. Filter the report by Employee Responsible = XX(XX is also the Employee Responsible in the Sales Orders which are missing in the Report).
  7. In the report results, the account YY and the corresponding Sales Order ZZ are missing(YY is the account ID  and ZZ is the Sales Order ID which the user is unable to find in the report).


The user has restricted access for the work center sales order based on sales unit XYZ(XYZ is the ID for Sales Unit) which means, the user XX can only see the sales orders which is having the sales unit XYZ.

The user is unable to see the Sales Order ZZ in the report because, the sales order ZZ does not have the Sales Unit XYZ.


This is standard system behavior. If you want the user to see the sales orders then you will have to enhance the access restrictions for the user XX

  1. Go to Application and User Management work center
  2. Go to Business Users
  3. Search for user XX and edit Access restrictions
  4. Go to tab Access Restrictions and search for Work center view ID CRM_SALESORDERS
  5. Select the line CRM_SALESORDERS, under detailed restrictions you can see to which all sales unit , this particular user is having access.
  6. Provide access to other sales units by clicking on the checkbox to resolve the issue.


Sales Order Item; Data Source; Sales Order missing; , KBA , sales order item data source , AP-SLO-SO-ANA , Analytics , Problem


SAP Business ByDesign 1911