Skip to Content
avatar image
Former Member

Creating OData Service from existing Table

Hello,

I want to create an OData Service from an existing SAP Table on a non HANA System.

The OData service should provide records from KNA1.

How can I do it? The data should later be used in a UI5 application.

On HANA XS I was able to create such a service, but I don't know how to create it on R/3 😉

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 04, 2015 at 12:54 PM

    Hi,

    You can use Import as DDIC structure while doing modelling. There are multiple docs available for the same.

    http://help.sap.com/saphelp_gateway20sp09/helpdata/en/93/73f7aa7d9e4db4b73c29395a0f06e3/content.htm

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2015 at 12:50 PM

    Hello Enzo,

    In SEGW create Model having all the input and output fields/properties.

    Generate Run-Time objects.

    Implement Get_Entity_Set / Query Operation inside DPC_EXT class. Write the logic to fetch the data from KNA1 table here.

    In the URL finally pass all the input fields as filter Parameters.

    Please check below Query Operation section in the below->

    Let’s code CRUDQ and Function Import operations in OData service!

    Regards,

    Ashwin

    Add comment
    10|10000 characters needed characters exceeded