Skip to Content
Feb 04, 2014 at 02:40 PM

System query options $orderby etc error for sap.m.Table bindItem method


I am trying to bind an OData Service to a sap.m.Table using bindItem method as follows:

closingBalanceTable.bindItems("/CreditSocietyStatementSet('2014')",new sap.m.ColumnListItem({

cells: [

new sap.m.Text({

text : "{TotContriOpenBal}"


new sap.m.Text({

text : "{TotContriOpenBal}"




its throwing following error:

{"error":{"code":"005056A509B11EE1B9A8FEC11C23378E","message":{"lang":"en","value":"System query options '$orderby,$skip,$top,$skiptoken,$inlinecount,' are not allowed in the requested URI"}}}

OData Service returns only single element as follows response:

<content type="application/xml">