Preface

13

Target Audience

13

How to Read This Book

14

How This Book Is Organized

14

Acknowledgments

17

1 Introduction

19

1.1 SAP Real-Time Replication Tools

20

1.2 SAP LT Replication Server Technical Functionality

21

1.3 Architecture

23

1.4 Replication Scenarios

24

1.4.1 ABAP to ABAP Scenario

24

1.4.2 ABAP/Non-ABAP to SAP BW Scenario

25

1.4.3 ABAP/Non-ABAP to SAP S/4HANA Scenario (Central Finance)

26

1.4.4 ABAP/Non-ABAP to SAP Data Services Scenario

27

1.4.5 ABAP to SAP Data Intelligence Cloud Scenario

27

1.5 Sizing Considerations

28

1.6 Deployment Options

30

1.7 Installation

32

1.8 SAP LT Replication Server: Multisupport System

33

1.9 Features

35

1.9.1 Email Notifications

35

1.9.2 Replication Logging

36

1.9.3 Archival Features

37

1.10 Use Cases

37

1.10.1 Data Migration

37

1.10.2 Data Consolidation

43

1.10.3 Real-Time Reporting

44

1.11 Summary

47

2 Loading and Replication to SAP HANA

49

2.1 Architecture

50

2.2 Overview of Replication Process

51

2.3 Authorizations

52

2.4 Configuring Replication Process

54

2.4.1 Creating SAP LT Replication Server Configuration

54

2.4.2 Triggering Table Load and Replication

57

2.5 Managing Outages When Replicating Data

63

2.5.1 Source System Is Down

64

2.5.2 SAP LT Replication Server Is Down

65

2.5.3 Target SAP HANA System Is Down

65

2.6 Summary

65

3 Loading and Replication to SAP BW or SAP BW/4HANA

67

3.1 Architecture

69

3.2 Overview of the Replication Process

70

3.3 Authorizations

73

3.4 Configuring the Replication Process

74

3.4.1 Creating a Configuration in SAP LT Replication Server

75

3.4.2 Activating ODP Usage for SAP LT Replication Server

78

3.4.3 Creating a Logical System in SAP BW

79

3.4.4 Creating Transfer Objects in SAP BW

80

3.4.5 Creating an Advanced DataStore Object

83

3.5 Managing Outages When Replicating Data

89

3.5.1 Source System Is Down

90

3.5.2 SAP LT Replication Server Is Down

91

3.5.3 Target System Is Down

91

3.6 Summary

92

4 Loading and Replication to Central Finance and SAP S/4HANA

93

4.1 Architecture

94

4.2 Authorizations

97

4.3 Configuring Replication Process

98

4.3.1 Creating the SAP LT Replication Server Configuration

98

4.3.2 Creating Predefined Migration Objects

101

4.3.3 Triggering Table Load and Replication

106

4.4 Managing Outages When Replicating Data

112

4.4.1 Source System Is Down

113

4.4.2 SAP LT Replication Server Is Down

114

4.4.3 Target SAP S/4HANA System Is Down

114

4.5 Summary

115

5 Loading and Replication to Cloud Applications

117

5.1 Using SAP Data Services

118

5.1.1 Architecture

120

5.1.2 Overview of the Replication Process

121

5.1.3 Authorizations

123

5.1.4 Configuring the Replication Process

124

5.1.5 Managing Outages When Replicating Data

143

5.2 Using SAP Data Intelligence Cloud

144

5.2.1 Architecture

146

5.2.2 Overview of the Replication Process

147

5.2.3 Authorizations

149

5.2.4 Configuring the Replication Process

151

5.2.5 Managing Outages When Replicating Data

166

5.3 Summary

168

6 Scheduled Downtime: Recovery Procedures

169

6.1 SAP Source System Undergoing Upgrade Process

170

6.1.1 Initial Steps

170

6.1.2 Drop the SAP LT Replication Server Triggers in the Source System

172

6.1.3 Recreate the SAP LT Replication Server Triggers

175

6.1.4 Compare the Structure and Resolve Inconsistencies

178

6.1.5 Final Steps

179

6.2 DMIS Upgrade in Source System and SAP LT Replication Server

181

6.2.1 Initial Steps

181

6.2.2 Drop the SAP LT Replication Server Triggers in the Source System

183

6.2.3 Recreate the SAP LT Replication Server Triggers

186

6.2.4 Compare the Structure and Resolve Inconsistencies

188

6.2.5 Final Steps

190

6.3 Target SAP HANA System Undergoing Patch Upgrade

192

6.3.1 Initial Steps

193

6.3.2 Connection Test

194

6.3.3 Final Steps

197

6.4 Source System Undergoing Database Migration

198

6.4.1 Initial Steps

198

6.4.2 Drop the SAP LT Replication Server Logging Tables in the Source System

200

6.4.3 Recreate the SAP LT Replication Server Triggers and Logging Tables

201

6.4.4 Final Steps

203

6.5 Source Transition from On-Premise to Private Cloud

204

6.6 Switch Replications from One SAP LT Replication Server System to Another

208

6.7 Summary

211

7 Security

213

7.1 User Management

213

7.1.1 SAP LT Replication Server

214

7.1.2 ABAP Source System

214

7.1.3 Non-ABAP Source System

215

7.2 Authorization Objects

215

7.2.1 S_DMIS

216

7.2.2 S_DMC_S_R

218

7.2.3 S_DMIS_SLT

219

7.2.4 S_DMIS_MOM

219

7.2.5 S_DHCDCACT

220

7.2.6 S_DHBASACT

221

7.2.7 S_DHCDCCDS

222

7.2.8 S_DHCDCTAB

224

7.2.9 S_DHCDCSTP

224

7.2.10 S_DMISIUCA

225

7.3 Roles and Privileges

226

7.3.1 User Roles for SAP LT Replication Server

227

7.3.2 User Roles for ABAP Source System

228

7.3.3 User Roles for Non-ABAP Source System

230

7.3.4 User Roles for ABAP Targets

231

7.3.5 User Roles for the SAP HANA Target System

232

7.3.6 Limiting Access in Source System

239

7.4 Network and Communication Security

243

7.4.1 Configuring Access to ABAP Source Systems

244

7.4.2 Configuring Access to Non-ABAP Source System

245

7.4.3 Configuring Access to Target SAP HANA System

245

7.5 Summary

246

8 Performance Optimization

249

8.1 Optimizing Initial Data Loads

249

8.1.1 Preparation Activities

251

8.1.2 Reading Types

251

8.1.3 Parallelization Job Settings

264

8.1.4 Filter Unwanted Data

265

8.1.5 Planning the Initial Load

267

8.2 Performing and Optimizing Data Replication

267

8.2.1 Options for Logging Tables

268

8.2.2 Generic Ranges and Range Conditions

270

8.2.3 Filter Conditions

274

8.3 Subscription-Based Change Data Capture

275

8.4 Summary

275

9 Transformations

277

9.1 Type Mapping

277

9.1.1 Data Type Handling for Source and Target System

278

9.1.2 Global Mapping Values

283

9.1.3 Mapping Values for Table

284

9.2 Rule Assignment

286

9.2.1 Field-Based Rules

286

9.2.2 Event-Based Rules

288

9.2.3 Filter Rules

290

9.3 Summary

291

10 Monitoring

293

10.1 Email Notifications

294

10.2 Health Checks

299

10.3 Using SAP Solution Manager

301

10.4 Summary

304

11 Troubleshooting

305

11.1 Resolving Common Replication Errors

305

11.1.1 Duplicate Key Issue

305

11.1.2 Cannot Replicate Data from Table XXX, Different Trigger Option Exists

306

11.1.3 Table Does Not Exist or Unknown

307

11.1.4 Communication Issue

307

11.1.5 Cannot Create Logging Table /1CADMC/XXXX; Table Exists with Different Structure

308

11.2 Resolving Structural Inconsistencies between Source and Target

308

11.3 Transactions for Troubleshooting

309

11.4 Summary

310