Skip to Content
0
Former Member
Dec 08, 2011 at 06:46 AM

Table creation in HANA

182 Views

Guys,

Need your help, I am trying to create a table so that I can build the analytical/calulated view over it. I am using sql editor and this is the script which I wrtie is given below:

Now the problem which I am facing it is neither giving any success or error message whether table is created or not. What it shows is just red coloured 'X' not sure what does that mean?

question 1) Where to see the error?

question 2) what is the statement to create a table ? I have also tried with create column table sl_extract, it also didnot work.

question 3) Do we need to create a schema first and then create the table?

Please help

create type SL_EXTRACT as table(

RCLNT CHAR(3),

RLDNR char(2),

RRCTY char(1),

RVERS char(3),

RTCUR varchar(3),

RUNIT char(3),

DRCRK char(1),

POPER char(1),

DOCCT char(1),

DOCNR char(10),

DOCLN char(6),

RBUKRS char(4),

ACCT_NO char(10),

PROFT_CTR char(10),

CP char(5),

CN char(5),

DEAL_TYPE char(2),

DEAL_REF char(10),

DEAL_SQ char(5),

ORDER_NUMBER char(12),

CONSUMPTION_PERIOD char(6),

LOGSYS char(10),

CO_AREA char(4),

MOVEMENT_TYPE char(3),

DOC_TYPE char(2),

MATERIAL char(18),

PLANT char(4),

DOC_CURY_AMOUNT decimal,

LOC_CUR_AMOUNT decimal,

GROUP_CURR decimal,

AC_DOC_NO char(10))

N