{"id":1713,"date":"2019-02-14T00:13:58","date_gmt":"2019-02-14T00:13:58","guid":{"rendered":"https:\/\/www.se80.co.uk\/training-education\/?p=1713"},"modified":"2019-02-18T09:58:14","modified_gmt":"2019-02-18T09:58:14","slug":"populate-sap-table-tcode","status":"publish","type":"post","link":"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/","title":{"rendered":"Populate SAP table t-code"},"content":{"rendered":"\n<p>There are two basic ways you can add data to a database table within your SAP system. The first method is to do it manually via transactions such as SM30, SE16, SE80 etc. The second method is to use <a href=\"https:\/\/www.se80.co.uk\/training-education\/abap-populate-sap-table\/\">ABAP code within a program to add data to an SAP table<\/a>.&nbsp;<\/p>\n<h2>\n<p><strong>Creating table data via SAP transaction SM30 or SE16<\/strong>&nbsp;<\/h2>\n<p>When using transactions SM30 or SE16 to create data it depends on the table settings as to whether you can actually perform this functionality. This is because some tables are not intended to be updated by users manually and are only updated via ABAP code using specific SAP functionality transactions. I.e. table EKKO is updated via SAP purchasing transactions.&nbsp;<\/p>\n<h2>\n<p><strong>Adding database data via transaction SE16<\/strong>&nbsp;<\/h2>\n<p>The easiest way to test if you can update the table manually is to enter it into the t-code SE16 and press the create button or SM30 and press the Maintain button. I will use tables EKKO and J_3RF_PRECMET as examples, J_3RF_PRECMET allows data to be entered and EKKO is restricted.&nbsp;<\/p>\n<p>First execute transaction SE16, enter your table name and press the create button&nbsp;<\/p>\n<p>If the table is not maintainable you will receive the message &#8220;Table maintenance not allowed for table &lt;table&gt;&#8221;&nbsp;<br \/><img decoding=\"async\" src=\"https:\/\/www.se80.co.uk\/sapinfo\/images\/add-data1.png\" \/>&nbsp;<\/p>\n<p>If the table is maintainable like J_3RF_PRECMET then the create entries screen will be displayed.&nbsp;<br \/><img decoding=\"async\" src=\"https:\/\/www.se80.co.uk\/sapinfo\/images\/add-data2.png\" \/>&nbsp;<\/p>\n<p>On the create entries screen click on the New Entries button&nbsp;<br \/><img decoding=\"async\" src=\"https:\/\/www.se80.co.uk\/sapinfo\/images\/add-data3.png\" \/>&nbsp;<\/p>\n<p>You will now be able to add your new entries into the editable fields and press save. At this point, you might be asked for a transport depending table setting and how the data is maintained.&nbsp;<br \/><img decoding=\"async\" src=\"https:\/\/www.se80.co.uk\/sapinfo\/images\/add-data4.png\" \/>&nbsp;<\/p>\n<h2><strong>Adding data via transaction SM30<\/strong>&nbsp;<\/h2>\n<p>Using transaction SM30 is very similar but has slightly different technical requirements. For example, the table needs to have a table maintenance dialog available for it. This is created via t-code SE11 during the table creation process.&nbsp;<\/p>\n<p>To test via SM30 firstly execute the transaction, enter the table name and press maintain&nbsp;<\/p>\n<p>If not maintainable you will get a message along the lines of &#8220;Maintenance dialog for &lt;table&gt; is incomplete or not defined&#8221;.&nbsp;<br \/><img decoding=\"async\" src=\"https:\/\/www.se80.co.uk\/sapinfo\/images\/add-data5.png\" \/>&nbsp;<\/p>\n<p>If it is maintainable and the table maintenance exists you will be taken to the same New entries screen as via SE16.&nbsp;<br \/><img decoding=\"async\" src=\"https:\/\/www.se80.co.uk\/sapinfo\/images\/add-data6.png\" \/>&nbsp;<br \/><img decoding=\"async\" src=\"https:\/\/www.se80.co.uk\/sapinfo\/images\/add-data7.png\" \/>&nbsp;<\/p>\n<p><strong><a href=\"https:\/\/www.se80.co.uk\/sapinfo\/abap-add-table-data.htm\">Add data to SAP table via ABAP code<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are two basic ways you can add data to a database table within your SAP system. The first method is to do it manually via transactions such as SM30, SE16, SE80 etc. The second method is to use ABAP code within a program to add data to an SAP table.&nbsp; Creating table data via [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1799,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[53],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Add data to SAP database table via tcode SM30 SE16 or ABAP code<\/title>\n<meta name=\"description\" content=\"When using transactions SM30 or SE16 to create data it depends on the table settings as to whether you can actually perform this functionality...\" \/>\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.se80.co.uk\/training-education\/populate-sap-table-tcode\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Add data to SAP database table via tcode SM30 SE16 or ABAP code\" \/>\n<meta property=\"og:description\" content=\"When using transactions SM30 or SE16 to create data it depends on the table settings as to whether you can actually perform this functionality...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/\" \/>\n<meta property=\"og:site_name\" content=\"SAP Help, Training and Education\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-14T00:13:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-18T09:58:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.se80.co.uk\/training-education\/wp-content\/uploads\/2019\/02\/add-data5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"332\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"se80\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"se80\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/\",\"url\":\"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/\",\"name\":\"Add data to SAP database table via tcode SM30 SE16 or ABAP code\",\"isPartOf\":{\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#website\"},\"datePublished\":\"2019-02-14T00:13:58+00:00\",\"dateModified\":\"2019-02-18T09:58:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/ddc6a049c1b0790f62d70278be75e511\"},\"description\":\"When using transactions SM30 or SE16 to create data it depends on the table settings as to whether you can actually perform this functionality...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.se80.co.uk\/training-education\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Populate SAP table t-code\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#website\",\"url\":\"https:\/\/www.se80.co.uk\/training-education\/\",\"name\":\"SAP Help, Training and Education\",\"description\":\"Learn SAP\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.se80.co.uk\/training-education\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/ddc6a049c1b0790f62d70278be75e511\",\"name\":\"se80\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3fd4e388f05bf3c763e46cd1f77afeb2?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3fd4e388f05bf3c763e46cd1f77afeb2?s=96&d=retro&r=g\",\"caption\":\"se80\"},\"url\":\"https:\/\/www.se80.co.uk\/training-education\/author\/se80\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Add data to SAP database table via tcode SM30 SE16 or ABAP code","description":"When using transactions SM30 or SE16 to create data it depends on the table settings as to whether you can actually perform this functionality...","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.se80.co.uk\/training-education\/populate-sap-table-tcode\/","og_locale":"en_US","og_type":"article","og_title":"Add data to SAP database table via tcode SM30 SE16 or ABAP code","og_description":"When using transactions SM30 or SE16 to create data it depends on the table settings as to whether you can actually perform this functionality...","og_url":"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/","og_site_name":"SAP Help, Training and Education","article_published_time":"2019-02-14T00:13:58+00:00","article_modified_time":"2019-02-18T09:58:14+00:00","og_image":[{"width":400,"height":332,"url":"https:\/\/www.se80.co.uk\/training-education\/wp-content\/uploads\/2019\/02\/add-data5.png","type":"image\/png"}],"author":"se80","twitter_card":"summary_large_image","twitter_misc":{"Written by":"se80","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/","url":"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/","name":"Add data to SAP database table via tcode SM30 SE16 or ABAP code","isPartOf":{"@id":"https:\/\/www.se80.co.uk\/training-education\/#website"},"datePublished":"2019-02-14T00:13:58+00:00","dateModified":"2019-02-18T09:58:14+00:00","author":{"@id":"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/ddc6a049c1b0790f62d70278be75e511"},"description":"When using transactions SM30 or SE16 to create data it depends on the table settings as to whether you can actually perform this functionality...","breadcrumb":{"@id":"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.se80.co.uk\/training-education\/populate-sap-table-tcode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.se80.co.uk\/training-education\/"},{"@type":"ListItem","position":2,"name":"Populate SAP table t-code"}]},{"@type":"WebSite","@id":"https:\/\/www.se80.co.uk\/training-education\/#website","url":"https:\/\/www.se80.co.uk\/training-education\/","name":"SAP Help, Training and Education","description":"Learn SAP","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.se80.co.uk\/training-education\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/ddc6a049c1b0790f62d70278be75e511","name":"se80","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.se80.co.uk\/training-education\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3fd4e388f05bf3c763e46cd1f77afeb2?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3fd4e388f05bf3c763e46cd1f77afeb2?s=96&d=retro&r=g","caption":"se80"},"url":"https:\/\/www.se80.co.uk\/training-education\/author\/se80\/"}]}},"jetpack_featured_media_url":"https:\/\/www.se80.co.uk\/training-education\/wp-content\/uploads\/2019\/02\/add-data5.png","_links":{"self":[{"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/posts\/1713"}],"collection":[{"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/comments?post=1713"}],"version-history":[{"count":2,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/posts\/1713\/revisions"}],"predecessor-version":[{"id":1715,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/posts\/1713\/revisions\/1715"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/media\/1799"}],"wp:attachment":[{"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/media?parent=1713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/categories?post=1713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.se80.co.uk\/training-education\/wp-json\/wp\/v2\/tags?post=1713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}