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.
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 (firstname.lastname@example.org).
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.sme.sap.com/irj/sme/community/collaboration/forums) 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 Ideas Forum to submit an idea: https://ideasbydesign-en.ideascale.com/.
Please don't hesitate to contact me for further questions.
KBA , SRD-CC-FED , Feeds , How To