{"id":11194,"date":"2018-08-30T12:00:00","date_gmt":"2018-08-30T12:00:00","guid":{"rendered":"https:\/\/zapliance.com\/?p=11194"},"modified":"2022-08-26T13:43:04","modified_gmt":"2022-08-26T13:43:04","slug":"overdelivery-made-easy","status":"publish","type":"post","link":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/","title":{"rendered":"Overdelivery made easy"},"content":{"rendered":"\n<p>You pay for what you ordered! That\u2019s usually the simple rule. However, some companies place so many orders that it is difficult to keep track of all of them and the SAP system is there to help ensure that vendors do not deliver more than was actually ordered. In this blog post, you can find out whether your SAP system allows for overdeliveries and for which orders this is the case.<\/p>\n\n\n\n<p>In principle, your SAP system can monitor whether an overdelivery can be made for an order or not. This means that the SAP system is able to issue a warning in the event of an overdelivery to the plant gate or even refuse an overdelivery of quantities on the system side. The only question is whether your SAP system is set up correctly and whether such control functions are \u201cfinely-tuned\u201d.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">A never-ending story<\/h2>\n\n\n\n<p>The extent to which an overdelivery is permitted is stored in each purchase order, or rather, in each purchase order item in SAP (table EKPO). The most extensive possibility for overdelivery is the possibility of open-ended overdelivery. Each order item indicates whether it can be overdelivered indefinitely. This is shown in the data by the flag in the UEBTK data field of the EKPO table.<\/p>\n\n\n\n<p>The following SQL query determines all the order items in your system for which overdeliveries are or have been allowed indefinitely. Of course, this does not mean that such an overdelivery has actually taken place. If you want to test the query yourself on your own SAP system, use the \u201cDBACOCKPIT\u201d transaction and navigate to the \u201cSQL Editor\u201d (tested on a HANA database) via \u201cDiagnostics\u201d:<\/p>\n\n\n\n<p><code>SELECT EBELN, EBELP, MATNR, TXZ01, MENGE AS AMOUNT , UEBTK FROM EKPO WHERE MATNR != '' AND MENGE&gt;0 AND UEBTK='X' ORDER BY EBELN, EBELP<\/code><\/p>\n\n\n\n<p>On my test data set, this gives the following results:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>EBELN<\/th><th>EBELP<\/th><th>MATNR<\/th><th>TXZ01<\/th><th>AMOUNT<\/th><th>UEBTK<\/th><\/tr><tr><td>5500000032<\/td><td>10<\/td><td>AM2-730<\/td><td>on board computer<\/td><td>90<\/td><td>X<\/td><\/tr><tr><td>5500000034<\/td><td>10<\/td><td>AM2-600<\/td><td>air condition<\/td><td>1.121<\/td><td>X<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>On purchase order 550000000034, air conditioning units were ordered and it would have been possible to make overdeliveries for the quantity indefinitely.<\/p>\n\n\n\n<p>Do not focus on the individual lines at first but start by checking how many document items are found at all to get an impression as to whether systematic overdelivery is allowed. If systematic overdelivery is possible, this is an indication of failings in your internal control system.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Possibility of overdeliveries on a massive scale<\/h2>\n\n\n\n<p>Open-ended overdeliveries have the potential to cause problems on a massive scale. However, you can also specify how much can be overdelivered as a percentage of the quantity ordered. This is stored in the \u201cUEBTO\u201d data field in each document item. First define an overdelivery limit as a percentage in excess of which you consider overdeliveries to be critical. If we take this to be a percentage of more than 50% overdelivery, then such cases can be identified using the following query:<\/p>\n\n\n\n<p><code>SELECT EBELN, EBELP, MATNR, TXZ01, MENGE, UEBTO FROM EKPO WHERE MATNR IS NOT NULL AND MENGE &gt; 0 AND UEBTO &gt; 50.0 AND UEBTK='' ORDER BY EBELN, EBELP<\/code><\/p>\n\n\n\n<p>The same applies to this query as we have already said above: The results do not indicate that an overdelivery was actually made, but only that it is or was possible.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why not let zap Audit do the work for you?<\/h2>\n\n\n\n<p>If this all sounds too technical for you, then you\u2019ll be pleased to hear that zap Audit already contains an indicator to identify the cases of overdelivery described above. So why not give it a try: zap Audit is free of charge for small company codes and we will be happy to give you some advance guidance to show you how to obtain the analysis results you are looking for.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You pay for what you ordered! That\u2019s usually the simple rule. However, some companies place so many orders that it is difficult to keep track of all of them and the SAP system is there to help ensure that vendors do not deliver more than was actually ordered. In this blog post, you can find [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":10699,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[38,37,40],"tags":[],"class_list":["post-11194","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-en-audit","category-en-compliance","category-en-finance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Overdelivery made easy - zapliance<\/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:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Overdelivery made easy - zapliance\" \/>\n<meta property=\"og:description\" content=\"You pay for what you ordered! That\u2019s usually the simple rule. However, some companies place so many orders that it is difficult to keep track of all of them and the SAP system is there to help ensure that vendors do not deliver more than was actually ordered. In this blog post, you can find [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/\" \/>\n<meta property=\"og:site_name\" content=\"zapliance\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-30T12:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-26T13:43:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"962\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nick Gehrke\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nick Gehrke\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/\"},\"author\":{\"name\":\"Nick Gehrke\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a\"},\"headline\":\"Overdelivery made easy\",\"datePublished\":\"2018-08-30T12:00:00+00:00\",\"dateModified\":\"2022-08-26T13:43:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/\"},\"wordCount\":574,\"publisher\":{\"@id\":\"https:\/\/zapliance.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"articleSection\":[\"Audit\",\"Compliance\",\"Finance\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/\",\"url\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/\",\"name\":\"Overdelivery made easy - zapliance\",\"isPartOf\":{\"@id\":\"https:\/\/zapliance.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"datePublished\":\"2018-08-30T12:00:00+00:00\",\"dateModified\":\"2022-08-26T13:43:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#primaryimage\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"width\":2400,\"height\":962},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/zapliance.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Overdelivery made easy\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zapliance.com\/en\/#website\",\"url\":\"https:\/\/zapliance.com\/en\/\",\"name\":\"zapliance\",\"description\":\"Be the agent of change\",\"publisher\":{\"@id\":\"https:\/\/zapliance.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zapliance.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/zapliance.com\/en\/#organization\",\"name\":\"zapliance\",\"url\":\"https:\/\/zapliance.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg\",\"width\":200,\"height\":45,\"caption\":\"zapliance\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a\",\"name\":\"Nick Gehrke\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg\",\"caption\":\"Nick Gehrke\"},\"description\":\"is Chief of Data &amp; Knowledge and Co-Founder at zapliance as well as Professor of Information Systems with a Big 4 background. He prefers to work as a business information scientist and tax consultant at the converging points of finance, accounting, taxation, audit and ERP systems, data science and information technology.\",\"url\":\"https:\/\/zapliance.com\/en\/blog\/author\/nick-gehrke\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Overdelivery made easy - zapliance","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:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/","og_locale":"en_US","og_type":"article","og_title":"Overdelivery made easy - zapliance","og_description":"You pay for what you ordered! That\u2019s usually the simple rule. However, some companies place so many orders that it is difficult to keep track of all of them and the SAP system is there to help ensure that vendors do not deliver more than was actually ordered. In this blog post, you can find [&hellip;]","og_url":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/","og_site_name":"zapliance","article_published_time":"2018-08-30T12:00:00+00:00","article_modified_time":"2022-08-26T13:43:04+00:00","og_image":[{"width":2400,"height":962,"url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","type":"image\/png"}],"author":"Nick Gehrke","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nick Gehrke","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#article","isPartOf":{"@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/"},"author":{"name":"Nick Gehrke","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a"},"headline":"Overdelivery made easy","datePublished":"2018-08-30T12:00:00+00:00","dateModified":"2022-08-26T13:43:04+00:00","mainEntityOfPage":{"@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/"},"wordCount":574,"publisher":{"@id":"https:\/\/zapliance.com\/en\/#organization"},"image":{"@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#primaryimage"},"thumbnailUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","articleSection":["Audit","Compliance","Finance"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/","url":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/","name":"Overdelivery made easy - zapliance","isPartOf":{"@id":"https:\/\/zapliance.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#primaryimage"},"image":{"@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#primaryimage"},"thumbnailUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","datePublished":"2018-08-30T12:00:00+00:00","dateModified":"2022-08-26T13:43:04+00:00","breadcrumb":{"@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#primaryimage","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","width":2400,"height":962},{"@type":"BreadcrumbList","@id":"https:\/\/zapliance.com\/en\/blog\/overdelivery-made-easy\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/zapliance.com\/en\/"},{"@type":"ListItem","position":2,"name":"Overdelivery made easy"}]},{"@type":"WebSite","@id":"https:\/\/zapliance.com\/en\/#website","url":"https:\/\/zapliance.com\/en\/","name":"zapliance","description":"Be the agent of change","publisher":{"@id":"https:\/\/zapliance.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zapliance.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/zapliance.com\/en\/#organization","name":"zapliance","url":"https:\/\/zapliance.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg","width":200,"height":45,"caption":"zapliance"},"image":{"@id":"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a","name":"Nick Gehrke","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg","caption":"Nick Gehrke"},"description":"is Chief of Data &amp; Knowledge and Co-Founder at zapliance as well as Professor of Information Systems with a Big 4 background. He prefers to work as a business information scientist and tax consultant at the converging points of finance, accounting, taxation, audit and ERP systems, data science and information technology.","url":"https:\/\/zapliance.com\/en\/blog\/author\/nick-gehrke\/"}]}},"views":1744,"_links":{"self":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/comments?post=11194"}],"version-history":[{"count":1,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11194\/revisions"}],"predecessor-version":[{"id":11195,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11194\/revisions\/11195"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/media\/10699"}],"wp:attachment":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/media?parent=11194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/categories?post=11194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/tags?post=11194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}