SAP Knowledge Base Article - Preview

2628006 - Nvl function not working as designed - SAP Data Services 4.x


  • When using a NVL function the output displays the incorrect results.
  • In the source table the quantity field has the value: 0,004280
  • But in the output table the quantity field is transformed to  4280.000000  (multiply  by 1 000 000)



  • Windows 2008 R2
  • SAP BusinessObjects BI 4.1 Support Pack 6
  • SAP Data Services 4.2 SP5
  • Microsfot SQL 2012


SAP Data Services 4.1


NVL function , KBA , EIM-DS-DES , User Interface/Designer , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.