{"id":590,"date":"2017-05-29T09:44:08","date_gmt":"2017-05-29T07:44:08","guid":{"rendered":"http:\/\/www.esfoor.fi\/en\/?p=590"},"modified":"2018-04-12T12:01:11","modified_gmt":"2018-04-12T10:01:11","slug":"sap-query-key-figure-signs","status":"publish","type":"post","link":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/","title":{"rendered":"SAP Query key figure signs"},"content":{"rendered":"

SAP stores all the\u00a0SD key figures\u00a0(net value, weight, volume, cost) in the data base as absolute values. In my billing query\u00a0I\u00a0had an invoice of 100 and a credit note of 100. Both with positive signs. In the query their sum was 200. Obviously\u00a0I need to do something.<\/p>\n

In the accounting document there is a special field(SHKZG)\u00a0that indicates whether\u00a0it is as\u00a0\u00a0debit or credit posting. Is there something similar in\u00a0billing document?<\/p>\n

In the billing header table (VBRK) there are no fields that uniquely determine the sign. Only the Billing Type (VBRK-FKART) and Document Category (VBRK-VBTYP)\u00a0could be used for this purpose. Disadvantage is that you need\u00a0to know, which types are used and which of them produce negative values.<\/p>\n

In t\"SAP<\/a>he item table (VBRP) there is are promising field VBRP-SHKZG with somewhat\u00a0strange name ‘Returns Item’. In accounting document\u00a0the field\u00a0 SHKZG indicates debit and credit. A closer look\u00a0at VBRP reveals that field SHKZG\u00a0does \u00a0identify the sign also in sales documents.\u00a0Value X indicates\u00a0 that the value is negative. Multiplication with -1 corrects the sign in the report.<\/p>\n

As I was unsure of the alternative values (A,B,X) I used QuickViewer to check the values in IDES and a couple of productive ECC systems. Billing types RE, G2, S1 all had value X in this field.<\/p>\n

Local Field solution<\/h3>\n

First\u00a0I\u00a0tried to solve the\u00a0sign problem at query level\u00a0using Local fields. The formulas for both Billing type (VBRK-FKART) and Returns Item (VBRP-SHKZG) worked fine. The shortage of Local field solution is the need to\u00a0define them separately<\/span> in every query.<\/p>\n

Additional Field solution<\/h3>\n

The ideal solution would be to include the definition in the InfoSet, but it requires coding. In Stephan Kaleske’s excellent book ‘SAP Query Reporting’ <\/a>I\u00a0learned how this is done using field SHKZG. I am\u00a0borrowing the code\u00a0 in\u00a0my query.<\/p>\n

You can check the result\u00a0in the picture above.<\/p>\n

Below you find two documents that describe both solutions.<\/p>\n

 <\/p>\n

\n

<\/i>\u00a0SAP Query VBRK_VBRP: Determine Key Figure signs using Local fields\u00a0<\/a><\/h4>\n

\u00a0SAP Query VBRK_VBRP: Determine Key Figure signs using Additional Fields<\/a><\/h4>\n
\n","protected":false},"excerpt":{"rendered":"

[…]<\/p>\n","protected":false},"author":3,"featured_media":591,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,15,91],"tags":[57,58,56],"class_list":["post-590","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all-materials","category-reporting","category-sap-query","tag-sap-query-additional-fields","tag-sap-query-key-figure-signs","tag-sap-query-local-fields"],"yoast_head":"\nSAP Query key figure signs - VBRP-SHKZG\u00a0- Esfoor<\/title>\n<meta name=\"description\" content=\"SAP Query Key figure signs: All SD key figures (net value, weight, volume, cost) have positive signs. Field VBRP-SHKZG indicates the sign.\" \/>\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\/29\/sap-query-key-figure-signs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP Query key figure signs - VBRP-SHKZG\u00a0- Esfoor\" \/>\n<meta property=\"og:description\" content=\"SAP Query Key figure signs: All SD key figures (net value, weight, volume, cost) have positive signs. Field VBRP-SHKZG indicates the sign.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/\" \/>\n<meta property=\"og:site_name\" content=\"Esfoor\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-29T07:44:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-04-12T10:01:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Query_Change_returns_item_report.png\" \/>\n\t<meta property=\"og:image:width\" content=\"972\" \/>\n\t<meta property=\"og:image:height\" content=\"134\" \/>\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\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/\"},\"author\":{\"name\":\"Ritva\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"headline\":\"SAP Query key figure signs\",\"datePublished\":\"2017-05-29T07:44:08+00:00\",\"dateModified\":\"2018-04-12T10:01:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/\"},\"wordCount\":361,\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/05\\\/SQ_Query_Change_returns_item_report.png\",\"keywords\":[\"SAP Query: Additional Fields\",\"SAP Query: Key figure Signs\",\"SAP Query: Local Fields\"],\"articleSection\":[\"Materials\",\"Reporting\",\"SAP Query\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/\",\"name\":\"SAP Query key figure signs - VBRP-SHKZG\u00a0- Esfoor\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/05\\\/SQ_Query_Change_returns_item_report.png\",\"datePublished\":\"2017-05-29T07:44:08+00:00\",\"dateModified\":\"2018-04-12T10:01:11+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/#\\\/schema\\\/person\\\/5cfab60aa96362164c1e83f7bcb8f3f8\"},\"description\":\"SAP Query Key figure signs: All SD key figures (net value, weight, volume, cost) have positive signs. Field VBRP-SHKZG indicates the sign.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/05\\\/SQ_Query_Change_returns_item_report.png\",\"contentUrl\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2017\\\/05\\\/SQ_Query_Change_returns_item_report.png\",\"width\":972,\"height\":134,\"caption\":\"SAP Query Key figure signs\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/2017\\\/05\\\/29\\\/sap-query-key-figure-signs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.esfoor.fi\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP Query key figure signs\"}]},{\"@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 key figure signs - VBRP-SHKZG\u00a0- Esfoor","description":"SAP Query Key figure signs: All SD key figures (net value, weight, volume, cost) have positive signs. Field VBRP-SHKZG indicates the sign.","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\/29\/sap-query-key-figure-signs\/","og_locale":"en_US","og_type":"article","og_title":"SAP Query key figure signs - VBRP-SHKZG\u00a0- Esfoor","og_description":"SAP Query Key figure signs: All SD key figures (net value, weight, volume, cost) have positive signs. Field VBRP-SHKZG indicates the sign.","og_url":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/","og_site_name":"Esfoor","article_published_time":"2017-05-29T07:44:08+00:00","article_modified_time":"2018-04-12T10:01:11+00:00","og_image":[{"width":972,"height":134,"url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Query_Change_returns_item_report.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\/05\/29\/sap-query-key-figure-signs\/#article","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/"},"author":{"name":"Ritva","@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"headline":"SAP Query key figure signs","datePublished":"2017-05-29T07:44:08+00:00","dateModified":"2018-04-12T10:01:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/"},"wordCount":361,"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Query_Change_returns_item_report.png","keywords":["SAP Query: Additional Fields","SAP Query: Key figure Signs","SAP Query: Local Fields"],"articleSection":["Materials","Reporting","SAP Query"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/","url":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/","name":"SAP Query key figure signs - VBRP-SHKZG\u00a0- Esfoor","isPartOf":{"@id":"https:\/\/www.esfoor.fi\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/#primaryimage"},"image":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Query_Change_returns_item_report.png","datePublished":"2017-05-29T07:44:08+00:00","dateModified":"2018-04-12T10:01:11+00:00","author":{"@id":"https:\/\/www.esfoor.fi\/en\/#\/schema\/person\/5cfab60aa96362164c1e83f7bcb8f3f8"},"description":"SAP Query Key figure signs: All SD key figures (net value, weight, volume, cost) have positive signs. Field VBRP-SHKZG indicates the sign.","breadcrumb":{"@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/#primaryimage","url":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Query_Change_returns_item_report.png","contentUrl":"https:\/\/www.esfoor.fi\/en\/wp-content\/uploads\/sites\/3\/2017\/05\/SQ_Query_Change_returns_item_report.png","width":972,"height":134,"caption":"SAP Query Key figure signs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.esfoor.fi\/en\/2017\/05\/29\/sap-query-key-figure-signs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esfoor.fi\/en\/"},{"@type":"ListItem","position":2,"name":"SAP Query key figure signs"}]},{"@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\/590","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=590"}],"version-history":[{"count":22,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/590\/revisions"}],"predecessor-version":[{"id":601,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/posts\/590\/revisions\/601"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media\/591"}],"wp:attachment":[{"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/media?parent=590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/categories?post=590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esfoor.fi\/en\/wp-json\/wp\/v2\/tags?post=590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}