2918187 - Custom report shows value of a field as # or empty or unexpected value

When you built a report you may see that few values are appearing as # or empty you wanted to know which data source is causing this issue.

SAP Business ByDesign

Custom report is based on standard data  source but standard data source does not  display the results ,the reason for the same is explained below

Let me explain with example field "purchase request ID" that has value # or  empty in your report against few Purchase orders  where

The report xxx is a customized report  that is based on customized data source YY

1. The report xxx is a customized report . that is based on customized data source YY
2. Go to Business analytics work center-> data sources view and select data source yy and click on edit.
3. Go to Joined data sources tab and then go to "Add from" option and choose each data source one at a time to find the field "Purchase request ID"
4. You will see that "Purchase request Id "is coming from data source ZZ
5. repeat the step 2 and 3
6. You will see that "Purchase request Id "is coming from data source SRMPO_U01
7. Go to Business analytics work center-> data sources view and select data source SRMPO_U01, but edit option is grayed out
8. This data source SRMPO_U01 is standard data source and a combined data source.
9. Go to Business analytics work center-> data sources view and select data source SRMPO_U01and then scroll to right and click on documentation link.
10. You will see that data source type is "Combined" and thus if you scroll down you will find the list of all data sources combined under "Involved data sources".
11. then scroll down to Element mapping, were you will see that there are various columns for each data sources Involved.
12. Find the field you are using that is "purchase request ID" , then check under which column the field is appearing.
13. Here the fields"Purchase request ID" appears under column"Purchase Order Items without Follow-Up Documents- SRMPO_B08"
14. That means that the value of this field Purchase request ID comes from that data source:SRMPO_B08.
15. Go to Business analytics work center-> data sources view and select data source SRMPO_B08
16. You cannot find the Data source SRMPO_B08 in data sources, so you cannot check where it gives you the results of the filed Purchase request ID or not .
17. Thus you just have to understand based on the description of the data source that is""Purchase Order Items without Follow-Up Documents"
18. which means data source"Purchase Order Items without Follow-Up Documents" only shows the Purchase orders without any follow up documents.
19. So purchas eorders with status - finished( it has follow up documents) and PO status - follow up document created has no purchase request ID visible in your report
20. You have to use different data source like SRMPO_B12 instead of SRMPO_U01.
21. Go to Business analytics work center-> data sources view and select data source SRMPO_B12 and click on preview to ensure  it gives you result of the field as expected

 so while joining data sources  ensure that each data source will give you desired results in the preview for the fields  as required.

You can check the fields and their data sources in this  below link

https://help.sap.com/doc/0cb1a8377ed34291887409d02e183785/1908/en-US/E-MDAV-DOKU.pdf

Joined data sources, customized data sources , KBA , SRD-SRM-PRO , Purchase Requests and Orders , AP-SIP , Supplier Invoice Processing , Problem