{"id":2010,"date":"2014-02-05T07:02:00","date_gmt":"2014-02-05T07:02:00","guid":{"rendered":"https:\/\/www.dab-europe.com\/\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/"},"modified":"2025-09-12T13:34:23","modified_gmt":"2025-09-12T13:34:23","slug":"currency-fields-in-sap-the-devil-is-in-the-details","status":"publish","type":"articles","link":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/","title":{"rendered":"Currency fields in SAP\u00ae &#8211; the devil is in the details"},"content":{"rendered":"<h2>Currency fields in SAP\u00ae &#8211; the devil is in the details<\/h2>\n<p class=\"align-justify\">There are several approaches to access SAP\u00ae data.<\/p>\n<p class=\"align-justify\">SAP-transactions as e.g. <strong>SE16<\/strong> can be used to locally download files as spreadsheet in Excel format or as text file. Afterwards the data can be analyzed with appropriate tools (Excel\u2122, ACL\u2122, Access\u2122 etc.).<\/p>\n<p class=\"align-justify\">SAP is very special considering currency fields. As an example let\u2019s have a look at this document:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140206_SAP_CurrencyFields_D_01.png\" \/><\/p>\n<h2>Currency fields in SAP &#8211; 2<\/h2>\n<p class=\"align-justify\">This posting is an outgoing payment in local currency JPY (Japanese Yen). 11,000.00 had been posted to the vendor account C.E.B. New York.<\/p>\n<p class=\"align-justify\">This record can directly be displayed with transaction SE16 by entering the following in table BSAK (cleared vendor items).<\/p>\n<ul>\n<li>the document number 1500000014<\/li>\n<li>company code 3000<\/li>\n<li>fiscal year 1996<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140206_SAP_CurrencyFields_D_02.png\" \/><\/p>\n<h2>Currency fields in SAP &#8211; 3<\/h2>\n<p class=\"align-justify\">The displayed record has significant differences from our posting document from above. The currency amount in field \u2018Amount\u2019 is displayed as 111,00 instead of 11.100,00 JPY!<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140206_SAP_CurrencyFields_D_03.png\" \/><\/p>\n<h2>Currency fields in SAP &#8211; 4<\/h2>\n<p class=\"align-justify\">This has tremendous impact on analytics that run on SAP Downloads, because in certain circumstances there could be values differently stored than displayed with data browser of SE16. Especially currency fields may, but do not have to be affected. <strong>But what could be the reason then, and how do these cases differ?<\/strong><\/p>\n<p class=\"align-justify\">The answer is that SAP ALWAYS stores amounts with 2 decimals in the database. This works fine for the Euro, as Euro has Cents and are stored with 2 decimals. If the amount is 5 Euros, then 5,00 is stored, 5 Euros and 10 Cents -&gt; 5,10, or 5 Euros and 11 Cents (5,11) etc.<\/p>\n<p class=\"align-justify\">But then there are currencies, as the Japanese Yen from the example, which have no decimals at all. Other currencies maybe have 3 or 4 decimals but in the database only 2 decimals are stored.<\/p>\n<p class=\"align-justify\">For this reason SAP introduced a separate table named <strong>TCURX<\/strong>, where the number of decimals per currency can be found, and provides the factor by which an amount must be multiplied to be properly displayed.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140206_SAP_CurrencyFields_D_04.png\" \/><\/p>\n<h2>Currency fields in SAP &#8211; 5<\/h2>\n<p class=\"align-justify\">The example above shows, that \u2013 whenever downloading data from SAP that contains currency amount fields \u2013 it needs to be treated carefully. It is not guaranteed that those values can be used directly; in some cases a conversion beforehand may be necessary.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Accessing SAP\u00ae data can be done in various ways. In SAP\u00ae, there are some special features, especially in terms of currency fields.<\/p>\n","protected":false},"author":2,"featured_media":7831,"template":"","articles_category":[],"articles_tag":[92,93],"class_list":["post-2010","articles","type-articles","status-publish","has-post-thumbnail","hentry","articles_tag-sap","articles_tag-accounting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Currency fields in SAP \u2013 the devil is in the details<\/title>\n<meta name=\"description\" content=\"Using currency fields correctly in SAP \u2713 Important tips with examples \u2713 Efficient management \u2713 Avoid errors \u2013 Learn more online now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Currency fields in SAP \u2013 the devil is in the details\" \/>\n<meta property=\"og:description\" content=\"Using currency fields correctly in SAP \u2713 Important tips with examples \u2713 Efficient management \u2713 Avoid errors \u2013 Learn more online now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/\" \/>\n<meta property=\"og:site_name\" content=\"dab\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-12T13:34:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2014\/02\/20140205_Waehrungsfelder_EN_V1.0.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"1044\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/currency-fields-in-sap-the-devil-is-in-the-details\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/currency-fields-in-sap-the-devil-is-in-the-details\\\/\",\"name\":\"Currency fields in SAP \u2013 the devil is in the details\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/currency-fields-in-sap-the-devil-is-in-the-details\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/currency-fields-in-sap-the-devil-is-in-the-details\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2014\\\/02\\\/20140205_Waehrungsfelder_EN_V1.0.png\",\"datePublished\":\"2014-02-05T07:02:00+00:00\",\"dateModified\":\"2025-09-12T13:34:23+00:00\",\"description\":\"Using currency fields correctly in SAP \u2713 Important tips with examples \u2713 Efficient management \u2713 Avoid errors \u2013 Learn more online now!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/currency-fields-in-sap-the-devil-is-in-the-details\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/currency-fields-in-sap-the-devil-is-in-the-details\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/currency-fields-in-sap-the-devil-is-in-the-details\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2014\\\/02\\\/20140205_Waehrungsfelder_EN_V1.0.png\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2014\\\/02\\\/20140205_Waehrungsfelder_EN_V1.0.png\",\"width\":1500,\"height\":1044},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/currency-fields-in-sap-the-devil-is-in-the-details\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Currency fields in SAP\u00ae &#8211; the devil is in the details\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"name\":\"dab\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\",\"name\":\"dab\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"width\":2560,\"height\":1463,\"caption\":\"dab\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Currency fields in SAP \u2013 the devil is in the details","description":"Using currency fields correctly in SAP \u2713 Important tips with examples \u2713 Efficient management \u2713 Avoid errors \u2013 Learn more online now!","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:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/","og_locale":"en_US","og_type":"article","og_title":"Currency fields in SAP \u2013 the devil is in the details","og_description":"Using currency fields correctly in SAP \u2713 Important tips with examples \u2713 Efficient management \u2713 Avoid errors \u2013 Learn more online now!","og_url":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/","og_site_name":"dab","article_modified_time":"2025-09-12T13:34:23+00:00","og_image":[{"width":1500,"height":1044,"url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2014\/02\/20140205_Waehrungsfelder_EN_V1.0.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/","url":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/","name":"Currency fields in SAP \u2013 the devil is in the details","isPartOf":{"@id":"https:\/\/www.dab-europe.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/#primaryimage"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2014\/02\/20140205_Waehrungsfelder_EN_V1.0.png","datePublished":"2014-02-05T07:02:00+00:00","dateModified":"2025-09-12T13:34:23+00:00","description":"Using currency fields correctly in SAP \u2713 Important tips with examples \u2713 Efficient management \u2713 Avoid errors \u2013 Learn more online now!","breadcrumb":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/#primaryimage","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2014\/02\/20140205_Waehrungsfelder_EN_V1.0.png","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2014\/02\/20140205_Waehrungsfelder_EN_V1.0.png","width":1500,"height":1044},{"@type":"BreadcrumbList","@id":"https:\/\/www.dab-europe.com\/en\/articles\/currency-fields-in-sap-the-devil-is-in-the-details\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dab-europe.com\/en\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.dab-europe.com\/en\/articles\/"},{"@type":"ListItem","position":3,"name":"Currency fields in SAP\u00ae &#8211; the devil is in the details"}]},{"@type":"WebSite","@id":"https:\/\/www.dab-europe.com\/en\/#website","url":"https:\/\/www.dab-europe.com\/en\/","name":"dab","description":"","publisher":{"@id":"https:\/\/www.dab-europe.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dab-europe.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dab-europe.com\/en\/#organization","name":"dab","url":"https:\/\/www.dab-europe.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","width":2560,"height":1463,"caption":"dab"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles\/2010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles"}],"about":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/types\/articles"}],"author":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/users\/2"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media\/7831"}],"wp:attachment":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media?parent=2010"}],"wp:term":[{"taxonomy":"articles_category","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_category?post=2010"},{"taxonomy":"articles_tag","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_tag?post=2010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}