Respected SAP DEVELOPERS
==============
THERE IS A BUG IN ODATA SERVICE
steps to reproduce
=========
Create a base CDS view (ZPURCHASEORG TABLE
create a consumption cds view - (ZPURCHAEDOCUMENT TABLE)
create an associtaion the consumption cds view in this case underneath table
ZPURCHAEDOCUMENT table purchasingorganization (is a foreign key ) and ZPURCHASEORGANIZATION table
purchasingorganization is a primary key (character length 4 )
I have data stored in the zpurchasedocument table as
PurchasingOrganization column(Foreign Key)
=====
ORG1
ORG2
ORG3
========
in the ZPURCHASEORGANIZATION table
PurchasingOrganization column (Primary key) has data CASE SENSITIVE
org1
org2
org3
ORG1
ORG2
ORG3
I then created a sap fiori list report based template application using SAP WEB IDE AND pointing to the Odata SERVICE that is created by consumption cds view next when I launch the fiori launchpad test and access the app
it gives ABAP DUMP WITH -Runtime Error: 'ITAB_ILLEGAL_SCND_SORT_KEY'. The OData request processing has been abnormal terminated, I put external breakpoint in the ODATA service to debug it is deep inside SAP code
so as a work around I have redefined the GET_EX[PANDED_ENTITY and GET_EXPANDED_ENTITYSET methods
I have attached the screen shot of SAP GATEWAY CLIENT with exact query that is sent as a BATCH request by FIORI app
please take a look
thanks
Rama Anne
