Data Management Guide

Best-Practice Document

Data Management Guide for

SAP Business Suite

Version 6.7

Dietmar-Hopp-Allee 16

D-69190 Walldorf

DATE July 2014

SAP PRODUCT(S)

Generic

OPERATING SYSTEM(S)

All

ALM PHASE(S)

Run

SAP SOLUTION MANAGER 7.1 SP

Generic

PRODUCT VERSION(S)

Independent

DATABASE(S)

All

SAP SOLUTION MANAGER WORK CENTER(S)

Data Volume Management

© 2014 SAP SE or an SAP affiliate company – DM_Guide_67_final_bestpractice style.docx

Best-Practice Document

Data Management Guide for SAP Business Suite

Table of Contents

1 Management Summary/Introduction

1.1 Motivation

1.2 Contact SAP

1.3 SAP Data Volume Management (DVM)

1.4 Data Volume Management Guide for SAP Banking Services 6.0

1.5 SAP Information Lifecycle Management (SAP ILM)

1.6 Examples of Data Growth in SAP Systems

1.6.1 Retail

1.6.2 Consumer Products

2 Goal of Using this Best-Practice Document

3 Which Tables Are Examined?

4 Best-Practice Document: Housekeeping

4.1 Housekeeping for Background Jobs

4.1.1 Administration Data for Background Jobs

4.1.2 Print Parameters for Background Jobs

4.1.3 Runtime Statistics for Background Jobs

4.1.4 Consistency Check for Administration Tables of Background Jobs

4.1.5 Orphaned Temporary Variants in Table VARI

4.2 Housekeeping for Spool Data

4.2.1 Spool Data and Administration Data for Spool Jobs

4.2.2 Spool Data Consistency Check

4.2.3 Orphaned ADS Spool Files

4.3 Orphaned Job Logs

4.4 TemSe: File System Against TST01

4.5 Administration Data for Batch Input

4.6 ABAP Short Dumps

4.7 External Job Scheduling Tools

4.8 Checking Database Indexes

4.9 Housekeeping for SAP CRM

4.9.1 SAP CRM Inactive Products

4.9.2 CRM Middleware Tables

4.10 Housekeeping for SAP Solution Manager (BW Housekeeping for Diagnostics)

4.11 Housekeeping for SAP BW Systems

4.12 Housekeeping for SAP EWM Systems

5 Best-Practice Document: Detailed Table-Specific Information

5.1 SAP NetWeaver

5.1.1 ADQUINDX: Business Addresses INDX

5.1.2 APQD,...