Delete Trigger for BP Delta Queue
Application component: Contract Accounts Receivable and Payable
App type: SAP GUI
Description:  You can extract all business items, both posted and statistical items, for evaluation of receivables and payables in Business Intelligence (BI). You can run the extraction as full update, delta initialization, and delta update. 
Key features:  Extraction Structure The extract structure FKKOPBW_DELTA contains all fields that could be relevant for the evaluations in BI, but the DataSource delivered with the BI content only extracts the most important of these fields. If you require additional fields for your individual evaluation, you have to adjust the DataSource accordingly and replicate it in your BI system Delta Update The delta procedure is realized with the update of a delta queue. Transactions that create or change the business partner items do not update the delta directly (for example, Post Document (FPE1)). Instead, they only save the document numbers in a trigger table. In the SAP Easy Access screen, under Periodic Processing  Extraction for Business Intelligence  Business Partner Items with Delta Procedure  Update Delta Queue for Business Partner Items (transaction FPOP), update the delta queue. The delta procedure After Image via Delta Queue (AIM) is used. The parallelization object of the mass activity is a three character figure. If the last three figures of the document number are numerical, the system uses these for the parallelization object. Otherwise the system uses a random generator to generate a three character figure for each document. Run the delta extractions as soon after the activation as possible. Connection to Archive The extractor 0FC_BP_ITEMS supports the connection to archives. For the extraction from archives you can create and schedule Info Packages in full update. Note that with selection by date of entry of a document (CPUDT), you cannot access the archive and you have to preselect the archive files to be selected when you create info packages. Deletion of Triggers After the extraction, you can delete the document numbers that trigger the delta update from the trigger table (see SAP Easy Access screen Periodic Processing  Extraction for Business Intelligence  Business Partner Items with Delta Procedure  Delete Triggers; transaction FPOPDEL). However, you should not delete triggers for documents that will probably be changed again in the future. For example, receivables documents or documents with repetitions that are cleared periodically. You can restrict the document numbers to be selected by the date the document was created or last changed. The final date of the selection must not be after the date of the last successful delta extraction. For security purposes, we also recommend a safety interval of 90 days between the final date of the selection and the current date. You can also restrict the triggers to be delete by selection of the document number. If you define an own number range for documents with repetitions that are to be cleared periodically, you can exclude these directly, for example. Reconciliation with the General Ledger You can reconcile the business partner items extracted with the balances of the corresponding G/L accounts in the general ledger in the BI system. The prerequisite for the reconciliation is that the extractions of the FI-CA business partner items and the G/L items in the general ledger take place in close succession and that you only run the reconciliation for closed posting periods.