Change data type of RowID attribute "ID" possible?

[Former Member]

Dear all,

we redefined an easy query in our BW 7.31 system. The SEGW-process will integrate the attribute "ID" as key into the entities attributes. The data type is Edm.String without a definite length.

That is normally no problem. Now we want to be able to take advantage of the offline features of our SMP. However SMP has the restriction, that the key field has a maximum of 512 bytes. Therefore an unrestricted Edm.String leads to the following error in the SMP:

• Caused by: com.sap.odata.offline.util.MODataException: [-100061] Property "ID" cannot be supported because it has a max length value that is too large for a key or referential constraint property

Is there a way to change the data type attributes of the generated "ID" attribute during service generation?

Thanks in advance!

Best regards, Daniel

[former_member184867 · Accepted solution]

Hi Daniel,

In service generation it is not possible to specify the length of ID field.

However by manual coding in MPC_EXT class you can change the length of the ID property.

But the length specification is not possible in bytes rather in number of characters.

Regards

Atanu