Error while creating Calculation View using SQL Script

[Former Member]

Hi All,

Iam creating calculation view by using SQL script .using the below code.

BEGIN

  SELECT1 = CE_COLUMN_TABLE("EHP5"."CE1IDEA",[GJAHR]);

    SELECT2 = CE_COLUMN_TABLE("EHP5"."CE2IDEA",[GJAHR]);

  VAR_OUT = CE_UNION_ALL(:SELECT1, :SELECT2);

END

where CE1IDEA is one table and CE2IDEA is another table.But while giving other fileds apart from GJAHR it's not activating.

after using single fileds GJAHR iam getting few data records only.

Please explain me these CE functions and How it works and problem in this code.

Thanks in advance.

Phani Rayasam

[Former Member]

Hi Phani,

When you are selecting the fields, The fields from CE1IDEA and CE2IDEA should match.

The code you have written is correct.

As Anooj mentioned please post the code in which you are facing the issue so that it can be analysed more.

Regards,

Shilpa

[Former Member]

Hi Phani,

To understand CE functions, it's correct syntax and what each does, please refer to the guide http://help.sap.com/hana/hana_dev_sqlscript_en.pdf

For this example of yours, can you please post your code that wouldn't activate and also the error message.

Thanks,

Anooj