{"id":604,"date":"2017-05-27T19:55:24","date_gmt":"2017-05-27T17:55:24","guid":{"rendered":"http:\/\/www.esfoor.fi\/en\/?p=604"},"modified":"2018-04-14T13:36:13","modified_gmt":"2018-04-14T11:36:13","slug":"sap-query-additional-fields","status":"publish","type":"post","link":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/","title":{"rendered":"SAP Query: additional fields (posting period, fiscal year)"},"content":{"rendered":"<p>Accounting asks you to\u00a0add month (posting period) and year (fiscal year) to the billing query. You\u00a0find both fields in\u00a0the\u00a0billing header table\u00a0VBRK.\u00a0 The bad thing is that both Posting period (POPER) and Fiscal year (GJAHR) are empty. What to do? You can add these fields to the query using SAP Query: additional fields functionality.<\/p>\n<p>Invoice date is the only date in the query .\u00a0To get the figures for a certain month or year, you must\u00a0enter a date intervall\u00a0in the report selection. Totals or\u00a0subtotals by period are no possible. The period\u00a0\u00a0is not a \u00a0possible selection criteria, either.<\/p>\n<p>Is it possible to derive the period from the billing date? SAP Query: additional fields solves the problem. In the example below we add two additional fields (month and year) to the query. The values for these fields come from the invoice date VBRP-FKDAT, which is in the database in format YYYMMDD. The first four characters (YYYY) define the year and the next two (MM) the month. With a small code snippet these can be added to the infoset.<\/p>\n<hr noshade=\"noshade\" width=\"100%\" \/>\n<h4><a href=\"http:\/\/www.esfoor.fi\/files\/REP_SAP_Query_Change_Additional_Fields_period.html\">Additional fields (posting period and fiscal year)<\/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":624,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,15,91],"tags":[70],"class_list":["post-604","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all-materials","category-reporting","category-sap-query","tag-sap-query-additional-fields-period"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SAP Query:\u00a0additional fields (posting period and fiscal year)<\/title>\n<meta name=\"description\" content=\"The fields VBRK-POPER and GJAHR are empty. How can you get the posting period and fiscal year to the query? SAP Query: additional fields solves the problem.\" \/>\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\/27\/sap-query-additional-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP Query:\u00a0additional fields (posting period and fiscal year)\" \/>\n<meta property=\"og:description\" content=\"The fields VBRK-POPER and GJAHR are empty. How can you get the posting period and fiscal year to the query? SAP Query: additional fields solves the problem.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"Esfoor\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-27T17:55:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-04-14T11:36:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Change_query_test_ZMM_ZYY.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1003\" \/>\n\t<meta property=\"og:image:height\" content=\"118\" \/>\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\\\/27\\\/sap-query-additional-fields\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/\"},\"author\":{\"name\":\"Ritva\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"headline\":\"SAP Query: additional fields (posting period, fiscal year)\",\"datePublished\":\"2017-05-27T17:55:24+00:00\",\"dateModified\":\"2018-04-14T11:36:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/\"},\"wordCount\":201,\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/05\\\/SQ_Change_query_test_ZMM_ZYY.png\",\"keywords\":[\"SAP Query: Additional Fields (Period)\"],\"articleSection\":[\"Materials\",\"Reporting\",\"SAP Query\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/\",\"name\":\"SAP Query:\u00a0additional fields (posting period and fiscal year)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/05\\\/SQ_Change_query_test_ZMM_ZYY.png\",\"datePublished\":\"2017-05-27T17:55:24+00:00\",\"dateModified\":\"2018-04-14T11:36:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"description\":\"The fields VBRK-POPER and GJAHR are empty. How can you get the posting period and fiscal year to the query? SAP Query: additional fields solves the problem.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/05\\\/SQ_Change_query_test_ZMM_ZYY.png\",\"contentUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/05\\\/SQ_Change_query_test_ZMM_ZYY.png\",\"width\":1003,\"height\":118,\"caption\":\"SAP Query: additional fields (Month, Year)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/27\\\/sap-query-additional-fields\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP Query: additional fields (posting period, fiscal year)\"}]},{\"@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:\u00a0additional fields (posting period and fiscal year)","description":"The fields VBRK-POPER and GJAHR are empty. How can you get the posting period and fiscal year to the query? SAP Query: additional fields solves the problem.","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\/27\/sap-query-additional-fields\/","og_locale":"en_US","og_type":"article","og_title":"SAP Query:\u00a0additional fields (posting period and fiscal year)","og_description":"The fields VBRK-POPER and GJAHR are empty. How can you get the posting period and fiscal year to the query? SAP Query: additional fields solves the problem.","og_url":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/","og_site_name":"Esfoor","article_published_time":"2017-05-27T17:55:24+00:00","article_modified_time":"2018-04-14T11:36:13+00:00","og_image":[{"width":1003,"height":118,"url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Change_query_test_ZMM_ZYY.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\/27\/sap-query-additional-fields\/#article","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/"},"author":{"name":"Ritva","@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"headline":"SAP Query: additional fields (posting period, fiscal year)","datePublished":"2017-05-27T17:55:24+00:00","dateModified":"2018-04-14T11:36:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/"},"wordCount":201,"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Change_query_test_ZMM_ZYY.png","keywords":["SAP Query: Additional Fields (Period)"],"articleSection":["Materials","Reporting","SAP Query"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/","url":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/","name":"SAP Query:\u00a0additional fields (posting period and fiscal year)","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/#primaryimage"},"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Change_query_test_ZMM_ZYY.png","datePublished":"2017-05-27T17:55:24+00:00","dateModified":"2018-04-14T11:36:13+00:00","author":{"@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"description":"The fields VBRK-POPER and GJAHR are empty. How can you get the posting period and fiscal year to the query? SAP Query: additional fields solves the problem.","breadcrumb":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/#primaryimage","url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Change_query_test_ZMM_ZYY.png","contentUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Change_query_test_ZMM_ZYY.png","width":1003,"height":118,"caption":"SAP Query: additional fields (Month, Year)"},{"@type":"BreadcrumbList","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/27\/sap-query-additional-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esfoor.fi\/en\/"},{"@type":"ListItem","position":2,"name":"SAP Query: additional fields (posting period, fiscal year)"}]},{"@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\/604","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=604"}],"version-history":[{"count":25,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/604\/revisions"}],"predecessor-version":[{"id":1407,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/604\/revisions\/1407"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media\/624"}],"wp:attachment":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media?parent=604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/categories?post=604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/tags?post=604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}