Deleting Master Data

Description

This program deletes master data in Financial Accounting and is designed for preparing the system for productive startup. It deletes:

Customer master data

Vendor master data

G/L account master data

You can run this program in three different ways:

1. Deleting general master data (in G/L accounts in one chart of accounts)

2. Deleting master data dependent on company code

3. Deleting general master data and master data dependent on company code

For each deletion run, you can specify whether or not the system should take into account the deletion flag in master records ("Delete per deletion flag only"). If it takes into account deletion flags, it uses the following standard logic:

Option 1: The "All areas" deletion flag must be set.

Option 2: The "Specified co. code" deletion flag must be set.

Option 3: It is sufficient to have the "All areas" deletion flag set.

Note: Deletion blocks are always checked at general data and company code-dependent data level. If there is a block at company code-dependent data level, then the general data is not deleted either. The deletion block takes precedence over the deletion flag.

General master data in Financial Accounting can also be used in other SAP applications:

Customer master data in Sales and Distribution

Vendor master data in Purchasing

G/L accounts as primary cost elements in Cost Accounting

The program deletes the following:

Change documents for master data

SAPscript text files

The following data is deleted for customers:

General master data

Bank details

VAT registration numbers

Addresses

Classifications

Credit management: across control areas

Credit management: centrally

Unloading points

Tax indicators

Contact persons

Licenses

Partner function limit

Shipping data

Master data in the company code

Dunning data

Linked data

The following data is deleted for vendors:

General master data

Bank details

Contact persons

VAT registration numbers

Addresses

Classifications

Master data in the company code

Dunning data

Linked data

The following data is deleted for G/L accounts:

General master data in the chart of accounts

Names in the chart of accounts

Key word list in the chart of accounts

Master data in the company code

Sample accounts, if selected

For customer and vendor contact persons, the addresses are not determined from central address management until the actual runtime. Therefore differences can arise as to the number of addresses in the detail log between the test run and the update run.

Automatic worklists for customers and vendors are also deleted with the general master data. Matchcodes are always deleted.

You may have to fix the number ranges after the program run.

The system makes changes to the database in the update run only. It will then also write a system log entry for documentation.

Requirement

General master data can only be deleted if no other application makes reference to the account. Use the resetting programs from

Sales and Distribution (customer master data)

Purchasing (vendor master data)

Cost Accounting (G/L account master data)

If you want to delete only general master data, master data dependent on company code cannot have been created in Financial Accounting.

If you want to delete master data in a test company code, master data dependent on company code cannot have been created in any other company code except the test company code. The productive indicator cannot be set for the company code.

If a customer or vendor is referenced by another customer or vendor (for example, via fiscal address or alternative payee), you can only delete the referenced master record by deleting the referencing master record at the same time.

Furthermore, you can only delete master data in Financial Accounting if no transactions have been posted to the corresponding accounts. If there are transaction figures in one of the selected accounts, you have to manually access and run program SAPF020 (reset transaction data from a company code) before you can delete that account.

Output

The log lists every table which is processed in the program selection.

You can also create a detail log for each account type to find out why certain data cannot be deleted. The detail logs show you what other company codes and applications use the data and how customers and vendors are linked to one another.

Note

Since deleting or displaying even smaller volumes of data can result in runtime problems, you should run this program as a background job. Currently, the program individually deletes matchcodes for each master record in the database. Several match code IDs refer to each matchcode. This can place a considerable load on the database.

You cannot delete transaction data in individual accounts.
Important: The archiving programs in Financial Accounting are designed for the productive system.

If you are running this deletion program for the first time, then you must start program SAPF047 before deletion in order to generate link information.