{"id":85805,"date":"2021-02-24T10:25:46","date_gmt":"2021-02-24T04:55:46","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=85805"},"modified":"2021-02-24T10:25:46","modified_gmt":"2021-02-24T04:55:46","slug":"sap-abap-data-dictionary","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/","title":{"rendered":"SAP ABAP Data Dictionary"},"content":{"rendered":"<p>In this tutorial, we will learn about SAP ABAP Data Dictionary, which is the main point of all information available in the entire database, or information repository.<\/p>\n<p>We will learn about what it means, how it works and its importance in the SAP ABAP system database.<\/p>\n<p>Let&#8217;s start without wasting any time!!!!<\/p>\n<h3>What is the ABAP Data Dictionary?<\/h3>\n<ul>\n<li>The ABAP Data Dictionary can be defined as a source of all data in the SAP Database.<\/li>\n<li>Ideally, it contains the data of all data i.e. metadata about all objects in the database system.<\/li>\n<li>Data stored in a dictionary is integrated, secured and consistent.<\/li>\n<li>The main function of the data dictionary is to create and manage various components like Tables, Views, Types and Domains.<\/li>\n<\/ul>\n<h3>How is SAP ABAP Dictionary related to SQL?<\/h3>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-is-it-Relate-to-SQL.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-85838\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-is-it-Relate-to-SQL.jpg\" alt=\"How is SAP ABAP Related to SQL\" width=\"500\" height=\"300\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-is-it-Relate-to-SQL.jpg 500w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-is-it-Relate-to-SQL-300x180.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-is-it-Relate-to-SQL-150x90.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-is-it-Relate-to-SQL-320x192.jpg 320w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<ul>\n<li>SQL is Structured Query Language<\/li>\n<li>It is the language used by databases, and can be divided into two parts:\n<ul>\n<li><strong>DDL (Data Definition Language):<\/strong> useful for creation and deletion of table<\/li>\n<li><strong>DML (Data Manipulation Language):<\/strong> useful for query and updation of table<\/li>\n<\/ul>\n<\/li>\n<li>In SAP ABAP, Data Dictionary handles the \u2018DML\u2019 part<\/li>\n<\/ul>\n<h3>Levels in SAP ABAP Dictionary<\/h3>\n<p>The elementary levels or types in ABAP Data Dictionary are as follows &#8211;<\/p>\n<h4>1. Data Elements<\/h4>\n<ul>\n<li>Describe the role played by element<\/li>\n<li>Defines the type, length etc, of the elements<\/li>\n<li>Fields equivalent in semantics may refer to same data element<\/li>\n<\/ul>\n<h4>2.\u00a0 Structures<\/h4>\n<ul>\n<li>Structures may have any data type<\/li>\n<li>They are a collection of elementary components<\/li>\n<li>Similar to a table but not as structured as one<\/li>\n<\/ul>\n<h4>3. Tables<\/h4>\n<ul>\n<li>Describes the internal table and its structure<\/li>\n<li>Much more organised than structures<\/li>\n<li>Fields of table are defined with their respective data types<\/li>\n<li>An internal table can be defined independently of its database<\/li>\n<\/ul>\n<h3>Aggregated Objects in the ABAP Dictionary<\/h3>\n<p>Aggregated Objects in ABAP mean the objects that are composed of several elementary objects.<\/p>\n<h4>1. Views<\/h4>\n<ul>\n<li>They are tables that are not stored in permanent memory.<\/li>\n<li>Views are usually used to choose, filter, and combine fields from one or multiple tables and view them as one.<\/li>\n<li>They can summarize data from a table or multiple tables as well.<\/li>\n<li>Views usually serve a specific purpose required for analysis.<\/li>\n<\/ul>\n<h4>2. Lock Objects<\/h4>\n<ul>\n<li>This is basically a synchronisation technique used in case more than one user is currently making changes.<\/li>\n<li>Locks are set and released according to how many people are currently accessing or trying to access an object, and this is done via lock objects.<\/li>\n<\/ul>\n<h4>3. Search Help<\/h4>\n<ul>\n<li>Search help is equivalent to \u2018F1\u2019 used in layman terms.<\/li>\n<li>It is used to search through the names and other data about objects.<\/li>\n<li>If a data record or key is unknown, one may use the search help for assistance.<\/li>\n<li>Keyboard shortcut for search help is the key \u2018F4\u2019.<\/li>\n<\/ul>\n<h3>Functions &amp; Responsibilities of the Data Dictionary<\/h3>\n<p>The data dictionary is tasked with several crucial responsibilities, such as &#8211;<\/p>\n<h4>1. Enforcing and maintaining the integrity of data<\/h4>\n<ul>\n<li>Integrity of data means that all changes made by all authorised users are properly merged, synced and all users view the same data in the same table.<\/li>\n<li>The data dictionary has to make sure this integrity is not compromised, and it uses various mechanisms like lock objects to do so.<\/li>\n<\/ul>\n<h4>2. Avoiding redundancy while managing data definitions<\/h4>\n<ul>\n<li>Data, after all, is stored in the database.<\/li>\n<li>Adding repetitive or redundant information in the database would cause a waste of resources.<\/li>\n<li>While managing data definitions, the data dictionary needs to avoid such redundancy at all costs.<\/li>\n<\/ul>\n<h4>3. Making sure all data is consistent with the ABAP Development Workbench<\/h4>\n<ul>\n<li>The ABAP Development workbench is the central system used by all ABAP developers.<\/li>\n<li>It is a system useful to code programs and the data dictionary must be in check with the changes and updates occurring in the workbench.<\/li>\n<\/ul>\n<h3>How to use Data Dictionary in ABAP<\/h3>\n<p>The steps to get to the Data Dictionary are as follows &#8211;<\/p>\n<ol>\n<li>Open the SAP System \u2192 Easy Access.<\/li>\n<li>Now click on the \u2018Tools\u2019 tab on top.<\/li>\n<li>Select the \u2018ABAP Workbench\u2019 option.<\/li>\n<li>Under the option, you will find a small menu. Click on \u2018Development\u2019.<\/li>\n<li>Now, select \u2018ABAP Dictionary\u2019.<\/li>\n<\/ol>\n<p>This is the screen you will now see &#8211;<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-to-use-Data-Dictionary-in-ABAP.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-85839\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-to-use-Data-Dictionary-in-ABAP.png\" alt=\"How to use Data Dictionary in ABAP\" width=\"413\" height=\"364\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-to-use-Data-Dictionary-in-ABAP.png 413w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-to-use-Data-Dictionary-in-ABAP-300x264.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-to-use-Data-Dictionary-in-ABAP-150x132.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/How-to-use-Data-Dictionary-in-ABAP-320x282.png 320w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/a><\/p>\n<p>Here you can look for various components &#8211;<\/p>\n<ol>\n<li>Database Table<\/li>\n<li>View<\/li>\n<li>Data Type<\/li>\n<li>Type Group<\/li>\n<li>Domain<\/li>\n<li>Search Help<\/li>\n<li>Lock object<\/li>\n<\/ol>\n<p>Once entered, you can choose one of the following options &#8211;<\/p>\n<ol>\n<li><strong>Display:<\/strong> if the object you entered is already created, and you only want to view it but not update.<\/li>\n<li><strong>Change<\/strong>: if the object you entered is already created, and you want to modify it rather than simply view it.<\/li>\n<li><strong>Create<\/strong>: if the object you entered does not exist, but you want to create a new one with that name.<\/li>\n<\/ol>\n<h3>Important Transactions related to ABAP Data Dictionary<\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>TRANSACTION CODE (T-CODE)<\/b><\/td>\n<td><b>DESCRIPTION<\/b><\/td>\n<\/tr>\n<tr>\n<td>SE11<\/td>\n<td>Initial screen of the data dictionary<\/td>\n<\/tr>\n<tr>\n<td>SE12<\/td>\n<td>Initial screen of the data dictionary in read-only mode<\/td>\n<\/tr>\n<tr>\n<td>SE13<\/td>\n<td>Technical settings of the data dictionary<\/td>\n<\/tr>\n<tr>\n<td>SE14<\/td>\n<td>Database utility<\/td>\n<\/tr>\n<tr>\n<td>SE15<\/td>\n<td>Provides information related to the repository<\/td>\n<\/tr>\n<tr>\n<td>SE16<\/td>\n<td>Data browser (to view content of table)<\/td>\n<\/tr>\n<tr>\n<td>SE17<\/td>\n<td>Table display<\/td>\n<\/tr>\n<tr>\n<td>SE38<\/td>\n<td>ABAP editor<\/td>\n<\/tr>\n<tr>\n<td>SE55<\/td>\n<td>Maintenance of table views<\/td>\n<\/tr>\n<tr>\n<td>SE91<\/td>\n<td>Maintenance of messages<\/td>\n<\/tr>\n<tr>\n<td>SE93<\/td>\n<td>Maintenance of transaction (or transaction codes)<\/td>\n<\/tr>\n<tr>\n<td>SM30, SM31<\/td>\n<td>Maintenance of table<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Summary<\/h3>\n<p>Thus, in this tutorial we learnt about a very important component in the world of ABAP &#8211; the Data Dictionary.<\/p>\n<p>The dictionary handles everything from scratch, and stores valuable information related to the data in the repository.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will learn about SAP ABAP Data Dictionary, which is the main point of all information available in the entire database, or information repository. We will learn about what it means,&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":85820,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23786],"tags":[23799,23801,23800],"class_list":["post-85805","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-abap","tag-abap-data-dictionary","tag-abap-dictionary","tag-sap-abap-data-dictionary"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SAP ABAP Data Dictionary - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn what is SAP ABAP Data Dictionary with its functions and responsibilities, Levels in it, Uses and Transactions related to it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP ABAP Data Dictionary - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn what is SAP ABAP Data Dictionary with its functions and responsibilities, Levels in it, Uses and Transactions related to it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-24T04:55:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/SAP-ABAP-Data-Dictionary.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP ABAP Data Dictionary - DataFlair","description":"Learn what is SAP ABAP Data Dictionary with its functions and responsibilities, Levels in it, Uses and Transactions related to it.","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:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/","og_locale":"en_US","og_type":"article","og_title":"SAP ABAP Data Dictionary - DataFlair","og_description":"Learn what is SAP ABAP Data Dictionary with its functions and responsibilities, Levels in it, Uses and Transactions related to it.","og_url":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2021-02-24T04:55:46+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/SAP-ABAP-Data-Dictionary.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9"},"headline":"SAP ABAP Data Dictionary","datePublished":"2021-02-24T04:55:46+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/"},"wordCount":893,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/SAP-ABAP-Data-Dictionary.jpg","keywords":["ABAP Data Dictionary","ABAP Dictionary","SAP ABAP Data Dictionary"],"articleSection":["SAP ABAP Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/","url":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/","name":"SAP ABAP Data Dictionary - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/SAP-ABAP-Data-Dictionary.jpg","datePublished":"2021-02-24T04:55:46+00:00","description":"Learn what is SAP ABAP Data Dictionary with its functions and responsibilities, Levels in it, Uses and Transactions related to it.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/SAP-ABAP-Data-Dictionary.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/02\/SAP-ABAP-Data-Dictionary.jpg","width":1200,"height":628,"caption":"SAP ABAP Data Dictionary"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sap-abap-data-dictionary\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP ABAP Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-abap\/"},{"@type":"ListItem","position":3,"name":"SAP ABAP Data Dictionary"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team is a group of passionate educators and industry experts dedicated to providing high-quality online learning resources on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. With years of experience in the field, the team aims to simplify complex topics and help learners advance their careers. At DataFlair, we believe in empowering students and professionals with the knowledge and skills needed to thrive in today\u2019s fast-paced tech industry. Follow us for Free courses, expert insights, tutorials, and practical tips to boost your learning journey.","url":"https:\/\/data-flair.training\/blogs\/author\/datafbdad\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/85805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=85805"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/85805\/revisions"}],"predecessor-version":[{"id":85840,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/85805\/revisions\/85840"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/85820"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=85805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=85805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=85805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}