sales-orders-union

Extend Sales Orders View V_SALES_ORDERS

1. Navigate to the Repostiory Explorer.

2. Search and open the View V_SALES_ORDERS.
   
   

3. In the Sources select your newly created Open SQL Schema, e.g. ZST_WORKSHOP#SAN and find the tabe T_SPECIAL_SALES_ORDERS.
   
   

4. Drag and drop the table T_SPECIAL_SALES_ORDERS into the canvas on the Filter Node. Select the Union as the operator.
   
   
   
   
   

5. Select the Union node and make sure that all table fields are mapped. Note: the warnings regarding mismatched data types can be ignored in this exercise.
   
   

6. Click on Deploy button to apply the changes.
   
   

7. Select the Output node and click on Data Preview from the context menu. In the results the newly created Sales Order record should be listed.