{"id":11469,"date":"2016-11-23T12:44:00","date_gmt":"2016-11-23T12:44:00","guid":{"rendered":"https:\/\/zapliance.com\/?p=11469"},"modified":"2022-08-26T14:20:33","modified_gmt":"2022-08-26T14:20:33","slug":"fixed-asset-data-structure-in-sap","status":"publish","type":"post","link":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/","title":{"rendered":"Fixed asset data structure in SAP"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Part VIII of the series: \u201cDigitization of auditing SAP Fixed Asset and Inventory Processes\u201d<\/h2>\n\n\n\n<p>This blog post is covering the most important SAP tables in the area of fixed assets and inventories, which are of interest to the auditor for analytic purposes.<\/p>\n\n\n\n<p>1.&nbsp;<a href=\"https:\/\/zapliance.com\/blog\/auditing-sap-processes-for-fixed-asset-and-inventory?lang=en\">Auditing SAP processes in fixed asset and inventory<\/a><br>2.&nbsp;<a href=\"https:\/\/zapliance.com\/blog\/master-data-audit-of-sap-fixed-assets?lang=en\">Master Data audit of SAP fixed assets<\/a><br>3.&nbsp;<a href=\"https:\/\/zapliance.com\/blog\/how-to-audit-fixed-assets-procurement-in-sap?lang=en\">How to audit&nbsp;fixed assets procurement in SAP<\/a><br>4.&nbsp;<a href=\"https:\/\/zapliance.com\/blog\/sap-data-analytics-for-fixed-asset-depreciation-2?lang=en\">SAP data analytics for fixed asset depreciation<\/a><br>5.&nbsp;<a href=\"https:\/\/zapliance.com\/blog\/auditing-fixed-asset-retirement-in-sap?lang=en\">Auditing fixed asset retirement in SAP<\/a><br>6.&nbsp;<a href=\"https:\/\/zapliance.com\/blog\/process-analytics-for-sap-current-asset-transactions?lang=en\">Process analytics for SAP current asset transactions<\/a><br>7.&nbsp;<a href=\"https:\/\/zapliance.com\/blog\/segregation-of-duties-in-sap-asset-management?lang=en\">Segregation of Duties in SAP asset management<\/a><br><strong>8.&nbsp;Fixed asset data structure in SAP<\/strong><br>9.&nbsp;<a href=\"https:\/\/zapliance.com\/blog\/professional-judgement-in-auditing-sap-fixed-assets?lang=en\">Professional Judgement&nbsp;in auditing SAP fixed&nbsp;assets<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/2492072\/38f4f086-08c1-40e4-9055-785a51dc619f\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/2492072\/38f4f086-08c1-40e4-9055-785a51dc619f.png\" alt=\"Auditing fixed asset and inventory is even more straight forward with this  automated data analysis. Just take a look.\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Important SAP tables in&nbsp;fixed asset and inventory<\/h2>\n\n\n\n<p>The most important SAP tables&nbsp;for auditing SAP fixed assets and inventories&nbsp;for the auditor are:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>ANKA:&nbsp;Asset Classes (General Data)<\/li><li>ANKT: Asset Classes (Description)<\/li><li>ANLH:&nbsp;Main Asset Number<\/li><li>ANLA:&nbsp;Asset Master Record Segment<\/li><li>ANLB:&nbsp;Abschreibungsparameter<\/li><li>ANLC:&nbsp;Asset Value Fields<\/li><li>ANLP:&nbsp;Asset Periodic Values<\/li><li>MARA:&nbsp;General Material Data<\/li><li>MBEW:&nbsp;Material&nbsp;Valuation<\/li><li>MKPF:&nbsp;Header Material Document<\/li><li>MSEG:&nbsp;Document Segment Material<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Relations to accounting<\/h2>\n\n\n\n<p>Certain documents in the accounting system refer to documents on fixed assets. These are business transactions in connection with fixed assets: access to a fixed asset, disposal of a fixed asset or depreciation. In the accounting document (table BSEG), you can see a reference to a fixed asset in the data fields ANLN1 (main asset number) and ANLN2 (asset subnumber).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Data mining your SAP system<\/h2>\n\n\n\n<p><a href=\"https:\/\/zapliance.com\/zap-audit?lang=en\">Mining data<\/a>&nbsp;from your SAP system is not always easy. There are various tools on the market which allow for data extraction from SAP systems. Usually for this purpose, an ABAP program needs to be installed.&nbsp;However, this is at the same time a \u201cshow-stopper\u201d in many companies, as transports into a SAP system require a Change Management process.&nbsp;They often take a long time and have to go through a series of authorization steps.<\/p>\n\n\n\n<p>Another possibility is to manually download single tables from the SAP system. To do so, transactions, like SE16 may be applied. However, this requires a lot of manual handling&nbsp;and is rather inconvenient.<\/p>\n\n\n\n<p>Via Remote Function Call (RFC), SAP data tables can be extracted from a SAP system. For doing this, a user account with corresponding user rights needs to call up RFC-components. As a result an ABAP program is not required. On the one hand RFC is comparatively old and sometimes slow. On the other hand it is established and available in every SAP system. By using RFC, the data extraction can cleverly be optimized. In addition it makes SAP&nbsp;data extraction for analytic purposes easy and convenient. You can try this approach being included in zap Audit free of charge. Want to know more? Just schedule an appointment&nbsp;<a href=\"https:\/\/zapliance.com\/contact?lang=en\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Part VIII of the series: \u201cDigitization of auditing SAP Fixed Asset and Inventory Processes\u201d This blog post is covering the most important SAP tables in the area of fixed assets and inventories, which are of interest to the auditor for analytic purposes. 1.&nbsp;Auditing SAP processes in fixed asset and inventory2.&nbsp;Master Data audit of SAP fixed [&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-11469","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.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fixed asset data structure in SAP - 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\/fixed-asset-data-structure-in-sap\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fixed asset data structure in SAP - zapliance\" \/>\n<meta property=\"og:description\" content=\"Part VIII of the series: \u201cDigitization of auditing SAP Fixed Asset and Inventory Processes\u201d This blog post is covering the most important SAP tables in the area of fixed assets and inventories, which are of interest to the auditor for analytic purposes. 1.&nbsp;Auditing SAP processes in fixed asset and inventory2.&nbsp;Master Data audit of SAP fixed [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/\" \/>\n<meta property=\"og:site_name\" content=\"zapliance\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-23T12:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-26T14:20:33+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=\"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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/\"},\"author\":{\"name\":\"Nick Gehrke\",\"@id\":\"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a\"},\"headline\":\"Fixed asset data structure in SAP\",\"datePublished\":\"2016-11-23T12:44:00+00:00\",\"dateModified\":\"2022-08-26T14:20:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/\"},\"wordCount\":494,\"publisher\":{\"@id\":\"https:\/\/zapliance.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#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\/fixed-asset-data-structure-in-sap\/\",\"url\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/\",\"name\":\"Fixed asset data structure in SAP - zapliance\",\"isPartOf\":{\"@id\":\"https:\/\/zapliance.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png\",\"datePublished\":\"2016-11-23T12:44:00+00:00\",\"dateModified\":\"2022-08-26T14:20:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#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\/fixed-asset-data-structure-in-sap\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/zapliance.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fixed asset data structure in SAP\"}]},{\"@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\/ef4d227360d4b66b84aa95cb72c12f5a\",\"name\":\"Nick Gehrke\",\"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_4_1657803044-96x96.jpg\",\"contentUrl\":\"https:\/\/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:\/\/zapliance.com\/en\/blog\/author\/nick-gehrke\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fixed asset data structure in SAP - 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\/fixed-asset-data-structure-in-sap\/","og_locale":"en_US","og_type":"article","og_title":"Fixed asset data structure in SAP - zapliance","og_description":"Part VIII of the series: \u201cDigitization of auditing SAP Fixed Asset and Inventory Processes\u201d This blog post is covering the most important SAP tables in the area of fixed assets and inventories, which are of interest to the auditor for analytic purposes. 1.&nbsp;Auditing SAP processes in fixed asset and inventory2.&nbsp;Master Data audit of SAP fixed [&hellip;]","og_url":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/","og_site_name":"zapliance","article_published_time":"2016-11-23T12:44:00+00:00","article_modified_time":"2022-08-26T14:20:33+00:00","og_image":[{"width":2400,"height":962,"url":"https:\/\/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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#article","isPartOf":{"@id":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/"},"author":{"name":"Nick Gehrke","@id":"https:\/\/zapliance.com\/en\/#\/schema\/person\/ef4d227360d4b66b84aa95cb72c12f5a"},"headline":"Fixed asset data structure in SAP","datePublished":"2016-11-23T12:44:00+00:00","dateModified":"2022-08-26T14:20:33+00:00","mainEntityOfPage":{"@id":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/"},"wordCount":494,"publisher":{"@id":"https:\/\/zapliance.com\/en\/#organization"},"image":{"@id":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#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\/fixed-asset-data-structure-in-sap\/","url":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/","name":"Fixed asset data structure in SAP - zapliance","isPartOf":{"@id":"https:\/\/zapliance.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#primaryimage"},"image":{"@id":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#primaryimage"},"thumbnailUrl":"https:\/\/zapliance.com\/wp-content\/uploads\/2022\/08\/Blog-Dummy.png","datePublished":"2016-11-23T12:44:00+00:00","dateModified":"2022-08-26T14:20:33+00:00","breadcrumb":{"@id":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zapliance.com\/en\/blog\/fixed-asset-data-structure-in-sap\/#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\/fixed-asset-data-structure-in-sap\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/zapliance.com\/en\/"},{"@type":"ListItem","position":2,"name":"Fixed asset data structure in SAP"}]},{"@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\/ef4d227360d4b66b84aa95cb72c12f5a","name":"Nick Gehrke","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_4_1657803044-96x96.jpg","contentUrl":"https:\/\/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:\/\/zapliance.com\/en\/blog\/author\/nick-gehrke\/"}]}},"views":12647,"_links":{"self":[{"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11469","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/comments?post=11469"}],"version-history":[{"count":1,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11469\/revisions"}],"predecessor-version":[{"id":11470,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/posts\/11469\/revisions\/11470"}],"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=11469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/categories?post=11469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zapliance.com\/en\/wp-json\/wp\/v2\/tags?post=11469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}