Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Cdc enhancement guide Cross Database Comparison Enhancement Guide Document Version - - Cwww sap com TABLE OF CONTENT MOTIVATION Characteristics of generated CDC Data Extractors Limitation of generated CDC Data Extractors DATA EXTRACTORS FOR SOURCE TYPE AB

Cross Database Comparison Enhancement Guide Document Version - - Cwww sap com TABLE OF CONTENT MOTIVATION Characteristics of generated CDC Data Extractors Limitation of generated CDC Data Extractors DATA EXTRACTORS FOR SOURCE TYPE ABAP General Procedure to enhance the generated ABAP data extractor Example case DATA EXTRACTORS FOR SOURCE TYPE ADBC General Procedure to enhance the generated ADBC SQL statement ENHANCEMENT SPOTS WITHIN CDC Enhancement Spot DSWPCDCCONVERSION Procedure Enhancement Spot DSWPCDCSOURCE Filter possibilities for implementation Interface to be implemented CREATING YOUR OWN SOURCE TYPES Procedure De ?nition of the source type Creation of the class Which methods have to be implemented Embedding a speci ?c UI for your source type APPENDIX Enhancing SQL extractions with DISTINCT Business Example Enhancing SQL extractions with relative date selections Business Example MS -SQL server MaxDB Enhanced ABAP data extractor with relative date selection on yesterday simple date ?eld Enhanced ABAP data extractor with relative date selection on yesterday timestamp ?eld independent SELECT FOR ALL ENTRIES additional application logic key mapping BAdI implementation for enhancement spot DSWPCDCSOURCE Business Use Case Procedure CCROSS DATABASE COMPARISON ?? ENHANCEMENT GUIDE MOTIVATION Characteristics of generated CDC Data Extractors With the Cross Database Comparison CDC tool you de ?ne a graphical data model of both source systems and the mapping of the comparison ?elds between them This data model o ?ers a lot of exibility like joins on several tables and ?lters on ?xed and dynamic criteria Based on the data model certain source types like ABAP and ADBC perform a generation which is an automatic creation of the corresponding extractor ABAP function module or the native SQL statement This generation happens based on ?xed templates to create the code to extract the data based on the object model using best practices and common procedures to facilitate an ??as-close-as-possible ? match to the expected extraction scenario Limitation of generated CDC Data Extractors However there might be cases where the generated data extractor does not fully meet the requirement Examples are Instead of INNER JOINs you require other JOIN types Instead of JOINs you rather require nested select loops e g to have the possibility to insert additional logic between the selection of header and child tables You need to perform additional application logic like special data conversion key mapping customizing lookup extra ?ltering and so on You require additional authorization checks CCROSS DATABASE COMPARISON ?? ENHANCEMENT GUIDE DATA EXTRACTORS FOR SOURCE TYPE ABAP General Procedure to enhance the generated ABAP data extractor Create the data model the source tables do not really need to match the real situation but the mapping must consist exactly of all required key and data ?elds Generate the ABAP RFC extractor function module Optionally copy it to some other name Using ABAP Workbench manually change and enhance the coding o Usually you should only modify the middle part with the database selections o Please note that there is one selection to get the expected number of records SELECT COUNT and another part for the actual