Export from the SEM Data Pool 

You can use this function to extract data from the SEM Data Pool and import it into other systems. Loans, forex transactions, option transactions, and all transactions that you can transfer to SEM using external data transfer (EDT) belong to the SEM Data Pool. For a complete list of all export object categories, see the Export Interface Tables document.

Extraction programs are available for both initial data extractions (Initial Load) and delta extractions (delta load). For performance reasons it is recommended that you first extract the data in full, using the initial load program, and export it to the target systems. When you start a delta load at a later point in time, the system then has to transfer the changed data only.   

BAPIs (Business Application Programming Interfaces) are used as export functions. BAPIs therefore provide a general interface, which can be used both internally and externally. The BAPIs generate the IDoc structure and, in doing so, provide fixed data structures that can be used to transfer the data and to depict the SEM Data Pool in the structures of the target systems.

When you use a delta load, the system extracts only data that has been changed since the last export. You can use the settings in Customizing to determine which objects are export relevant and change relevant. You can make these settings in Customizing by choosing SAP Banking ® Strategic Enterprise Management (SEM) ® SEM Basic Settings ® Export from the Data Pool ® Settings for Export Relevance/Settings for Change Relevance.

The system uses change pointers to log changes to data in the SEM Data Pool. When a change is made, the system generates a change pointer. The change pointer contains information about which object category and which object was changed.  During extraction, the system reads the change pointer tables (JBDCPHDR, JBDCPHDR2, JBDCPPOS, and JBDCPPOS2), and lists the object keys of the changed objects. These object keys are transferred to modules specific to the object category. These modules read the data relating to the objects from the data pool, and generate IDocs from that data.  The extraction program then sets the export status of the change pointers to Processed. The ALE layer can then process the saved IDocs automatically. As a prerequisite, you must have configured the ALE interface  appropriately.

The SEM Data Pool does not contain version management. The system therefore always extracts the transaction data that is current at the time of extraction. If more than one change is made to an object between two extractions, the system groups together the change pointers, and extracts the object once only.

Prerequisites

In order to export data from the SEM Data Pool into other systems, you must fulfill the following prerequisites:

·        You have configured the ALE interface.

·        You have filled the export interface tables.

·        You have activated the export interface in Customizing.