Create Tables in the Form

Once you have completed the prerequisite mission, your process should look something like below.

1. In the Order Processing process:

   • Choose + after the Get Order Details.

   

   • Select Decision.

   

   • Select Blank Decision.

   

2. A pop up will appear to configure the decision. Enter Order Validity Check as decision name and choose Create.

   

1. Go to the Overview Tab. Choose the Create button. Create an artifact of the type Data Type.

   

2. A new pop-up will appear.

   • Enter Name of the data type: Error Output
   • Enter Description of your choice
   • Choose Create

   

3. In the Data Type Error Output add new fields as following.

   Field Name	Type
   ErrorCode	String
   ErrorDescription	String

   

   

4. Choose Save.

1. Navigate to the Order Processing process.

2. Select the decision Order Validity Check menu option and choose Open Editor.

   

3. Add Input and Output parameters.

   

4. Edit Input and Output parameters as follows.

   Parameter Name	Data Type	Parameter Type	Description
   Input Sales Order	Sales Order	Input	Input Sales Order
   Validity Check Output	Error Output	Output	Validity Check Output

   CAUTION: Select the List checkbox to make the output type as list of Error Output.

   

5. Select the Rules tab. Choose Add Rule.

   

6. Enter Rule Name as Error Check and Rule Description of your choice.

7. For Hit Policy, select All Match.

   What is going on?

   With a First Match hit policy, the rule engine fetches the first occurrence that matches the condition and returns it as the result. On the other hand, with a All Match hit policy, the rule engine fetches all the occurrences that matches the condition and returns them as the result.

8. Choose Next Step.

   

9. In the Configure Conditions section, expand the Input Sales Order parameter.

   

10. For this scenario you will be choosing expectedDeliveryDate, orderAmount, shippingCountry and orderStatus. Choose Next Step.

    

11. In the Configure Results section, enter Validity Check Output (List) in Result Vocabulary. Choose Validity Check Output parameter. Choose Next Step.

    

12. In the Review section, a summary of the rule to be added is displayed. Choose Create.

    

13. Enter Full Screen Mode by clicking on the icon on the top right corner.

    

14. In the Decision Table, add the below mentioned conditions.

    Parameter Name	Condition	Error Code	Error Description
    expectedDeliveryDate	<TODAY()	‘ERR01’	‘Delivery date is before current date’
    orderAmount	>100000	‘ERR02’	‘Fraudulent Request’
    shippingCountry	NOTEXISTSIN [‘India’,‘United Kingdom’]	‘ERR03’	‘Delivery not supported in this country’
    orderStatus	=’'	‘ERR04’	‘Order status is not set’

15. Click on the first column.

    

16. Type <TODAY, and choose TODAY from Array Operators. When finished, click outside the input field to confirm.

    

17. Proceed in the same way for Error Code and Error Description (or Then section):

    

    Remember that for all String type data object attributes, you must add a single quote (’) before and after the text.

18. To add a new row to the decision table:

    • Choose the check-box of the first row
    • Choose Add Row
    • From the dropdown options, select Insert After

    

19. Similarly, enter the above values for the next rows.

20. Choose Save.

    

1. Navigate back to the Order Processing process.

2. Select the Order Validity Check decision and choose Inputs in decision details.

3. Map the input parameters listed in Input Sales Order to the selectedOrder output variables from Get Order Details automation.

4. Choose save.

   

1. In the Overview tab, click the Create dropdown and choose Form.

   

2. In the Create Form popup, enter the form name and choose Create.

   

3. Add a Headline and Paragraph to provide necessary details. Add two Text fields and name them Customer Name and Order Number.

4. Check both Text fields as read only.

   

5. Add a Table with Error Details as title. Mark it as Read Only.

   

6. Choose the + icon in the table and select Text. Enter Error Code as field name.

   

7. Choose the + icon beside Error Code field and select Text.

   

8. Enter Error Description as field name and choose Save.

   

1. In the Order Processing process choose the + sign after the Order Visibility Check decision.

   

2. Choose Controls and Events.

   

3. Select Condition.

   

4. Choose the Open Condition Editor for the new condition.

   

5. In the Edit Branch Condition popup select the list-Validity Check Output parameter.

   

6. Put 0 as value and select Apply.

   

7. In the If branch of the new condition, choose + to add a new artifact.

   

8. Select Form.

   

9. Select Order Rejection Notification With Errors under Available Forms.

   

10. In the General section of form details:

    • Enter as Subject: Order Rejected due to errors
    • Choose Process Started By as users under Recipients

    

11. Under Inputs section, choose Select list and bind list-Validity Check Output to it.

    

12. Choose the Order Number and Customer Name from trigger form to map them with the respective input fields.

    

13. Select the + after Order Rejection Notification with Errors form.

    

14. Choose Controls and Events.

    

15. Choose End.

    

    At the end, your process will look like this.

16. Save your work.

    

1. In the Order Processing process, choose the Release button on the top right corner.

   

2. In the Release Project popup, select Release.

   

3. In the Overview section that appears, choose Deploy.

   

4. Choose the Environment and select Deploy.

   

5. In the Define Variables section, enter the OrderfilePath for the excel file you downloaded in the prerequisites section. Choose Deploy.

   

   Your project is deployed.

   

1. In the Order Processing process, choose the Order Processing Form artifact. On the right panel that appears, select the Copy Link icon next to Form Link field.

   

2. Before executing the process, make sure your desktop agent is in unattended mode. You can refer to the prerequisites to Execute the Process with an Automation.

   

3. In a new tab in your browser, enter the form link. Enter the details required in the form and select Submit.

   

   When you enter the order number in the form, the automation fetches the order details from excel stored in your machine. The details are validated according to the rules in the decision table and the respective errors are shown in a table in the form.

4. In the SAP Build Lobby, choose the Inbox icon on the top right.

   

5. You will get a notification with the error details in a table.

   

This sample project can be downloaded from the SAP Build Store.

To retrieve this sample, please follow these steps:

1. From the SAP Build Lobby, navigate to Store.

2. Search for the sample project: Sales Order Management (MI05).

3. Choose Create from Template to retrieve the sample and save it as a new project in your lobby.

   

4. Choose Create.

   

   Your project gets created in editable version. You may release and deploy it and run the project.

5. Navigate back to the lobby by clicking on the SAP logo.

   

   You can see your project is available in the lobby.