The data source Supplier Invoice Item (ID: SRMIV_B03) throws an exception during the runtime execution: No SID found for value 'CL' of characteristic @MSRMIV_B03/BU_QTY_UNIT
Reproducing the Issue
Steps to reproduce:
- Go to Business Analytics
- Go to Design Reports
- Search SRMIV_B03
- Click on Preview
No SID found for value 'CL' of characteristic @MSRMIV_B03/BU_QTY_UNIT.
The error of view element: BU_QTY_UNIT implies to be the characteristic named: Base UoM.
In this case you might have Credit Memos which have the quantity unit of measure as 'CL' and 'UN' or even any other that will be described in the error message itself, which does not exist in the system.
So now when the report is opened and loaded the processing of the query happens at the BW layer which is integrated to Bydesign where the parameters are passed. Now since the UoM 'CL' is not present it results in this exception.
So please correct the Credit Memos which contain the wrong quantity unit of measure defined.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To