SAP MII (eBook)

Suman Mukherjee has around 7 years of IT experience with specialization in SAP manufacturing domain. He is currently working under Cognizant Technology Solutions as Technical Lead in SAP Manufacturing Business Unit. He worked on many high quality global manufacturing solutions by defining the architecture design and managing the deliverables by leading the team for custom SAP MII, MEINT and OEE applications. He worked as a technical reviewer for a SAP OEE book. He is actively involved in SCN SAP MII/OEE articles, discussions and has authored several technical blogs. He has been recognized as SCN Topic Leader for SAP MII. Previously he worked with IBM India Pvt. Ltd and Infosys India Limited. He has a Bachelor of Technology in Electronics & Instrumentation Engineering.Saptaparna Mukherjee (Das) is associated with Cognizant Technology Solutions as a SAP MII Subject Matter Expert and Business Analyst in the Engineering Manufacturing Business Unit. She has around 7 years of IT experience with specializations in several SAP domains. She worked on several manufacturing implementaion projects and proposals involving SAP MII, SAP OEE, SAP MEINT and SAP ECC and managing the deliverables by leading the team in onsite-offshore role. She contributed in SCN for several technical discussions, forums and blogs. Previously, she worked with L&T Infotech Solutions. She has a Bachelor of Engineering in Computer Technology from Nagpur University.

Chapter 01: SAPMII Overview

Chapter length: 27 pages

 

Topics covered:

 

1.      Concept of Manufacturing

2.      Revolution in Manufacturing

3.      Manufacturing Processes

Ø Types of manufacturing

·        Discrete manufacturing

·        Process manufacturing

4.      Filling the gap in manufacturing

5.      History of SAP MII (Manufacturing Integration and Intelligence)

6.      Glimpse of SAP MII

Ø SAP MII  Architecture

7.      SAP MII System Overview

Ø SAP MII Installation

8.      Architecture of the UME9.      Data Access

10.  Encryption Configuration

11.  Credential Store

12.  Illuminator Services

13.  SAP MII Admin Configuration

Ø System Management

·        System Properties

·        System Jobs

·        Transaction Manager

·        Log Viewer

·        Scheduler

·        Active Sessions

·        Custom Attributes

·        Custom Attributes Mapping

·        Configurations

·        Projects

·        Localization

Summary

 

Chapter 2: Why to use MII-in Manufacturing Industries

Chapter length: 29 pages

 

Topics covered:

 

1.      Why to use SAPMII?

2.      Key Challenges & Solutions in Manufacturing Industries

Ø  Competitive market and lower manufacturing costs

Ø  Preference of Lean Supply Chain Strategy

Ø  Disparate Manufacturing Plant Systems

Ø  Business and Financial Impact of Production Issues

Ø  Lack of Control and Monitoring Mechanism for Production

Ø  Lack in decision making process to meet production level targets

Ø  Copies of Master Data leading to Quality and Compliance Issues

3.      Functional Aspects of SAP MII

Ø  Availability of SAP MII Product

Ø  Integration Benefit

Ø  Infrastructure Benefit

Ø  Intelligence Benefit

Ø  Innovation Benefit

Ø  Flexibility Across Plant Level Machineries

Ø  Easy to Use with Other SAP Manufacturing Products

Ø  Integration as per industry standards

Ø  Statistical and Other Mathematical Analyses

Ø  Capability of Predictive Analyses

4.      Technical Advantages of SAP MII

Ø  Easy Coding Standard

Ø  Flexibility with XML language

Ø  High End Advanced Business Logic Services

Ø  Compliant with International Standard for Integration

Ø

Ø  Easy to Configure and Flexible Solution

Ø  Flexibility to communicate to any legacy system

Ø  Flexibility to communicate with any Plant Level Device

Ø  Compatibility of Connection to Files in Shared Network

Ø  Service Exposure to NetWeaver Stack

Ø  High-end Visualization Capability

Ø  Capability to Support Web service

Ø  Provision of Flexibility for Language Support

Ø  Support for Analytics with Graphical Representation

Ø  Easy Debugging Techniques

Ø  Alert and KPI Framework

Ø  Internal Data Storage Capability

5.      Business Perspective

Ø  Lower Cost for Server Setup and Installation

Ø  Low Risk to Business

Ø  Provision of Vast Scalability throughout Applications

Ø  Improved Efficiency

Ø  Low Total Cost for Ownership

Ø  Customization

Ø  Smaller Project Team

Ø  Unified User Maintenance in NetWeaver

Ø  Multilayer Security as per Customer Requirement

Ø  Better utilization of Human resource

Ø  Guaranteed Message Delivery

Ø  Provision of Local Survivability

Ø  Single-User Interface for Manufacturing Employees

6.      BI/BW Vs MII Vs PI

Ø  What is SAP BI/BW?

Ø  When to use BI/BW?

Ø  What is SAP PI?

Ø  When to use PI?

Ø  What is SAP MII?

Ø  When to use MII?

7.      BI or PI or MII: Which One to Use

Summary

 

Chapter 3: Basics of SAP MII

Chapter length: 37 pages

 

Topics covered:

 

1.      Data Services

Ø  Data servers

Ø  Creating a connector

·         MDO Connector

·         IDBC (SQL/Oracle) Connector

·         PCo Connector

·         UDC (OLEDB) Connector

·         XML Connector

·         Xacute Connector

Ø  Connections

Ø  Connection Status

Ø  Shared Memory

2.      Message service

Ø  Message listeners

Ø  Message Processing Rules

Ø  Message Clean Up Rules

Ø  Message Monitor

3.      Message Services: Quality of Services

4.      Content Development

Ø  NWDI Configuration

Ø  Workbench

·         Business Logic Services (BLS)

·         Query Template

·         MDO Object

5.      Visualization Service

6.      Animated Graphics

Ø Self Service Composition Environnent

Summary

 

Chapter 04: Implementation of SAP MII in the Discrete Manufacturing Industries

Chapter length: 10 pages

 

Topics covered:

 

1.      Industries with Discrete Manufacturing

Ø  Automobile

·         Requirement of SAP MII in Automobile industries

·         Achieving the Solution with SAP MII

Ø  Aviation& Defense Airspace

·         Requirement of SAP MII in Aviation Industries

·         Achieving the Solution with SAP MII

Ø  Power Generation& Mining

·         Requirement of SAP MII in Power Generation & Mining

·         Achieving the solution with SAP MI

Summary

 

Chapter 5: Implementation in Process Manufacturing

Chapter length: 12 pages

 

Topics covered:

 

1.      Process Manufacturing

2.      Oil and Gas Manufacturing

Ø Oil Upstream

·         Requirement of SAP MII in Oil Upstream

·         Solution with SAP MII

Ø Oil Downstream

·         Requirement of SAP MII in Oil Downstream

·         Solutions with SAP MII

3.      CPG Manufacturing

Ø  Raw material loading and weighing

Ø  Preparation of base material

Ø  Preparation of molds

Ø  Filling the material

Ø  De-lensing/separation process

Ø  Packaging the products

Ø  Final Boxing

Ø  Quality Control

Ø  Requirement of SAP MII in CPG

Ø  Solution with SAP MII

4.      Pharmaceutical Manufacturing

Ø  Molding Process

Ø  Finishing Process

Ø  Lens manufacturing in modernized integrated process

Ø  Quality control

Ø  Requirement of SAP MII in Pharmaceutical Industries

Ø  Solution with SAP MII

Summary

 

Chapter 6: Integration with SAP MII

Chapter length: 70 pages

 

Topics covered:

 

1.      Integration of SAP MII with Databases

Ø  Data Servers

Ø  Query Templates

Ø  Configuring SQL Query Templates

Ø  URL Format for Queries

·         MDO Query

·         Configuring MDO Query

·         PCo Query

·         Configuring PCo Query

·         XML Query

·         Xacute Query

2.      Integration of SAP MII using Business Logic Services

Ø  What is Business Logic Services?

Ø  How to create a BLS?

Ø  Common Action Blocks

·         Logic

·         Logging

·         SAP MII XML output

·         Data Queries

3.      Integration of SAP MII with ERP (SAP ECC)

Ø  Why do we need ERP (SAP ECC) in Manufacturing Industry?

Ø  How to integrate SAP ECC with shop-floor?

Ø  Integrating SAP MII with SAP ECC

·         Integration of SAP ECC and MII using IDoc

·         Integration of SAP ECC and MII using RFCs(BAPI)

4.      Integration of SAP MII with SMTP server

5.      Integration of SAP MII with web protocols

Ø  Web Service Action Block

Ø  HTTP Post Action Block

6.      Integration of SAP MII with file systems

Ø  Get File List Action Block

Ø  Write File Action Block

Ø Create FTP Connection

7.      Integration of SAP MII with other Manufacturing products

8.      What is Workflow?

9.      Configuration of Workflow

Summary

 

Chapter 7: New Features of SAP MII

Chapter length: 117 pages

 

Topics covered:

 

1.      MDO - What is it?

2.      Why MDO?

3.      Details of MDO and how it works

Ø  Persistent MDO

Ø  On Demand MDO

Ø  Joined MDO

4.      How to create MDO?

Ø  Persistent MDO creation

·         Data provider

·         Attributes

·         Lifecycle

·         Security

Ø  On Demand MDO creation

Ø  Joined MDO creation

·         Data Source

·         Attributes

·         Layout

·         Security

5.      Limitations of MDO

6.      Visualization Services

Ø  Dynamic Page Generator

·         iGrid

·         iTicker

·         iChart

·         iSPCChart

·         iBrowser

·         iCommand

·         iCalendar

·         i5Grid

·         i5Chart

·         i5SPCChart



Ø  Animated Objects

7.      SAP UI5

Ø  SAP UI5 Data Binding

Ø  Data Binding Model Types

8.      SSCE

9.      Key Performance Indicator

Ø  KPI Framework

·         KPI Definition

Ø  Type of KPI

Ø  Base KPI

·         Base KPI Configuration

Ø  Composite KPI

Ø  Composite KPI Configuration

10.  Data Consumption and Monitoring

Ø  KPI Query

Ø  Configure KPI Query

Ø  KPI Monitor Page

Ø  Use of Alerts in KPIs

11.  PIC – Plant Information Catalog

Ø  Advantages of PIC

12.  Create PIC Hierarchy in SAP MII

Ø  Consume PIC Hierarchy

13.  PIC Web Services

Ø  Ø  Catalog Admin Service

Ø  Change List Service

Ø  Property Set Service

14.  PCO –What is SAP Plant Connectivity (PCo)?

15.  Why PCo?

16.  History of PCo

Ø  Integration with Automation System

Ø  Machine Data Connection

Ø  What is OPC?

Ø  Destination System Configuration

Ø  Notification Processing Event Configuration

Ø  Integrating Excel with SAP MII using SAP PCo

Ø  Managing Notifications from MII Menu page

Ø  Manage Notification by PIC

Ø  Browse Notification

17.  Sessioning in Queries & JRA

Ø  SQL Transaction Begin

Ø  SQL Transaction Commit

Ø  SQL Transaction Rollback

Ø  SQL Transaction END

18.  SAP JRA (Java Resource Adapter)

19.  SAP JCo (SAP Java Connector)

20.  New action blocks from SAP 15.X

Summary

 

Chapter 8: Best Practices and FAQs

Chapter length: 8 pages

 

Topics covered:

 

1.      Best Practices

Ø  Project Handling

Ø  Project Folder Structure

Ø  Naming Convention

Ø  Development

2.      FAQs – Frequently Asked Questions

Summary