SAP Note 409267 - Removing classification system objects w/o assignment

Component : Specification Management -

Solution : https://service.sap.com/sap/support/notes/409267 (SAP Service marketplace login required)

Summary :
This SAP Note addresses the issue of data inconsistency in the R/3 System where classification system objects (KSSK and AUSP records) are not linked to any value assignment instance (ESTVA records), resulting in unused database storage. The note provides ABAP program texts for three specific reports to physically delete these unlinked objects for various EH&S versions. Each report caters to different EH&S version compatibilities and prerequisites. The execution of these reports involves a TESTRUN parameter that allows for either simulated or actual deletions, facilitating precise control over the cleanup process.

Key words :
additional key words ehs27bsp01psehs25bsp06psehs22bpl07psmaster data matchup, rc1phdelset deletion indicatordelete physicallyehsb_delflaged_data_removec151_delflaged_data_remove, classification system tablespreconditionsan eh&, classification system objects, prerequisites causeinconsistent data, attached correction instruction, module 'industrial hygiene, report physically deletes, abap program texts, assigned data record

Related Notes :

1406547Program RC1PHDEL requires excessive runtime
1071805EHS data records cannot be accessed in classification system
398352Corrections for EH&S 2.2B: Patch level 07
395095Corrections EH&S 2.5B: Support Package 06
391318EH&S 2.7B corrections: Support Package 01