/scripts/ahub.form.attachments.js
0

XSOdata - POST on table with no key column

May 19, 2017 at 06:50 PM

241

avatar image

I have a table that does not require a key column to be specified. When defining an odata service, I used the 'Keys generate as local("ID")' to specify a key.

Problem is when I use a POST method to create records, I get 'Status - 501 not implemented', both when I use an ID column or if I drop it. Is there a way around this or should I define a dummy key column in my table?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Krishna Tangudu May 23, 2017 at 05:56 PM
0

This should work benedict. Can you share your code which you are trying to use.
I didn't double check in my system but as per this post this should work

https://archive.sap.com/discussions/thread/3945703

Regards,
Krishna Tangudu

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I use a simple definition,

TABLE:

table.schemaName = "<schema>"; table.tableType = COLUMNSTORE; // ROWSTORE is an alternative value table.columns = [ {name = "MY_COL1"; sqlType = VARCHAR; length = 200; }, {name = "MY_COL2"; sqlType = INTEGER; defaultValue = "1";}, {name = "MY_COL3"; sqlType = NVARCHAR; length = 200; } ]; //table.primaryKey.pkcolumns = ["MY_COL1", "MY_COL2"];

ODATA:

service { "VENMANBV"."sce_tdm.test.venmanbv_D75.catalogObjects::ODATA_SAMPLE" as "MyView"

keys generate local "ID";

}

0
Skip to Content