Kontakt

Ansicht
Dokumentation

SAPF019 - Deleting Master Data

SAPF019 - Deleting Master Data

BAL Application Log Documentation   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

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.

Requirements

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.






BAL_S_LOG - Application Log: Log header data   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 7859 Date: 20240531 Time: 173622     sap01-206 ( 89 ms )