{"id":2215,"date":"2014-06-05T12:06:00","date_gmt":"2014-06-05T12:06:00","guid":{"rendered":"https:\/\/www.dab-europe.com\/\/articles\/turnover-analysis\/"},"modified":"2025-03-11T12:53:09","modified_gmt":"2025-03-11T12:53:09","slug":"turnover-analysis","status":"publish","type":"articles","link":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/","title":{"rendered":"Turnover analysis"},"content":{"rendered":"<h2>Turnover analysis<\/h2>\n<p class=\"align-justify\">In this article, I would like to show you some possible approaches in order to analyze turnover figures of vendors and customers and which questions are relevant. The analyses are shown by means of the analysis software ACL\u2122 Analytics. <\/p>\n<h2>Structure of table LFC1 <\/h2>\n<p class=\"align-justify\">The vendors\u2019 turnover figures are displayed in table LFC1 per vendor number (field LIFNR), company code (field BUKRS) and fiscal year (field GJAHR). The balance carried forward at the beginning of the fiscal year is stored in the field UMSAV; this corresponds to the open amount which was not cleared in the previous year. The subsequent fields are listed per period, this means 16 times. XX is the placeholder for the current period. One posting period corresponds to one month, periods 13 \u2013 16 are special periods where year-end closing postings are done:<\/p>\n<ul>\n<li class=\"align-justify\">LFC1_UMXXS: Sum of the debit postings in the period <\/li>\n<li class=\"align-justify\">LFC1_UMXXH: Sum of the credit postings in the period  <\/li>\n<li class=\"align-justify\">LFC1_UMXXU: Turnover in the period. The field includes the sum of all sales-related postings in this posting period. It depends on the posting key if a posting is sales-related. For instance, a vendor invoice is sales-related whereas a payment is non-sales-related; this means that it is not relevant for the turnover amount if a vendor invoice has been already cleared.    <\/li>\n<\/ul>\n<p class=\"align-justify\">The following example displays transaction figures of vendor 111 in the transaction SE16. For visualization reasons, the view was separated to two screenshots: <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140605_SAP_Analyze_Turnover_D_01.png\" \/><\/p>\n<p class=\"align-justify\">In this example, the balance carried forward had a credit amount of 158,385.48 Euro at the beginning of fiscal year 2004. A negative amount represents credit postings whereas a positive amount represents a debit posting. The balance carried forward was calculated by making the balance of all debit postings and credit postings in the previous year. <\/p>\n<p class=\"align-justify\">Furthermore the sum of the credit and debit postings as well as the sum of the turnover is listed for each period. You see in this example that turnovers are only displayed with a negative amount. As already mentioned, credit postings are totaled as negative amount. Since the credit sum is always corresponding to the turnover sum, the credit postings were always sales-related. In period 12, the sum of the debit postings had an amount of 213,275.06 Euro. Since this amount did not influence the turnover in period 12, the debit postings were not sales-related. <\/p>\n<h2>Analysis of vendors\u2019 turnover figures in ACL\u2122 Analytics <\/h2>\n<p class=\"align-justify\">In this chapter, the turnover trend will be looked at. First and foremost the following aspects will be regarded: <\/p>\n<ul>\n<li>Which vendors had the highest turnovers? <\/li>\n<li>Which vendors had the highest deviations? <\/li>\n<\/ul>\n<p class=\"align-justify\">The analyses are shown by means of ACL\u2122 Analytics. We can use table LFC1 as basis for the turnover figures. Since we are interested in the total turnover per year, we create a calculated field c_Turnover which totals the turnovers of all periods. Since the turnovers are shown with a negative amount, the sum is multiplied by (-1). <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/2024\/04\/20140605_SAP_Analyze_Turnover_D_03.png\" \/><\/p>\n<p class=\"align-justify\">In the first analysis, the vendors with the highest turnover in company code 1000 from the years 2005 \u2013 2008 should be identified. First, the turnover per vendor must be totaled by vendor, filtered to company code 1000. In our example, customer 1075 has the highest turnover: rder value.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/2024\/04\/20140605_SAP_Analyze_Turnover_D_04.png\" \/><\/p>\n<p class=\"align-justify\">A further interesting aspect is to analyze the turnover trend per vendor and identify huge deviations. In the following example, the turnover of two fiscal years will be compared. In table LFC1, the fiscal years are listed one below the other; therefore the comparability is difficult. By means of the CROSSTAB command, it is possible to list the turnover figures side by side. For to keep the example easy to read, only two fiscal years (2005 \u2013 2006) will be compared. Field LFC1_LIFNR is selected as row whereas field LFC1_GJAHR is selected as column. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/2024\/04\/20140605_SAP_Analyze_Turnover_D_05.png\" \/><\/p>\n<p class=\"align-justify\">In the result table, a column is created for each fiscal year to make turnover per fiscal year visible. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140605_SAP_Analyze_Turnover_D_06.png\" \/><\/p>\n<p class=\"align-justify\">To compare the turnover figures in the years 2005 and 2006, we create a calculated field c_Dif_Turnover which subtracts the turnover in year 2005 from the turnover in year 2006. To identify the hugest turnover increases, the result table is sorted descending by the difference. We get the following table as result. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140605_SAP_Analyze_Turnover_D_07.png\" \/><\/p>\n<h2>Analysis of customers\u2019 turnover figures in ACL\u2122 Analytics<\/h2>\n<p class=\"align-justify\">The customers\u2019 turnover figures are stored in table KNC1. In contrary to vendors, the turnovers are displayed with a positive amount here. Therefore the annual turnover per customer is calculated the following way:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/2024\/04\/20140605_SAP_Analyze_Turnover_D_08.png\" \/><\/p>\n<p class=\"align-justify\">The subsequent analyses are analog to table LFC1; therefore a further description is not necessary.  <\/p>\n<h2>Conclusion <\/h2>\n<p class=\"align-justify\">This article has shown with two examples which analysis possibilities exist in table LFC1\/KNC1. In the first example, the total turnover of the vendor\/customer was calculated; in the second example, the absolute increase of the turnover within a year was calculated. Indeed, we can get more information from these tables and make further analyses. A complete vendor ranking or customer ranking bases mostly on the turnovers in a longer period and analyses their trends.  <\/p>\n<p class=\"align-justify\">If you have any questions on this topic or want to place a comment, feel free to contact me on&nbsp;<a href=\"mailto:info@dab-gmbh.de\">info@dab-gmbh.de<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Turnover analysis In this article, I would like to show you some possible approaches in order to analyze turnover figures of vendors and customers and which questions are relevant. The analyses are shown by means of the analysis software ACL\u2122 Analytics. Structure of table LFC1 The vendors\u2019 turnover figures are displayed in table LFC1 per [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":4688,"template":"","articles_category":[],"articles_tag":[91,92],"class_list":["post-2215","articles","type-articles","status-publish","has-post-thumbnail","hentry","articles_tag-data-analytics","articles_tag-sap"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The sales analysis \u2013 An analysis of sales figures<\/title>\n<meta name=\"description\" content=\"Sales analysis as analysis of sales figures from suppliers and customers \u2713 Using the ACL analysis software \u2713 Structure of the LFC1 table \u2013 Read more here!\" \/>\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.dab-europe.com\/en\/articles\/turnover-analysis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The sales analysis \u2013 An analysis of sales figures\" \/>\n<meta property=\"og:description\" content=\"Sales analysis as analysis of sales figures from suppliers and customers \u2713 Using the ACL analysis software \u2713 Structure of the LFC1 table \u2013 Read more here!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/\" \/>\n<meta property=\"og:site_name\" content=\"dab\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-11T12:53:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0663-1024x683.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"683\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/turnover-analysis\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/turnover-analysis\\\/\",\"name\":\"The sales analysis \u2013 An analysis of sales figures\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/turnover-analysis\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/turnover-analysis\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0663-scaled.jpg\",\"datePublished\":\"2014-06-05T12:06:00+00:00\",\"dateModified\":\"2025-03-11T12:53:09+00:00\",\"description\":\"Sales analysis as analysis of sales figures from suppliers and customers \u2713 Using the ACL analysis software \u2713 Structure of the LFC1 table \u2013 Read more here!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/turnover-analysis\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/turnover-analysis\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/turnover-analysis\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0663-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0663-scaled.jpg\",\"width\":2560,\"height\":1707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/turnover-analysis\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Turnover analysis\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"name\":\"dab\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\",\"name\":\"dab\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"width\":2560,\"height\":1463,\"caption\":\"dab\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The sales analysis \u2013 An analysis of sales figures","description":"Sales analysis as analysis of sales figures from suppliers and customers \u2713 Using the ACL analysis software \u2713 Structure of the LFC1 table \u2013 Read more here!","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.dab-europe.com\/en\/articles\/turnover-analysis\/","og_locale":"en_US","og_type":"article","og_title":"The sales analysis \u2013 An analysis of sales figures","og_description":"Sales analysis as analysis of sales figures from suppliers and customers \u2713 Using the ACL analysis software \u2713 Structure of the LFC1 table \u2013 Read more here!","og_url":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/","og_site_name":"dab","article_modified_time":"2025-03-11T12:53:09+00:00","og_image":[{"width":1024,"height":683,"url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0663-1024x683.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/","url":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/","name":"The sales analysis \u2013 An analysis of sales figures","isPartOf":{"@id":"https:\/\/www.dab-europe.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/#primaryimage"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0663-scaled.jpg","datePublished":"2014-06-05T12:06:00+00:00","dateModified":"2025-03-11T12:53:09+00:00","description":"Sales analysis as analysis of sales figures from suppliers and customers \u2713 Using the ACL analysis software \u2713 Structure of the LFC1 table \u2013 Read more here!","breadcrumb":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/#primaryimage","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0663-scaled.jpg","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0663-scaled.jpg","width":2560,"height":1707},{"@type":"BreadcrumbList","@id":"https:\/\/www.dab-europe.com\/en\/articles\/turnover-analysis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dab-europe.com\/en\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.dab-europe.com\/en\/articles\/"},{"@type":"ListItem","position":3,"name":"Turnover analysis"}]},{"@type":"WebSite","@id":"https:\/\/www.dab-europe.com\/en\/#website","url":"https:\/\/www.dab-europe.com\/en\/","name":"dab","description":"","publisher":{"@id":"https:\/\/www.dab-europe.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dab-europe.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dab-europe.com\/en\/#organization","name":"dab","url":"https:\/\/www.dab-europe.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","width":2560,"height":1463,"caption":"dab"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles\/2215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles"}],"about":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/types\/articles"}],"author":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/users\/5"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media\/4688"}],"wp:attachment":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media?parent=2215"}],"wp:term":[{"taxonomy":"articles_category","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_category?post=2215"},{"taxonomy":"articles_tag","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_tag?post=2215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}