Show TOC

Function documentationJoined MDO

 

You use this function to display a consolidated result from multiple MDO tables. You can select attributes from multiple MDOs, define a JOIN condition and display the results.

Note Note

Only persistent MDO objects can be used to create a new joined MDO.

End of the note.

Features

The Joined MDO supports INNER JOIN and LEFT OUTER JOINs between the MDOs.

A database view will be created for every joined MDO with actual MDO tables and columns. You have to define at least one condition for every JOIN. A Joined MDO consists of the following tabs:

  • Data Source:

    You have to select a connector from a list of MDO connectors that is configured in the system.

  • Attributes:

    You can select the attributes from different MDOs and specify JOIN conditions between the MDOs. You can also specify the Where clause in the definition. Following are the available screens in this tab:

    • Available Objects: Displays a list of all the persistent MDOs available in the selected MDO connector.

    • Selected Objects: You can select the MDOs from the Available Objects column. You can add, delete, replace, and change the hierarchy of the MDOs in this column.

    • Available Attributes: Displays all the attributes for the selected MDO in the Available Objects column.

    • Selected Attributes: You can select the attributes from the Available Attributes column. You can add, delete and change the hierarchy of the attributes.

  • Join Expression:

    You can create join conditions for the selected MDOs.

  • Filter Expression:

    You can define filter expressions for fetching the attributes.

  • Layout:

    Displays the graphical view of the joins between the MDO objects. This screen reflects any changes done on the Attribute tab.

  • Visualization:

    For more information, see MDO Visualization.

  • Security:

    For more information, see Manufacturing Data Object.

Activities

  1. On the SAP MII Workbench, choose Start of the navigation path File Next navigation step New Next navigation step Joined MDO. End of the navigation path

    The DataSource screen appears.

  2. From the Template Categories tab, choose Attributes.

    A screen with all the Available Objects and attributes of persistent and Join MDOs appear.

  3. Add the tables from the Available Objects column to Selected Objects column.

  4. Add the selected attributes from the Available Attributes to Selected Attributes.

  5. Click the Join Expression column with secondary mouse button and choose Add.

  6. Choose the attributes from the drop-down list of Table column and type from the Join Type column.

  7. To add conditions to the join, select a row from the Join Expression tab.

  8. Click the conditions table with the secondary mouse button and select Add.

  9. Choose the list of attributes of the selected MDOs from the Columns and the operators from the Operators column.

Note Note

You can enter the filter, sort and group expressions manually.

End of the note.

To delete a row from the join table, select a row and click the Joins table with the secondary mouse button. Choose Delete. The row along with the conditions will be deleted.