Skip to Content
Technical Articles
Author's profile photo Andre Fischer

New SAP Gateway Demo System available

Updates

  • 23.01.2018 – Show how to enter a TCODE
  • 29.05.2018 – Added the section “What you can’t do with the SAP Gateway Demo System”
  • 26.09.2018 – Added links to the $metadata documents of the SAP Fiori Reference Apps
  • 10.05.2019 – Added link to reset your password
  • 29.09.2019 – Added link to the trial offering of SAP Cloud Platform, ABAP environment
  • 10.02.2021 – Added information about two read-only services that do not require any authentication

What you can’t do with the SAP Gateway Demo System

  • You can’t develop your own repository objects such as tables, CDS views or classes to ensure stabiltity of the system. If you want to develop your own OData Services you have to get a trial version. Here we have two options:
  • Access is limited to WebGUI
  • You will not find any real Business data in this System since ES5 is just a pure SAP NetWeaver AS ABAP 7.51 System without having a SAP S/4HANA system running on top of it.

How to do I get a user?

As with the predecessor system you have to sing up for an account in ES5. To do so simply follow this link:

Sign up for a demo account on ES5 here

How can I reset my password?

If you forgot your password you simply have to click on the same link that you have used to Register for a new user:

Click here to reset your password in ES5

What’s new?

The new SAP Gateway System is based on SAP NetWeaver 751 and thus comes with several new features as opposed to the predecessor system ES4 which was based on SAP NetWeaver 740.

SAP Fiori Launchpad and SAP Fiori Reference apps

For all users we have configured SAP Fiori Launchpad where you will find four applications that have been deployed.

 

 

Launch the SAP Fiori Launchpad

Demo services for SAP Fiori development

You can use SAP Web IDE to develop SAP Fiori applications on top of the demo services that are provided in the SAP Gateway demo system.

SAP Fiori Sample Applications

As an example you will find OData services that allow you to create SAP applications based on SAP Fiori Sample Applications.

Approve Purchase Orders

A SAP Fiori Reference Application used to demonstrate the approval process
Oased on the EPM model This is a master-detail applicatiom

https://sapes5.sapdevcenter.com/sap/opu/odata/sap/EPM_REF_APPS_PO_APV_SRV/$metadata

Shop

A SAP Fiori Reference Application used to demonstrate a shopping scenario on the EPM model This is a full screen application.

https://sapes5.sapdevcenter.com/sap/opu/odata/sap/EPM_REF_APPS_SHOP_SRV/$metadata

Manage Products

A SAP Fiori Reference Application used to demonstrate the creation and maintenance of product entities for the EPM model This app is Oased on Fiori Elements

https://sapes5.sapdevcenter.com/sap/opu/odata/sap/EPM_REF_APPS_PROD_MAN_SRV/$metadata

Procurement Overview

A SAP Fiori Reference Application used to demonstrate an over,new ofthe EPM model. This app is based on the new SAP Fiori Elements Overview page.

https://sapes5.sapdevcenter.com/sap/opu/odata/sap/SEPMRA_OVW/$metadata

Sample service GWSAMPLE_BASIC

There is also the well known basic sample service GWSAMPLE_BASIC available that provides you with a practical, working OData service with meaningful content that supports basic OData operations.

The following link would provide you a list of items of a sales order from the Enterprise Procurement demo data:

https://sapes5.sapdevcenter.com/sap/opu/odata/iwbep/GWSAMPLE_BASIC/SalesOrderSet?(%270500000001%27)/ToLineItems

You can find more information about the basic sample service in the SAP Online Documentation

SAP Online Documentation: Sample Service – Basic

OData V4 demo service

In ES5 there is now also a first demo service available that supports OData V4.

https://sapes5.sapdevcenter.com/sap/opu/odata4/sap/ze2e001/default/sap/ze2e001_salesorder/0001/$metadata

More details can be found in the following blog OData V4 code based implementation – Overview.

RMTSAMPLEFLIGHT

Also the RMTSAMPLEFLIGHT service is available

https://sapes5.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/$metadata

Services that do not require authentication

We have added the following two services for read-only access that do not require any authentication.

We do not have a service that allows updates  and creates without an authentication since for this you need a CSRF token which is not issued by the ICF framework when an ICF node contains hardcoded credentials.

EPM Demo Sales Orders

https://sapes5.sapdevcenter.com/sap/opu/odata/sap/ZSOCDS_SRV/?$format=xml

EPM Demo Products

https://sapes5.sapdevcenter.com/sap/opu/odata/sap/ZPDCDS_SRV/?$format=xml

 

Which type of Access do I have?

After you have signed up for an account you can access the demo system in various ways:

SAP Web IDE

In your SAP Cloud Platform Cockpit you have to create a destination using the following data:

#
#Tue Dec 05 14:36:33 UTC 2017
Description=SAP Gateway Demo System
Type=HTTP
TrustAll=true
Authentication=NoAuthentication
WebIDEUsage=odata_abap, bsp_execute_abap, odata_gen
Name=ES5
WebIDEEnabled=true
CloudConnectorVersion=2
URL=https\://sapes5.sapdevcenter.com
ProxyType=Internet
sap-client=002
WebIDESystem=ES5

You can simply create a text file that contains the above mentioned data and import the destination as follows:

  1. Login to the SAP Cloud Server Cockpit
  2. Select your account
  3. Click Connectivity
  4. Click Destinations
  5. Click Import Destination
  6. Select your destination configuration file and click Open.

 

SAPGUI for HTML

Using this link SAPGUI for HTML access you can log on to the system using SAPGUI for HTML.You will see the following logon screen: Access is a restricted to read-only access for developers though. Reason is that otherwise the stability of this system could not be guranteed.

In order to add a transaction code you have to click on the ellipsis and choose GUI Actions and Settings →  Show OK Code Field.

Then you will be able to enter transaction codes in the OK Code field on the left hand side of your screen.

 

and here a description how to access a transaction without having to activate the TCODE field …

How to access the SAP Gateway Error Log as a SAP UI5 developer

Assigned Tags

      129 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo DJ Adams
      DJ Adams

      Great news, thanks Andre and team!

      Author's profile photo Jessica Merz
      Jessica Merz

      Very nice, thanks! I can make good use of this.

      Author's profile photo Javier Caceres
      Javier Caceres

      Good article

       

      Author's profile photo Paul Hardy
      Paul Hardy

      Mr. Andre,

      I am desperate to ask you a philosophical question about Gateway.  Another SAP employee was blogging about Gateway on the weekend, but it turns out there are many components inside SAP, all called Gateway, so i got confused and asked him about Gateway and he told me I had the wrong Gateway.

      So just to be clear, I am talking about the Gateway component where you define services using SEGW (at least for now) and they get exposed as ODATA. that sounds just like what you are talking about above. If, after reading my question, it turns out there is yet another component in SAP called Gateway, please point me in that direction.

      We have a customer portal where the user enters a sales order on their phone or laptop or whatever, and the JavaScript code on the device does a call to a Gateway service I wrote in SAP. It all works just fine, and we are on top of the indirect licencing thingy, so everything in the garden was rosy.

      Now we have a proposal for a generic middleware layer, all Microsoft based, taking in the HTTP call from the mobile device, in whatever country, working out dynamically the correct source system and connecting to it. All lovely and object oriented, several layers all abstracted from each other.

      The problem is the architecture calls for assorted Microsoft integration services connecting to the source systems. the one chosen to connect to SAP is from a company called Theobald software, which works by connecting to custom RFC function modules inside SAP.

      Now I don;t want to give up Gateway. The arguments I am facing in favour of RFC function modules instead of Gateway are as follows:-

      • it (RFC) works and it is easy
      • all the other source systems are contacted directly and contacting Gateway is contacting “middleware” instead of the actual source system, thus giving one source system special treatment instead of treating all source systems the same
      • the call to Gateway will introduce two more HTTP calls in addition to the original one from the device, thus negatively effecting performance, and making t more difficult to pinpoint any point of failure
      • Gateway cannot do an asynchronous call

      Now, I would like to tell me that these arguments are nonsense, and give me some cast iron reasons I can use to knock holes in the proposed plans. However if the above are valid arguments, please tell me that as well.I try to keep an open mind, and I have a lot of respect for the architect of the middle ware framework and how well designed it is from an abstract OO perspective. It is just this one little technical part of the pie I am concerned with.

      I have talked to lots of my fellow SAP Mentors about this, and the only argument I have thus far is a philosophical one in that Gateway is SAP’s future direction. Whilst I agree with this 100% it is not getting me very far at work as an argument. I need something more concrete.

      Cheersy Cheers

      Paul

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Paul,

      yes there is a problem with all the Gateway's within the SAP stack and with regards to the naming we unfortunately haven't followed the highlander principle.

      So yes there is the SAP Gateway you are using to develop and publish OData services and the RFC Gateway within the ABAP AS which is responsible for the RFC based communication.

      But coming back to your questions around the architecture. First of all I do not see a point in replacing an existing OData service through a RFC call to build a new UI on top of this.

      This would be taking several steps down the ladder of evolution of SAP UI’s which meanwhile have fully embraced OData with SAP Fiori 2.0 also being available for the SAP Business Suite and OData being the basis for SAP Fiori UIs in S/4 HANA.

      With regards to your questions I can answer as follows.

      1. ."it (RFC) works and it is easy"

        RFC is not that easy that’s why we at SAP have decided to go for OData for UI scenarios. RFC has definitely is pros but this is more in the area of system to system communication where for example two SAP backend systems are talking to each other exchanging huge amount of data

        OData services having being added more and more to our portfolio (there are already a large number being part of the latest EHP8 in the SAP Business Suite) and going forward with SAP S/4 Hana the SAP Fiori is the UI paradigm and SAP Fiori UI’s are typically using OData services.

      2. ."all the other source systems are contacted directly and contacting Gateway is contacting “middleware” instead of the actual source system, thus giving one source system special treatment instead of treating all source systems the same"

        It is also possible to run the SAP Gateway Hub and Backend components on one system using the so called embedded deployment. As of 750 SP04 (which is for example used with SAP Business Suite EHP8) you can gain significant performance improvements as described in my blog
        https://blogs.sap.com/2016/10/10/take-advantage-performance-improvements-sap-gateway-sap-netweaver-7.50-sp04/
        Replicating data into a middleware also poses a security risk since you have to rebuild authorization checks that are in place in your SAP Business Suite backend system. Also features such as Read-Access-Logging (RAL) that are available for OData with SAP NW 750 could not be used in a reliable way.

        The SAP Gateway Hub scenario (used as a frontend server for SAP Fiori) also has it pro’s especially when using several SAP backend systems as described in landscape deployment recommendations in the SAP Enterprise Architecture Explorer
        https://eaexplorer.hana.ondemand.com/_item.html?id=11122#!/overview

      3. "the call to Gateway will introduce two more HTTP calls in addition to the original one from the device, thus negatively effecting performance, and making t more difficult to pinpoint any point of failure"

        Putting a middleware in between the UI and your backend will definitely make the search of a root cause of a problem more complicated. But this is also true if your UI speaks RFC with your backend opposed to OData. But when you have the OData services in place you can consume those via your SAP Fiori frontends directly without the need of any middleware at all.

      4. "Gateway cannot do an asynchronous call"

        It is true that the OData V2 protocol does not offer asynchronous calls as part of the OData V2 specification. But I see several options how to achieve this.

        • You can use a function import that even can take some parameters that simply takes the data, performs some calculations and would inform the end user later on for example via email
        • Using the notification channel such asynchronous scenarios could be implemented as well and the end user would receive a notification on the side panel of the SAP Fiori Launchpad.
          I did a mini code jam about this at SAP TechEd and will publish a blog about this in January https://sessioncatalog.sapevents.com/go/agendabuilder.sessions/?l=159&sid=49582_474721&locale=en_US

      Hope this helps,

      Best Regards,

      Andre

       

      Author's profile photo Vladislav Volodin
      Vladislav Volodin

      Gateway cannot do an asynchronous call

      You can play with websockets, that are supported by NetWeaver. Start the task and notify the user, when it finishes.

       

      Author's profile photo SEAN TRACEY
      SEAN TRACEY

      Hello,

       

      I just created a user id for ES5. I used ES4 for the past few 6-9 months and within ES4 I see the LOGISTICS menu in place. I specialize in MM/PP/SD/WM/QM etc. within the SAP applications. This menu does not exist in ES5 and the transaction are also missing. VA01 VA03 MM01 MM03 etc. Can you explain?

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Sean,

      the reason is that ES5 is only a SAP NetWeaver System and not a SAP Business Suite System.

      The system is meant to be a demo system for the latest technologies (SAP Fiori, OData, SAP Gateway) and these are only available on pure SAP NetWeaver stacks or S/4 HANA.

      Best Regards,

      Andre

       

      Author's profile photo SEAN TRACEY
      SEAN TRACEY

      Hi Andre,

       

      I'm a bit confused now. I attend a OPEN .SAP.COM class last year. See below

      Building Portal Sites on SAP Cloud Platform

      Instructors: Ido Shamesh, Murali Shanmugham and Thomas Hensel

      During this class we connected to ES4 within the SAP Cloud portal via a P number and on the SAP CP built a Portal site and then designed a APP Roles catalogs to produce a FIORI AND freestyle APP. The app connected to ES4 returned materials and sales orders. So I don't understand your comments from above:

      @Andre "The system is meant to be a demo system for the latest technologies (SAP Fiori, OData, SAP Gateway) and these are only available on pure SAP NetWeaver stacks or S/4 HANA."

       

      Secondly if ES4 is being replaced by ES5 will the APP work?. If we don't have the Business suite in place (that contains a massive investment) then how do we get at the data we have in the back end system.

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I assume that you haven't used real Business Suite data but have rather used data from the SAP NetWeaver demo data model.

      Did you use the following service called GWSAMPLE_BASIC?

      https://sapes5.sapdevcenter.com/sap/opu/odata/IWBEP/GWSAMPLE_BASIC/?$format=xml 

      Best Regards,

      Andre

      Author's profile photo SEAN TRACEY
      SEAN TRACEY

      Hi

      The course asked that we connect to ES4: I did this all in my SAP CP account P (NUMBER) and I created a SAPUIG App. Created a portal site and a FIORI launch pad. And is good. We get sales order and materials from ES4.  When I logged onto ES5 there was no logistics hence the note. So how do we get at that information that I belived came from ES4 using SAP CP PORTAL APP & FIORI? Do I need to talk to the course owners mentioned above or can you do that?

       

      I added ES5 at the request of the help desk within OPEN.SAP.COM and I have never used or seen the link from the service GWSAMPLE_BASIC

       

      I can go over it with you if you have time or can send more details

       

      Thanks,

      Sean.

      HTTP ES4 Authentication

      BasicAuthentication

      ProxyType

      Internet

      URL

      https://sapes4.sapdevcenter.com

      HTTP ES5 Authentication

      NoAuthentication

      ProxyType

      Internet

      URL

      https://sapes5.sapdevcenter.com

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      please post your question on the opensap page.

      I will inform the colleagues nevertheless.

      best regards,

      Andre

      Author's profile photo SEAN TRACEY
      SEAN TRACEY

      Thanks for your help and time..

      Author's profile photo Di Ana
      Di Ana

      Hi!

      just replaced ES4 with ES5, but when I log in I don't see any tcode input field. Is that supposed to be this way and I should add tcode manually using favorites or am I missing something?

       

      Thanks,

      Di

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Di,

      I have updated my blog. Thanks for the hint.

      Best regards,

      Andre

       

      Author's profile photo Azeem Quadri Mohammed Abdul
      Azeem Quadri Mohammed Abdul

      Hi I am not able to signup for ES5 system. Is there any other system that I can sign up for.

      https://register.sapdevcenter.com/SUPSignForms/

      Thanks Azeem

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I just tested the registration process and it works fine for me.

      You have to authenticate using a SAP CP user when registering for ES5.

      When you have been authenticated by SAP CP a user will be created for you in ES5 and mail with the credentials will be sent to you.

      Regards,

      Andre

       

      Author's profile photo Christian Schuff
      Christian Schuff

      Hi Andre,

      the link does not work for me either... Is this supposed to work with a trial user?

      BR

      Chris

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Yes.

      Author's profile photo Chiranjeevi Giri
      Chiranjeevi Giri

      Hi,

       

      Do we have developer access for ES5 demo system ?

       

      Thanks & Regards,

      Chiranjeevi

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      No, because this would destabilize the system.

      Author's profile photo Ram K
      Ram K

      Hi Andre,

      Is there flight sample data service as in previous releases RMTSAMPLEFLIGHT ?

      Please provide the details.

       

      Thanks,

      Ram

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I have added the link. You just have to replace the "4" with a "5" in the link you provided.

      Author's profile photo Harpreet Daphu
      Harpreet Daphu

      Hello Andre,

      When I try creating a Master - Detail Application using the - RMTSAMPLEFLIGHT service, it doesn't allow me to proceed. Can you confirm if this service is maintained in ES5?

      I am able to access the metadata of RMTSAMPLEFLIGHT service but not able to use it in my application.

      GWSAMPLE_BASIC works fine.

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I can confirm this issue but I have not been able to find the root cause yet.

      Best Regards,

      Andre

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I checked with another system and there the same issue occurs.

      So it might be related to SAP Web IDE.

      Regards,

      Andre

       

      Author's profile photo Harpreet Daphu
      Harpreet Daphu

      Thank you Andre for taking a look.

      Please keep us posted, if it gets fixed.

       

      Regards,

      harpreet

       

      Author's profile photo Prasad Ganta
      Prasad Ganta

      Hello Andre,

       

      Having trouble with RMTSAMPLEFLIGHT service, it doesn’t allow me to proceed during creation of master detail app. Are you able to find the issue?

       

      Thanks,

      Prasad

      Author's profile photo Boghyon Hoffmann
      Boghyon Hoffmann

      Now even the service metadata document can't be retrieved. RMTSAMPLEFLIGHT seems to be removed completely (not sure since when). Could you confirm? If true, would be nice if the blog could be updated.

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      The service was there but did not work. I deleted and re-published it and tested it.

      It again works as supposed.

      Thanks for pointing me to this issue.

      Author's profile photo Denis Aleksandrovich
      Denis Aleksandrovich

      Hi,

      Do you have plans for setting up the workflow (TCODE SWU3)? To start the demo workflow, the "Notification of Absence" (TCODE SWXF).

      And also configure the application Fiori MyInbox (OData-service TASKPROCESSING).

      Now when sending a request to the object data, an error occurs: "The task phase for the provider is not implemented." I can help customizing on and send instructions.

      I'm studying sap ios sdk, and I want to develop an iOS application based on the oData service.

      Thanks

      Regards,

      Denis

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I will check with my colleagues whether we can make the service and app available.

      Best Regards,

      Andre

       

       

      Author's profile photo Gowtham Raja M
      Gowtham Raja M

      Hi Experts,

      I have gone through this page. I have logged into demo es5 system in cloud but there is no provision provided for going gateway client. When i type tcode /iwfnd/gw_client, it throws me message popup that the tcode does not exist. Please help me.

      Thanks,

      Gowtham

       

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      You have to add a "/n" in front of the transaction code since the transaction code starts with "/I" which is a reserved keyword.

      So try to enter "/n/iwfnd/gw_client" instead.

      Best Regards,

      Andre

      Author's profile photo Michael Koch
      Michael Koch

      Hi Andre

      Thanks for this helpful blog post.

      However, I've just spent a couple of frustrating hours establishing what was wrong with my ES5 connection. I imported your ES5 profile text file from above, but because it doesn't contain authentication details, my account became locked after probably about 3 attempts.

      I've now waited for an automatic reset of my ES5 user and edited my profile to contain Basic Authentication with my registered ES5 user and pw.

      Maybe it would make sense to add that authentication is required?

      Thank you for submitting all the helpful info about ES5.

      Kind regards,

      M

      Author's profile photo Mihai Dipsan
      Mihai Dipsan

      Hi Michael,

      I think I have the same problem as you with my ES5 user. I cannot connect and after I changed my password it still doesn't work. I get the same message every time, that my user or password is not correct.

      It works for you now? Can you please tell me what you've done?

      Kind Regards,

      Mihai

      Author's profile photo srivedhasankaran anbalagan
      srivedhasankaran anbalagan

      Hi Andre,

      when i try to practice UI5 using webide and when i wanted to create ODATA for that APP, I couldn't create it(since i don't have authorization). When i try to use any existing ODATA  Application no existing odata application was available. can you kindly suggest me a way to create or use any ODATA application so i can link it with webide and practice end to end.

      Author's profile photo Former Member
      Former Member

      Is it possible log on with SAP GUI application? I don't like HTML GUI

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      No, this is not possible. 

      Author's profile photo Former Member
      Former Member

      I signed up for the demo account. I am able to access SAP GUI HTML .  I am trying register GWSAMPLE_BASIC  sample service as stated below link but getting an error that I do not have authorization to use transaction /IWFND/MAINT_SERVICE.

       

      https://help.sap.com/viewer/68bf513362174d54b58cddec28794093/7.51.4/en-US/3a1236932c344e529ef3f621c6e75433.html

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      There is no need to register this service since it has already been registered.

      Administrative access to this system is limited.

      If you want to try out such things you have to get your own ABAP trial system in the cloud or download it.

      Regards

      Andre

      Author's profile photo Former Member
      Former Member

      Destination is giving me this pop up when trying to connect

       

      Connection to "ES5" established. Response returned: "307: Temporary Redirect

       

      Author's profile photo Kiran Kumar Sangem
      Kiran Kumar Sangem

      Hi, I have the same problem, please post the steps if it is resolved.

      Author's profile photo Kiran Kumar Sangem
      Kiran Kumar Sangem

      Hello!! Any help here?

       

      Author's profile photo kyo choi
      kyo choi

      I got the same message and the connection worked.  Try creating Fiori Master Detail app.

      Author's profile photo vincent chen
      vincent chen

      Hi,

      I would like to know if Human Resources will be available on SAP ES5 ?

      Thanks

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Vincent,

      no, it can't be available on this box since this is a plain SAP NW ABAP system.

      Regards,

      Andre

       

      Author's profile photo RSB SAP
      RSB SAP

      Hi ,

      I just signed up in ES5 but I'm unable to create any custom table to create sample service and unable to access contents from std tables .Im getting authentication while creating custom table and RFC error .I have tried to create destination but Im unable to find  connectivity option in SAP Cloud Platform cockpit  .Can any one please help to access ES5 without errors

      Thank you ,

      Ravi.

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Ravi,

      you can't create repository objects in this system. See also my latest update "What you can't do with the SAP Gateway Demo System" at the top of this blog.

      Regards,

      Andre

       

      Author's profile photo RSB SAP
      RSB SAP

      Thank you Andre Fischer 🙂

      Author's profile photo Nelson Kharat
      Nelson Kharat

      Hi Andre,

      I am not able to access the registration link for SAP ES5 Demo System. Please help.

      https://register.sapdevcenter.com/SUPSignForms

      Both of the above links are not working.

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I deleted the second link since it points to a test system that definitly does not run and I informed the owner of the registration page that the same is not running.

      Regards,
      Andre

       

      Author's profile photo Nelson Kharat
      Nelson Kharat

      Hey Andre,

       

      Thank you for your reply, however I am not able to access it. When I tried accessing it, I get this. Need directions.

       

      Author's profile photo Sachin Soni
      Sachin Soni
      Hi Andre,
      Just like Nelson, 

      I am not able to access the registration link for SAP ES5 Demo System. Please help.

      https://register.sapdevcenter.com/SUPSignForms

      Both of the above links are not working.

      Although when i ping the URL register.sapdevcenter.com it does reach the URL but the complete one with forms isnt working !

       

       

      Thanks,

      Sachin

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I deleted the second link since it points to a test system that definitly does not run and I informed the owner of the registration page that the same is not running.

      Regards,
      Andre

       

      Author's profile photo Emanuele Ricci
      Emanuele Ricci

      Is the V4 OData endpoint still available? I cannot access any of the EntitySet

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Not sure whether there was a temporary issue. But I can Access my sample Service

      https://sapes5.sapdevcenter.com/sap/opu/odata4/sap/ze2e001/default/sap/ze2e001_salesorder/0001/SalesOrder?$top=1&sap-ds-debug=true

      Regards,

      Andre

       

       

      Author's profile photo Boghyon Hoffmann
      Boghyon Hoffmann

      Why does the service require $filter or $top in order address entities? Does OData V4 allow such restrictions? Couldn't find any reference of this in the OData spec.

      Also other features like filtering with YEAR function ($filter=year(Creationdatetime) eq 2016) are not supported.

      It would be nice if all limitations are documented somewhere - Maybe in the section "What you can’t do with the SAP Gateway Demo System".

      Author's profile photo Emanuele Ricci
      Emanuele Ricci

      Hi, I'm developing a series of exercises around ES5 GWSAMPLE_BASIC service. I've already done READ, DELETE, UPDATE but I've some trouble with the POST request.

      I'm trying to create with SAPUI5 an entry for the set SalesOrderLineItemSet

      When I submit all my changes I get back this error:

      {
      	"error": {
      		"code": "005056A509B11ED199D8826D151FC0FE",
      		"message": {
      			"lang": "en",
      			"value": "The specified HTTP method is not allowed for the resource identified by the Data Service Request URI"
      		},
      		"innererror": {
      			"transactionid": "B9E0A2A100BE0160E005BF4BBFD5771F",
      			"timestamp": "20181125104513.5724410",
      			"Error_Resolution": {
      				"SAP_Transaction": "Run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details",
      				"SAP_Note": "See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"
      			}
      		}
      	}
      }

      Does it mean that POST requests are forbidden or am I doing something wrong?

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      If the following payload is posted on the URL

      /sap/opu/odata/IWBEP/GWSAMPLE_BASIC/SalesOrderLineItemSet

      of the Entity set SalesOrderLineItemSet

      a new item in the sales order 0500000000 is created .

      A reason why a post may fail could be that the Status of the sales order does not allow any changes, because the status is not 'N' = New

      <d:LifecycleStatus>N</d:LifecycleStatus>

      <?xml version="1.0" encoding="utf-8"?>
      <entry xml:base="https://sapes5.sapdevcenter.com/sap/opu/odata/IWBEP/GWSAMPLE_BASIC/" xmlns="http://www.w3.org/2005/Atom" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
        <content type="application/xml">
        <m:properties>
         <d:SalesOrderID>0500000000</d:SalesOrderID>
         <d:ProductID>HT-1000</d:ProductID>
         <d:Note>EPM DG: SO ID 0500000000 Item 0000000010</d:Note>
         <d:NoteLanguage>EN</d:NoteLanguage>
         <d:CurrencyCode>USD</d:CurrencyCode>
         <d:GrossAmount>1137.64</d:GrossAmount>
         <d:NetAmount>956.00</d:NetAmount>
         <d:TaxAmount>181.64</d:TaxAmount>
         <d:DeliveryDate>2018-12-07T23:00:00.0000000</d:DeliveryDate>
         <d:Quantity>1</d:Quantity>
         <d:QuantityUnit>EA</d:QuantityUnit>
        </m:properties>
       </content>
      </entry> 

       

      Author's profile photo Emanuele Ricci
      Emanuele Ricci

      Hi Andre,

      I’ve one more question: How to calculate the TaxAmount and NetAmount?

      The only information I have about the Product is the TaxTarifCode (on the Product metadata) but there’s no way to calculate the amount from that information. How can I do that?

      Author's profile photo Emanuele Ricci
      Emanuele Ricci

      Hi Andre, I've tried to use your same data to create an entry into the

      /sap/opu/odata/IWBEP/GWSAMPLE_BASIC/SalesOrderLineItemSet URL but I still get this error message:
      
      
      {
      	"error": {
      		"code": "CX_SXML_PARSE_ERROR/001560AA0E081DEB8CA398CC1690D406",
      		"message": {
      			"lang": "en",
      			"value": "Error while parsing an XML stream"
      		},
      		"innererror": {
      			"application": {
      				"component_id": "OPU-BSE-SDE",
      				"service_namespace": "/IWBEP/",
      				"service_id": "GWSAMPLE_BASIC",
      				"service_version": "0001"
      			},
      			"transactionid": "B9E0A2A100BE00C0E005BF37BF470302",
      			"timestamp": "20181206153106.8948610",
      			"Error_Resolution": {
      				"SAP_Transaction": "Run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details",
      				"SAP_Note": "See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"
      			},
      			"errordetails": []
      		}
      	}
      }
      
      Do you know I can I solve this issue?
      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I took a look at the error log in ES5.

       

      The payload you used posted is the first one shown below.

      When I changed it to the second rormat shown below it worked.

       

      The difference is that in your payload there are no spaces before and after the colon

      “NoteLanguage”:”EN”,

      “NoteLanguage” : “EN”,

      and you did not use colons for the numbers.

      “TaxAmount”:181.64

      rather than

      “TaxAmount” : “181.64”

       

      Best Regards,

      Andre


      Your payload

      {"SalesOrderID":"0500000000","ProductID":"HT-1000","Note":"EPM DG: SO ID 0500000000 Item 0000000010","NoteLanguage":"EN","CurrencyCode":"USD","GrossAmount":1137.64,"NetAmount":956,"TaxAmount":181.64,"DeliveryDate":"/Date(1544113089733)/","Quantity":1,"QuantityUnit":"EA","__metadata":{"type":"GWSAMPLE_BASIC.SalesOrderLineItem"},"ItemPosition":"0500000000"}

      My changed payload

      {
      "SalesOrderID" : "0500000000",
      "ProductID" : "HT-1000",
      "Note" : "EPM DG: SO ID 0500000000 Item 0000000010",
      "NoteLanguage" : "EN",
      "CurrencyCode" : "USD",
      "GrossAmount" : "1137.64",
      "NetAmount" : "956",
      "TaxAmount" : "181.64",
      "DeliveryDate" : "/Date(1544113089733)/",
      "Quantity" : "1",
      "QuantityUnit" : "EA",
      "__metadata" : {"type":"GWSAMPLE_BASIC.SalesOrderLineItem"},
      "ItemPosition" : "0500000000"
      }
      
      
      Author's profile photo Emanuele Ricci
      Emanuele Ricci

      Hi Andre, I don't get where could be the problem on the Payload spaces. It's JSON compliant and spaces should not be a problem if not a waste of bytes. Anyway, that payload is not generated manually by me but by SAPUI5 framework when I use ODataModel submitChanges method.

      For the TaxAmount part, I'm just converting Edm.Decimal fields into float because I'm respecting the OData $metadata XML manifest. All the amounts and quantity are Edm.Decimal type so my current version should be compliant.

      Isn't it possible to know perfectly which is the specific issue from the log?

       

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      In ES5 I did not find a more detailed error message but I am trying to reproduce the issue in other systems and yes you are right, your JSON is valid.

       

      Author's profile photo Kris Gell
      Kris Gell

      I am trying to create a Project in SEGW in Odata Demo system(ES5). it is not allowing me to create and giving authorization error. is there any solution for this? is there a way to use demo system without creating project?

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      https://answers.sap.com/answers/745695/view.html

      Author's profile photo Viorel N Dragan
      Viorel N Dragan

      Resolved, there are cookies stored on the client which may cause this not to work in a browser.

      It works fine from Postman.

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Thanks for posting the solution of your problem !

      Author's profile photo Jay Malla
      Jay Malla

      Hi Andre,

      It seems like there is an issue with ES5.  I can no longer connect to it as I used to.  Can you please check?

      The destinations that I have in show a ping error: https://sapes5.sapdevcenter.com/sap/opu/odata/IWBEP/GWSAMPLE_BASIC/

      It looks like it was not available since yesterday.

       

      Thanks,

      Jay

       

       

      Author's profile photo Jay Malla
      Jay Malla

      Hi Andre,

      Here are the error screenshots:

      Here is the error trying to ping the destination through my Hana trial account.

      Here is the error opening up the link in Safari

      And here is the error I am getting on my SAP UI5 Hybrid mobile app with the Logon control - this error message is misleading as it it a problem connecting from SAP Cloud Platform mobile services to the ES5 backend.

      Thanks,

      Jay

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      It should be fixed now. The colleagues installed a new certificate. Thank you very much for your detailed error description.

      Regards,

      Andre

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      see my answer below. It has been fixed today.

      Author's profile photo Roman Broich
      Roman Broich

      Hi all.

      I am getting a "CSRF token validation failed" error when trying to execute a POST to this URI:

      https://sapes5.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/BookingCollection

       

      As first step I am doing a GET with the header "X-CSRF-Token": "fetch"

      Then the token X-CSRF-Token get parsed from the response headers and added to the post request headers:

       

      The parsing works, unfortunately I am getting this 403 error:

       

      Seems like I am not the only one facing this issue:
      https://social.msdn.microsoft.com/Forums/en-US/29452ba9-61fa-420b-831a-79ee354f38d4/enable-csrf-token-in-logic-app

       

      Any ideas?

      Many thanks for your support!
      Roman

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Sorry about this inconvenience.

      Yes I know that lots of people are struggling with this and my colleagues are working on a solution.

      But unfortunately I can't tell you yet when this issue will be fixed.

      Best regards,
      Andre

       

      Author's profile photo Roman Broich
      Roman Broich

      Hi Andre,

      many thanks for your quick response and for following up this issue!

      In the meantime I was able to reproduce the required POST request with a plain vanilla HTTP/REST client:

      # @name login

      GET https://sapes5.sapdevcenter.com/sap/opu/odata/iwbep/GWSAMPLE_BASIC/SalesOrderSet(%270500000010%27)/ToBusinessPartner HTTP/1.1

      Authorization: Basic XXX:XXXX

      X-CSRF-Token: fetch

      @authToken = {{login.response.headers.X-CSRF-Token}}

      # @name bookFlight

      POST https://sapes5.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/BookingCollection HTTP/1.1

      Authorization: Basic XXXX:XXXX

      X-CSRF-Token: {{authToken}}

      Content-Type: application/json

      {

      KEYS:VALUES

      }

      Author's profile photo Roman Broich
      Roman Broich

      The issue with Azure Logic Apps got solved by Bartosz Jarkowski :

      https://blogs.sap.com/2019/05/28/your-sap-on-azure-part-18-the-story-of-a-missing-csrf-token/

      Author's profile photo Manjunath Gudisi
      Manjunath Gudisi

      Hi,

      I have a strange issue. Im using Google chrome browser. Open SAPES5 GUI in a tab and open https://sapes5.sapdevcenter.com/sap/opu/odata/sap/SEPMRA_PO_APV/$metadata in a new tab (in the same browser), then it works fine and see the metadata. However, unable to access the same URL in incongnito mode.

      I have also tested it in Postman, it says unauthorized, 401 error.

      I need to test the URL in incongnito mode, then only I can go ahead and create a mobile destination in mobile services cockpit.

      Anyone has any idea how to test the above URL in Postman or incognito mode?

      Thanks, Manju

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      The login client for the ICF node was set to client 000.

      However ES5 uses client 002.

      I changed that and will check why we have this setting and how to activate 002 as the default logon client for OData services.

      Regards,

      Andre

       

      Author's profile photo Manjunath Gudisi
      Manjunath Gudisi

      Hi Andre

      Seems you already have made the necessary settings. I can now access https://sapes5.sapdevcenter.com/sap/opu/odata/sap/SEPMRA_PO_APV/$metadata in both browser (with incognito mode) and Postman without setting of sap-client=002 as a header. Thank you for your quick fix.

      Thanks, Manju

      Author's profile photo Boghyon Hoffmann
      Boghyon Hoffmann

      Hi Andre Fischer

      According to OData reference services (e.g. Northwind), concatenating query values with whitespace after comma is allowed. Not sure if the OData V2 spec actually allows that, but I could see that GW services don’t. Here is an example:

      (the same applies to $expand)

      Unless OData V2 spec explicitly states that there shouldn't be any whitespace in between, it would be nice if the GW sample services could be fixed accordingly so that e.g. $expand and $select work with whitespace after comma.

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I will check this with our colleague that is responsible for the OData specification.

      Best Regards,

      Andre

      Author's profile photo Boghyon Hoffmann
      Boghyon Hoffmann

      Any news? Maybe Ralf Handl could give us a hint..

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      It is a bug and it will be fixed.

      But I can’t tell you when this will be done and when this fix will reach ES5.

      Again thanks for pointing us to this.

      Best Regards,

      Andre

       

      Author's profile photo Boghyon Hoffmann
      Boghyon Hoffmann

      For other readers: according to this comment on GitHub, this bug is fixed.

      The OData V2 spec allows these whitespaces. The colleagues of Gateway have provided a fix for SAP S/4 HANA Cloud 1911.

      @Andre Fischer: Is there a plan to downport the fix to the system serving the current ES5 services?

      Author's profile photo Sijin Chandran
      Sijin Chandran

      At least basic authorizations of viewing already built Gateway Projects should be granted in my opinion. Even SE11 Table content Display authorization is not there 🙁

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Have you tried the property WebIDESystem in capita letters, thus ES5 instead of es5.

      And have you tried to authenticate as P200... instead of p200...

      You can also try to use Basic Authentication for the destination entering your credentials there as I described in my blog.

      Regards,

      Andre

       

      Author's profile photo abhijeet kankani
      abhijeet kankani

      Hi Andre,

       

      Is it possible to expose CDS view  as reference data source for generating odata version 4.

      or Can we use CDS with BOPF also for generating SAP odata version 4 .

       

      Regards

      Abhijeet Kankani

      Author's profile photo Ariel Godoy
      Ariel Godoy

      Hello,

      I'm trying to use the GWSAMPLE_BASIC for a demo, but as you can see here there's only one sales order, and it doesn't have any items, yesterday the same service returned a lot of orders and line items.

      I didn't delete anything so my question is, Is the data shared globally? isn't there some way to freeze a minimum dataset so it can't be deleted?

       

      Kind regards,

      Ariel

      Author's profile photo neha sandeep naik
      neha sandeep naik

      could anyone please let me know ,how to proceed as i'm facing this connection error.

      Author's profile photo Ariel Godoy
      Ariel Godoy

      Hello,

       

      In the GWSAMPLE_BASIC there's a function called RegenerateAllData that we can use to create new orders, however, I couldn't find anything similar in EPM_REF_APPS_PO_APV_SRV

       

      Is there any way to regenerate the data there or create more orders without having to wait for the automatic refresh the next day?

       

      Thanks in advance,

      Ariel

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      No, unfortunately only GWSAMPLE_BASIC has this feature and only for SO's.

      The EPM demo data can however be refreshed using transaction SEPM_DG.

      Best Regards,

      Andre

       

      Author's profile photo Ariel Godoy
      Ariel Godoy

      Hi Andre,

       

      That option works wonders! I saw that we also can set the number of PO to generate, thanks a lot!

       

      Are there other transactions to refresh other services? is that documented somewhere?

       

      Thanks again,

      Ariel

      Author's profile photo Manjunath Gudisi
      Manjunath Gudisi

      Hi Andrew Fisher

      Could you please help me what is the OData service it is calling when I check out in Shop application. I mean, what is the OData service for creating a purchase order?.

      Also, could you please confirm is this the service (/IWBEP/GWSAMPLE_BASIC) to create the salesorder after approving the purchase order?. As per the document, /IWBEP/GWSAMPLE_BASIC is the service to CRUDQ operations for the entity types BusinessPartnerContactProductSalesOrderSalesOrderLineItem. https://help.sap.com/viewer/68bf513362174d54b58cddec28794093/7.51.4/en-US/59283fc4528f486b83b1a58a4f1063c0.html 

      Thanks, Manju

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Manju,

      No, I can't confirm that. /IWBEP/GWSAMPLE_BASIC is a sample service to show the code based implementation of OData V2 services using the SAP Gateway framework.

      As I wrote above these are two OData Service that are used by the SAP Fiori Reference Applications "Shop" and "Approve Purchase Orders".

      Approve Purchase Orders

      A SAP Fiori Reference Application used to demonstrate the approval process
      Oased on the EPM model This is a master-detail applicatiom

      https://sapes5.sapdevcenter.com/sap/opu/odata/sap/EPM_REF_APPS_PO_APV_SRV/$metadata

      Shop

      A SAP Fiori Reference Application used to demonstrate a shopping scenario on the EPM model This is a full screen application.

      https://sapes5.sapdevcenter.com/sap/opu/odata/sap/EPM_REF_APPS_SHOP_SRV/$metadata

       

      Regards,

      Andre

       

      Author's profile photo Manjunath Gudisi
      Manjunath Gudisi

      Thanks for your swift reply Andrew Fisher What about my first question "what is the OData service for creating purchase order".

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      There is a service called SEPMRA_PO_MAN available.

      https://sapes5.sapdevcenter.com/sap/opu/odata/sap/SEPMRA_PO_MAN/?$format=xml&sap-client=002

      when you retrieve a list of purchase orders

      https://sapes5.sapdevcenter.com/sap/opu/odata/sap/SEPMRA_PO_MAN/SEPMRA_C_PO_PurOrd?sap-ds-debug=true&$top=2

      you will se that this service is using draft so you would have to be able to handle draft with your client.

      Regards,

      Andre

       

      Author's profile photo Manjunath Gudisi
      Manjunath Gudisi

      Thank you Andrew Fisher  I will check that

      Author's profile photo JAVIER RUBIO
      JAVIER RUBIO

      Hello Andre,

      I am facing this error when running the sales order project from my hcp trial account pointing to the backend system.

      Can you advice please?

       

      Sorry, a technical error occurred! Please try again later.

      \{ 
      
              "requestUri": "/sap/opu/odata/iwbep/GWSAMPLE_BASIC/$metadata?sap-language=EN", 
      
              "statusCode": 401, 
      
              "statusText": "", 
      
              "headers": [], 
      
              "body": "" 
      
      }
      Author's profile photo Srikanth Vavilala
      Srikanth Vavilala

      Hi All,

      Can someone help me to achieve this, am having an ES5 demo system and i just want to develop a fiori based SalesOrder application in SAP WebIde and can be deployed in Sap Cloud Platform, i just want to use the sample odata service of salesorder which is available in ES5 Demo system, can this service will be suitable for my application "GWSAMPLE_BASIC". Please help me. Thanks

      Author's profile photo Tarig Elomari
      Tarig Elomari

      Hi All,

      GWSAMPLE_BASIC seems to be down at the moment along with that server. Here's the error returned... perhaps it has run out of resources?

      <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <code>DBSQL_SQL_ERROR</code>
      <message>Runtime Error: 'DBSQL_SQL_ERROR'. The OData request processing has been abnormal terminated. If "Runtime Error" is not initial, launch transaction ST22 for details and analysis. Otherwise, launch transaction SM21 for system log analysis.</message>
      <timestamp>20200727165814</timestamp>
      </error>
      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Unfortunately I know that there is an issue with ES5 in general and thus with the service GWSAMPLE_BASIC in particular.

      Colleagues from our IT department are investigating the root cause of this error and I will provide an update once I get feedback if and when this error can be fixed.

       

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      ES5 is back again.

      Author's profile photo Harshit Srivastava
      Harshit Srivastava

      Dear Andre,

       

      I have registered in ES5 system.

      While connecting ES5 system to the local SAP WebIDE getting Service catalog unavailable error below.

       

      Can you please help me how to resolve this error and also I don't have access for /iwfnd/maint_service  t-code while accessing it saying missing authorization 'S_TABU_DIS' failed.

      Please help me.

       

      Regards,

      Harshit

      Author's profile photo Sagar Salyan
      Sagar Salyan

      Nice article, Andre Fischer can you tell me how can can i create tile in the fiori launchpad, i am not able to access Fiori designer URL.

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      You can't access it since no development is allowed on this system.

      You can use the fiori launchpad in your SAP Cloud Platform trial account instead.

      Author's profile photo Sagar Salyan
      Sagar Salyan

      Thanks Andre, can you tell me how to use it in SAP Cloud Platform.

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      https://developers.sap.com/mission.portal-cf.html

      Author's profile photo Sagar Salyan
      Sagar Salyan

      Thanks for sharing

      Author's profile photo Sweta Gohil
      Sweta Gohil

      Hi Experts,

      I am having query what is the difference between ES5 and BTP? do they same ? both are having same features? or whats add on ? what will be in future lead?

      Thanks & Regards.

      Author's profile photo Boghyon Hoffmann
      Boghyon Hoffmann

      Some demo services don't seem to require authentication. E.g.:

      Was this intended? As far as I can remember, we used to have to have an account just for consuming the above services. Can we use those services now publicly without an account from the ES5 server? That would be indeed great, for example, when reporting bugs / issues in client-side OData implementations (e.g. UI5).

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Boghyon,

      yes it is intended that some, but not all services do not require an authentication. They use hardcoded credentials so that it is easy to include the for example as a value help as we did it in the SAP OpenSAP course about the ABAP RESTful Programming Model.

      These services do however only offer read access.

      EPM Demo Sales Orders

      https://sapes5.sapdevcenter.com/sap/opu/odata/sap/ZSOCDS_SRV/?$format=xml

      EPM Demo Products

      https://sapes5.sapdevcenter.com/sap/opu/odata/sap/ZPDCDS_SRV/?$format=xml

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      I checked the system and found that somebody had added hardcoded credentials to the ICF node of GWSAMPLE_BASIC. I removed those.

      It was not intended to add hardcoded credentials for GWSAMPLE_BASIC.

      See also the new section for read-only services in this blog.

      Author's profile photo Jan Schober
      Jan Schober

      Hi all,

       

      has the dataset for https://sapes5.sapdevcenter.com/sap/opu/odata/sap/EPM_REF_APPS_PROD_MAN_SRV changed?

      In the past it was computers and accessories (like Mice, Keyboard, etc) - now it seems to be pens and chairs.

       

      Is this intended? Can I find the old products and categories somewhere?

       

      Thanks and BR,

      Jan

      Author's profile photo Joe Robertson
      Joe Robertson

      Hello all,

      Just to add, we have also noticed the same thing, and this is causing some issues around some of our demonstration assets.

      Be interested to hear whether the old dataset is still available?

      Kind regards,

      Joe

       

      Author's profile photo Miller Lam
      Miller Lam

      Dear Jan Schober,

       

      With T-Code: SE38.

      You can execute program: SEPM_DG_EPM_STD_CHANNEL to create some demo data records.

      Refer to here: EPM Model Data Generation

      🙂

       

      Author's profile photo Jan Schober
      Jan Schober

      Thanks Miller Lam  for the hint.

       

      Unfortunately, it doesn't help if somebody resets the generated data after a couple of hours as again 🙁

      Author's profile photo Mostafa Abd Elmottaleb
      Mostafa Abd Elmottaleb

      Hello,

      Is sap gateway demo system es5 down?

      Author's profile photo Ulrich Becker
      Ulrich Becker

      Hello together,

       

      i never got any registration mail. so i never realized that the account has been activated before trying online and i also do not get any mail when i try to reset password.

      I checked the registered e-mail with exact spelling and it is working.

      I do not have any option to log on without the initial password.

      i did not try yet to delete  and re-register using a private mail address, but i can't imagine that this is the problem.

       

      Thanks for any response.

       

      Uli

       

      p.s.: Aim of registration is to  connected Scenarios from Cloud Foundry trial to a backend , without having to deal with company restricitons.

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Ulrich,

      I don't exactly understand your issue.

      What happens when you click on

      SAP Gateway Demo System - Registration - ES5 (sapdevcenter.com)

      Do you get a message that an account exists or are you offered to register a new one?

      Regards,

      Andre

       

      Author's profile photo Ulrich Becker
      Ulrich Becker

      Hy Andre,

       

      nothing happens . I got a text, taht i would receive a mail, when the account is activated, but i never got one.

      A week later i just check it again and it says, my accoount is active.

      But i do not have any credentials to log on.

      When i use the password reset, the same thing happens again.

      The displayed e-mail adress fro my acocunt is correct, but no e-mail is being sent, or at least not received.

       

      Author's profile photo Ulrich Becker
      Ulrich Becker

      Hello Andre,

      sorry for bothering community.

      The mails have been detected as phishing and the spam notification has reached me very late yesterday.

      I could bot believe , it takes 5 days  to inform me about that...

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Thanks for the update !

      Author's profile photo Rynaldi Maydrian Lauren
      Rynaldi Maydrian Lauren

      Hello Andre,

      sorry if someone else may have asked this question. I am very new in SAP. I've been reading through the community to check if it's actually possible to create an entity in the ES5 demo server, but I couldn't find it. I only see that people are not able to create project in the demo server. But I don't know whether it is the same to create a project and to update or to create an entity.

      I am accessing the ES5 server from ThingWorx. GetProperties operation works fine, but when I want to update certain property of an entity it always throws the error

       Failed to execute service 400 {"error":{"code":"CX_SXML_PARSE_ERROR/001560AA0E081DEB8CA398CC1690D406","message":{"lang":"en","value":"Failed to read property 'Price' at offset '9'"},"innererror":{"application":{"component_id":"OPU-BSE-SDE","service_namespace":"/IWBEP/","service_id":"GWSAMPLE_BASIC","service_version":"0001"},"transactionid":"B9E0A2A100BE0050E0060B2F4803A732","timestamp":"20210622140504.1695040","Error_Resolution":{"SAP_Transaction":"For backend administrators: use ADT feed reader \"SAP Gateway Error Log\" or run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[]}}}

      I am wondering if it's authorization problem or there is something wrong in my ThingWorx. I am performing an update on one of the property of a ProductSet by specifying its ProductID.

      Any help would be appreciated!

      Best regards,

      Rynaldi

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      Hi Rynaldi,

      sorry, I have to correct myself.

      Technically it is possible to create a new product when calling the appropriate OData Service and when you use the appropriate payload.

      There is however a job that deletes and recreates all data on a daily basis.

      When I used the following payload it worked.

      {
        
          "ProductID" : "WD-PC-10AF",
          "TypeCode" : "PR",
          "Category" : "Pencils & Colouring",
          "Name" : "Colour Pencils - Assorted - Pack of 24",
          "NameLanguage" : "EN",
          "Description" : "Hexagonal coloured pencils in 24 vibrant colours; Ultra-resistant lead to prevent breaking; Easy to sharpen Made from 50 per cent recycled material; hardwearing pencils resistant to chewing and splinter-proof.",
          "DescriptionLanguage" : "EN",
          "SupplierID" : "0100000017",
          "SupplierName" : "FamousUS (NY)",
          "TaxTarifCode" : 1,
          "MeasureUnit" : "EA",
          "WeightMeasure" : "0.000",
          "WeightUnit" : "",
          "CurrencyCode" : "USD",
          "Price" : "8.90",
          "Width" : "0.000",
          "Depth" : "0.000",
          "Height" : "0.000",
          "DimUnit" : ""
          
      }

       

       

      Author's profile photo Rynaldi Maydrian Lauren
      Rynaldi Maydrian Lauren

      Hi Andre,

      thank you for the very fast response!

      Okay. That means the only operation we can perform on the sample ES5 service (GWSAMPLE_BASIC) is only reading the query, right?

      Because when I open the link SAP Online Documentation: Sample Service – Basic written on the explanation about the sample service GWSAMPLE_BASIC, I am directed to the page where it says that I can perform CRUDQ operations on the entity type BusinessPartner, Contact, Product, SalesOrder, SalesOrderLineItem. So, I thought I could perform an update on the entity or even create a new entry.

       

      Best regards,

      Rynaldi

      Author's profile photo Andre Fischer
      Andre Fischer
      Blog Post Author

      No it is not for reading alone. See my response above.

      Author's profile photo Rynaldi Maydrian Lauren
      Rynaldi Maydrian Lauren

      Hi Andre,

      Sorry, I didn't see that you edited your reply when I was typing my reply.

      I've tried using the payload you gave, but it still throws the same error

      Failed to execute service 400 {"error":{"code":"CX_SXML_PARSE_ERROR/001560AA0E081DEB8CA398CC1690D406","message":{"lang":"en","value":"Failed to read property 'Price' at offset '433'"},"innererror":{"application":{"component_id":"OPU-BSE-SDE","service_namespace":"/IWBEP/","service_id":"GWSAMPLE_BASIC","service_version":"0001"},"transactionid":"B9E0A2A100BE0060E0060BA140A5AA3B","timestamp":"20210622151056.0863830","Error_Resolution":{"SAP_Transaction":"For backend administrators: use ADT feed reader \"SAP Gateway Error Log\" or run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[]}}}

      It seems like there is an error in reading a number. For instance, when I place "Height" or "Width" before "Price", then it says "Failed to read property 'Height' at .... "

      Author's profile photo Rynaldi Maydrian Lauren
      Rynaldi Maydrian Lauren

      Hi Andre,

      another interesting thing is that I tried just now to put "0.000" for the "Price" and it works. I just realize that in your payload there is another decimal type before "Price" property which is "WeightMeasure" with the value "0.000" that doesn't throw any error. So, I tried to just change the value of "Price" to "0.000" and it works.

      Any idea what the problem is?

      Best regards,

      Rynaldi