{"id":30161,"date":"2014-11-09T10:58:00","date_gmt":"2014-11-09T09:58:00","guid":{"rendered":"https:\/\/alistar.net\/?p=30161"},"modified":"2026-10-02T16:04:55","modified_gmt":"2026-10-02T14:04:55","slug":"sap-data-extraction-sap-extractors","status":"publish","type":"post","link":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/","title":{"rendered":"SAP data extraction\u2026 SAP extractors?"},"content":{"rendered":"<p class=\"wp-block-paragraph\">SAP Data Services offers various options for extracting data from an SAP system; examples include direct table reads (with or without an ABAP dataflow) or IDocs (for data transfers of business transactions). However, it is also possible to use a standard ODP extractor available in SAP. Extractors feature a delta mechanism. This makes them suitable, for example, for quickly reloading very large tables on a daily basis, or eliminates the need for you to manually determine which source fields are suitable for delta calculation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Using an extractor in Data Services isn't very complicated. First, you need an \u2018SAP Applications\u2019 data store. Extractors can then be defined under ODP (Operational Data Provisioning) objects; in this case, two have been added:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The newly created extractor\u2014for example, 2LIS_11_VAHDR for sales document header data\u2014can be used as a source in a data flow:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The data provided by the extractor comes primarily from the VBAK table; this is why the target table is named after it. On the <a href=\"http:\/\/help.sap.com\/saphelp_nw70\/helpdata\/en\/f0\/3baf6718d2427a94ced005f298be06\/content.htm\" target=\"_blank\" rel=\"noreferrer noopener\">SAP Help Portal<\/a>&nbsp;You can see exactly which source data the 2LIS_11_VAHDR extractor accesses.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By adjusting the extractor's configuration, you can specify that only the deltas (i.e., changed records) be retrieved:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With the settings outlined in red above, the extractor only transfers the changes, since \u2018Initial Load\u2019 is set to \u201cNo.\u201d Only records that have changed since the datetime value specified under \u201cExtract from datetime\u201d are retrieved. The value $p_Delta_Datum refers to a user-defined parameter and contains the date and time of the previous delta processing, based on a control table containing the history of previous runs of the job. All other settings are populated with default values.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the output fields shown in the screenshot above, two are outlined in green; these provide crucial information for using the extractor as a delta mechanism. The DI_SEQUENCE_NUMBER field indicates the order in which changes occurred; DI_OPERATION_TYPE contains the value \u2018I\u2019 or \u2018D\u2019 to indicate whether a record is an insertion or a deletion. An update does not have a separate status; it is simply a deletion of the old record followed by an insertion of the new one.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is also possible to request a complete VBAK export simply by adjusting the configuration:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To be clear, this time no date and time were entered in the \u2018Extract datetime from\u2019 setting. These fields could be filled in, but they have no effect when \u201cInitial Load\u201d is set to \u201cYes.\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Standard extractors in SAP can work very well in certain situations, thanks to their built-in delta mechanism combined with good performance. However, an extractor may not contain all the fields you need (now or in the future), so it is preferable to use direct table reads.<\/p>","protected":false},"excerpt":{"rendered":"<p>SAP Data Services offers various options for extracting data from an SAP system; examples include direct table reads (with or without an ABAP data flow) or IDocs (for data transfers from business transactions). <\/p>","protected":false},"author":16,"featured_media":30163,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[27],"tags":[745],"industrie-type":[],"interesses":[],"techologie":[],"alistar_language":[],"class_list":["post-30161","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-nl","tag-sap-analytics"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SAP data extractie\u2026 SAP extractors? - Alistar<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/alistar.net\/en\/blog\/sap-data-extraction-sap-extractors\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP data extractie\u2026 SAP extractors? - Alistar\" \/>\n<meta property=\"og:description\" content=\"In SAP Data Services bestaan diverse mogelijkheden om gegevens uit een SAP-systeem te ontsluiten; denk bijvoorbeeld aan\u00a0direct table reads(al dan niet via een ABAP dataflow) of\u00a0IDocs\u00a0(voor data transfers van business transacties).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/alistar.net\/en\/blog\/sap-data-extraction-sap-extractors\/\" \/>\n<meta property=\"og:site_name\" content=\"Alistar\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-09T09:58:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-02T14:04:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/alistar.net\/wp-content\/uploads\/2025\/10\/shutterstock_2280243177-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Shardae Castelen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shardae Castelen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/\"},\"author\":{\"name\":\"Shardae Castelen\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/person\\\/3c047614ccf88bd8927ae653882b3b50\"},\"headline\":\"SAP data extractie\u2026 SAP extractors?\",\"datePublished\":\"2014-11-09T09:58:00+00:00\",\"dateModified\":\"2026-10-02T14:04:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/\"},\"wordCount\":487,\"publisher\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/shutterstock_2280243177-scaled.webp\",\"keywords\":[\"SAP Analytics\"],\"articleSection\":[\"Blog NL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/\",\"name\":\"SAP data extractie\u2026 SAP extractors? - Alistar\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/shutterstock_2280243177-scaled.webp\",\"datePublished\":\"2014-11-09T09:58:00+00:00\",\"dateModified\":\"2026-10-02T14:04:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/#primaryimage\",\"url\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/shutterstock_2280243177-scaled.webp\",\"contentUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/shutterstock_2280243177-scaled.webp\",\"width\":2560,\"height\":1280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/sap-data-extractie-sap-extractors\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/alistar.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP data extractie\u2026 SAP extractors?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/\",\"name\":\"Alistar\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/alistar.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\",\"name\":\"Alistar\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/favicon-new.svg\",\"contentUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/favicon-new.svg\",\"width\":260,\"height\":260,\"caption\":\"Alistar\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/alistar\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/person\\\/3c047614ccf88bd8927ae653882b3b50\",\"name\":\"Shardae Castelen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"caption\":\"Shardae Castelen\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP data extraction\u2026 SAP extractors? - Alistar","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/alistar.net\/en\/blog\/sap-data-extraction-sap-extractors\/","og_locale":"en_US","og_type":"article","og_title":"SAP data extractie\u2026 SAP extractors? - Alistar","og_description":"In SAP Data Services bestaan diverse mogelijkheden om gegevens uit een SAP-systeem te ontsluiten; denk bijvoorbeeld aan\u00a0direct table reads(al dan niet via een ABAP dataflow) of\u00a0IDocs\u00a0(voor data transfers van business transacties).","og_url":"https:\/\/alistar.net\/en\/blog\/sap-data-extraction-sap-extractors\/","og_site_name":"Alistar","article_published_time":"2014-11-09T09:58:00+00:00","article_modified_time":"2026-10-02T14:04:55+00:00","og_image":[{"width":2560,"height":1280,"url":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/10\/shutterstock_2280243177-scaled.webp","type":"image\/webp"}],"author":"Shardae Castelen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shardae Castelen","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/#article","isPartOf":{"@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/"},"author":{"name":"Shardae Castelen","@id":"https:\/\/alistar.net\/en\/#\/schema\/person\/3c047614ccf88bd8927ae653882b3b50"},"headline":"SAP data extractie\u2026 SAP extractors?","datePublished":"2014-11-09T09:58:00+00:00","dateModified":"2026-10-02T14:04:55+00:00","mainEntityOfPage":{"@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/"},"wordCount":487,"publisher":{"@id":"https:\/\/alistar.net\/en\/#organization"},"image":{"@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/#primaryimage"},"thumbnailUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/10\/shutterstock_2280243177-scaled.webp","keywords":["SAP Analytics"],"articleSection":["Blog NL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/","url":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/","name":"SAP data extraction\u2026 SAP extractors? - Alistar","isPartOf":{"@id":"https:\/\/alistar.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/#primaryimage"},"image":{"@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/#primaryimage"},"thumbnailUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/10\/shutterstock_2280243177-scaled.webp","datePublished":"2014-11-09T09:58:00+00:00","dateModified":"2026-10-02T14:04:55+00:00","breadcrumb":{"@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/#primaryimage","url":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/10\/shutterstock_2280243177-scaled.webp","contentUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/10\/shutterstock_2280243177-scaled.webp","width":2560,"height":1280},{"@type":"BreadcrumbList","@id":"https:\/\/alistar.net\/en\/blog\/sap-data-extractie-sap-extractors\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/alistar.net\/"},{"@type":"ListItem","position":2,"name":"SAP data extractie\u2026 SAP extractors?"}]},{"@type":"WebSite","@id":"https:\/\/alistar.net\/en\/#website","url":"https:\/\/alistar.net\/en\/","name":"Alistar","description":"","publisher":{"@id":"https:\/\/alistar.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/alistar.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/alistar.net\/en\/#organization","name":"Alistar","url":"https:\/\/alistar.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alistar.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/07\/favicon-new.svg","contentUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/07\/favicon-new.svg","width":260,"height":260,"caption":"Alistar"},"image":{"@id":"https:\/\/alistar.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/alistar\/"]},{"@type":"Person","@id":"https:\/\/alistar.net\/en\/#\/schema\/person\/3c047614ccf88bd8927ae653882b3b50","name":"Shardae Castelen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","caption":"Shardae Castelen"}}]}},"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/30161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/comments?post=30161"}],"version-history":[{"count":1,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/30161\/revisions"}],"predecessor-version":[{"id":76135,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/30161\/revisions\/76135"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/media\/30163"}],"wp:attachment":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/media?parent=30161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/categories?post=30161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/tags?post=30161"},{"taxonomy":"industrie-type","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/industrie-type?post=30161"},{"taxonomy":"interesses","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/interesses?post=30161"},{"taxonomy":"techologie","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/techologie?post=30161"},{"taxonomy":"alistar_language","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/alistar_language?post=30161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}