Skip to Content

Connect Action Project to Dropdown in Form

Use and add a data source to the form dropdown field in order to display information from external systems
You will learn
  • How to use action project to retrieve data from data source and show in dropdown in form
aviral-agarwal-sapAviral AgarwalApril 29, 2024
Created by
aviral-agarwal-sap
April 7, 2023
Contributors
celineaudinsap
aviral-agarwal-sap

In this tutorial, you will create a project using a template from the store and edit the trigger form to create a dropdown and populate it with the values from the action project.

  • Step 1
    1. From the SAP Build lobby, select the Store tab.

      Import Project
    2. On the Store page, search for Sales Order Management (MI01) and once it loads, click Create from Template.

      Import Project
    3. In the Project Name field, enter Sales Order Approvals Project.

      You can keep the default description or enter the description of your choice

      • Click Create.
      Import Project
    4. Open Lobby and you will see your project created.

    5. Click on the Sales Order Approvals Project to open it.

      Import Project

    Where can you find the project template?

  • Step 2
    1. Select the Order Processing Form.

      Action Project
    2. Select the menu for the Customer Name text field and select Delete.

      Action Project

      You will now replace the text field with a dropdown field.

    3. Drag and drop a Dropdown field in the form and enter the name as Customer Name.

    4. Check the required box on the right side panel.

    5. Choose save.

      Action Project
  • Step 3
    1. Select the Settings icon at the top-right corner.

      Action Project
    2. In the Project Properties pop-up, select Environment Variables and choose + Create.

      Action Project
    3. Fill in the information:

      • Enter S4_Business_Partner as identifier.
      • Enter Description of your choice.
      • Select the Type as Destination.
      • Choose Create.
      Action Project
    4. Once the environment variable is created, close the pop-up.

      Action Project
  • Step 4
    1. Select the Customer Name dropdown.

    2. As Data to display, choose Data Source.

    3. Select the value-help option for Data Source field.

      Action Project
    4. In the Browse Library pop-up, choose GET as Action Type.

    5. Select the Add option for the action project you created earlier.

      Action Project

      CAUTION: The action project will only be visible in the Browse Library pop-up if the Main Output Array is marked in the action response as described in previous tutorial.

    6. Select the S4_Business_Partner as the Destination Variable and select the value-help option for Available Data field.

      Action Project
    7. Choose the Customer Name option from the dropdown.

      Action Project
    8. Save the form.

      Action Project

      With this, you have created a form with dropdown as input field and connected your action project to the dropdown.

    Will the action project be visible in Browse Library popup in the Form Editor if the Main Output Array is not specified in the results output parameter of Action Project?

Back to top