{"id":110,"date":"2017-04-20T11:00:52","date_gmt":"2017-04-20T09:00:52","guid":{"rendered":"http:\/\/www.siliconlabs.fi\/wp\/?p=110"},"modified":"2018-03-18T11:53:27","modified_gmt":"2018-03-18T09:53:27","slug":"reporting-in-sap-erp","status":"publish","type":"post","link":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/","title":{"rendered":"SAP ERP Reporting tools"},"content":{"rendered":"<p>Finance users often find the SAP standard reports <span id=\"result_box\" class=\"short_text\" lang=\"en\">insufficient<\/span>. The processes are integrated, but reporting is not. The reports are module specific\u00a0and don&#8217;t support\u00a0merging data from different sources into one report.\u00a0\u00a0This explains the enormous\u00a0popularity of Excel sheets.<\/p>\n<p>O<span id=\"result_box\" class=\"short_text\" lang=\"en\">ver the years<\/span> SAP has\u00a0added ALV (ABAP List Viewer) functionality to\u00a0several\u00a0 reports.\u00a0ALV enables interactive layout functions for such as sorting, filtering, summation, moving or hiding columns, etc. Yet many FI\u00a0reports offer very little flexibility.<\/p>\n<p>Of course there\u00a0are BW, Business Objects, BPC plus\u00a0non-sap reporting environments for custom reporting.\u00a0 But t<span id=\"result_box\" class=\"short_text\" lang=\"en\">heir use requires a professionals, report definitions, interfaces, mappings, blueprints, projects&#8230; What if you only\u00a0want an answer to a simple question or need an urgent ad-hoc report for your boss.<\/span>\u00a0Or your Company has not invested in these tools.<\/p>\n<p>SAP does provide\u00a0also reporting tools that enable users\u00a0without programming skills to build their own reports. Data Browser (SE16\/SE16N), SAP QuickViewer, SAP Query, and Report Painter are examples of these. They are\u00a0great tools for ad hoc reporting, problem solving and error hunting in the daily work of the financial and controlling departments. Also SAP has used\u00a0 these tools in\u00a0standard reports. Most CO reports are Report Painter reports. Drill Down reports are\u00a0common in financials, profit center accounting and COPA. HR and asset accounting reports are SAP Queries.<\/p>\n<p>If you are a programmer, you are\u00a0probably laughing.\u00a0 Why not quickly make an ABAP-program? Well, first of all I am not a programmer, secondly I never had a budget. The tools I had access to were SAP Query and Report Painter. Luckily in the early SAP era, I had the luxury of SAP ALL authorization. Very seldom I had to admit that it\u00a0is impossible to get the information my organization wanted out of SAP.<\/p>\n<h3>CO Reporting in SAP ERP<\/h3>\n<div class=\"ead-preview\"><div class=\"ead-document\" style=\"position: relative;padding-top: 90%;\"><div class=\"ead-iframe-wrapper\"><iframe src=\"\/\/docs.google.com\/viewer?url=https%3A%2F%2Fwww.esfoor.fi%2Fen%2Fwp-content%2Fuploads%2Fsites%2F3%2F2017%2F04%2FEN_CO_REPORTING_SAPERP.pdf&amp;embedded=true&amp;hl=en\" title=\"Embedded Document\" class=\"ead-iframe\" style=\"width: 100%;height: 100%;border: none;position: absolute;left: 0;top: 0;visibility: hidden;\"><\/iframe><\/div>\t\t\t<div class=\"ead-document-loading\" style=\"width:100%;height:100%;position:absolute;left:0;top:0;z-index:10;\">\n\t\t\t\t<div class=\"ead-loading-wrap\">\n\t\t\t\t\t<div class=\"ead-loading-main\">\n\t\t\t\t\t\t<div class=\"ead-loading\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.esfoor.fi\/en\/wp-content\/plugins\/embed-any-document\/images\/loading.svg\" width=\"55\" height=\"55\" alt=\"Loader\">\n\t\t\t\t\t\t\t<span>Loading...<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"ead-loading-foot\">\n\t\t\t\t\t\t<div class=\"ead-loading-foot-title\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.esfoor.fi\/en\/wp-content\/plugins\/embed-any-document\/images\/EAD-logo.svg\" alt=\"EAD Logo\" width=\"36\" height=\"23\"\/>\n\t\t\t\t\t\t\t<span>Taking too long?<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<div class=\"ead-document-btn ead-reload-btn\" role=\"button\">\n\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.esfoor.fi\/en\/wp-content\/plugins\/embed-any-document\/images\/reload.svg\" alt=\"Reload\" width=\"12\" height=\"12\"\/> Reload document\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<span>|<\/span>\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/04\/EN_CO_REPORTING_SAPERP.pdf\" class=\"ead-document-btn\" target=\"_blank\">\n\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.esfoor.fi\/en\/wp-content\/plugins\/embed-any-document\/images\/open.svg\" alt=\"Open\" width=\"12\" height=\"12\"\/> Open in new tab\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div><p class=\"embed_download\"><a href=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/04\/EN_CO_REPORTING_SAPERP.pdf\" download>Download [1.49 MB] <\/a><\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p> [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":458,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,15,88],"tags":[66],"class_list":["post-110","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all-materials","category-reporting","category-sap-erp-reprorting-tools","tag-sap-reporting-tools"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SAP ERP Reporting tools - Esfoor<\/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:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP ERP Reporting tools - Esfoor\" \/>\n<meta property=\"og:description\" content=\"[&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Esfoor\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-20T09:00:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-03-18T09:53:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/04\/REP_reporting_choices.png\" \/>\n\t<meta property=\"og:image:width\" content=\"472\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ritva\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ritva\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/\"},\"author\":{\"name\":\"Ritva\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"headline\":\"SAP ERP Reporting tools\",\"datePublished\":\"2017-04-20T09:00:52+00:00\",\"dateModified\":\"2018-03-18T09:53:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/\"},\"wordCount\":331,\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/04\\\/REP_reporting_choices.png\",\"keywords\":[\"SAP Reporting Tools\"],\"articleSection\":[\"Materials\",\"Reporting\",\"SAP ERP Reporting Tools\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/\",\"name\":\"SAP ERP Reporting tools - Esfoor\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/04\\\/REP_reporting_choices.png\",\"datePublished\":\"2017-04-20T09:00:52+00:00\",\"dateModified\":\"2018-03-18T09:53:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/04\\\/REP_reporting_choices.png\",\"contentUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/04\\\/REP_reporting_choices.png\",\"width\":472,\"height\":300,\"caption\":\"SAP ERP Reporting tools\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/04\\\/20\\\/reporting-in-sap-erp\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP ERP Reporting tools\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/\",\"name\":\"Esfoor\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\",\"name\":\"Ritva\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g\",\"caption\":\"Ritva\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP ERP Reporting tools - Esfoor","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.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/","og_locale":"en_US","og_type":"article","og_title":"SAP ERP Reporting tools - Esfoor","og_description":"[&hellip;]","og_url":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/","og_site_name":"Esfoor","article_published_time":"2017-04-20T09:00:52+00:00","article_modified_time":"2018-03-18T09:53:27+00:00","og_image":[{"width":472,"height":300,"url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/04\/REP_reporting_choices.png","type":"image\/png"}],"author":"Ritva","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ritva","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/#article","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/"},"author":{"name":"Ritva","@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"headline":"SAP ERP Reporting tools","datePublished":"2017-04-20T09:00:52+00:00","dateModified":"2018-03-18T09:53:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/"},"wordCount":331,"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/04\/REP_reporting_choices.png","keywords":["SAP Reporting Tools"],"articleSection":["Materials","Reporting","SAP ERP Reporting Tools"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/","url":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/","name":"SAP ERP Reporting tools - Esfoor","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/04\/REP_reporting_choices.png","datePublished":"2017-04-20T09:00:52+00:00","dateModified":"2018-03-18T09:53:27+00:00","author":{"@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"breadcrumb":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/#primaryimage","url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/04\/REP_reporting_choices.png","contentUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/04\/REP_reporting_choices.png","width":472,"height":300,"caption":"SAP ERP Reporting tools"},{"@type":"BreadcrumbList","@id":"https:\/\/www.esfoor.fi\/en\/2017\/04\/20\/reporting-in-sap-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esfoor.fi\/en\/"},{"@type":"ListItem","position":2,"name":"SAP ERP Reporting tools"}]},{"@type":"WebSite","@id":"https:\/\/www.esfoor.fi\/en\/#website","url":"https:\/\/www.esfoor.fi\/en\/","name":"Esfoor","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esfoor.fi\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8","name":"Ritva","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a17e2ad0884bf13057a20e1b29af1b27511ad1869de1ac25410e5eee52429e5a?s=96&d=mm&r=g","caption":"Ritva"}}]}},"_links":{"self":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/comments?post=110"}],"version-history":[{"count":30,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/110\/revisions"}],"predecessor-version":[{"id":1341,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/110\/revisions\/1341"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media\/458"}],"wp:attachment":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media?parent=110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/categories?post=110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/tags?post=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}