{"id":11114,"date":"2019-08-22T11:00:00","date_gmt":"2019-08-22T11:00:00","guid":{"rendered":"https:\/\/zapliance.com\/?p=11114"},"modified":"2022-08-26T13:27:50","modified_gmt":"2022-08-26T13:27:50","slug":"account-movements-on-the-sap-test-bench","status":"publish","type":"post","link":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/","title":{"rendered":"Account movements on the SAP test bench"},"content":{"rendered":"\n

Account movements, cash flow, debit, credit, credit or debit, you name it. Let\u2019s take a look today at exactly what somehow connects them all: Movements on accounts. To do this, we will first take a look at all the accounts, select three interesting examples and take a closer look at them in a time series. That sounds complex and complicated at first, but thanks to the finished SQL statements and a few tricks in Excel it\u2019s not at all.<\/p>\n\n\n\n

The necessary basics for accounts in SAP<\/h2>\n\n\n\n

Let\u2019s start with the necessary tables and fields before we export the files and visualize them in Excel. The following queries can easily be tried out via the transaction \u201cDBACOCKPIT\u201d and then via the navigation \u201cDiagnosis\u201d to the \u201cSQL-Editor\u201d. All queries were also tested on a HANA database.<\/p>\n\n\n\n

In order to apply the analysis only to accounts that were actually used in the financial year to be examined, we first use the table BSEG (document segment accounting \u2013 FI) and restrict the analysis to the object to be examined (client 800, company code 1000 and financial year 2017) as follows:<\/p>\n\n\n\n

SELECT DISTINCT BSEG.HKONT FROM BSEG
WHERE BSEG.MANDT = '800' AND BSEG.BUKRS='1000' AND BSEG.GJAHR=2017<\/code><\/p>\n\n\n\n

However, the query only provides us with the number of the G\/L account for General Ledger Accounting in SAP without the name:<\/p>\n\n\n\n

HKONT<\/th><\/tr>
0000160000<\/td><\/tr>
0000790000<\/td><\/tr>
0000191100<\/td><\/tr>
0000231500<\/td><\/tr>
\u2026<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Now you could go with the list to the appropriate department, or you simply read this article further. Unfortunately, the account name is not in the BSEG, because SAP separates the transaction data from the master data. However, a simple join to another table is not enough, as we also need the corresponding chart of accounts. This can be found in table T001 (Company Codes \u2013 Customizing), but not in BSEG, so we build the join as follows:<\/p>\n\n\n\n

SELECT DISTINCT BSEG.HKONT, T001.KTOPL FROM BSEG
LEFT JOIN T001 ON BSEG.MANDT = T001.MANDT AND BSEG.BUKRS=T001.BUKRS
WHERE BSEG.MANDT='800' AND BSEG.BUKRS='1000' AND BSEG.GJAHR=2017<\/code><\/p>\n\n\n\n

The result provides us with the corresponding chart of accounts:<\/p>\n\n\n\n

HKONT<\/th>KTOPL<\/th><\/tr>
0000160000<\/td>INT<\/td><\/tr>
0000790000<\/td>INT<\/td><\/tr>
0000191100<\/td>INT<\/td><\/tr>
0000231500<\/td>INT<\/td><\/tr>
\u2026<\/td>\u2026<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

However, we have not made much progress with this in connection with the account name. To do this, we also need the table SKAT (G\/L account master (chart of accounts: name)), which we add as follows:<\/p>\n\n\n\n

SELECT DISTINCT BSEG.HKONT, T001.KTOPL, SKAT.TXT50 FROM BSEG
LEFT JOIN T001 ON BSEG.MANDT = T001.MANDT AND BSEG.BUKRS=T001.BUKRS
LEFT JOIN SKAT ON SKAT.MANDT = BSEG.MANDT AND BSEG.HKONT = SKAT.SAKNR AND T001.KTOPL = SKAT.KTOPL AND SKAT.SPRAS = 'E'
WHERE BSEG.MANDT='800' AND BSEG.BUKRS='1000' AND BSEG.GJAHR=2017<\/code><\/p>\n\n\n\n

So far so good. The result can be seen already times:<\/p>\n\n\n\n

HKONT<\/th>KTOPL<\/th>TXT50<\/th><\/tr>
0000160000<\/td>INT<\/td>Trade Payables \u2013 domestic<\/td><\/tr>
0000790000<\/td>INT<\/td>Unfinished products<\/td><\/tr>
0000191100<\/td>INT<\/td>Goods Rcvd\/Invoice Rcvd (third party)<\/td><\/tr>
0000231500<\/td>INT<\/td>Expense from price difference of own goods<\/td><\/tr>
\u2026<\/td>\u2026<\/td>\u2026<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

However, the list of accounts to be examined must be further restricted, since the sheer number alone is enough to kill you.<\/p>\n\n\n\n

Analysis of account movements using 3 examples in SAP<\/h2>\n\n\n\n

So let\u2019s take a look at three different types of accounts: First, we take an expense account, a bank account and a turnover account and illustrate the individual movements in a graph with Excel. Let\u2019s start with an expense account, such as depreciation. To do this, we only need to adjust the upper query slightly:<\/p>\n\n\n\n

SELECT DISTINCT BSEG.HKONT, T001.KTOPL, SKAT.TXT50 FROM BSEG
LEFT JOIN T001 ON BSEG.MANDT = T001.MANDT AND BSEG.BUKRS=T001.BUKRS
LEFT JOIN SKAT ON SKAT.MANDT = BSEG.MANDT AND BSEG.HKONT = SKAT.SAKNR AND T001.KTOPL = SKAT.KTOPL AND
SKAT.SPRAS = 'D'
WHERE BSEG.MANDT='800' AND BSEG.BUKRS='1000' AND BSEG.GJAHR=2017 AND SKAT.TXT50 LIKE '%depreciation%'<\/code><\/p>\n\n\n\n

The supplement searches the TXT50 field (G\/L account long text) of table SKAT for the keyword \u201cdepreciation\u201d, where the % means that everything should be included before and after the word. For example, you get \u201cimputed depreciation\u201d as well as \u201cdepreciation on fixed assets (unscheduled)\u201d if this type of account name exists. In this case you have to pay attention to upper and lower case, as Hana takes it very seriously in this context. In the IDES test system I only get 3 accounts listed for the query, whereby I also had to adjust the fiscal year:<\/p>\n\n\n\n

HKONT<\/th>KTOPL<\/th>TXT50<\/th><\/tr>
0000211100<\/td>INT<\/td>Ordinary depreciation \u2013 fixed assets<\/td><\/tr>
0000211200<\/td>INT<\/td>Extraordinary depreciation \u2013 fixed assets<\/td><\/tr>
0000481000<\/td>INT<\/td>Cost-accounting depreciation<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

And now I had to fall back on Prof. Gehrke, because now it\u2019s getting complex. We execute the following query with the G\/L account number:<\/p>\n\n\n\n

SELECT D.MONAT as MONTH, SUM(CASE WHEN SHKZG='S' THEN DMBTR ELSE 0 END) BALANCE_DEBIT, SUM(CASE WHEN SHKZG='H' THEN DMBTR ELSE 0 END) BALANCE_CREDIT, SUM(CASE WHEN SHKZG='S' THEN DMBTR ELSE 0 END) - SUM(CASE WHEN SHKZG='H' THEN DMBTR ELSE 0 END) TOTAL FROM
(SELECT MONAT, HKONT
FROM BKPF
JOIN BSEG ON (BKPF.MANDT = BSEG.MANDT AND BKPF.BUKRS = BSEG.BUKRS AND BKPF.GJAHR = BSEG.GJAHR AND BKPF.BELNR=BSEG.BELNR)
WHERE HKONT='0000211200' GROUP BY MONAT, BSEG.HKONT) D
JOIN BSEG B ON D.HKONT = B.HKONT
JOIN BKPF BK ON (B.MANDT = BK.MANDT AND B.BUKRS = BK.BUKRS AND B.GJAHR = BK.GJAHR AND B.BELNR = BK.BELNR AND B.HKONT = D.HKONT)
WHERE BK.MONAT<=D.MONAT AND B.MANDT='800' AND B.BUKRS='1000' AND B.GJAHR=2017
GROUP BY D.MONAT
ORDER BY D.MONAT;<\/code><\/p>\n\n\n\n

What does the query essentially do?
Basically, it goes through all postings to a defined account (highlighted in orange), adds all debit and credit items, and calculates the difference between the two, whereby the values are cumulated for up to one month. The result for the account is scheduled depreciation on fixed assets:<\/p>\n\n\n\n

MONTH<\/th>BALANCE_DEBIT<\/th>BALANCE_CREDIT<\/th>TOTAL<\/th><\/tr>
01<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
02<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
03<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
04<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
05<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
06<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
07<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
08<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
09<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
10<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
11<\/td>112155,97<\/td>0,00<\/td>112155,97<\/td><\/tr>
12<\/td>1354655,06<\/td>0,00<\/td>1354655,06<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

The account probably corresponds to current practice for the time being, whereby the prompt posting of depreciation for monthly or quarterly financial statements is highly recommended. However, it is not critical in the sense of the annual financial statements.<\/p>\n\n\n\n

According to the procedure, I took a closer look at the following two accounts:<\/p>\n\n\n\n

  • Deutsche Bank (domestic) (0000113100)<\/li>
  • Sales revenues \u2013 domestic \u2013 finished goods (0000800000)<\/li><\/ul>\n\n\n\n

    I have adapted the query with the LIKE \u2018%depreciation%\u2019 to LIKE \u2018%Bank%\u2019 and LIKE \u2018%Sales%\u2019 accordingly, copied the number of the G\/L accounts and pasted it into the professor\u2019s query. I then exported the three results to Excel and placed them next to each other as follows:<\/p>\n\n\n\n

    Ordinary depreciation<\/strong><\/th><\/tr>
    MONTH<\/th>BALANCE_DEBIT<\/th>BALANCE_CREDIT<\/th>TOTAL<\/th><\/tr>
    01<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    02<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    03<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    04<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    05<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    06<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    07<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    08<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    09<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    10<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    11<\/td>112.155,97<\/td>0,00<\/td>112.155,97<\/td><\/tr>
    12<\/td>1.354.655,06<\/td>0,00<\/td>1.354.655,06<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    Deutsche Bank (domestic)<\/strong><\/th><\/tr>
    MONTH<\/th>BALANCE_DEBIT<\/th>BALANCE_CREDIT<\/th>TOTAL<\/th><\/tr>
    01<\/td>0<\/td>0<\/td>0<\/td><\/tr>
    02<\/td>0,00<\/td>1.789,52<\/td>-1.789,52<\/td><\/tr>
    03<\/td>0,00<\/td>13.211,24<\/td>-13.211,24<\/td><\/tr>
    04<\/td>0,00<\/td>13.211,24<\/td>-13.211,24<\/td><\/tr>
    05<\/td>0,00<\/td>13.211,24<\/td>-13.211,24<\/td><\/tr>
    06<\/td>0,00<\/td>24.510,79<\/td>-24.510,79<\/td><\/tr>
    07<\/td>0,00<\/td>24.510,79<\/td>-24.510,79<\/td><\/tr>
    08<\/td>0,00<\/td>58.204,92<\/td>-58.204,92<\/td><\/tr>
    09<\/td>0,00<\/td>58.210,03<\/td>-58.210,03<\/td><\/tr>
    10<\/td>0,00<\/td>58.210,03<\/td>-58.210,03<\/td><\/tr>
    11<\/td>18.968,93<\/td>111.972,37<\/td>-93.003,44<\/td><\/tr>
    12<\/td>5.243.255,27<\/td>4.364.440,71<\/td>878.814,56<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    Sales revenues \u2013 domestic \u2013 finished goods<\/strong><\/th><\/tr>
    MONTH<\/th>BALANCE_DEBIT<\/th>BALANCE_CREDIT<\/th>TOTAL<\/th><\/tr>
    01<\/td>25.839,67<\/td>218.339,79<\/td>-192.500,12<\/td><\/tr>
    02<\/td>25.839,67<\/td>454.773,72<\/td>-428.934,05<\/td><\/tr>
    03<\/td>25.839,67<\/td>519.837,58<\/td>-493.997,91<\/td><\/tr>
    04<\/td>25.839,67<\/td>884.841,46<\/td>-859.001,79<\/td><\/tr>
    05<\/td>25.839,67<\/td>1.022.669,98<\/td>-996.830,31<\/td><\/tr>
    06<\/td>25.839,67<\/td>1.076.643,02<\/td>-1.050.803,35<\/td><\/tr>
    07<\/td>25.839,67<\/td>1.113.846,64<\/td>-1.088.006,97<\/td><\/tr>
    08<\/td>25.839,67<\/td>1.239.086,20<\/td>-1.213.246,53<\/td><\/tr>
    09<\/td>25.839,67<\/td>1.362.847,61<\/td>-1.337.007,94<\/td><\/tr>
    10<\/td>25.839,67<\/td>1.507.697,83<\/td>-1.481.858,16<\/td><\/tr>
    11<\/td>25.839,67<\/td>1.654.096,21<\/td>-1.628.256,54<\/td><\/tr>
    12<\/td>25.839,67<\/td>1.797.220,47<\/td>-1.771.380,80<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    I then converted the months into plain text so that they were easier to read in the graph and then inserted a line diagram of the months and balances. The result will look like this:<\/p>\n\n\n\n

    \"account-movements\"<\/figure>\n\n\n\n

    I had already said a few words about the write-offs, so we\u2019ll take a look at Deutsche Bank\u2019s G\/L account next. The slightly negative trend until November is noticeable, when over 5 million are suddenly paid in. Of course, I am aware that this is a test system, but such anomalies should definitely be questioned. It would be similar with strong swings in one direction or the other. In this case it would be interesting to investigate how much the deviations deviate from the average in order to be able to speak of a significant deviation.<\/p>\n\n\n\n

    Revenues, on the other hand, develop exactly as one would probably wish (the negative sign here does not mean falling revenues, but rising ones). The cost of goods is constant at just under \u20ac26,000, whereas revenues are rising steadily to just under \u20ac1.8 million.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Account movements, cash flow, debit, credit, credit or debit, you name it. Let\u2019s take a look today at exactly what somehow connects them all: Movements on accounts. To do this, we will first take a look at all the accounts, select three interesting examples and take a closer look at them in a time series. […]<\/p>\n","protected":false},"author":5,"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-11114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-en-audit","category-en-compliance","category-en-finance"],"acf":[],"yoast_head":"\nAccount movements on the SAP test bench - zapliance<\/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:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Account movements on the SAP test bench - zapliance\" \/>\n<meta property=\"og:description\" content=\"Account movements, cash flow, debit, credit, credit or debit, you name it. Let\u2019s take a look today at exactly what somehow connects them all: Movements on accounts. To do this, we will first take a look at all the accounts, select three interesting examples and take a closer look at them in a time series. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/\" \/>\n<meta property=\"og:site_name\" content=\"zapliance\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-22T11:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-26T13:27:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/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=\"Alexander Ruehle\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alexander Ruehle\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/\"},\"author\":{\"name\":\"Alexander Ruehle\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/215958640076a72c61876b1ec9e23211\"},\"headline\":\"Account movements on the SAP test bench\",\"datePublished\":\"2019-08-22T11:00:00+00:00\",\"dateModified\":\"2022-08-26T13:27:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/\"},\"wordCount\":1002,\"publisher\":{\"@id\":\"https:\/\/zapliance.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"articleSection\":[\"Audit\",\"Compliance\",\"Finance\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/\",\"url\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/\",\"name\":\"Account movements on the SAP test bench - zapliance\",\"isPartOf\":{\"@id\":\"https:\/\/zapliance.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"datePublished\":\"2019-08-22T11:00:00+00:00\",\"dateModified\":\"2022-08-26T13:27:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#primaryimage\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"width\":2400,\"height\":962},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/zapliance.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Account movements on the SAP test bench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zapliance.com\/en\/#website\",\"url\":\"https:\/\/zapliance.com\/en\/\",\"name\":\"zapliance\",\"description\":\"Be the agent of change\",\"publisher\":{\"@id\":\"https:\/\/zapliance.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zapliance.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/zapliance.com\/en\/#organization\",\"name\":\"zapliance\",\"url\":\"https:\/\/zapliance.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg\",\"width\":200,\"height\":45,\"caption\":\"zapliance\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/215958640076a72c61876b1ec9e23211\",\"name\":\"Alexander Ruehle\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_5_1657802999-96x96.jpg\",\"contentUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_5_1657802999-96x96.jpg\",\"caption\":\"Alexander Ruehle\"},\"description\":\"is CEO & Co-Founder of zapliance and has been an auditor at heart for over 15 years. He is both a Certified Internal Auditor and Certified Information Systems Auditor and is moving forward as a thought leader to transform the finance, audit and compliance industry - people-centric, data-driven and context-driven.\",\"url\":\"https:\/\/zapliance.com\/en\/blog\/author\/alexander-ruehle\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Account movements on the SAP test bench - zapliance","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:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/","og_locale":"en_US","og_type":"article","og_title":"Account movements on the SAP test bench - zapliance","og_description":"Account movements, cash flow, debit, credit, credit or debit, you name it. Let\u2019s take a look today at exactly what somehow connects them all: Movements on accounts. To do this, we will first take a look at all the accounts, select three interesting examples and take a closer look at them in a time series. […]","og_url":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/","og_site_name":"zapliance","article_published_time":"2019-08-22T11:00:00+00:00","article_modified_time":"2022-08-26T13:27:50+00:00","og_image":[{"width":2400,"height":962,"url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","type":"image\/png"}],"author":"Alexander Ruehle","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alexander Ruehle","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#article","isPartOf":{"@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/"},"author":{"name":"Alexander Ruehle","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/215958640076a72c61876b1ec9e23211"},"headline":"Account movements on the SAP test bench","datePublished":"2019-08-22T11:00:00+00:00","dateModified":"2022-08-26T13:27:50+00:00","mainEntityOfPage":{"@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/"},"wordCount":1002,"publisher":{"@id":"https:\/\/zapliance.com\/en\/#organization"},"image":{"@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#primaryimage"},"thumbnailUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","articleSection":["Audit","Compliance","Finance"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/","url":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/","name":"Account movements on the SAP test bench - zapliance","isPartOf":{"@id":"https:\/\/zapliance.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#primaryimage"},"image":{"@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#primaryimage"},"thumbnailUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","datePublished":"2019-08-22T11:00:00+00:00","dateModified":"2022-08-26T13:27:50+00:00","breadcrumb":{"@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#primaryimage","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","width":2400,"height":962},{"@type":"BreadcrumbList","@id":"https:\/\/zapliance.com\/en\/blog\/account-movements-on-the-sap-test-bench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/zapliance.com\/en\/"},{"@type":"ListItem","position":2,"name":"Account movements on the SAP test bench"}]},{"@type":"WebSite","@id":"https:\/\/zapliance.com\/en\/#website","url":"https:\/\/zapliance.com\/en\/","name":"zapliance","description":"Be the agent of change","publisher":{"@id":"https:\/\/zapliance.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zapliance.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/zapliance.com\/en\/#organization","name":"zapliance","url":"https:\/\/zapliance.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/06\/zap_logo.svg","width":200,"height":45,"caption":"zapliance"},"image":{"@id":"https:\/\/zapliance.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/215958640076a72c61876b1ec9e23211","name":"Alexander Ruehle","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_5_1657802999-96x96.jpg","contentUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/07\/avatar_user_5_1657802999-96x96.jpg","caption":"Alexander Ruehle"},"description":"is CEO & Co-Founder of zapliance and has been an auditor at heart for over 15 years. He is both a Certified Internal Auditor and Certified Information Systems Auditor and is moving forward as a thought leader to transform the finance, audit and compliance industry - people-centric, data-driven and context-driven.","url":"https:\/\/zapliance.com\/en\/blog\/author\/alexander-ruehle\/"}]}},"views":2460,"_links":{"self":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/comments?post=11114"}],"version-history":[{"count":1,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11114\/revisions"}],"predecessor-version":[{"id":11115,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11114\/revisions\/11115"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/media\/10699"}],"wp:attachment":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/media?parent=11114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/categories?post=11114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/tags?post=11114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}