Transporting Table Records From Dev to Qua by Workbench request

Business Scenario: Need to transport some table records from development system to the Test System. Here three cases are considered. Case 1. If there is no TMG for the table, how to transport the records. Case 2. In there is a  TMG for the table is present then how to transport the records. Case 3. Directly from SE09 adding the records to the workbench request.
Case 1.
Step1. Go to SE11.

Step2. Provide the  table name name 'ZSTUDENT_DET1'  and click on display button.

Step3. Some of the table entries are already created without the TMG. Click on the Display contents button.

Step4. The table contains 4 records.

Step5. Select the the records need to transport to the Quality system. Here we have selected all the records and from the menu Table Entry click on Transport Entries.

Step6. Click on Create button to create a New Request.

Step7. Provide the description and click on the SAVE button.

Step8. The Request is created and click on Continue button.

Step9. Now go to SE10.

Step10. Click on the display button and provide the Request number created above.

Step11. Double click on the Task under the request.

Step12. One entry is created Under the Task. Click On the KEY under the Function column.

Step13. The mandt and the primary value of the records are populated here. Now click on the Contents button.

Step14. Select the radio button as highlighted and click on Continue button.

Step15. All the Non primary filed values also added to the task under the created request.

______________________________________________________________________________

Case 2: Creating the table and then creating the table TMG and adding the records and then transporting the records from Dev system to Quality system.

Step1. The table ZSTUDENT_DET2 is created with following fields and activated.

Step2. Create the TMG by following the highlighted path.

Step3. Provide the details and select the radio button as highlighted and Save it. Go Back.

Step4. Create some table records.

Step5. Click on New Entries button.

Step6. Provide some values and save it and go back.

Step7. Click on the contents button.

Step8. It shows the above created values.

Step9. Select the records & from the menu Table Entry the TRANSPORT ENTRIES button is deactivated as there is a TMG created for the table.

Step10. Go to SM30.

Step11. Provide the table name and click on Maintain button.

Step12. Select the records and From the menu Table view select Transport.

Step13. Provide the Request Number and click on continue button.

Step14. Select teh Button Include In Request.

Step15. Go to SE09 and display the request and double  click on the Task under the request.

Step16. Click on the Key button under the Function column.

Step17. The primary field values and displayed here and click on Contents button.

Step18. Select the highlighted radio button and click on continue button.

Step19. The non primary key fields are also added to the request.

______________________________________________________________________________

Case3: Directly from SE09 adding table records to the Request.

Step1. Go to tcode- SE09.

Step2. Click on the create button.

Step3. Select the Workbench request & click on continue button.

Step4. Provide the short text and click on save button.

Step5. Double click on the request number.

Step6. Click on the change button.

Step7. A new editable line appears.

Step8. Provide the details like: ProgramID: R3TR, Object type- TABU and Object name: SCARR(here we are transporting data from scarr table) and click on the key button.

Step9. The below screen appears.

Step10. Provide the client (200) and the key field value of the table SCARR and then clcik on the contents button.

Step11. Select the highlighted radio button and click on Continue button.

Step12. The non primary key fields of the added key fields also included in the request.

Step13. Save it and from the pop up click on Yes.

Step14. Now the records are added to the request to be transported to the Quality system.

_______________________________________________________________________________

Web Service creation and consuming it In SAP ABAP

Business Scenario: Creating a function module. Creation of  Service Definition from function module and creation of service consumer to consume the Service Definition.
                             
Step1. Go to Tcode- SE80 to create a Function group.

Step2. Select the Function Group and Provide the function Group name and hit the Enter button.

Step3 Provide short description and click on SAVE button.

Step4. Navigate along the highlighted path to create a function module.

Step5. Provide the Function module name, description and click on SAVE button.

Step6. Provide the importing parameters.

Step7. Provide the exporting parameters .

Step8. Provide below code to add two numbers and activate the function  module.

Step9. Navigate along the highlighted path to create Enterprise Service.

Step10. Provide the Service Name and description and click  on continue button.

Step11. Click on continue button.

Step12.  Click on continue button.

Step13. Select the highlighted values and Click on continue button.

Step14. Select as local object and Click on continue button.

Step15. Click on Complete button to finish the Service definition creation.

Step16. Activate the service definition 'ZWS_ADDITION'.

Step17. Go to the Internal View tab to see the details.

Step18. To create the binding for the service definition go to the Tcode- SOAMANAGER.

Step19. Click on WEB SERVICE Configuration under Service Administration.

Step20. From the Search tab, Select Service Definition and provide the service definition name 'ZWS_ADDITION' and click on Go button.

Step21. Select the Service definition and click on Apply Selection button as highlighted.

Step22. Go to Configuration tab to create the Binding.

Step23. Click on Create Button.

Step24. From the Pop up Modify the Service Name, description and Binding Name if needed and click on apply settings button.

Step25. Select the below highlighted buttons and Save it.

Step26. Now the binding is Active and click on Overview Tab.

Step27. Click on 'Open WSDL document for selected binding or service'.

Step28. The WSDL of the Service definition is displayed in a new browser window.

Step29. Now click on 'Show/Hide selected Binding or Service's WSDL URL' to display the web service definition URL. Copy the URL to be used later.

Step30. Now the Service definition is created with WSDL and URL. Go to Tcode- SE80 to create the Service Consumer.

Step31. Select the package and navigate along the highlighted path.

Step32. Select the Service Consumer button and click on Continue Button.

Step33. Select External WSDl and click on Continue Button.

Step34. Select the URL button and Click on Continue button.

Step35. Provide the URL generated in the Service Definition creation time and click on Continue button.

Step36. Select the Local Object and Provide the Prefix name and click on Continue button.

Step37. Click on COMPLETE button.

Step38. Provide the USER credentials and click on OK button.

Step39. The Proxy name 'ZCLCO_ZWS_ADDITION' is generated with is a class. Now Activate the Service Consume 'ZWS_ADDITION'.

Step40. Now double click on the Proxy Name 'ZCLCO_ZWS_ADDITION'.

Step41. The Function module now appears as a method of the class. Double click on the importing parameter type and exporting parameter type as highlighted.

Step42.  The Input Structure.

Step43.  The output Structure.

Step44. Now go to Tcode- SOAMANAGER to create a logical port for the service consumer.

Step45. Select WEB SERVICE Configuration under Service Administration tab.

Step46. From the search tab, select Consumer Proxy and provide the Consumer proxy name and click on go button.

Step47. Select the Consumer Proxy and click on Apply Selection button as highlighted.

Step48. Click on Configuration Tab.

Step49. Click on the Create button.

Step50. Provide a logical port name, description. Provide the Service Definition URL and user details and click on Apply Settings button.

Step51. Select the Binding created in the Service definition phase and click on Apply settings button.

Step52. Provide the User details and Save the Port 'ZADD_PORT'.

Step53. Now the port 'ZADD_PORT' is active.

Step54. Now click on Overview tab to see the details.

Step55. Now go to the service consumer and click on Execute button to consume the Service.

Step56. From the appearing screen provide the above created port 'ZADD_PORT' and click on  execute button.

Step57. Thee value of NUM1 = 1 and NUM2 = 2. Click on Execute button.

Step58. The result is 3.

Step59. Go back and again click on the Execute Button. To change the Input values click on the highlighted button.

Step60. Change the input number values and click on execute button.

Step61. The result appears as shown below.

Step62. Lets create a report program to call the web service to consume it.. So go to Tcode- SE38.

Step63. Provide the below code and activate and execute it. Instantiate the class ZCLCO_ZWS_ADDITION' and call the method 'ZNUM_ADD' .

Step64. The Result as follows:

______________________________________________________________________________