statement:Original Works，when reproduced, please indicate the article from
The SAP division is tooTechnology Blog ( Bo/guest/Park www.cnblogs.com): Www.cnblogs.com/jiangzhengjun，and indicate the original source of the article in the form of a hyperlink，Otherwise the legal liability will be investigated! Original link: http://www.cnblogs.com/jiangzhengjun/p/4297181.html
Table of incremental processing of data sources:
Roosource
attribute table for incremental processing:
Rodeltam
the objvers represents the version of the data source, there are two types of values,Aindicates the active version, the active version that can be used,RSA6to view (as long as it's active, whether it's a data source you've built or a system-standard, can be found through RSA6 );Drepresents a system standard version of a data source that can beRSA5to view the standard data sources provided by the system (Note:RSA5 can only see the standard), New onLineSystem Standard data source needs to be activated through RSA5 before it can be viewed and used in RSA6 , so the standard data source that is generally activated, there will be two data in this table, one is a version, one is D Version
ABR: Use of logistic data sources,update mode with new image, front image, rear image, and reverse mirrorthat is, support coverage, also support totals, so logistics data can be directly pumped into the DSO or cube
AIE:Financialdata source Use,with post-image mode,only supportoverwrite, total not supported, if you want to load into the cube, you need to first pass the standardcoverage of the DSO(in pumping towhen the DSO is overwritten, the data change log will be in the changes log table), and then to cube, so the financial data can not be directly extracted from the cube. this kind of increment processing method is applied more in Fi-ar/ap
ADD:only add-ons are supported, so the data can be used directly to the cube orTotal DSO
Generally speaking:
- co add e
- fi aie e
- lo abr d
- self-built default is aie fi No change method is provided, so the self-built unification is aie e
- master data One aie aim newe
Below is a brief description under aie abr The difference:
- ABR Way is doomed, not only suitable for uploading directly to the DSO, can be directly uploaded to the CUBE, not through the DSO , because not only serialization, but also a variety of mirrors.
- AIEonly post-mirroring is supported, that is, it can only be loaded first intoDSO, and then analyze it, and when the data is activated, we will mirror the previous image toDSOof theLOGtable, thus guaranteeing theDSOof the detailed requirements, but also toCUBEExtractLOGget the correct data when the table is BecauseCUBEonly rollup, no overwrite feature.
Finally, I want to explain FI The data extraction method is not the same as other modules.
- FIis throughBWthe request, toR3executes the correspondingFM, and then get the data, writeDELTAqueue, this way is called Pull. Custom data sources are the same way
ABR support new, modify and delete, applicable to the Logistics Module , and ABR recording mode of the delta data is applicable to the total DSO and cube, also applicable to the cover type DSO AIE only support new and modified, does not support the deletion, so aie only applicable to the financial module, because the financial module does not delete operations, in addition, the AIE record mode data can not be extracted to the accumulated type of DSO and cube (However, the standard DSO can be used to transition, because even if only after post-like record mode of incremental data, after the standard DSO dump, will be in the Change Log table to fill inrecord mode is before records, so that the entire modification process is restored, and then pumped up into the cube, the system will be aggregated according to these logs )
DeltaType: Incremental types, either push or pull, refer to whether the incremental data enters the delta-queue in a proactive way, or push (such as logistic delta data) if it is active Otherwise, pull (such as the increment of the financial data source is not populated until BW data is pumped)
Data source incremental processing (Delta Proess) three main properties: Recod Mode, Delta Type, serialization
