Skip to Content
Author's profile photo Selvakumar Shanmugam

SAPUI5 CRUD Master-Detail Application with MII OData Modeller and Web IDE


This is a step by step guide to create a simple SAPUI5 CRUD Master Detail Application using SAP Web IDE  and SAP MII OData Modeller.


  • SAP MII 15.1 SP03 (OData Modeller is a new feature available from MII 15.1 SP03 )
  • SAP HANA Cloud Connector
  • Trial Account in SAP HANA Cloud Platfrom


Step 1 : Create OData (2.0) Service using MII OData Modeller

OData Modeller helps in exposing Manufacturing Data Objects (MDO) as OData 2.0 compliant services.

Create Sample MDO

Let’s create following sample MDO in MII, which can be exposed as OData Services.

Persistent MDO : Material

Attribute Data Type Key
MaterialID String(50) X
Quantity Integer
UOM String(10)



Create Entity in OData Modeller

  • Open OData Modeller from MII Menu under Content Development.
  • Click on Create Button.
  • Provide Entity Name Field as Material.
  • Select MDO Material(Created in the Step above).
  • OData Modeller will show all the available attributes under Properties.
  • Click on Save Button.

Enter the below mentioned URL in Browser to test MII OData Service



Step 2 : Configure SAP MII as Destination in HANA Cloud Platform 

Install and Configure HANA Cloud Connector

Install SAP HANA Cloud Connector by following > SAP HANA Cloud Connector > Installing the Cloud Connector

and Configure the same by following > SAP HANA Cloud Connector > Configuring the Cloud Connector

Once HANA Cloud Connector is installed and Configured, Follow the below steps to Map SAP MII to HANA Cloud Platform

  • Login to HANA Cloud Connector and Navigate to Access Control.
  • Click on Add Button under Mapping Virtual to Internal System.
  • Select SAP Application Server Java.

  • Click Next Button.
  • Select relevant protocol and Click on Next Button.
  • Enter MII Hostname and Port Number.

  • Press Next Button until Finish and Click on Finish.
  • Select the Line Item added and Click on Add Button under Resources Accessible.

  • Enter URL Path as “/” and click on Save Button.
  • Now the State will change to Green in both the Tables as shown below.

Create Destination in HANA Cloud Platform 

Follow the below steps to create Destination in HANA Cloud Platform

  • Login to your HANA Cloud Platform Cockpit.
  • Navigate to Connectivity > Destination.
  • Click on New Destination and provide details as in the below screen shot.

  • Provide URL as your MII System URL (http://<MII-Server>:<Port>/).
  • Provide MII User and Password.
  • Click on Save.


Step 3 : Create CRUD Master-Detail Application using Web IDE

Follow the below steps to create simple CRUD Master-Detail Application in Web IDE

  • Open Web IDE, select Workspace > Right Click > New > Project from Template.
  • Change Category as All Categories.
  • Select CRUD Master Detail Application.

  • Click Next
  • Provide below mentioned details and click on Next

  • Select Service URL and Select System as MIINEW (Created in Step 2)
  • Enter Relative URL as “/XMII/MIIODataV2/” and click on Test. Entity Material will be visible under MIIODataV2 as shown below

  • Select Material and Click on Next.
  • Select details as mentioned below and click on Next

  • Click Finish, A new Project with Name Material will be created in Workspace.
  • Select Project and Select App in FLP Sandbox near Run Button.
  • Click on Run to test the Project.


  • Click + Button to Add Material.
  • On click of Save data will be saved to MII MDO.


The Steps above will help in creating a simple SAPUI5 CRUD Master-Detail Application in Hana Cloud Platform using MII OData Modeller.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ravi Pandey
      Ravi Pandey

      Good Initiative, Selva.


      Author's profile photo Former Member
      Former Member

      Very helpful blog. Thanks so much for posting it.

      Author's profile photo Felipe Andahur
      Felipe Andahur

      Hi selva,

      I have a question. How i can add a property to object before this method oModel.submitChanges();

      I need to save user create.

      OBJECT.USERCREATE = sap.ushell.Container.getService("UserInfo").getId();

      I work in CreateEntity.Controller becouse i cannot to do in the view

      Please help,


      Author's profile photo Xianshuai Dai
      Xianshuai Dai


      I have a question,when I create odata modeller in XMII , but I can only select MDO for persistence, It can't select other type MDO or data source provider, ex,SQL Query.