Skip to Content
Author's profile photo Jeff Gebo

Gateway Service Builder (SEGW) with a focus on DDIC Importer

SAP NetWeaver Gateway 2.0 SP4 contained the first release of the Gateway Service Builder transaction – SEGW. This transaction will grow going forward. Today you can create service with it by importing DDIC structures or EDMX models, or you can define them by hand. I wanted to create some simple videos to that show this new transaction. The first of these is focusing on the DDIC importer, you can watch it on youtube here:

Let me know what you think about this new transaction – SEGW.

Thanks!

Jeff

Assigned Tags

      24 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Arun Chembra
      Arun Chembra

      Thanks jeff......

      Author's profile photo Former Member
      Former Member

      Hi Jeff,

      I cannot find the service in SAP NetWeaver Gateway server, am I missing something?

      Author's profile photo Syam Babu
      Syam Babu

      Hi Thanh,

      Have implemented new services or planning to consume standared services whatever have in your system.

      Thanks,

      Syam

      Author's profile photo Aliaksandr Shchurko
      Aliaksandr Shchurko

      Thanks !!!!

      Author's profile photo Gustavo Bueno
      Gustavo Bueno

      Hi Jeff,

      Could you please share the source code you paste in method  BANKS_GET_ENTITYSET.

      Thanks.

      Author's profile photo Abhijit Zope
      Abhijit Zope

      Thanks Jeff, for nice demo.

      Author's profile photo Ebinezar Munnangi
      Ebinezar Munnangi

      Hi Jeff,

      Could you please tell me, which component should apply to get this transaction as there are so many components in NW Gateway like Gateway server core, BEP, CBS, CNT.

      SEGW transaction does not exist in our system.

      Author's profile photo Jeff Gebo
      Jeff Gebo
      Blog Post Author

      Yep, component is IW_BEP.

      Cheers,
      Jeff

      Author's profile photo Ebinezar Munnangi
      Ebinezar Munnangi

      Thank you Jeff.....

      Author's profile photo Former Member
      Former Member

      This is great.  Thanks Jeff.  Could you please share the source code you paste in methods like BANKS_GET_ENTITYSET?

      Author's profile photo Former Member
      Former Member

      May be this code will helps you Joanna.

      DATA: LS_KEY_TAB LIKE LINE OF IT_KEY_TAB,

               LV_MAKE  TYPE ZCTC_MAKER,

               LT_TAB TYPE ZCTC_MODEL_LIST, "its my table

               LS_TAB LIKE LINE OF LT_TAB,

               LS_ENTITYSET TYPE ZCL_ZGW_CTC_VEHICLE_MPC=>TS_F4_MODEL.  " ZCL_ZGW_CTC_VEHICLE_MPC is class TS_F4_MODEL in structure.

         LOOP AT IT_KEY_TAB INTO LS_KEY_TAB.

           CASE LS_KEY_TAB-NAME.

             WHEN 'MAKE'.                               

               LV_MAKE = LS_KEY_TAB-VALUE.

           ENDCASE.

         ENDLOOP.

         IF LV_MAKE IS NOT INITIAL.

          Select <F1>

                     <F2>

           Into table LT_TAB

           Where   MAKE  = LV_MAKE.

         IF LT_TAB[] IS NOT INITIAL.

           LOOP AT LT_TAB INTO LS_TAB.

             LS_ENTITYSET-MAKE = LV_MAKE.

             LS_ENTITYSET-MODEL = LS_TAB-MODEL.

             LS_ENTITYSET-MODEL_CODE = LS_TAB-MODEL_CODE.

             APPEND LS_ENTITYSET TO ET_ENTITYSET.

           ENDLOOP.

         ENDIF.

         ENDIF.

      I have used Association

      Capture.PNG

      Entity Set - F4_Mode

      http://akshath.corp.aks.com:8000/sap/opu/odata/sap/ZGW_CTC_VEHICLE_SRV/F4_Mode(MAKE='Audi')/F4_Mod

      F4_Mode is my entity set Make is input field and F4_Mod is my association set.

      Jeff used filter and he has declared internal table type /iwep/s_mgw_select_option.

      Capture2.PNG

      Author's profile photo Former Member
      Former Member

      Hi Akshath,

      Thanks a lot for your reply.  That helps.


      Regards,

      Joanna

      Author's profile photo Former Member
      Former Member

      This was a great help

      Author's profile photo Former Member
      Former Member

      Thanks Jeff..Nice blog and nice explanation.

      If you have link or video blog for Create, delete and update operations please share with us.

      Reg,

      Akshath

      Author's profile photo Trond Stroemme
      Trond Stroemme

      Nice blog. Quick question: How does my gateway service "know" whether to invoke the get_entityset or the get_entity method? I didn't see you make any kind of relation between them and the service name... nor put anything specific in the URL?

      Regards,

      Trond

      Author's profile photo Chandrashekhar Mahajan
      Chandrashekhar Mahajan

      Hi,

      Allow me to answer. Based on URL, gateway service knows if it is call for get_entityset or get_entity method. May be you want to look at my blog Let’s code CRUDQ and Function Import operations in OData service! where I explained about query and read operations.

      Regards,

      Chandra

      Author's profile photo Trond Stroemme
      Trond Stroemme

      Thanks Chandra - just what I needed!

      Author's profile photo Former Member
      Former Member

      hi, someone can help me?

      I followed step by step this guide

      Step-by-step guide to build an OData Service based on RFCs – Part 2

      , but it does not work, the service when I call SalesOrderCollection or SalesOrderItemCollection gives me an error like this:

      Immagine.JPG

      Author's profile photo Former Member
      Former Member

      Nice demo Jeff,  This is very helpful.

      Chad

      Author's profile photo Former Member
      Former Member

      Jeff,

      Great demo, can you share the code you added, as that the missing piece.

      Thanks

      Martin

      Author's profile photo YUNUS KALDIRIM
      YUNUS KALDIRIM

      Thanks Jeff. Very well sample 🙂

      Author's profile photo Former Member
      Former Member

      The SEGW comes with netweaver stack 7.40 and works like a champ.  Really good for odata access for backend system.  🙂

      Author's profile photo Former Member
      Former Member

      Hi Jeff,

      Thanks I could replicate the project.However,at the end when the data is returned they are in reverse sequence.!?

      I mean my ztable has fields sequence field1 ,field2 but when output i see field2,field1.

      Will you please let me know,where i went wrong?

      Thanks  in advance

      Lakshmi

      Author's profile photo Former Member
      Former Member

      Transaction is a real horror.  It does not met the quality standard i am used in former times by SAP.
      + documentation most in english and not translated.

      + no Version control

      + no step back in case some thing is deleted.

      + using F4 help to choose Entries also inactive Entries will be shown, but if they are choosen the value vanish without some massages ...

      That is only the tip of the iceberg