Sap Odata Filter On Expanded Entity

You work with Dynamics CRM 2016 new WebApi can use clear FetchXml for data querying. Along with the release of Visual Studio 2013 came a new release of ASP. Online tracking of submitted filings including filing rejection management and approved services tab for filing evidence. Editable and can be exported to a single page HTML document. The Add New Dataset dialog is displayed. SAP NetWeaver Gateway is a technology that provides a simple way to connect devices, environments and platforms to SAP software based on market standards. Introduction. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Right-click the Resources folder and click to open the OData Connection wizard. Usually we encounter a business case where in we need to Fetch Parent child relationship data in single call or we may need to. CRUD operation oData This step-by-step post describes how to UPDATE, DELETE & MODIFY record into table using GET_ENTITY method in oData service. Next, we apply the Filter, Sort, Expand and Group functionalities to this list. Make Power Query use filter on expanded Entity on Odata API Hi, I'm using Power Query to import data of my OData API into Excel and Power BI. I got the information from PG that "OData filter are not supported in Power BI I know it’s working in PBI Desktop, but it will break on the service. ODATA EXPAND FILTER; SBX - Heading. Join a community of over 2. Configure the “where” filter so that the SAP OData Agency No. DateTime, you will need to some at some point construct a proper OData query string. Interactively build OData Queries. But if it is a 1:n relationship, you cannot filter based on the other entity. Simple Exercise on OData and SAP UI5 Application for the basic CRUD Operation by Mohamed Meeran DEVELOP AN E2E INTEGRATION SCENARIO WITH SAP GATEWAY, SAP HANA AND SAPUI5 by Andre Fischer From OData Modelling To Service Execution using GWPA:PART-1 by Vishnu Pankajakshan. Entity types may derived by single inheritance from other entity types. This integrated example of how to build an SAP Fiori application provides a step-by-step approach for how to transfer SAP materials management data onto a mobile device. In this project you will create a new database view to analyze the product data. I have a problem using Filter in query. For a deep query customizations the library use odata-query as a builder. This is an object which is based on an entity type which is a specialization of the OdataObject entity in the OData Connector for SAP solutions domain model. Learn more. Overview and code samples for the $expand, $select, and $value options in OData Web API 2 for ASP. Here, Employee class defines the navigation property for Department and same as Department class has navigation property Employee class. In this document we will discuss the EmpPayCompNonRecurring entity in the context of OData API. of output records through Odata API This is helpful to troubleshoot or investigate issues with missing records in the output file. An OData service MAY respond with 301 Moved Permanently or 307 Temporary Redirect from the canonical URL to the actual URL. lead' and 'Ed. Nested filters are not working (ignored) by OData when doing an expand on single Entity with EntityFramework. DateTime type. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods. The following tutorial will introduce you to the latest features of the S/4HANA Cloud SDK regarding extensibility, eager and type-safe expand as well as dependency injection with the Virtual Data Model for OData for any SAP S/4HANA system. SelectRows: If properties of the OData entity sets are marked with these annotations,. SBX - Ask Questions. I am trying to List Records via CDS, filtering on a field that is a MultiSelect Options Set. Sample ABAP Implementation of GET_ENTITYSET in SAP GW. OData Query Options. Query options overview. The filter are applied globally on a DbContext in dependency of the entity type. Below are few commonly used Filters in OData services. in addition to any custom navigations. Online search of all registered entities with expanded entity information including report history, trade name and governor information; 13. Solved: Hello, I have built an report where the source is odata. Consider below entity relation ship ENTITY A -> ENTITY B-> ENTITY C linked with Navigation properties Entity A to Entity B = AB and Entity B to Entity C = BC. js stream or as a library. With OData API, SuccessFactors is leading the league in providing Rest-ful integration services for your HR data in cloud. Terminology in Azure Cognitive Search differs from the OData standard in a few ways. It was OData at it most simplest form with just one method re-defined to get POHeaderSet. The value of. This community is for SAP ERP discussions either pro or con. But there are some things we still need to code. Association and Navigation in OData Service ※OData関連の投稿一覧は以下の記事をご参照ください。 【SAPUI5】OData(1) ODataとは. In other words, whether your source of data is SQL, Cosmos DB or just plain text files, and whether your format is XML, Json or raw text or any other type out there, What the entity data model does is to turn that raw data into entities that allow functionality like count, select, filter and expand to be performed seamlessly through your API. OData v4 now supports Enumeration types, along with Primitive types, Complex types, and Entity types. Source code structure. What we call a field in Azure Cognitive Search is called a property in OData, and similarly for field path versus property path. The Add New Dataset dialog is displayed. Previous proposal: (was 11. Creating an OData Service with an Entity Relationship. 0 Connector option. I will try to involve others who is more fimilar with this kind of issue to have a look at it. Query options overview. NavPropCollection: Same as NavPropSingle except it must identify a Collection of Entries (that is, have a "to many" relationship). Results are not determined by the RBP permissions for EC entities. You will also notice in the screenshot that we’ve chosen studentsdata as an account name for the purpose of this demo, but the most important part of this setup is to select the right API to ensure you can leverage the native support of OData, in our demo here, you will need to select Azure Table which is the API Cosmos DB offers with OData. Below is a list of available statuses and their meanings:. And we expect there will be heavy usage of them. JayStack OData V4 Server. Test the service again using the same steps as in the previous section of this exercise. NET Web API OData that came out in June 2013. This site uses cookies for analytics, personalized content and ads. This article explores how to setup an OData API with ASP. With OData you can enable pagination, ordering of data, reshaping and restructuring of the data and much more with only 4 lines of code. All rights reserved. 5 Dos - OData Query Options $select and $filter ¾Do use $select to specify the fields returned in the result set. Make Power Query use filter on expanded Entity on Odata API Hi, I'm using Power Query to import data of my OData API into Excel and Power BI. my recent experience is: Yes, the successfactors connector can handle SFAPI and OData: for OData upsert choose Execute and then upsert in the operation + make sure you search for entity names starting with SFOdata in import. Let's look at an example. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request. OData service for Angular; Credits. As SAP's OData implementation finds its home in SAP Gateway, you also find lots of documentation within the Gateway documentation: In OData filters (technically: URL parameters) can be used to search for a set of enitites which match special criteria. EC API delivers parameters like asOfDate, fromDate, and toDate for effective dated entities so that you can query the history or future records of an entity. We will work on the same ZGW_PO_SRV service of the earlier post and add more complexity and features to dive deep into OData implementation and put forth the concept behind it. So if team is a lookup on system user, you could apply filter on the name attribute. The synchronous inbound call, that we will define in the next step, needs to go back into this entity – and the only way to achieve this is to specify the mentioned OData API Entity as the starting entity. And we expect there will be heavy usage of them. Navigation Property is used for Relation between Entity Types that used as Request URI using…. Solved: Hello, I have built an report where the source is odata. Creating an OData Service with an Entity Relationship. First thing, add another Entity CustomerSrchHelp which will provide values for Customer Search help. Navigation properties describe the navigation path between the related entities. We will walk through an example and some scenarios…. How to count or verify the no. "OData filter are not supported in Power BI. the starting OData API Entity. The materials available on this site are licensed as set forth here. We could use a string type property, but an. The names of all query string parameters defined by OData are prefixed with a "$" character. SAP Fiori - OData Services - OData is used to define best practices that are required to build and consume RESTful APIs. OData is a REST based open web protocol for sharing data in a standardized format for easy consumption by other systems. For entity instances that are not of type VipCustomer , or any of its subtypes, that entity instance MUST be returned with no inline representation for the expanded. Questions are welcomed! Get Expanded Entity Set /Get Expanded Entity Sap OData. Working Example for SAP Netweaver Gateway Beginners: SAP NetWeaver Gateway is used to share data between SAP and Non-SAP Systems using its ODATA Capabilities. In this tutorial we are going to implement the service i. Part XIII. 12 reasons to consume OData feeds using Simple. OData, short for Open Data Protocol, is an open protocol to allow the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way. August 8, 2019. Filtering works as expected for base query, for example, querying an entity set called "Address" and filter following a parameter called "city" work very well. If no field is selected, then all fields are returned. "OData filter are not supported in Power BI. Create a new project and give the appropriate name of the project. Stream ad-free or purchase CD's and MP3s now on Amazon. This is can be achieved using association and navigation property. Our Company is Not Affiliated to SAP SE / SAP AG or any of its Subsidiaries including Sybase, Hybris Business Objects, Ariba and SuccessFactors. How to count or verify the no. The Add New Dataset dialog is displayed. How to add Multiple Entities (Relationship Data) in one Operation in SAP Netweaver and OData Services? The context for today's article: I was working on a Fiori PoC (Proof of Concept) for my client where I had to do an update on one of the entity sets with multiple records in one call (one header and multiple line items). The method signature is similar to the CREATE_ENTITY method except that it has an additional parameter IO_EXPAND. Entity Framework gives the keyword include which add a reference to an other entity or a list of entities. Build and Use the Container in ODataLib. DateTime type. 0 project to the solution and enable Odata in it. equals the ID that was extracted by the Set variable node. The Entity Data Model (or EDM) is the “schema” for a given set of entities and their relationships. The first example of this exercise was very simplistic because it only exposed one database table as a single entity. A singleton may also be a member of an entity set. I am going to using search help DEBIA to full fill customer search help values so I have defined fields in entity from view M_DEBIA. First I thought the same as you it should filter out ProductPrices but when I faced this issue, I realized that from logical point of view it works correctly - We specifying filter for Product and it returns Products containing at least one Active ProductPrice. Send an AdGroupAdService. GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together. 50 SP04 for OData V4 Implementation: 25. Unfortunately it is not possible to build OData query that will include expand on related entity and filter on it. In OData 2, if a single value navigation property is expanded, you get all the properties of the entity if it was a single value navigation property. For example you might want to build an OData service which has both the Purchase Order Header and Items. In this step-by-step post we will create oData project which consumes RFC: BAPI_FLIGHT_GETLIST. In this blog I will explain creation of simple SAP Gateway OData service having association and navigation between entities. This integrated example of how to build an SAP Fiori application provides a step-by-step approach for how to transfer SAP materials management data onto a mobile device. 0 project to the solution and enable Odata in it. Dismiss Join GitHub today. 14 videos Play all SAP NetWeaver Gateway & OData Complete Training Learn Fiori Most Leaders Don't Even Know the Game They're In | Simon Sinek at Live2Lead 2016 - Duration: 35:09. Now we need to add our CDS views into the OData project: Expand the OData project tree structure. Asking for help, clarification, or responding to other answers. OData provides a uniform way to query and manipulate data sets through CRUD operations (create, read, update, and delete). Query Options means what are the additional parameters/syntaxes can we add to the OData Service URI to perform extra work. You can execute an SQL query or use the UI. In the Service Root URI box, enter the OData endpoint of the API Server. Simon Sinek. Individual requests or responses that don’t include the OData-Version header inherit the OData version of the overall batch request or response. JSON_NO_METADATA ), we need to create the context URL. It does not work on expanded entities. SAP NetWeaver Gateway offers development and generation tools to create OData services to a variety of client development tools. The Open Data Protocol (OData) enables the creation of REST-based data services, which allow resources, identified using Uniform Resource Locators (URLs) and defined in a data model, to be published and edited by Web clients using simple HTTP messages. Terminology in Azure Cognitive Search differs from the OData standard in a few ways. Expand the Generic section and click the Generic OData 2. Either you can reverse the query or. Developers sometimes think of OData batches as transactions, but this is not correct. ComponentModel. Let's look at an example. OData query cheat sheet. I use the Firefox browser and the Representational State Transfer (REST) Client Add-on for illustrating Create, Read, Update, and Delete (CRUD) operations. : We have made the WfRequestUIData entity available in the public category. Note: Changing this value after the SmartFilterBar is initialized. See section for the way create an entity or a list of entities. The value of. SAP S/4HANA OData Cloud Connector Release Notes - Mule 4 Support Category: Premium Anypoint Connector for SAP S/4HANA OData Cloud Connector provides full support to query, create, update, and delete entities, and execute remote functions using the SAP S/4HANA API. When creating an association a navigation property is created in principal entity. 0, SP07 Version 1. But what we want here is based on selected Sales Order# we would like to pull the item data from other entity type. We will work on the same ZGW_PO_SRV service of the earlier post and add more complexity and features to dive deep into OData implementation and put forth the concept behind it. There are two ways to query effective dated entities: asOfDate Query: returns information as of a specific date. Part 2: URL Conventions. OData & SAP Netweaver Gateway - 018 Step 5 Implement Header Entity Type and Set - Duration: 15:02. Questions are welcomed! Get Expanded Entity Set /Get Expanded Entity Sap OData. This community is for SAP ERP discussions either pro or con. A query option is a set of query string parameters applied to a resource that can help control the amount of data being returned for the resource in the URL. These entities are the ones created in the domain models which you can download from the App Store or import via the OData Model Creator for SAP solutions. All examples in this page are based on the. Query options overview. In this tutorial, you learn how to expose Oracle Database data via WCF Data Services and OData through Oracle's Entity Framework support. But what we want here is based on selected Sales Order# we would like to pull the item data from other entity type. 0 June 2015 How To. This uses the ODC (OData Channel) method for implementing an OData service which is the recommended approach by SAP. 1 Annotations. The value of. The Add New Dataset dialog is displayed. Now we need to add our CDS views into the OData project: Expand the OData project tree structure. These options are the links we prepare and send from front end (SAPUI) client system. Introduction. For endpoints that return a specific entity or are executed on the context of a specific entity (bound function/action or navigate), parameters will be generated based on the key attributes of that entity (as specified in the OData spec). Client with batch operations. Stream ad-free or purchase CD's and MP3s now on Amazon. In OData filter syntax the dot notation in the member name means a fully qualified type name. The Azure Cognitive Search terminology is. Create an account to save searches, add your entity to an opportunity's Interested Vendors List, and receive automatic updates when opportunities change. feed with an M function in the URI (to filter requierd data before downlaoding). Expand the Generic section and click the Generic OData 2. Likewise, for User entity. OData Query Options. Drag an SAP S/4HANA Cloud connector operation to the canvas. An index containing documents in Azure Cognitive Search is referred to more generally in OData as an entity set containing entities. I recently had an issue with trying to expand the lookup & user columns in a SharePoint 2013 OnPrem list which I`m importing into a SQL Server 2012 database. The Add New Dataset dialog is displayed. In my previous post oData Service - with INSERT statement, we have already discussed about how to INSERT record into table using GET_ENTITY method. Begin by creating a new SAPUI5 application by referring the post on Follow the steps upto Code View1. 0 (or are made conformant by the removal of versioning information), should have the same validation behavior across 1. Association and Navigation Let's keep things simple to understand. Go to Gateway Service builder SEGW and expand the Service Implementation node of the service. Specify a project name and click Finish. SAP ODATA Overview & Guidelines 1. Filter, Orderby, Expand or our simple Format are some of the commonly used Query Options. Hello, Writing this blog for purpose of beginners in order to explain Deep structures handling in SAP OData. Additionally, the arrow pointing back to itself shows that the User entity navigates back to the User entity. Hello everyone, in this tutorial we will learn how to use filter query option in SAP OData service. The SAP Gateway passes the incoming OData requests to the backend via a trusted RFC connection. You can see the Entity Types as well as the relationships defined within the model. The resource folder, package name, and resource name of the OData connection are provided by default. What is the name of the protocol that is supported by SAP Gateway? A1. requests will return JSON formatted objects. Cardinality means relation between table, here we set the relation between header->item are one to many. So I have 2 entities - SalesOrder and SalesPos. What is OData? OData in Design-time (Entity Data Model ) EntityTypes - data model definitions(for example customer, product), structured types consisting of list of properties (simple or complex) Complex Types - structured types also consisting of a list of properties but with no key. Creating an OData Service with an Entity Relationship. For common default implementations, see \Drupal\Core\Entity\Sql\SqlContentEntityStorage for content entities and \Drupal\Core\Config\Entity\ConfigEntityStorage for config entities. Sometimes, we need to filter out data according to our requirement, or to get total number of data counts or to get data in specific order. The Entity Data Model (or EDM) is the "schema" for a given set of entities and their relationships. Hi there, this is my first post and I am quite new to Flow. In our first sap netweaver gateway how to guides we have modeled the OData service. Please feel free to insert the link of your document or blog by selecting the edit button from Actions. Dear SAPLearners, in this gateway tutorial we will learn how to use $expand query option in SAP OData service. OData and SAP Netweaver Gateway. OData Version 4. In OData filter syntax the dot notation in the member name means a fully qualified type name. For more info Check out my Blog www. Once you open the page, click “Use this template”. BUSINESSPARTNERS_GET_ENTITYSET. Expand the Generic section and click the Generic OData 2. Likewise, for User entity. Begin by creating a new SAPUI5 application by referring the post on Follow the steps upto Code View1. This can be a bit of a challenge as if you don't know the correct syntax for the Edm. Dear SAPLearners, in this gateway tutorial we will learn how to use $expand query option in SAP OData service. In this blog I will explain creation of simple SAP Gateway OData service having association and navigation between entities. Even i faced the same issue, Pls check if the component names of cr_entity and lr_entity are same while debugging… this can happen when you define declare a deep structure within your get_expanded_entity. Use the “OData Query Designer” tool to get the “expand” name and column names To get related entity record fields, click “One To Many” tab and choose the relationship Get Related Entity Fields. OData with RFC function module. SAP Yard 3,903 views. Asked: July 2, 2019 In: SAP PORTAL. DateTime type. FEATURED CONTENT. In OData filter syntax the dot notation in the member name means a fully qualified type name. Working Example for SAP Netweaver Gateway Beginners: SAP NetWeaver Gateway is used to share data between SAP and Non-SAP Systems using its ODATA Capabilities. XOData is a generic OData API/Service visualizer and explorer. Filter, Orderby, Expand or our simple Format are some of the commonly used Query Options. Hello, Writing this blog for purpose of beginners in order to explain Deep structures handling in SAP OData. When creating entities in entity sets that are proxy tables in a database, ensure that all key. How to add Multiple Entities (Relationship Data) in one Operation in SAP Netweaver and OData Services? The context for today's article: I was working on a Fiori PoC (Proof of Concept) for my client where I had to do an update on one of the entity sets with multiple records in one call (one header and multiple line items). And we expect there will be heavy usage of them. What is the name of the tool that is used to implement OData services for SAP Gateway?. I have a problem using Filter in query. In this step you'll find the EPM OData service by looking for it via the maintenance transaction for the Internet Communication Framework (ICF), to understand how web-based resources in general and OData services in particular are managed within an ABAP system. OData Producers comply with OData protocol version 2 specifications with some limitations and exceptions. Working Example for SAP Netweaver Gateway Beginners: SAP NetWeaver Gateway is used to share data between SAP and Non-SAP Systems using its ODATA Capabilities. Web API is also supporting OData. Hello, We are trying to run a filter query on our OData service generated by hana-shine-xsa. Follow RSS feed Like. Regards, Mona. Stream ad-free or purchase CD's and MP3s now on Amazon. Model and instance elements can be decorated with Annotations. Create an account to save searches, add your entity to an opportunity's Interested Vendors List, and receive automatic updates when opportunities change. After getting input from frontend this oData service will execute and send filtered records back to frontend as output. This course uncovers the SFAPI and ODATA APIs , which are the interoperability mechanism offered by SAP Successfactors. Individual requests or responses that don’t include the OData-Version header inherit the OData version of the overall batch request or response. Person, Customer, Order, etc) and keys; Relationships between entities. After entering values to these fields click next. SAP Gateway $batch from OData | DEEP ENTITY using OData Service | SAP Netweaver OData Training - Duration: 2:03:34. 0, but SAP Gateway uses 2. 02 ≥ SP07 Version 2. Build and Use the Container in ODataLib. This is can be achieved using association and navigation property. I recently had an issue with trying to expand the lookup & user columns in a SharePoint 2013 OnPrem list which I`m importing into a SQL Server 2012 database. So that you can able to filter the OData service feed/collection based on the fields available in the Entity Type set. You find following some useful Implementations of GET_ENTITYSET SAP GW method for Business Partners, Sales Orders and Sales Order Items. The names of all query string parameters defined by OData are prefixed with a "$" character. Consider below entity relation ship ENTITY A -> ENTITY B-> ENTITY C linked with Navigation properties Entity A to Entity B = AB and Entity B to Entity C = BC. With OData, the keyword is expand. The standard was initially created by Microsoft, and the committee is now chaired by a Microsoft and an SAP employee. Defines the interface for entity storage classes. OData, short for Open Data Protocol, is an open protocol to allow the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way. Regardless you know there is a fault when using as a web api project. Even i faced the same issue, Pls check if the component names of cr_entity and lr_entity are same while debugging… this can happen when you define declare a deep structure within your get_expanded_entity. 44 In computing, Open Data Protocol ( OData ) is an open protocol which allows the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way. 2 OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. In this blog I will explain creation of simple SAP Gateway OData service having association and navigation between entities. To under stand Association and Navigation in oData, let's work on simple FLIGHT Model data. docx), PDF File (. UI5Con presentation on UI5 OData V4 Model 1. DateTime type. 0 SAP Gateway 2. In the sample TripPin service, the entity type Event and Flight both derive from entity type PlanItem. SAP HANA, Intermediate, Tutorial, SAP HANA, express edition, OData. The OData Generator also have some additional features for expanding data from the relationships on the entity. In this document we will discuss the EmpPayCompNonRecurring entity in the context of OData API. expand inherited methods node. SAP Fiori - OData Services - OData is used to define best practices that are required to build and consume RESTful APIs. Accrete Solutions 1 2. In SAP Lumira, click File -> New -> Query with SQL. JSON is a lightweight data-interchange format. Asking for help, clarification, or responding to other answers. Since alot of folks will be using web api over Odata api controllers, its up to you if you wish to fix, im just pointing it out that it doesn't work. I see in the. In my earlier blog Let's code CRUDQ and Function Import operations in OData service! we understood the basic operation performed in OData service. If there is only 1 value in the Option Set the List returns the record as expected, however when there are multiple values, nothing is returned. I see in the. 0 February 2012 How To Create Complex Business Entities using the Gateway OData Channel. Sample ABAP Implementation of GET_ENTITYSET in SAP GW. OData also guides you about tracking changes, defining functions/actions for reusable procedures and sending asynchronous/batch. Base on implementation of odata-v4-ng. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. oData and JSON Format The Open Data Protocol (OData) is a data access protocol built on core protocols like HTTP and commonly accepted methodologies like REST for the web. Walking down on the properties of the object tree is possible in the OData filter but the members' path must be separated by slash ('/') instead of dot ('. The following provides an example of a Server Function that integrates with a custom SAP module designed to perform property inspections. NET Web API (called Web API 2). OData Query Options. The value of. Documentations - tutorials, guides - for OData v4 Web API. EC API delivers parameters like asOfDate, fromDate, and toDate for effective dated entities so that you can query the history or future records of an entity. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Filtering works as expected for base query, for example, querying an entity set called "Address" and filter following a parameter called "city" work very well. For entity instances that are not of type VipCustomer , or any of its subtypes, that entity instance MUST be returned with no inline representation for the expanded. SelectRows:. All other Names, Brands, Logos, etc. CRM 2011 - oData Explained An exciting new feature of CRM 2011 is the introduction of a REST endpoint which you can use to perform oData based queries against. Begin by creating a new SAPUI5 application by referring the post on Follow the steps upto Code View1. Apache Olingo provides libraries which enable developers to implement OData producers and OData consumers. HTTP/HTTPS Configuration for SAP NetWeaver Gateway: 08. In SAP Lumira, click File -> New -> Query with SQL. For endpoints that return a specific entity or are executed on the context of a specific entity (bound function/action or navigate), parameters will be generated based on the key attributes of that entity (as specified in the OData spec). DateTime, you will need to some at some point construct a proper OData query string. Please keep in mind that the ABAP types will be mapped to EDMX types later on. Check out Filter on Amazon Music. OData Query Options. 5 Dos - OData Query Options $select and $filter ¾Do use $select to specify the fields returned in the result set. JayStack OData V4 Server. What is the name of the protocol that is supported by SAP Gateway? A1. Preparing OData.