2337107 - Error in Supplier Invoice Item data source

SAP Knowledge Base Article - Public

2337107 - Error in Supplier Invoice Item data source

Symptom

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:

  1. Go to Business Analytics
  2. Go to Design Reports
  3. Search SRMIV_B03
  4. Click on Preview

 No SID found for value 'CL' of characteristic @MSRMIV_B03/BU_QTY_UNIT.

Cause

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.

Resolution

So please correct the Credit Memos which contain the wrong quantity unit of measure defined.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP Business ByDesign 1711