{"id":7390,"date":"2025-08-05T01:59:31","date_gmt":"2025-08-04T20:29:31","guid":{"rendered":"https:\/\/www.sapewmhelp.com\/?question=tmg-table-maintenence-generator"},"modified":"2025-08-05T01:59:31","modified_gmt":"2025-08-04T20:29:31","slug":"tmg-table-maintenence-generator","status":"publish","type":"question","link":"https:\/\/www.sapewmhelp.com\/?question=tmg-table-maintenence-generator","title":{"rendered":"TMG ( Table Maintenence Generator )"},"content":{"rendered":"<p>The <strong>Table Maintenance Generator<\/strong> allows authorized users or support staff to:<\/p>\n<ul>\n<li>Maintain data in custom or standard tables without writing ABAP code.<\/li>\n<li>Provide a standardized UI for table maintenance.<\/li>\n<li>Enforce data consistency and validation through events and screen logic.<\/li>\n<\/ul>\n<table>\n<thead>\n<tr>\n<th>Use Case<\/th>\n<th>Description<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Maintain custom config tables<\/td>\n<td>Enter config data via SM30 instead of hardcoding<\/td>\n<\/tr>\n<tr>\n<td>Provide easy admin UI<\/td>\n<td>Let end-users maintain master or transactional data<\/td>\n<\/tr>\n<tr>\n<td>Enforce field-level validation<\/td>\n<td>Add checks during insert\/update via events<\/td>\n<\/tr>\n<tr>\n<td>Integrate with transport system<\/td>\n<td>Save table entries into transport requests<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 data-start=\"1126\" data-end=\"1152\">How to Create a TMG<\/h2>\n<ol>\n<li>\n<p><strong>Go to SE11<\/strong> \u2192 Create or open your <strong>Z-table<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Ensure:<\/p>\n<ul>\n<li>\n<p><strong>Delivery class = C<\/strong>, L, or G (client-dependent or -independent).<\/p>\n<\/li>\n<li>\n<p>Table is <strong>not pooled or clustered<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Table has a <strong>primary key<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>Click on <strong>Utilities<\/strong> \u2192 <strong>Table Maintenance Generator<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Enter:<\/p>\n<ul>\n<li>\n<p><strong>Authorization group<\/strong> (e.g., <code>&amp;NC&amp;<\/code> for none).<\/p>\n<\/li>\n<li>\n<p><strong>Function group<\/strong> (create one if needed).<\/p>\n<\/li>\n<li>\n<p>Maintenance type: One-step or two-step.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>Click <strong>Create<\/strong> \u2192 Save &amp; Activate.<\/p>\n<\/li>\n<\/ol>\n<p>Now, you can maintain the table via transaction <strong>SM30<\/strong>.<\/p>\n<p><strong>One-Step vs Two-Step<\/strong><\/p>\n<table>\n<thead>\n<tr>\n<th>Type<\/th>\n<th>Description<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>One-Step<\/td>\n<td>Data is maintained directly in list view<\/td>\n<\/tr>\n<tr>\n<td>Two-Step<\/td>\n<td>Selection screen first, then detail view (form)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","question-category":[158],"question_tags":[178,240,177,291],"class_list":["post-7390","question","type-question","status-publish","hentry","question-category-abap","question_tags-abap","question_tags-ddic","question_tags-sap","question_tags-tmg"],"_links":{"self":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question\/7390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question"}],"about":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7390"}],"wp:attachment":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7390"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion-category&post=7390"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion_tags&post=7390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}