Page tree
Skip to end of metadata
Go to start of metadata

From Netweaver 740SP06 onwards, it is possible to use native OData service to release an easy query. The steps are simpler than using Light Weight Consumption By Easy Query (See what features are supported for Easy Query here).

See OData Queries for details to this feature.


  1. Create a simple query in Query Designer (or Modeling Tool), switch on the flag 'By OData' for Light Weight Consumption setting. The OData service is generated automatically after saving the query. The naming convention for the generated service name is <query technical name>_SRV

    Remark: In SE37 tcode Function Module RSEQ_NAT_READ_CATALOG can be used to list all available OData enabled queries in your system.
  2. Go to transaction /n/IWFND/MAINT_SERVICE on the gateway system, click add service.
  3. Search for the service generated for this query.
  4. Click the Technical Service Name to add it. The technical Service Name is default to Z<query name>_SRV. Attention: For transportation, please assign proper package instead of $TMP

    After confirm a few popup boxes, the service is added successfully.
  5. Click 'Back (F3)' button to get back to the main screen of /IWFND/MAINT_SERVICE, now GL_ODATA1_SRV is available in the service catalog. You could set filter to the service name to find it more easily.
  6. Double click the service, you will see the ICF node is in green status. Now click 'SAP Gateway Client', you can consume this OData service to access the query information.
  7. By default, the service is called with parameter '?$format=xml', the full URI is: /sap/opu/odata/sap/<query name>_SRV/?$format=xml

    Here we can see, with parameter 'GL_ODATA1Results' we can access the data in the query result.
  8. Run URI: /sap/opu/odata/sap/GL_ODATA1_SRV/<query name>Results  to access the data

    This is exactly what we see in query result in RSRT:

  • No labels


  1. Hi Giselle,

    Why I can't find the technical odata service name generated by bex query when do the step 2

    1. Hi Bo,

      To generate odata service, the system needs to be properly set up, check the set up with report in Note 1944258 

      Also see more information about setup and functions at Easy Queries