CE function is not allowed here

28 Views

Hi everybody,

i have a problem with a CE_JOIN-function.

My coding looks like this:

et_out = CE_JOIN_VIEW(_SYS_BIC."test/zz_ts_uc");

et_out = SELECT ABRNR, ABRSTAT, SCHAEKZ, BILJJ, a.VTGNR, B_WHGNR, OW_WHGNR,

OW_BETR, AB_BETR, BUKRS, BAUSTEIN FROM :et_out AS a

JOIN :it_vtgnr AS b ON a.VTGNR = b.VTGNR;

et_out := CE_JOIN(:it_vtgnr, :et_out, ["VTGNR"], ["ABRNR", "ABRSTAT", "SCHAEKZ", "BILJJ", "VTGNR",

"B_WHGNR", "OW_WHGNR", "OW_BETR", "AB_BETR", "BUKRS", "BAUSTEIN"]);

The view is a simple Attribute View. I don't know why i am able to activate the coding with the SELECT, but it fails by trying to activate with CE_JOIN (one of the statements is commented out at the time of activation)

I get the following error-message:

ERROR msg/test/opensap/stanglt/Bachelorarbeit/zz_ts_unit_conversion2.procedure
Repository: Internal error during statement execution, please see the database error traces for additional details;error executing statement; feature not supported: CE function is not allowed here: line 14 col 11 (at pos 1411) at ptime/query/checker/check_expr.cc:301

ERROR msg/test/opensap/stanglt/Bachelorarbeit/zz_ts_unit_conversion2.procedure
Repository: Encountered an error in repository runtime extension;object was not activated due to previous activation errors

ERROR msg/test/opensap/stanglt/Bachelorarbeit/zz_ts_unit_conversion2.procedure
Object potentially broken due to transaction rollback.

ERROR exception 40177:
repository/base/activation/activator.cpp:828
Object potentially broken due to transaction rollback.

Any ideas?

Regards,

Tobias