Skip to Content
avatar image
Former Member

How to change the datatype of a column

Hi,

I have created 3 tables and created a analytical view using those tables. When I am activating the view , I faced errors saying that a field is incompatible.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 26, 2014 at 05:03 AM

    Hi Sreelatha,

    Can you check the datatype of Region_id as Varchar instead of NVARCHAR. Please share the snippet of your join data type for more analysis.

    Note: SAP recommends only using VARCHAR with ASCII characters based strings. If the data you wish to store contains characters other than ASCII characters, SAP recommends using NVARCHAR data type instead.


    The TINYINT data type stores an 8-bit unsigned integer. The minimum value is 0 and the maximum value is 255 for TINYINT.

    Regards,

    Kannan

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2014 at 05:24 AM

    Hi Shreelatha,

    if you want to change the data type of a column in a HANA table

    please use below syntax:

    alter table "schema"."table"("columnname" newdatatype)

    ex: alter table "SAP"."customer"("cust_id" INTEGER)

    regards,

    sai Krishna.

    Add comment
    10|10000 characters needed characters exceeded