Symptom
You are using the data source Supplier Invoice Item Details (SRMIV_B03) and have added the field Official Invoice ID to Rows.
The field displays # and you are expecting it to display the Supplier Invoice ID.
Reproducing the Issue
- Go to Business Analytics work center
- Go to Design Data Source view.
- Show All data sources and find SRMIV_B03.
- Select the data source Supplier Invoice Item Details.
- Move the field Official Invoice ID from Not Currently Shown to Rows;
You can see # is displayed instead of data in the field Official Invoice ID.
Cause
The field Official Invoice ID isn't returning any data because it is specific to Mexican invoices. It appears only for Mexican companies in Supplier Invoices and pulls its data from the data maintained by the user in the system in that specific field.
Resolution
This is expected system behaviour.
Keywords
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To
Product
SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711