General Comments on Extraction Procedure

The consistent data extraction in the delta procedure for IOA/IoA related information is based on extraction methods used in Finance for line items from General Ledger Accounting (FI-GL), selected subledgers (Accounts Receivable (FI-AR) and Accounts Payable (FI-AP)) and tax reporting with effect from SAP BW 3.1 Content. IOA/IoA extraction process enhances the possibilities of line item analysis already provided in SAP standard Financial Accounting.

To enter a consistent delta dataset, you can reuse any of the following BI standard InfoSources (with the corresponding DataSources and extractors in ECC):

The DGP//IoA related data can be transferred to BI using the following DataSources:

For the General Ledger, selection is made from the tables BKPF and BSEG, while selection for the subledgers is made from tables BSID/BSAD (Accounts Receivable) and BSIK/BSAK (Accounts Payable). IOA/IoA extraction is devided into category line items oriented extraction for open/cleared FI documents and preliminary documents such as MM invoices without an accounting (FI) document and preliminary FI documents and category IOA processing time document related extraction of open/cleared FI documents and preliminary FI / MM documents without related FI , (tables BSEG, VBKPF, BKPF , VBSEGK, VBSEGS, RBKP, RBCO, FPIA_INTEREST, FPIA_FI_IDX, FMIFIIT, INTITIT).

The consistent recording of data from General Ledger Accounting and IOA/IoA related information is provided by means of coupled delta extraction in the time stamp procedure. General ledger accounting is the main process in delta mode and provides IOA/IoA extraction (as well as subsidiary ledger extraction) with time stamp information. That is, time intervals of previously selected general ledger line items.

The ECC extractors of all DataSources concerning IOA line items, IOA processing times and IOA document number are primarily oriented on availability of documents in table FPIA_INTEREST and FPIA_FI_IDX. In contrast to General Ledger extractors as mentioned above, the extractors for IOA don’t deliver any other document and line items if the document number is neither contained in FPIA_INTEREST nor FPIA_FI_IDX as being leading tables during IOA extraction process.

IOA/IoA information in SRM contracts and purchase orders are delivered by DataSources 0PPS_BBP_TD_CONTR_2 and 0PPS_SRM_TD_PO. Both DataSources are copies of DataSources 0BBP_TD_CONTR_2 and 0SRM_TD_PO but include the additional interest key field.

Delta Method

Delta extraction enables you to load into BW only the data that has been added or has changed since the last extraction event. Data that has already been loaded and has not changed is not extracted and does not need to be deleted before a new load. This improves performance compared with periodic extraction of the entire dataset.

IOA line items (datasource 0PPS_FPIA_IOAIOA_LITEM_OC) consist of Financial Accounting line items that are read directly from the tables in ECC (mainly BSEG) but without IOA processing time data. A time stamp on the FPIA_INTEREST line items (field CHANGED_AT) serves to identify the status of the delta data. Time stamp intervals of open and cleared FI documents that have already been read are stored in a time stamp table (FPIA_INTEREST-CHANGED_AT). The delta dataset is transferred to BW directly, without records being transferred to the SAP standard delta queue in ECC (extractor delta method).

The IOA processing time open/cleared documents are extracted from ECC in their most recent status (after-image delta method). Like IOA line items, the delta procedure is not suitable for filling InfoCubes in BW directly. Therefore, firstly, the line items must be loaded in the BW system in a DataStore object that identifies the changes made to individual characteristics and Key Figures within a delta data record. Other data destinations (InfoCubes, DataSource objects) can be provided with data from this DataStore object.

If the DataStore object permits BEx Reporting, queries can be defined directly there.

The IOA document number master data is extracted from ECC in their most recent status (after-image delta method and to be loaded directly into characteristic 0PPS_DGDOCN, followed by an attribute change run.

Time Stamp Method

With Financial Accounting line items that have been posted in ECC since the last data request, the extractors identify the following delta dataset using the time stamp in the document header (BKPF-CPUDT in case of G/L extractors, FPIA_INTEREST-CHANGED_AT in case of IOA extractors).

When a delta dataset has been selected successfully, ECC logs two time stamps that delimit a selection interval for a DataSource in table BWOM2_TIMEST:

The time stamps are determined from the system date and time and converted to the format seconds since 1.1.1990, taking into account the time zone and daylight saving time. To ensure correct and unique reconversion to date and time, the time zone and daylight saving time must be stored in table BWOM2_TIMEST.

Table BWOM2_TIMEST therefore serves to document the loading history of Financial Accounting line items. It also provides defined restart points following incorrect data requests.

Recording Changed Line Items

Linking Data Load Processes

As of Plug-In 2002.2, it is no longer necessary to have DataSources linked. This means that you can load 0FI_GL_4, 0FI_AR_4, 0FI_AP_4, 0FI_TX_4, 0PPS_FPIA_IOAIOA_LITEM_OC, 0PPS_FPIA_IOAIOA_PROTIME_OC, and 0PPS_FPIA_DGDOCN_ATTR in any order. You also have the option of using DataSources 0PPS_FPIA_IOAIOA_LITEM_OC, 0PPS_FPIA_IOAIOA_PROTIME_OC and 0PPS_FPIA_DGDOCN_ATTR separately without 0FI_GL_4. The DataSources can then be used independently of one another (see SAP Note 551044).

Linking of DataSources in the delta helps to ensure consistent extraction of FI and IOA/IoA data with regard to time limits. Consistency with regard to the data extracted has to be ensured by means of the init selection criteria (see below).

Customer Enhancements of the Extraction Structure

You can enhance the extraction structure for DataSources 0PPS_FPIA_IOAIOA_LITEM_OC and 0PPS_FPIA_IOAIOA_LITEM_P in the ECC system by creating user-defined include structure or using transaction RSA6. The following customer includes are supported:

Global Settings

For the transfer of line items from Financial Accounting, important global settings can be made in ECC in table BWOM_SETTINGS. To do this, change the table using transaction SE16 (table maintenance):

BWFILOWLIM

You can set the lower time limit of the time stamp selection for data requests in update mode initialization of the delta method. Together with the selection criteria, this parameter is a decisive factor for the data volume with data requests in this update mode.

BWFISAFETY

You can set the upper time limit of the time stamp selection for data requests in all update modes. If the parameter has a value 1, the upper time limit of the time stamp selection is the previous day. Where the parameter values are larger than 1, the upper time limit of the time stamp selection is the corresponding number of days in the past.

ORGSYSONLY

If your ECC system is part of an ALE scenario, set this parameter to X. This ensures that only those line items that were originally posted to the BW system will be transferred there from the ECC system. This prevents line items being transferred several times to BW from various ECC systems.

DELTIMEST

You can set the retention period of entries that are no longer required in time stamp table BWOM2_TIMEST. The default setting for deletion of entries that are no longer required in the time stamp table is 60 days. The minimum retention period for entries in the time stamp table is 15 days. When entries are deleted from table BWOM2_TIMEST, the corresponding entries for the changed line items are deleted simultaneously from log table BWFI_AEDA2.

BWFIOVERLA

The logic of this parameter prevents records with the previous day as their CPU date from still being in the update at the time of extraction.

BWFITIMBOR

This parameter designates 02.00 (2 A.M.) as the time limit for extraction. If this limit is not reached, the system uses a security interval of one day to determine the To-value of the selection. If extraction is started before 02:00 therefore, the selection takes place only up to the day before the extraction run.