{"id":820,"date":"2017-05-25T16:53:40","date_gmt":"2017-05-25T14:53:40","guid":{"rendered":"http:\/\/www.esfoor.fi\/en\/?p=820"},"modified":"2018-04-14T15:47:12","modified_gmt":"2018-04-14T13:47:12","slug":"sap-query-output-format","status":"publish","type":"post","link":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/","title":{"rendered":"SAP Query: Output Format"},"content":{"rendered":"<p>SAP Query: Output Format defines the look and formatting of a finished SAP Query report.\u00a0 The output format is selected on the report\u2019s selection screen.\u00a0 Output format ABAP list is defaulted.<\/p>\n<h3>SAP List Viewer<\/h3>\n<p>The output format &#8216;SAP List Viewer&#8217;, which uses the ALV functionality, frees you from the choices of the Basic List (order, sort, total).<\/p>\n<p>ALV functions allow you to order the columns, sort, filter and summarize\u00a0 their contents. You can save and choose between several layouts.<\/p>\n<h3>Saved Lists<\/h3>\n<p>Running queries can be very time and resource consuming. You consider running them in background. The result is disappointing. You can no longer edit or drill down. Even the output format &#8216;Spreadsheet&#8217; turns into plain Abap List.<\/p>\n<p>The best solution is to run the query in background with the option &#8220;Save with ID&#8221; option. This saves the output as a\u00a0&#8216;Saved list&#8217;. You can later access these from the query screen (SQ00\/Sq01) menu Goto\/Saved lists.<\/p>\n<p>If the query has been assigned to an Area menu, it has a transaction code. You can start &#8216;Saved list&#8217; from there, too.<\/p>\n<p>Below an example of a query transaction added to the user&#8217;s favorites.<\/p>\n<p><a href=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_query_saved_lists.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1408\" src=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_query_saved_lists-300x178.png\" alt=\"SAP Query: output format - saved lists\" width=\"300\" height=\"178\" srcset=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_query_saved_lists-300x178.png 300w, https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_query_saved_lists.png 653w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Right click the transaction and a menu, where &#8216;Saved Lists&#8217; is an option, opens.<\/p>\n<p>&nbsp;<\/p>\n<div>Read more about query output formats.<\/div>\n<div><\/div>\n<hr noshade=\"noshade\" width=\"100%\" \/>\n<h4><a href=\"http:\/\/www.esfoor.fi\/files\/REP_SAP_Query_output_formats.html\"><i class=\"icon-file-text-alt icon-sm\"><\/i> SAP Query Output\u00a0Options<\/a> <strong><span style=\"color: #ff0000;\">&lt;<\/span><span style=\"color: #ff0000;\">HTML&gt;<\/span><\/strong><\/h4>\n<hr noshade=\"noshade\" width=\"100%\" \/>\n","protected":false},"excerpt":{"rendered":"<p> [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":821,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,15,91],"tags":[95,98],"class_list":["post-820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all-materials","category-reporting","category-sap-query","tag-sap-query-output-format","tag-sap-query-saved-lists"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SAP Query: Output Format - Esfoor<\/title>\n<meta name=\"description\" content=\"The look and formatting of a finished SAP Query report varies based on the selected SAP Query Output Format on the report\u2019s selection screen.\u00a0\" \/>\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\/05\/25\/sap-query-output-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP Query: Output Format - Esfoor\" \/>\n<meta property=\"og:description\" content=\"The look and formatting of a finished SAP Query report varies based on the selected SAP Query Output Format on the report\u2019s selection screen.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/\" \/>\n<meta property=\"og:site_name\" content=\"Esfoor\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-25T14:53:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-04-14T13:47:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/SQ_query_output_format_options.png\" \/>\n\t<meta property=\"og:image:width\" content=\"759\" \/>\n\t<meta property=\"og:image:height\" content=\"238\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/\"},\"author\":{\"name\":\"Ritva\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"headline\":\"SAP Query: Output Format\",\"datePublished\":\"2017-05-25T14:53:40+00:00\",\"dateModified\":\"2018-04-14T13:47:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/\"},\"wordCount\":226,\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/06\\\/SQ_query_output_format_options.png\",\"keywords\":[\"SAP Query: Output Format\",\"SAP query: saved lists\"],\"articleSection\":[\"Materials\",\"Reporting\",\"SAP Query\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/\",\"name\":\"SAP Query: Output Format - Esfoor\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/06\\\/SQ_query_output_format_options.png\",\"datePublished\":\"2017-05-25T14:53:40+00:00\",\"dateModified\":\"2018-04-14T13:47:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"description\":\"The look and formatting of a finished SAP Query report varies based on the selected SAP Query Output Format on the report\u2019s selection screen.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/06\\\/SQ_query_output_format_options.png\",\"contentUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/06\\\/SQ_query_output_format_options.png\",\"width\":759,\"height\":238,\"caption\":\"SAP Query Output Format\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/25\\\/sap-query-output-format\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP Query: Output Format\"}]},{\"@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 Query: Output Format - Esfoor","description":"The look and formatting of a finished SAP Query report varies based on the selected SAP Query Output Format on the report\u2019s selection screen.\u00a0","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\/05\/25\/sap-query-output-format\/","og_locale":"en_US","og_type":"article","og_title":"SAP Query: Output Format - Esfoor","og_description":"The look and formatting of a finished SAP Query report varies based on the selected SAP Query Output Format on the report\u2019s selection screen.\u00a0","og_url":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/","og_site_name":"Esfoor","article_published_time":"2017-05-25T14:53:40+00:00","article_modified_time":"2018-04-14T13:47:12+00:00","og_image":[{"width":759,"height":238,"url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/SQ_query_output_format_options.png","type":"image\/png"}],"author":"Ritva","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ritva","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/#article","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/"},"author":{"name":"Ritva","@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"headline":"SAP Query: Output Format","datePublished":"2017-05-25T14:53:40+00:00","dateModified":"2018-04-14T13:47:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/"},"wordCount":226,"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/SQ_query_output_format_options.png","keywords":["SAP Query: Output Format","SAP query: saved lists"],"articleSection":["Materials","Reporting","SAP Query"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/","url":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/","name":"SAP Query: Output Format - Esfoor","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/#primaryimage"},"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/SQ_query_output_format_options.png","datePublished":"2017-05-25T14:53:40+00:00","dateModified":"2018-04-14T13:47:12+00:00","author":{"@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"description":"The look and formatting of a finished SAP Query report varies based on the selected SAP Query Output Format on the report\u2019s selection screen.\u00a0","breadcrumb":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/#primaryimage","url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/SQ_query_output_format_options.png","contentUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/SQ_query_output_format_options.png","width":759,"height":238,"caption":"SAP Query Output Format"},{"@type":"BreadcrumbList","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/25\/sap-query-output-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esfoor.fi\/en\/"},{"@type":"ListItem","position":2,"name":"SAP Query: Output Format"}]},{"@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\/820","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=820"}],"version-history":[{"count":19,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/820\/revisions"}],"predecessor-version":[{"id":1409,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/820\/revisions\/1409"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media\/821"}],"wp:attachment":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media?parent=820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/categories?post=820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/tags?post=820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}