SAP MII - Question Shop floor solution based on NetWeaver database

[Former Member]

Hello,

We have built a MES shop floor solution (LP.MES) on basis of SAP MII 14 and applet-based screens. To store our internal records (e.g. master data, production orders, confirmations, …) we use a separate Microsoft SQL database server (independent of the SAP NetWeaver database) connected to the NetWeaver (Java Stack) via JDBC.

Currently we are migrating our solution to MII 15 and UI5-based screens. At the same moment we are planning to use the underlying NetWeaver database (like Sybase, Oracle, MaxDB, Hana, …) instead of using a separate Microsoft SQL database server.

My question is: What are the possibilities to use the underlying NetWeaver database?

I only know this so far from the ERP NetWeaver (ABAP Stack) to use the ABAP repository as a mid-layer where I can create transparent tables, which are then stored indirectly on the underlying NetWeaver database. When I understood correctly, there is also a mid-layer in Java for table definition available.

What is the best practice approach to do this in the MII NetWeaver (Java Stack)? It  would be very appreciated to get some information about where and how tables can be defined and how the tables can be addressed in queries and selects. My understanding is, if we can address the underlying NetWeaver database directly via the NetWeaver itself, we do not need to care about the different database dialects, is this correct?

As a second question I need to know, if this is (besides the technical feasibility) possible to use the database for 3^rd party solutions according to the SAP license model?

Thanks a lot in advance and best regards

Sebastian Rothe

[salvatore_castro]

Sebastian,

For MII 15.0 & 15.1 (GA today) this will run on any OS/DB combination that NetWeaver supports.  MII 15.0 requires NetWeaver 7.4 and MII 15.1 uses NetWeaver 7.5.  The details for the OS/DB combinations is outlined here in the SAP PAM (http://support.sap.com/pam) and search for NetWeaver 7.5 (or 7.4 if you’re using MII 15.0) and be sure to select “Application Server Java” from the drop down list.

As for your second question around DB development this is up to your SAP Contract so the SAP account team will have to provide an answer on this as I do not know what you’re licensed for.  I can however tell you that SAP MII MDO development will work regardless of the DB license you have and here’s the difference between DB & MDO development:

Hope this helps,

Sam