Skip to Content

Data Type Issuee On Reading Data From MSSQL to SAP BW

Hi

I'm creating BW info Cube Based on MSSQL table Contain column named "Salary" contain value (10000) , I created DB Connect from Source System which read the Field salary as "Int4" the issuee the "10000" is MSSQL is Readed in the BW as "10.000"

Data In the Source MSSQL Salary 10000

Data in Source system SAP BW 10.000

any help about the issuee ?

data-in-bw.jpg (39.0 kB)
data-in-mssql.jpg (13.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 31, 2018 at 05:06 AM

    Try to change the user specific setting for decimal points,

    Go to SU3 tcode and change the decimal notation.

    Thanks,

    Bhavin Vyas

    Add comment
    10|10000 characters needed characters exceeded