1 SAP HANA, SAP ERP, and SAP S/4HANA

21

1.1 What Is SAP ERP on SAP HANA?

23

1.1.1 Software

24

1.1.2 Hardware

25

1.2 What Is SAP S/4HANA?

26

1.3 SAP HANA and the Relational Database Management System

28

1.4 In-Memory Database versus Caching

30

1.5 SAP HANA Architecture Options

32

1.6 Summary

37

2 Establishing Project Scope

39

2.1 Upgrade and Migration Dependencies

40

2.1.1 Enhancement Packages

40

2.1.2 Support Packages

44

2.1.3 Add-On Compatibility

49

2.1.4 Non-Unicode versus Unicode

52

2.1.5 Upgrade Dependency Analyzer

59

2.2 Landscape Planning

60

2.2.1 Connected Systems Questions

61

2.2.2 System Strategy

62

2.3 SAP Solution Manager Tools for Establishing Scope

70

2.3.1 Solution Documentation

70

2.3.2 Scope and Effort Analyzer

88

2.4 Resource Planning

105

2.4.1 Project Team

106

2.4.2 Training Plan

110

2.5 SAP Best Practices

114

2.6 Summary

117

3 Infrastructure Planning

119

3.1 Enqueue Server

120

3.2 Dual Stack Split

125

3.3 Sizing

139

3.3.1 Ballpark Sizing

140

3.3.2 SAP Sizing Report for SAP Business Suite on SAP HANA

141

3.3.3 SAP Quick Sizer

144

3.4 Backup and Recovery

150

3.4.1 Backups

151

3.4.2 Recovery

155

3.5 Summary

161

4 Security Planning

163

4.1 Risk-Based Approach

164

4.2 Initial Security Implementation

165

4.2.1 Infrastructure Security

166

4.2.2 Security Configuration

167

4.2.3 Encryption

169

4.3 Application Security

171

4.3.1 Common ABAP Vulnerabilities

171

4.3.2 Recommendations for Managing Application Security

173

4.4 User Security

173

4.4.1 Access Control

173

4.4.2 Authentication

178

4.4.3 Endpoint Security

180

4.5 Ongoing Security Management

181

4.5.1 Vulnerability and Patch Management

181

4.5.2 Tracking and Monitoring Security Activity

182

4.6 Summary

183

5 Migration Tools and Options

187

5.1 Migration Tools

188

5.1.1 Maintenance Optimizer

189

5.1.2 Maintenance Planner

203

5.1.3 Software Update Manager

210

5.1.4 Software Provisioning Manager

225

5.1.5 Benchmark Migration

237

5.1.6 Table Comparison

247

5.1.7 Generating a Migration Key

257

5.2 Migration Options

260

5.2.1 Software Update Manager with Database Migration Option

261

5.2.2 Update with Software Update Manager and then Migrate with Software Provisioning Manager

265

5.3 Summary

269

6 Migration Using the Software Update Manager with the Database Migration Option

271

6.1 Prerequisites

271

6.2 Executing the Software Update Manager with Database Migration Option

272

6.3 Postprocessing

295

6.4 Troubleshooting and Tips

305

6.5 Summary

307

7 Migration Using the Software Provisioning Manager

309

7.1 Prerequisites

310

7.1.1 Preparing the Source System

311

7.1.2 Preparing the Target System

322

7.2 Preparation

324

7.2.1 Export Preparation

325

7.2.2 Table Splitting Preparation

328

7.3 Execution

331

7.3.1 Database Export: Source System

332

7.3.2 System Import: Target System

345

7.4 Troubleshooting

366

7.5 Summary

367

8 Test and Change Management Strategy

371

8.1 Regression Test Strategy

372

8.1.1 Software Provisioning Manager

374

8.1.2 Software Update Manager

377

8.2 SAP Solution Manager Business Process Change Analysis

377

8.2.1 Prerequisites

378

8.2.2 Executing the Business Process Change Analyzer

393

8.3 SAP Solution Manager Testing Tools

395

8.3.1 Test Option 1: Test Workbench

396

8.3.2 Test Option 1: Test Automation Framework

408

8.3.3 Test Option 2: Integration between HP Application Lifecycle Management and SAP Solution Manager

412

8.3.4 Test Option 3: IBM Rational

415

8.4 Change Management with SAP Solution Manager

417

8.4.1 Change Request Management

418

8.4.2 Quality Gate Management

422

8.4.3 Retrofit

424

8.5 Summary

428

9 Proactive Monitoring

431

9.1 SAP HANA Studio

432

9.2 SAP HANA Cockpit

440

9.3 SAP Database Control Center

447

9.4 SAP Solution Manager Technical Operations

451

9.4.1 Accessing Technical Monitoring

453

9.4.2 Accessing SAP EarlyWatch Reports

460

9.5 SAP Database Administration Cockpit

462

9.6 Summary

467

10 Cutover Planning

469

10.1 Building Cutover Plans

470

10.1.1 Migration Tasks

471

10.1.2 Rollback Plan

473

10.1.3 Communication Plan

474

10.1.4 Planning for Business Downtime

476

10.2 Cutover Support Resources

477

10.2.1 SAP Enterprise Support Services

478

10.3 Summary

481

11 ABAP Optimizations

485

11.1 Noncompliant Code

486

11.1.1 Finding SELECT without ORDER BY

486

11.1.2 Finding Native SQL Statements

492

11.2 Optimization Opportunities

496

11.2.1 Workload Monitor

496

11.2.2 SAP Workload Analysis

499

11.2.3 Database Administration Cockpit

502

11.3 Summary

503

12 SAP Business Suite Optimization

505

12.1 Technical Check

506

12.2 Functional Enhancements

510

12.2.1 Finance

511

12.2.2 Materials Management

512

12.2.3 Sales and Distribution

515

12.3 Enhancement Discovery

516

12.4 Summary

518

13 SAP S/4HANA Finance

521

13.1 Why SAP S/4HANA Finance?

522

13.2 Requirements

524

13.2.1 Functional Requirements

525

13.2.2 Technical Prerequisites

526

13.3 Installation

529

13.3.1 Maintenance Planner

529

13.3.2 Running Software Update Manager

534

13.4 Summary

545

14 SAP HANA Live

547

14.1 Installing SAP HANA Live Content

549

14.1.1 Prerequisites

550

14.1.2 Installation

554

14.1.3 Validating Installation

557

14.2 SAP HANA Live Explorer

559

14.3 SAP HANA Live Authorization Assistant

561

14.4 SAP HANA Live Extension Assistant

564

14.5 Summary

567

Appendices

569

A Project Documents

571

A.1 Project Charter

571

A.2 Communication Plan

578

A.3 Risk Plan

580

A.4 Cutover Plan

581

B Glossary

583

C The Author

587