Although this is simple delta rule, function module based generic extractor has to be developed to handle the WHERE clause in the Open SQL SELECT statement, in order to track and filter by the create date and changed on date. In the example of VBAK, ERDAT (created on) and AEDAT (changed on) need to be used for delta processing. When it comes to generic extractors, developers have to carefully craft up the delta calculation algorithms in order to make the generic extractors delta capable.įundamentally it is the same rationale for the delta scenario in generic extractors. Within SAP standard extractors, there are a lot of logic doing the table look-ups and joins on transactional tables, master tables, change document tables (like CDPOS) and system BAPIs to figure out the delta. One myth in SAP community is that a lot of people think extractor can magically deliver delta. In transaction code RSO2, it is easy to create the generic extractor based upon table or view. SAP source object: BKPF with 588448 rows, 112 columnsĭata extraction setup: SSIS 2017 and AecorSoft Extractor and AecorSoft Table source components running on 16GB quad-core i7-3720QM laptop computer. Test setup: SAP IDES Ehp7 running on 16GB 8-core Hyper-V VM on a Xeon E5-2670 2.6Ghz workstation. Performance Comparison System Preparation The Delta aspect is explained through the example of VBAK table. The Performance aspect is explained through the comparison between generic extractor and direct table read on BKPF table through application layer. With such level set, we look at two aspects of Performance and Delta extraction. Instead of attempting to cover all aspects of SAP extractor, the focus is here is around SAP table content extraction through generic extractor which is most online how-to guides cover, and its comparison with direct table extraction. This article uses fact and data, through the comparison of table extraction and generic extractor extraction, to objectively explain the decision criteria for SAP data extraction. Building a generic extractor has to be carefully justified. In the context of bringing SAP table content out without business rules, Extractor is not the silver bullet. However, one important missing factor is “why”. In the whole SAP data extraction thought process, there have been a lot of articles explaining the “how”, which is about how to create generic extractors based upon tables like VBAK. SAP also enables users to create generic extractors. SAP Extractor concept is fantastic especially when it comes to delta enabled standard extractors.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |