Controlling the Synchronization of Picklists (Example) (Biblioteca SAP

Controlling the Synchronization of Picklists (Example)

Use

You do not want the picklists in the XML repository to be overwritten by the picklists transferred by SAP R/3 to CATS notebook during synchronization. Instead, you want the picklists to be updated as follows:

If a row of the picklist already exists in the XML repository, you want it to be replaced by the row in the picklist received during synchronization.
If a row of the picklist is not yet in the XML repository, you want it to be inserted into the picklist.

Procedure

Define a separate class, ZsynchronizationInboundHandler. This class must implement the IsynchronizationInboundHandler interface.

Implement the getObjectName method.

Implement the handleInboundContainer method.

Create an instance of the IMessageContainer class to output messages about the synchronization operation as required. Note: For the sake of simplicity, this example does not cover the issuing of messages.

Read an instance of the DatabaseCustomer class.

Read sequentially the rows of the picklist received from SAP R/3 and check for each row whether there is already a row with the same primary key in the XML repository of CATS notebook.

If there is a row with the same primary key, delete it and insert the row from the picklist received into the picklist in the XML repository.
If no row with the same primary key exists, insert the row from the picklist received into the picklist in the XML repository.

Java Source Code

package com.sap.mycats.customer.examples;

import com.sap.mycats.basics.database.badi.*;

import com.sap.mycats.basics.tools.badi.*;

import com.sap.mycats.basics.customer.synchronization.ISynchronizationInboundHandler;

/**

* This example of an ISynchronizationInboundHandler appends or updates

* received elements. The standard handler would replace all records with the

* received table.

public class ZSynchronizationInboundHandler

implements ISynchronizationInboundHandler

{

public final static String ZPICKLIST_WBS = "ZPICKLIST_POSID";

public ZSynchronizationInboundHandler () {

}

public String getObjectName () {

return ZPICKLIST_WBS;

}

public void handleInboundContainer (ITableReadOnly anInboundContainer) {

DatabaseCustomer database = DatabaseCustomer.getInstance();

for (int i = 0; i < anInboundContainer.getRowCount(); i++) {

IRecordReadWrite record = null;

try {

record = RecordFactory.createRecord(ZPICKLIST_WBS);

} catch (Exception e) {

return;

}

record.setCorrespondingFields(anInboundContainer.getRecordReadOnly(i));

ITableReadWrite oldRecords

= database.select(ZPICKLIST_WBS, "primary", record, record);

for (int j = 0; j < oldRecords.getRowCount(); j++) {

database.delete(ZPICKLIST_WBS, oldRecords.getRecordReadWrite(j));

}

database.insert(ZPICKLIST_WBS, record);

}