Deleting Publications 

Use

You can delete publications when they are no longer needed for data distribution.

Data can become inconsistent when publications are deleted since there is no information available in the source system (typically a development or test system) about the subscriptions in the target system (typically a productive system).

The replicated data to be deleted cannot be removed automatically since the function modules required for this purpose are also influenced by the delete function.

This means that you must use the Administration Console to delete the corresponding subscriptions in the target system first. Only then may you apply the transport from the source system into the target system.

Prerequisites

You must have selected the object type Publication in the Object type selection list.

Procedure

You can delete a publication by using the Object ® Delete function or the corresponding symbol in the application toolbar, providing that no subscriptions have been assigned to it.

To delete a publication, proceed as follows:

1.       First delete the subscriptions in the target system for the affected publication. This means that the data for all the replication objects assigned to the publication is deleted on the clients .

2.       After realignment has taken place in the target system, check the following:

¡        For publications of type unfiltered (bulk):

Check in the look-up table SMOHLUBULK if there is still an entry for the affected publication. To do so, filter table SMOHPUBL using the name of the publication and the current industry indicator, and filter table SMOHLUBULK using the key of table SMOHPUBL for the field OBJ_ID.

¡        For intelligent publications:

Check that the look-up table of the corresponding replication object no longer contains an entry. The name of the relevant look-up table can be determined from the SMOHREPOBJ record of the replication object that is intended for deletion. To do so, filter table SMOHREPOBJ for the SHORT_NAME of the replication object and the current industry indicators. The LU_TABLE field of the entry you have determined in SMOHREPOBJ then gives you the character string for which you have to search in the ABAP Dictionary - prefixed by an asterisk (*) - in order to determine the name of the look-up table. If several tables with this character string in the name are found, select the table whose name begins with the character chain "/1CRMG0/" and the industry indicator.

This step is not relevant for publications of type simple unfiltered or simple intelligent.

       1.      Now check if there is still an entry for the replication object in the extract queue. To do this you have to filter table SMOHMSGQ for the type of the replication object, using QUEUENAME = EXTRACT and MSGTYP = SMOHREPOBJ-SHORTNAME.

This step is not relevant for publications of type unfiltered (bulk), simple unfiltered or simple intelligent.

       2.      If the look-up table is empty and there are no more entries in the extract queue, delete the subscription for the affected publication in the source system.

3.       After realignment has taken place in the source system, carry out the same checks there as you did in the target system.

       3.      If the look-up table is empty and there are no more entries in the extract queue, delete the publication in the source system.

       4.      Now release the transport request into the target system.