
Data Deletion
Use
Data for completed processes, which is no longer required for further analyses can be deleted from the system without being archived. The following are some areas in which data does not need to be archived.
The volume of data in individual areas indicates the regularity by which you delete data. Allocation, merchandise distribution, POS interface and replenishment are all areas in which a large volume of data is generated, due to the fact that a high number of articles and stores are used.
Features
Deleting Application Data
|
Area |
Data for Deletion |
Transaction |
Program |
Possible to Select Multiple Objects for Deletion |
|
Allocation |
Allocation data |
WA09 |
RWSDEL1T |
X |
|
Merchandise Distribution |
Distribution data |
WF40 |
RCLEANFRET |
X |
|
POS Inbound |
Status information Error messages Document flow |
RWPUDTST ,RWPUDLST, RSWWWIDE |
X |
|
|
POS Outbound |
Assortment list versions Status tables and change pointers |
WBBR ,WDSR |
RWBBVDEL ,RWDPOSRS |
X |
|
Replenishment |
Log data for replenishment runs |
WRDL |
RWRPLDEL |
X |
|
Merchandise Category |
Merchandise category master data |
WG23 |
||
|
Assortments |
Assortment, Assortment modules, Listing conditions, Change documents for |
WSOA4 |
RWARC009, RWSORT53, RWSORT54 |
X X X |
|
Product Catalogs |
Product catalog data |
WWM5 |
||
|
Bonus Buy |
Article groupings |
VBG2 |
Notes:
Deleting Administration Data
The following data should be scheduled for deletion at regular intervals (for more information, see SAP Note 16083). Where possible, use the recommended job names listed in the naming convention. This is particularly useful when checks are run to ascertain whether jobs have already been activated in your system, as it is easier to locate data that has been named correctly.
Program: RSBTCDEL
Reorganized tables: BTC*
Path for accessing files: /usr/sap/SID/SYS/global/<client>JOBLG
Job scheduling: daily (with variants)
Recommended job name: SAP_REORG_JOBS
Program: RSPO0041
Reorganized tables: TSP*
Path for accessing files: /usr/sap/SID/<instance>/data
Job scheduling: daily (with variants)
Recommended job name: SAP_REORG_SPOOL
Program: RSBDCREO
Reorganized tables: BDC* and APQ*
Path for accessing files: /usr/sap/SID/SYS/global
Job scheduling: daily (with variants)
Recommended job name: SAP_REORG_BATCHINPUT
Program: RSBPSTDE
Reorganized tables: BTCJSTAT*
Path for accessing files: not specified
Job scheduling: weekly (with variants)
Recommended job name: SAP_REORG_JOBSTATISTIC
See also:
Deleting Allocation Tables Distribution Processing: Distribution Data Archiving and Deleting Data in the POS Interface Deleting Assortment List Versions Replenishment Monitor