SAP Query Metadata/result mismatch

Error:


Metadata/result mismatch: Expected [n] columns but results contains [n-1]. 
Please select the query again (binocular) and make sure, all currency & unit field positions are set to 'after' in SAP.

Reason:


Wrong settings of the SAP query options can lead to columns shifting, accidentally.

Solution:


  1. Make sure that the unit and currency fields are set to 'after' in the unit field position, see screenshot below:

  2. Query the SAP query metadata again using the look-up process.

Creation date: 4/13/2023 3:44 PM      Updated: 7/12/2024 3:00 PM
Files   
DataImage51.png
31 KB
DataImage64.png
265 KB