{"type":"doc","content":[{"type":"paragraph","content":[{"text":"This article demonstrates how to prepare an OData Service in SAP and use it as a Data Source in Excel. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Procedure","type":"text"}]},{"type":"paragraph","content":[{"text":"In this example, we will create an OData Service based on an existing application called ","type":"text"},{"text":"IQX_IM_CER","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[49.0]},"content":[{"type":"paragraph","content":[{"text":"Step 1","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[711.0]},"content":[{"type":"paragraph","content":[{"text":"In the backend system, create a Structure in transaction ","type":"text"},{"text":"SE11 ","type":"text","marks":[{"type":"em"}]},{"text":"based on the fields that you would like to display from the application’s Data Model.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":768,"id":"8874fb86-e402-4816-b734-42b023b87a4a","collection":"contentId-1373962390","type":"file","height":502}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[49.0]},"content":[{"type":"paragraph","content":[{"text":"Step 2","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[711.0]},"content":[{"type":"paragraph","content":[{"text":"In the backend system, create a Project in transaction ","type":"text"},{"text":"SEGW","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":476,"id":"1a9b9c1c-861b-4f5e-bc2d-ad59410a00cf","collection":"contentId-1373962390","type":"file","height":320}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[49.0]},"content":[{"type":"paragraph","content":[{"text":"Step 3","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[711.0]},"content":[{"type":"paragraph","content":[{"text":"Create an Entity Type by right-clicking on ","type":"text"},{"text":"Entity Types","type":"text","marks":[{"type":"em"}]},{"text":" > ","type":"text"},{"text":"Create","type":"text","marks":[{"type":"em"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":449,"id":"1f34493e-5e89-4f07-bc1d-45819ced211e","collection":"contentId-1373962390","type":"file","height":214}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[49.0]},"content":[{"type":"paragraph","content":[{"text":"Step 4","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[711.0]},"content":[{"type":"paragraph","content":[{"text":"Define the ","type":"text"},{"text":"ABAP Structure Type Name","type":"text","marks":[{"type":"em"}]},{"text":" of the Entity Set using the structure created in ","type":"text"},{"text":"Step 1.","type":"text","marks":[{"type":"em"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":682,"id":"82ad80eb-180d-4027-a54f-e6ff24d8936a","collection":"contentId-1373962390","type":"file","height":73}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[49.0]},"content":[{"type":"paragraph","content":[{"text":"Step 5","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[711.0]},"content":[{"type":"paragraph","content":[{"text":"Import the fields from the structure by right-clicking on the name of the ","type":"text"},{"text":"Entity Type","type":"text","marks":[{"type":"em"}]},{"text":" > ","type":"text"},{"text":"Import ","type":"text","marks":[{"type":"em"}]},{"text":"> ","type":"text"},{"text":"Properties","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"In the Wizard, select all the fields that you would like to import and define the ","type":"text"},{"text":"Key","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":400,"id":"db23e324-78c9-48ad-904d-129aaf992e78","collection":"contentId-1373962390","type":"file","height":466}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[49.0]},"content":[{"type":"paragraph","content":[{"text":"Step 6","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[711.0]},"content":[{"type":"paragraph","content":[{"text":"Click the button ","type":"text"},{"text":"Generate Runtime Objects ","type":"text","marks":[{"type":"em"}]},{"text":"to generate the Implementation Class.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":30,"id":"06c0adc3-fe43-49b3-b04a-b7e8bcb60289","collection":"contentId-1373962390","type":"file","height":28}}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"width":838,"id":"9a5fabdb-3313-4683-a249-89637c045fb5","collection":"contentId-1373962390","type":"file","height":157}}]},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"align-start","width":58.0},"content":[{"type":"media","attrs":{"width":1010,"id":"b27e701b-ad03-4c15-af6f-726da74d2438","collection":"contentId-1373962390","type":"file","height":179}}]},{"type":"paragraph","content":[{"text":"Take note the names of the ","type":"text"},{"text":"Data Provider Extension Class, Method Name ","type":"text","marks":[{"type":"em"}]},{"text":"for the GetEntitySet (Query), and the ","type":"text"},{"text":"Registered Service","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[49.0]},"content":[{"type":"paragraph","content":[{"text":"Step 7","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[711.0]},"content":[{"type":"paragraph","content":[{"text":"Redefine the ","type":"text"},{"text":"Method ","type":"text","marks":[{"type":"em"}]},{"text":"in transaction SE24 or SE80. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Sample code:","type":"text"}]},{"type":"codeBlock","content":[{"text":" METHOD requestset_get_entityset.\n\n DATA:\n lv_formname TYPE /iqx/form_name,\n lv_where TYPE string,\n lt_inst TYPE STANDARD TABLE OF /iqx/formhd_inst,\n ls_inst LIKE LINE OF lt_inst,\n lt_data TYPE /iqx/forms_instance_data_tt,\n lt_related_data TYPE /iqx/forms_related_data_tt,\n ls_data TYPE zcl_iqx_im_cer=>t_data,\n lo_data TYPE REF TO data,\n lr_data TYPE REF TO zcl_iqx_im_cer=>t_data,\n lo_assist TYPE REF TO /iqx/cl_forms_assist.\n\n FIELD-SYMBOLS TYPE any.\n\n lv_formname = 'IQX_IM_CER'.\n\n\n SELECT * FROM /iqx/formhd_inst INTO TABLE lt_inst WHERE zform_name = lv_formname AND deleted = space.\n\n\n LOOP AT lt_inst INTO ls_inst.\n CLEAR: lo_assist, ls_data.\n\n CREATE OBJECT lo_assist.\n\n CALL METHOD lo_assist->read_form_data\n EXPORTING\n iv_form_name = lv_formname\n iv_instance = ls_inst-zinstance\n IMPORTING\n er_data = lo_data\n EXCEPTIONS\n no_authorization = 1\n no_instance_data = 2\n OTHERS = 3.\n\n CHECK sy-subrc = 0.\n ASSIGN lo_data->* TO .\n MOVE-CORRESPONDING TO ls_data .\n\n APPEND INITIAL LINE TO et_entityset ASSIGNING FIELD-SYMBOL().\n -req_id = ls_data-zdocumentnumber.\n\n -current_status = ls_data-currentstatus.\n -proj_name = ls_data-summary-projectname.\n -grand_total = ls_data-header-grandtotal.\n -company_code_currency = ls_data-summary-companycodecurrency.\n -inv_reason = ls_data-summary-investmentreason.\n -inv_reason_desc = ls_data-summary-investmentreasondescription.\n -asset_cat = ls_data-summary-assetcategory.\n -asset_cat_desc = ls_data-summary-assetcategorydescription.\n -fund_cat_desc = ls_data-summary-fundingcategorydescription.\n -total_budget_used = ls_data-summary-totalbudgetused.\n -expected_start = ls_data-summary-expectedstart.\n -expected_capitalization = ls_data-summary-expectedcapitalization.\n -fiscal_year = ls_data-summary-fiscalyear.\n\n ENDLOOP.\n\n SORT et_entityset BY expected_start DESCENDING.\n\n ENDMETHOD.","type":"text"}]}]}]}]},{"type":"paragraph"}],"version":1}

Browser not supported