{"id":11116,"date":"2019-08-08T11:00:00","date_gmt":"2019-08-08T11:00:00","guid":{"rendered":"https:\/\/staging.zapliance.com\/?p=11116"},"modified":"2022-08-26T13:28:09","modified_gmt":"2022-08-26T13:28:09","slug":"journal-entry-testing-the-best-queries-about-money-in-sap","status":"publish","type":"post","link":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/","title":{"rendered":"Journal Entry Testing: The Best Queries about Money in SAP"},"content":{"rendered":"\n<p>In German, there is a saying that everybody is going to be familiar with when the holiday season comes to an end, and it goes something like this: When the money runs out, there is still so much of the month left to go [<em>\u201eAm Ende des Geldes ist noch so viel Monat \u00fcbrig\u201d<\/em>]. What is often used as a phrase in private life can quickly become important in companies too. Because, in the end, it all comes down to liquidity. Or to put it another way: without money, you are nothing. An auditor should therefore always keep an eye on the bank accounts in financial accounting. So, in this article, I\u2019ll be showing you how you can analyze payouts in SAP.<\/p>\n\n\n\n<p>Reconciling cash accounts is a well-known audit procedure. If a balance can be reconciled that of course indicates that the balance is correct, but ultimately it is also of interest to see what a closer analysis of disbursements can reveal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cash accounts in SAP<\/h2>\n\n\n\n<p>First of all, it is important to identify the money accounts in the chart of accounts. Of course, you can now go through the chart of accounts and identify the cash accounts using the account names. But isn\u2019t there an easier way? In fact, the financial accounting accounts in the chart of accounts that represent cash accounts should also be customized as such in the chart of accounts. You can therefore recognize cash accounts in company code-specific \u201cCustomizing\u201d account in the table SKB1. The field XGKON=\u2019X\u2019 means that it is a cash account.<\/p>\n\n\n\n<p>The following SQL query determines how many documents were posted to the respective cash account for a particular company code and fiscal year. This gives you an indication of the \u201cimportance\u201d of a cash account. You can try out the query yourself in SAP by executing the \u201cDBACOCKPIT\u201d transaction and then navigating to \u201cSQL Editor\u201d via \u201cDiagnostics\u201d:<\/p>\n\n\n\n<p><code>SELECT HKONT, SKAT.TXT50, COUNT(DISTINCT BELNR) AS Anzahl_Belege<br>FROM BSEG<br>JOIN T001 ON (BSEG.MANDT = T001.MANDT AND BSEG.BUKRS = T001.BUKRS)<br>JOIN SKB1 ON (BSEG.MANDT = SKB1.MANDT AND BSEG.BUKRS = SKB1.BUKRS AND BSEG.HKONT = SKB1.SAKNR)<br>LEFT JOIN SKAT ON (SKAT.MANDT = BSEG.MANDT AND SKAT.KTOPL = T001.KTOPL AND SKAT.SAKNR = BSEG.HKONT AND SKAT.SPRAS = 'D')<br>WHERE SKB1.XGKON = 'X' AND BSEG.MANDT = '800'&nbsp;AND BSEG.BUKRS = '1000'&nbsp;AND GJAHR =&nbsp;2007<br>GROUP BY HKONT, SKAT.TXT50<br>ORDER BY COUNT(DISTINCT BELNR) DESC<\/code><\/p>\n\n\n\n<p>As always: remember to change the client (MANDT), company code (BUKRS) and fiscal year (GJAHR) to your object of investigation.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>HKONT<\/th><th>TXT50<\/th><th>Anzahl_Belege<\/th><\/tr><tr><td>113103<\/td><td>Deutsche Bank \u2013 foreign bank transfers<\/td><td>176<\/td><\/tr><tr><td>113102<\/td><td>Deutsche Bank \u2013 domestic bank transfers<\/td><td>18<\/td><\/tr><tr><td>113100<\/td><td>Deutsche Bank (domestic)<\/td><td>6<\/td><\/tr><tr><td>113130<\/td><td>Deutsche Bank \u2013 outgoing cash<\/td><td>2<\/td><\/tr><tr><td>119999<\/td><td>Derivative clearing account<\/td><td>2<\/td><\/tr><tr><td>113300<\/td><td>Commerzbank Frankfurt<\/td><td>2<\/td><\/tr><tr><td>113108<\/td><td>Deutsche Bank \u2013 checks received<\/td><td>1<\/td><\/tr><tr><td>113131<\/td><td>Deutsche Bank \u2013 incoming cash<\/td><td>1<\/td><\/tr><tr><td>\u2026<\/td><td>\u2026<\/td><td>\u2026<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>As you can see, Deutsche Bank is the most widely used bank.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The largest disbursements<\/h2>\n\n\n\n<p>We now want to get an overview of the payouts posted to the cash accounts. Payouts can be distinguished by the fact that they are credited, i.e. passively \u201coutgoing\u201d. Furthermore, we stratify all positions on the accounts into strata by thousands and thus obtain the number of documents per each stratum of \u20ac 1,000 and their total amount. The query for this is shown below and is an adaptation of the query above:<\/p>\n\n\n\n<p><code>SELECT HKONT, SKAT.TXT50, ROUND(DMBTR\/1000, 0, ROUND_DOWN) AS Betragsschichten, COUNT(DISTINCT BELNR) AS Anzahl_Belege, SUM(DMBTR) AS SUMME_IN_EUR FROM BSEG<br>JOIN T001 ON (BSEG.MANDT = T001.MANDT AND T001.BUKRS = BSEG.BUKRS)<br>JOIN SKB1 ON (BSEG.MANDT = SKB1.MANDT AND BSEG.BUKRS = SKB1.BUKRS AND BSEG.HKONT = SKB1.SAKNR)<br>LEFT JOIN SKAT ON (SKAT.MANDT = BSEG.MANDT AND SKAT.KTOPL = T001.KTOPL AND SKAT.SAKNR = BSEG.HKONT AND SKAT.SPRAS = 'D' )<br>WHERE SKB1.XGKON = 'X' AND BSEG.MANDT = '800' AND BSEG.BUKRS = '1000' AND GJAHR =&nbsp;2007<br>AND SHKZG = 'H'<br>GROUP BY HKONT, SKAT.TXT50, ROUND(DMBTR\/1000, 0, ROUND_DOWN)<br>ORDER BY HKONT, ROUND(DMBTR\/1000, 0, ROUND_DOWN)<\/code><\/p>\n\n\n\n<p>As always: remember to change the client (MANDT), company code (BUKRS) and fiscal year (GJAHR) to your object of investigation.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>HKONT<\/th><th>TXT50<\/th><th>Amount by strata<\/th><th>Document_<br>Amounts<\/th><th>SUM_IN_<br>EUR<\/th><\/tr><tr><td>113100<\/td><td>Deutsche Bank (domestic)<\/td><td>1<\/td><td>1<\/td><td>1.551,03<\/td><\/tr><tr><td>113100<\/td><td>Deutsche Bank (domestic)<\/td><td>4<\/td><td>1<\/td><td>4.599,00<\/td><\/tr><tr><td>113100<\/td><td>Deutsche Bank (domestic)<\/td><td>127<\/td><td>1<\/td><td>127.917,30<\/td><\/tr><tr><td>113100<\/td><td>Deutsche Bank (domestic)<\/td><td>567<\/td><td>1<\/td><td>567.110,00<\/td><\/tr><tr><td>113100<\/td><td>Deutsche Bank (domestic)<\/td><td>890<\/td><td>1<\/td><td>890.900,00<\/td><\/tr><tr><td>113100<\/td><td>Deutsche Bank (domestic)<\/td><td>126753<\/td><td>1<\/td><td>126.753.714,81<\/td><\/tr><tr><td>113102<\/td><td>Deutsche Bank \u2013 domestic bank transfers<\/td><td>0<\/td><td>6<\/td><td>157,00<\/td><\/tr><tr><td>113102<\/td><td>Deutsche Bank \u2013 domestic bank transfers<\/td><td>2700<\/td><td>3<\/td><td>8.100.028,00<\/td><\/tr><tr><td>113102<\/td><td>Deutsche Bank \u2013 domestic bank transfers<\/td><td>4000<\/td><td>2<\/td><td>8.000.000,00<\/td><\/tr><tr><td>113102<\/td><td>Deutsche Bank \u2013 domestic bank transfers<\/td><td>4834<\/td><td>1<\/td><td>4.834.625,00 \u20ac<\/td><\/tr><tr><td>113102<\/td><td>Deutsche Bank \u2013 domestic bank transfers<\/td><td>5000<\/td><td>3<\/td><td>15.000.000,00<\/td><\/tr><tr><td>113102<\/td><td>Deutsche Bank \u2013 domestic bank transfers<\/td><td>19133<\/td><td>1<\/td><td>19.133.380,07<\/td><\/tr><tr><td>\u2026<\/td><td>\u2026<\/td><td>\u2026<\/td><td>\u2026<\/td><td>\u2026<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>The amounts per strata (third column) are sorted in ascending order for each account. The auditor should pay particular attention to clear jumps between the total amounts of strata. With the money account \u201c113100 Deutsche Bank Inland\u201d, for example, there is one stratum with only one payment of approx. \u20ac 890,900 and then the next stratum is \u20ac 126,753 thousand. This is a blatant leap and the auditor should take a closer look at such \u201cdiscontinuities\u201d. Other clearly visible jumps are marked in yellow. Finally, we use the data as a basis to create a&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/en.wikipedia.org\/wiki\/Histogram\" target=\"_blank\">histogram&nbsp;<\/a>with the query.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In German, there is a saying that everybody is going to be familiar with when the holiday season comes to an end, and it goes something like this: When the money runs out, there is still so much of the month left to go [\u201eAm Ende des Geldes ist noch so viel Monat \u00fcbrig\u201d]. What [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":10699,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[38,37,40],"tags":[],"class_list":["post-11116","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-en-audit","category-en-compliance","category-en-finance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Journal Entry Testing: The Best Queries about Money in SAP - zapliance<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Journal Entry Testing: The Best Queries about Money in SAP - zapliance\" \/>\n<meta property=\"og:description\" content=\"In German, there is a saying that everybody is going to be familiar with when the holiday season comes to an end, and it goes something like this: When the money runs out, there is still so much of the month left to go [\u201eAm Ende des Geldes ist noch so viel Monat \u00fcbrig\u201d]. What [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/\" \/>\n<meta property=\"og:site_name\" content=\"zapliance\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-08T11:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-26T13:28:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"962\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nick Gehrke\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nick Gehrke\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/\"},\"author\":{\"name\":\"Nick Gehrke\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/#\/schema\/person\/8082e13c2d71610651baf9627ea0e18f\"},\"headline\":\"Journal Entry Testing: The Best Queries about Money in SAP\",\"datePublished\":\"2019-08-08T11:00:00+00:00\",\"dateModified\":\"2022-08-26T13:28:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/\"},\"wordCount\":644,\"publisher\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"articleSection\":[\"Audit\",\"Compliance\",\"Finance\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/\",\"url\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/\",\"name\":\"Journal Entry Testing: The Best Queries about Money in SAP - zapliance\",\"isPartOf\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"datePublished\":\"2019-08-08T11:00:00+00:00\",\"dateModified\":\"2022-08-26T13:28:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#primaryimage\",\"url\":\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"contentUrl\":\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"width\":2400,\"height\":962},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/staging.zapliance.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Journal Entry Testing: The Best Queries about Money in SAP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/#website\",\"url\":\"https:\/\/staging.zapliance.com\/en\/\",\"name\":\"zapliance\",\"description\":\"Be the agent of change\",\"publisher\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/staging.zapliance.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/#organization\",\"name\":\"zapliance\",\"url\":\"https:\/\/staging.zapliance.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg\",\"contentUrl\":\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg\",\"width\":200,\"height\":45,\"caption\":\"zapliance\"},\"image\":{\"@id\":\"https:\/\/staging.zapliance.com\/en\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/#\/schema\/person\/8082e13c2d71610651baf9627ea0e18f\",\"name\":\"Nick Gehrke\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/staging.zapliance.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg\",\"contentUrl\":\"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg\",\"caption\":\"Nick Gehrke\"},\"description\":\"is Chief of Data &amp; Knowledge and Co-Founder at zapliance as well as Professor of Information Systems with a Big 4 background. He prefers to work as a business information scientist and tax consultant at the converging points of finance, accounting, taxation, audit and ERP systems, data science and information technology.\",\"url\":\"https:\/\/staging.zapliance.com\/en\/blog\/author\/nick-gehrke\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Journal Entry Testing: The Best Queries about Money in SAP - zapliance","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Journal Entry Testing: The Best Queries about Money in SAP - zapliance","og_description":"In German, there is a saying that everybody is going to be familiar with when the holiday season comes to an end, and it goes something like this: When the money runs out, there is still so much of the month left to go [\u201eAm Ende des Geldes ist noch so viel Monat \u00fcbrig\u201d]. What [&hellip;]","og_url":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/","og_site_name":"zapliance","article_published_time":"2019-08-08T11:00:00+00:00","article_modified_time":"2022-08-26T13:28:09+00:00","og_image":[{"width":2400,"height":962,"url":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","type":"image\/png"}],"author":"Nick Gehrke","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nick Gehrke","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#article","isPartOf":{"@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/"},"author":{"name":"Nick Gehrke","@id":"https:\/\/staging.zapliance.com\/en\/#\/schema\/person\/8082e13c2d71610651baf9627ea0e18f"},"headline":"Journal Entry Testing: The Best Queries about Money in SAP","datePublished":"2019-08-08T11:00:00+00:00","dateModified":"2022-08-26T13:28:09+00:00","mainEntityOfPage":{"@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/"},"wordCount":644,"publisher":{"@id":"https:\/\/staging.zapliance.com\/en\/#organization"},"image":{"@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","articleSection":["Audit","Compliance","Finance"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/","url":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/","name":"Journal Entry Testing: The Best Queries about Money in SAP - zapliance","isPartOf":{"@id":"https:\/\/staging.zapliance.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#primaryimage"},"image":{"@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","datePublished":"2019-08-08T11:00:00+00:00","dateModified":"2022-08-26T13:28:09+00:00","breadcrumb":{"@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#primaryimage","url":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","contentUrl":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","width":2400,"height":962},{"@type":"BreadcrumbList","@id":"https:\/\/staging.zapliance.com\/en\/blog\/journal-entry-testing-the-best-queries-about-money-in-sap\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/staging.zapliance.com\/en\/"},{"@type":"ListItem","position":2,"name":"Journal Entry Testing: The Best Queries about Money in SAP"}]},{"@type":"WebSite","@id":"https:\/\/staging.zapliance.com\/en\/#website","url":"https:\/\/staging.zapliance.com\/en\/","name":"zapliance","description":"Be the agent of change","publisher":{"@id":"https:\/\/staging.zapliance.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/staging.zapliance.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/staging.zapliance.com\/en\/#organization","name":"zapliance","url":"https:\/\/staging.zapliance.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/staging.zapliance.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg","contentUrl":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg","width":200,"height":45,"caption":"zapliance"},"image":{"@id":"https:\/\/staging.zapliance.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/staging.zapliance.com\/en\/#\/schema\/person\/8082e13c2d71610651baf9627ea0e18f","name":"Nick Gehrke","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/staging.zapliance.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg","contentUrl":"https:\/\/staging.zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_4_1657803044-96x96.jpg","caption":"Nick Gehrke"},"description":"is Chief of Data &amp; Knowledge and Co-Founder at zapliance as well as Professor of Information Systems with a Big 4 background. He prefers to work as a business information scientist and tax consultant at the converging points of finance, accounting, taxation, audit and ERP systems, data science and information technology.","url":"https:\/\/staging.zapliance.com\/en\/blog\/author\/nick-gehrke\/"}]}},"views":1430,"_links":{"self":[{"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/comments?post=11116"}],"version-history":[{"count":1,"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11116\/revisions"}],"predecessor-version":[{"id":11117,"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11116\/revisions\/11117"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/media\/10699"}],"wp:attachment":[{"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/media?parent=11116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/categories?post=11116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.zapliance.com\/en\/wp-json\/wp\/v2\/tags?post=11116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}