Skip to Content
1
Jun 18, 2020 at 03:02 AM

re : BUG IN SAP ODATA SERVICE BASED ON CDS service

712 Views

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

Attachments

odatabug.jpg (255.9 kB)