Extract Open Items
Application component: Contract Accounts Receivable and Payable
App type: SAP GUI
Description:  You use the Extract Open Items transaction if you want to extract open items for a key date for Business Intelligence (BI). 
Key features:  The function extracts open items from Contract Accounts Receivable and Payable for a key date. To reduce the amount of data, you can condense the data to be extracted at any level. This means that you can always initialize certain values or under special conditions by using the Customizing settings in the extract set. For example, if only regional evaluations are of interest to you, you can initialize the business partner and contract account and only save the postal code of the business partner. However, you must also extract the required master data fields. In the standard system, you can extract the fields for the business partner and contract account. If you require additional data from other objects, you can retrieve this using event 2510 (see documentation of sample function module FKK_SAMPLE_2510). If you define event 2504, you can restrict extraction before the OI analysis to a subset of business partners. At event 2505, you can exclude unwanted combinations of business partner, contract account, and contract from the extraction quantity. The system recognizes the runs to be restricted on the basis of the naming conventions used in the event modules (fields LAUFD and LAUFI). Furthermore, during extraction, you can simulate credit item clearing with the oldest open receivables of a business partner. However, clearing only takes place if the transaction currency of the receivable(s) and the credit to be cleared match. At event 2506, you can specify which of the following data for clearing must match: Company code Business area G/L account  Unless you define the event individually, clearing only takes place if the company codes and general ledger accounts for the receivable(s) and credits match. During the simulation, the due date of the credit memos is set to the due date of the cleared receivables. When the items are totaled and sorted, the system displays a status that corresponds to the status that would be reached after clearing the credit with the oldest receivable(s) due. For a credit that is distributed to several receivables, the extractor simulates several fictitious items accordingly. During extraction, the selected data is then selected with the BI Extraction of Open Items mass activity (transaction FPBW) and saved in transparent table DFKKOPBW. Afterwards, the saved data records can be “fetched” with the extractor. For open items of Contract Accounts Receivable and Payable, SAP provides DataSource 0FC_OP_01. Based on the nature of the data, the DataSource supports the delta procedure only via full upload. You define additional extractors needed in transaction RSO2. Note You can enhance table DFKKOPBW with customer includes.If you have actively switched the use of the shadow table for business partner data to improve the performance of mass processes in the system (see Customizing for Contract Accounts Receivable and Payable, under Technical Settings  Performance Improvement of Mass Runs), the performance improvement is also used for the extraction of business partner data. In this case, before the first extraction, you must update the dataset of the shadow table for business partners so that the fields required for the BI extraction can be filled To do this, start report RFKKGPSH. Ensure that you read the report documentation. In the Administration of Extraction transaction (transaction FPBWS), you can display the selections of the created extracts and flag the extracts for deletion.