Preface for the Second Edition

15

Target Audience

15

How This Book Is Organized

16

Conclusion

17

Acknowledgments

17

1 SAP MII as an Industry 4.0 Implementation Platform

19

1.1 From Traditional Manufacturing to Industry 4.0

19

1.2 The Need for a Composition and Integration Platform to Enable Industry 4.0

24

1.3 SAP MII as a Manufacturing Integration Platform

27

1.4 SAP MII as a Manufacturing Intelligence and Analytics Platform

29

1.5 SAP OEE Management as a Manufacturing Performance Management Platform

34

1.6 Application Architecture of SAP MII

35

1.7 Use Case Scenario

37

1.8 Summary

38

2 Setting Up SAP MII

39

2.1 Software Components and Installation

39

2.2 Security and SAP NetWeaver AS Java Administration

40

2.2.1 Sizing Determination

40

2.2.2 User Management

42

2.2.3 Logging and Tracing Configuration

44

2.2.4 SAP Java Resource Adapter Configuration

46

2.3 SAP Plant Connectivity Installation

47

2.4 Postinstallation Configurations of SAP MII

53

2.4.1 System Properties in SAP MII

53

2.4.2 Active Sessions

62

2.4.3 Custom Attributes

63

2.4.4 Encryption Configurations

65

2.4.5 Personal Data Manager

66

2.4.6 Content Management Using NWDI

66

2.4.7 Content Transport Using CTS+

77

2.5 Summary

82

3 Managing Data from External Systems

83

3.1 Using SAP Plant Connectivity

83

3.1.1 Source System

84

3.1.2 Destination System

88

3.1.3 Agent Instance

91

3.1.4 Notification

100

3.1.5 Managing Notifications from SAP MII

105

3.2 Connecting to External Systems Using Data Servers

106

3.2.1 Data Server Configuration

108

3.2.2 IP21 Connector

110

3.2.3 IP21OLEDB Connector

110

3.2.4 InSQL Connector

114

3.2.5 InSQLPCo Connector

114

3.2.6 IDBC Connector

115

3.2.7 OLAP Connector

116

3.2.8 Open Connector

117

3.2.9 OLEDB Connector

121

3.2.10 Simulator Connector

122

3.2.11 Virtual Servers

123

3.2.12 XML Connector

126

3.2.13 Xacute Connector

127

3.2.14 PCo Connector

127

3.2.15 SAP MII and SAP HANA Integration Using SAP HANA Smart Data Integration

129

3.3 Data Access

130

3.4 Message Services: Synchronizing the Shop Floor with the Enterprise

131

3.4.1 Process Overview

131

3.4.2 Configuring the Message Listeners

133

3.4.3 Configuring the Processing Rules for Messages

137

3.4.4 Using the Message Monitor

139

3.4.5 Configuring and Using the Message Cleanup Rules

141

3.5 Summary

143

4 Developing Composite Applications

145

4.1 Projects and Configurations

145

4.1.1 Projects

145

4.1.2 Content Usage

146

4.1.3 Configurations

147

4.2 Using the SAP MII Workbench

148

4.2.1 Layout

149

4.2.2 Content Organization and Management

151

4.2.3 Important Menu Items and Functionality

152

4.2.4 SAP MII Content Security

153

4.3 Using Query Templates to Query Data from External Systems

155

4.3.1 Data Source Configuration

157

4.3.2 General Configuration

158

4.3.3 Date Range Configuration

162

4.3.4 Parameters Configuration

166

4.3.5 Transformation Configuration

166

4.4 Types of Query Templates

168

4.4.1 OLAPQuery

168

4.4.2 SQLQuery

170

4.4.3 PCoQuery

175

4.4.4 XMLQuery

181

4.5 Summary

182

5 Manufacturing Data Objects

183

5.1 Types of MDOs and Their Usage

184

5.2 Using an MDO as an Application Data Store

185

5.3 Creating and Configuring MDOs

185

5.4 On-Demand MDO

191

5.5 Joined MDO

191

5.6 MDO Query

194

5.7 OData Modeler

198

5.8 Summary

199

6 Business Logic Service Transactions

201

6.1 Creating a Transaction

201

6.2 Logic, Tracing, and Miscellaneous Functions

209

6.2.1 Logic Action Blocks

209

6.2.2 Miscellaneous Functions Action Blocks

222

6.2.3 Logging Action Blocks

226

6.3 Working with XML

229

6.3.1 SAP MII XML Output Action Blocks

229

6.3.2 XML Functions Action Blocks

236

6.3.3 Reference Documents Action Blocks

256

6.4 Connecting to Enterprise Systems

259

6.4.1 Creating an SAP Server Alias

260

6.4.2 SAP Java Connector Interface Action Blocks

261

6.4.3 SAP Java Resource Adapter Interface Action Blocks

268

6.4.4 XI Action Blocks

271

6.4.5 Web Service Blocks

274

6.4.6 JMS Action Blocks

278

6.4.7 Message Services Action Blocks

281

6.4.8 Manufacturing Dashboards Action Blocks

288

6.5 Managing Plant Data

290

6.5.1 Data Queries Action Blocks

290

6.5.2 SQL Transaction Support Action Blocks

293

6.5.3 Queuing Action Blocks

294

6.5.4 KPIs and Alerts Action Blocks

296

6.6 Charts, Animated Objects, and SQC Analysis

300

6.6.1 Charts Action Blocks

300

6.6.2 Quality Action Blocks

302

6.6.3 Dynamic Graphics Action Blocks

304

6.7 Web, Email, and File Handling

306

6.7.1 Web Action Blocks

306

6.7.2 Email Action Blocks

310

6.7.3 File I/O Action Blocks

312

6.7.4 SFTP Action Blocks

320

6.8 Executing BLS Transactions

321

6.8.1 Xacute Query

321

6.8.2 SOAP Web Service

323

6.8.3 Runner Service

323

6.9 Schedulers

324

6.10 Transaction Manager

327

6.11 Summary

328

7 Visualization Services

329

7.1 i5 Display Templates

329

7.1.1 i5Grid

330

7.1.2 i5Chart

338

7.1.3 i5SPCChart

351

7.1.4 i5ValueHelp

380

7.2 Web Report Development in SAP MII

382

7.2.1 SAPUI5 Application Development using SAP MII

382

7.2.2 Localization in SAPUI5

396

7.2.3 SAP MII Reports

398

7.2.4 Customizing Content for Mobile Devices

400

7.2.5 Localizing Web Content

401

7.3 Self-Service Composition Environment

403

7.3.1 My Dashboards Tab

403

7.3.2 Design Dashboard tab

404

7.3.3 Templates Tab

408

7.3.4 Global Settings

408

7.4 Navigation Services

408

7.5 Summary

411

8 Plant Information Catalog

413

8.1 Configuring the PIC Category and Property Set

414

8.1.1 Category

414

8.1.2 Property Sets

420

8.2 Plant Information Maintenance

426

8.2.1 Groups

427

8.2.2 Tags

431

8.2.3 Other Functions

438

8.3 Linking to an SAP ERP or SAP S/4HANA Source

440

8.3.1 Production Planning

442

8.3.2 Plant Maintenance

442

8.3.3 Assignment from SAP S/4HANA Source

443

8.3.4 Sync PIC Using PIC Scheduler

445

8.4 Linking to the Shop Floor System

447

8.5 Change Management

449

8.5.1 Change List

449

8.5.2 Approval Lists

452

8.6 Accessing PIC through Web Service

454

8.6.1 Plant Information Catalog Service

454

8.6.2 Plant Information Maintenance Services

456

8.6.3 Change Lists Services

462

8.6.4 Property Set Services

463

8.6.5 Accessing Plant Information Web Services from SAP MII Transactions

464

8.7 Catalog Query

466

8.8 Using PIC for Plant Data Collection

468

8.9 User Authorization in Catalog Services

469

8.10 Summary

473

9 Energy Monitoring and Analysis

475

9.1 Production Events

475

9.1.1 Production Event Templates Overview

476

9.1.2 Create Production Event Template

477

9.1.3 Create Production Event

479

9.1.4 Configuration of Production Event Type Scheduler

481

9.2 Key Performance Indicators

481

9.2.1 Creating a KPI

482

9.2.2 Creating a KPI Query

487

9.2.3 KPI Monitor

490

9.2.4 KPI Scheduler

493

9.3 Energy Tariff

495

9.4 Configuring Shift Patterns

497

9.5 Configuring Plant Information Catalog

499

9.6 PIC Analysis Query Report

501

9.7 Summary

504

10 Overall Equipment Effectiveness

505

10.1 SAP OEE Management Overview

506

10.1.1 Component Architecture

506

10.1.2 Formula and Calculations

507

10.1.3 User Role and Authorization

509

10.1.4 Data Model

511

10.2 Post-Installation Configuration of SAP OEE Management

513

10.2.1 SAP S/4HANA Customization for SAP OEE Management

514

10.2.2 SAP S/4HANA Master Data Setup

529

10.2.3 ALE Setup

542

10.2.4 Central Technical Configuration Wizard

550

10.3 ERP Shop Floor Integration for Worker UI

561

10.3.1 Global Configurations

561

10.3.2 Supported Plants

562

10.3.3 Workflow Configurations

563

10.3.4 Transfer Configuration and Master Data and Related Workflows

568

10.3.5 Queue Monitor

571

10.4 General Configuration

572

10.4.1 User Group Assignment

573

10.4.2 Customization Configuration

573

10.4.3 User Group Dashboard Assignment

580

10.4.4 Reason Code Configuration

581

10.4.5 Extension Configuration

582

10.5 Activity Configuration

583

10.5.1 Activity Description and Options

584

10.5.2 Activities

585

10.5.3 Managing Activity

589

10.6 Dashboard Configuration

590

10.6.1 Dashboard Details

590

10.6.2 Dashboard Description

591

10.6.3 Dashboard Buttons

592

10.7 Modify Order Status Description

594

10.8 Data Upload

596

10.8.1 Downtimes

597

10.8.2 Reason Code Assignment to Machine

597

10.8.3 Plant Information Catalog

598

10.9 Scheduled Downtime Maintenance

598

10.10 Order Dispatch

599

10.11 Display SAP S/4HANA Master Data

600

10.12 Audit Log

601

10.13 SAP OEE Management Dashboard

602

10.13.1 Operator Dashboard

602

10.13.2 Plant Monitor Dashboard

622

10.13.3 Line Monitor Dashboard

622

10.14 Application Launchpad

623

10.14.1 Setup and Configuration

624

10.14.2 Goods Issue

625

10.14.3 Goods Receipt

627

10.15 Custom Enhancements

629

10.15.1 Custom Dashboard

630

10.15.2 Custom Extension Development and Configuration

633

10.15.3 SAP_OEE_Integration Action Blocks

635

10.16 Reporting and Analytics

637

10.16.1 Plant-Level Reporting

637

10.16.2 Analytics Using SAP HANA

639

10.16.3 Analytics Using SAP Digital Manufacturing Cloud

640

10.17 Summary

642

A Advanced Techniques for SAP MII Composite Application Development

643

A.1 Creating and Deploying a Custom Action Block

643

A.1.1 Annotations

645

A.1.2 Interfaces

647

A.1.3 Class

648

A.1.4 Deployment

648

A.2 Using XPath Expressions in BLS Transactions

651

A.3 Creating Dynamic Queries Using JavaScript

655

A.4 Executing a BAPI/RFC with a Table as an Input Parameter

657

A.4.1 Solution Overview

657

A.4.2 Solution Walkthrough

658

A.4.3 An Alternative Approach

661

A.5 Using Virtual Servers for Communication among SAP MII Servers

662

A.6 Autobind and Session Variables in SAP MII

664

A.7 Dynamic Data Exchange among SAP MII Web Pages

668

A.7.1 Methods of Passing Variables among Pages

668

A.7.2 SAP MII Session Variables

668

A.7.3 SAP MII Reports

669

A.7.4 Weaving It All Together

670

A.8 Implementing Role-Based Access to SAP MII Web Pages

673

A.9 SAP MII Services: The Power behind SAP MII

674

A.9.1 Data Server Services

675

A.9.2 Admin Service

676

A.9.3 Indexing Service

677

A.9.4 Scheduler Service

678

A.9.5 Statistics Service

679

A.9.6 Transaction Service

680

A.9.7 Transport Service

680

A.9.8 Alert Service

681

A.9.9 Plant Information Maintenance Services

681

A.9.10 Plant Information Catalog Services

682

A.9.11 Message Service

682

A.9.12 Monitoring Service

683

A.9.13 MDO Service

684

A.9.14 SystemInfo Service

685

A.10 Summary

688