You want to create a report which will show the available Projects that do not contain Sales Orders.
You try to achieve this by creating a custom report based on a custom data source. For example, by joining the Projects, Baselines, and Snapshots (PROPRJU05) and the Sales Order Item (CRMSLOIB).
When you display the Project and Sales Order characteristics, on the report, you noticed that the Sales Order ID is shown as Not Assigned although the Project has a Sales Order linked to it.
SAP Business ByDesign
The behavior of the report is as designed.
The reason you see the Sales Order as Not Assigned is because the link from the Project to the Sales Order occurs at Project Task Level.
By not showing the Project Task on the report you will not be able to see, at Project Level, whether the Sales Order is linked to it.
With the current functionalities, the only suggestion we can provide is to display the Project Tasks on the report then verify that none of these are linked to a Sales Order i.e. for all the tasks of a project, the Sales Order should be Not Assigned (#).
If the above does not fulfill your needs then a detailed feasibility study on your requirements and expectation would need to be done.
If you need this report urgently you may approach directly the Service Center.
You can find more details about the services offered by Cloud Service Center on https://www.sap.com/services/application-development.html . You can contact Cloud Service Center as follows:
- If you are a partner: please use firstname.lastname@example.org or the Partnerfinder
- If you are a customer: please use the little blue box “Contact Us” shown on the very right hand side of https://www.sap.com/services/application-development.html, choose “Contact Us”, choose “Services”, choose “SAP Custom Development” and complete the page
Note: The services of the SAP Cloud Service Center will be charged as packaged services based on fixed prices.
Alternatively you can use the SAP Business ByDesign forums, available at: (https://www.sap.com/community/topic/business-bydesign.html) for further or future questions of this nature.
The forum is as great source of information and can be helpful to find answers to many questions regarding the implementation of SAP products. Alternatively, you may want to post questions that will then be answered by experts from the SAP Business ByDesign global community.
For long term request you may check the SAP Business ByDesign Influence Forum to submit an idea: https://influence.sap.com/SAPByDesign.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , SRD-PRO-ANA , Analytics Content , Problem