{"id":862,"date":"2024-11-19T16:14:39","date_gmt":"2024-11-19T07:14:39","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=862"},"modified":"2025-03-24T08:52:48","modified_gmt":"2025-03-23T23:52:48","slug":"abap-%e5%86%85%e9%83%a8%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=862","title":{"rendered":"ABAP \u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u306b\u3064\u3044\u3066"},"content":{"rendered":"\n<div class=\"toc\"><br \/>\n<b>Warning<\/b>:  Undefined array key \"is_admin\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>116<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_category_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>121<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>128<\/b><br \/>\n    <div id=\"toc_container\" class=\"sgb-toc--bullets js-smooth-scroll\" data-dialog-title=\"\u76ee\u6b21\">\n      <p class=\"toc_title\">\u76ee\u6b21 <\/p>\n      <ul class=\"toc_list\">  <li class=\"first\">    <a href=\"#i-0\">\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u306e\u57fa\u790e\u77e5\u8b58\u3092\u62bc\u3055\u3048\u3088\u3046<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u3068\u306f\u4f55\u304b\uff1f\u30e1\u30e2\u30ea\u4e0a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-2\">3\u3064\u306e\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u578b\u306e\u69cb\u6587\u30eb\u30fc\u30eb<\/a>      <\/li>      <li>        <a href=\"#i-3\">3\u3064\u306e\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u578b\u306e\u7279\u5fb4\u3068\u4f7f\u3044\u5206\u3051<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-4\">\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u5ba3\u8a00\u3059\u308b\u969b\u306e\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-5\">\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u52b9\u7387\u7684\u306b\u64cd\u4f5c\u3059\u308b\u30c6\u30af\u30cb\u30c3\u30af<\/a>    <ul class=\"menu_level_1\">      <li class=\"first last\">        <a href=\"#i-6\">\u30c7\u30fc\u30bf\u306e\u8ffd\u52a0\u30fb\u5909\u66f4\u30fb\u524a\u9664\u3092\u6700\u9069\u5316\u3059\u308b\u65b9\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-7\">\u5b9f\u8df5\u7684\u306a\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u6d3b\u7528\u8853<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-8\">\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u3067\u306e\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u306e\u4f7f\u3044\u65b9<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-9\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u3068\u306e\u9023\u643a\u30c6\u30af\u30cb\u30c3\u30af<\/a>      <\/li>    <\/ul>  <\/li><\/ul>\n      <a href=\"#\" class=\"sgb-toc-button js-toc-button\" rel=\"nofollow\" data-open-dialog=\"true\"><i class=\"fa fa-list\"><\/i><span class=\"sgb-toc-button__text\">\u76ee\u6b21\u3078<\/span><\/a>\n    <\/div><\/div><h2 class=\"wp-block-heading\" id=\"i-0\">\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u306e\u57fa\u790e\u77e5\u8b58\u3092\u62bc\u3055\u3048\u3088\u3046<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u3068\u306f\u4f55\u304b\uff1f\u30e1\u30e2\u30ea\u4e0a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/h3>\n\n\n\n<p>\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u306f\u3001ABAP\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u30e1\u30e2\u30ea\u4e0a\u306b\u4f5c\u6210\u3055\u308c\u308b\u4e00\u6642\u7684\u306a\u30c7\u30fc\u30bf\u69cb\u9020\u3067\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u3068\u306f\u7570\u306a\u308a\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u5b9f\u884c\u4e2d\u306e\u307f\u5b58\u5728\u3057\u3001\u9ad8\u901f\u306a\u30c7\u30fc\u30bf\u51e6\u7406\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u4e3b\u306a\u7279\u5fb4\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30d7\u30ed\u30b0\u30e9\u30e0\u7d42\u4e86\u6642\u306b\u30c7\u30fc\u30bf\u304c\u6d88\u53bb\u3055\u308c\u308b<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u4e0a\u3067\u9ad8\u901f\u306a\u51e6\u7406\u304c\u53ef\u80fd<\/li>\n\n\n\n<li>\u67d4\u8edf\u306a\u30c7\u30fc\u30bf\u69cb\u9020\u306e\u5b9a\u7fa9\u304c\u53ef\u80fd<\/li>\n\n\n\n<li>\u52d5\u7684\u306a\u30b5\u30a4\u30ba\u5909\u66f4\u304c\u53ef\u80fd<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">3\u3064\u306e\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u578b\u306e\u69cb\u6587\u30eb\u30fc\u30eb<\/h3>\n\n\n\n<p>ABAP\u306b\u306f3\u3064\u306e\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u578b\u304c\u3042\u308a\u3001\u305d\u308c\u305e\u308c\u7570\u306a\u308b\u69cb\u6587\u30eb\u30fc\u30eb\u306b\u5f93\u3044\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Standard Table\uff08\u6a19\u6e96\u30c6\u30fc\u30d6\u30eb\uff09<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DATA: gt_standard TYPE STANDARD TABLE OF scarr      \"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30a2\u30af\u30bb\u30b9\u7528\n      WITH NON-UNIQUE KEY carrid.                   \"\u975e\u30e6\u30cb\u30fc\u30af\u30ad\u30fc\u5b9a\u7fa9<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Sorted Table\uff08\u30bd\u30fc\u30c8\u30c6\u30fc\u30d6\u30eb\uff09<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DATA: gt_sorted TYPE SORTED TABLE OF scarr  \"\u30bd\u30fc\u30c8\u9806\u3067\u30a2\u30af\u30bb\u30b9\n      WITH UNIQUE KEY carrid.               \"\u30e6\u30cb\u30fc\u30af\u30ad\u30fc\u5fc5\u9808<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>Hashed Table\uff08\u30cf\u30c3\u30b7\u30e5\u30c6\u30fc\u30d6\u30eb\uff09<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DATA: gt_hashed TYPE HASHED TABLE OF scarr  \"\u30cf\u30c3\u30b7\u30e5\u30a2\u30af\u30bb\u30b9\n      WITH UNIQUE KEY carrid.               \"\u30e6\u30cb\u30fc\u30af\u30ad\u30fc\u5fc5\u9808<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-3\">3\u3064\u306e\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u578b\u306e\u7279\u5fb4\u3068\u4f7f\u3044\u5206\u3051<\/h3>\n\n\n<div id=\"id-1afedeae-c0c8-4900-a6e6-22bda18b8de1\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30c6\u30fc\u30d6\u30eb\u578b<\/th><th>\u4e3b\u306a\u7279\u5fb4<\/th><th>\u6700\u9069\u306a\u4f7f\u7528\u30b7\u30fc\u30f3<\/th><\/tr><\/thead><tbody><tr><td><font style=\"vertical-align: inherit;\"><font style=\"vertical-align: inherit;\">Standard Table\uff08\u6a19\u6e96\u30c6\u30fc\u30d6\u30eb\uff09<\/font><\/font><\/td><td>\u30fb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306b\u3088\u308b\u30a2\u30af\u30bb\u30b9<br>\u30fb\u30ad\u30fc\u306f\u4efb\u610f<br>\u30fb\u91cd\u8907\u53ef\u80fd<\/td><td>\u30fb\u30b7\u30fc\u30b1\u30f3\u30b7\u30e3\u30eb\u306a\u51e6\u7406<br>\u30fb\u5c0f\u301c\u4e2d\u898f\u6a21\u30c7\u30fc\u30bf<\/td><\/tr><tr><td><font style=\"vertical-align: inherit;\"><font style=\"vertical-align: inherit;\">Sorted Table\uff08\u30bd\u30fc\u30c8\u30c6\u30fc\u30d6\u30eb\uff09<\/font><\/font><\/td><td>\u30fb\u5e38\u306b\u30bd\u30fc\u30c8\u3055\u308c\u305f\u72b6\u614b<br>\u30fb\u30d0\u30a4\u30ca\u30ea\u30b5\u30fc\u30c1\u53ef\u80fd<br>\u30fb\u30ad\u30fc\u5fc5\u9808<\/td><td>\u30fb\u983b\u7e41\u306a\u691c\u7d22\u51e6\u7406<br>\u30fb\u30bd\u30fc\u30c8\u9806\u306e\u7dad\u6301\u304c\u5fc5\u8981<\/td><\/tr><tr><td><font style=\"vertical-align: inherit;\"><font style=\"vertical-align: inherit;\">Hashed Table\uff08\u30cf\u30c3\u30b7\u30e5\u30c6\u30fc\u30d6\u30eb\uff09<\/font><\/font><\/td><td>\u30fb\u30cf\u30c3\u30b7\u30e5\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0\u3067\u691c\u7d22<br>\u30fb\u30ad\u30fc\u5fc5\u9808<br>\u30fb\u9806\u5e8f\u306a\u3057<\/td><td>\u30fb\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u691c\u7d22<br>\u30fb\u4e00\u610f\u6027\u306e\u4fdd\u8a3c\u304c\u5fc5\u8981<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-4\">\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u5ba3\u8a00\u3059\u308b\u969b\u306e\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u69cb\u9020\u5b9a\u7fa9\u306e\u65b9\u6cd5<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\" \u65e2\u5b58\u306e\u30c7\u30fc\u30bf\u8981\u7d20\u3092\u4f7f\u7528\nDATA: gt_carriers TYPE STANDARD TABLE OF scarr.\n\n\" \u30a4\u30f3\u30e9\u30a4\u30f3\u3067\u69cb\u9020\u5b9a\u7fa9\nTYPES: BEGIN OF ty_custom,\n         id    TYPE i,\n         name  TYPE string,\n         value TYPE p DECIMALS 2,\n       END OF ty_custom.\nDATA: gt_custom TYPE TABLE OF ty_custom.<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30ad\u30fc\u5b9a\u7fa9\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u691c\u7d22\u983b\u5ea6\u306e\u9ad8\u3044\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u30ad\u30fc\u306b\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u30ad\u30fc\u9577\u306e\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30ad\u30fc\u30bf\u30a4\u30d7\uff08UNIQUE\/NON-UNIQUE\uff09\u306e\u9078\u629e<\/li>\n<\/ul>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u521d\u671f\u30b5\u30a4\u30ba\u306e\u6307\u5b9a<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\" \u4e88\u60f3\u3055\u308c\u308b\u30b5\u30a4\u30ba\u3092\u6307\u5b9a\u3057\u3066\u30e1\u30e2\u30ea\u52b9\u7387\u3092\u6539\u5584\nDATA: gt_large_table TYPE STANDARD TABLE OF scarr\n      INITIAL SIZE 1000.<\/pre>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong>\u53c2\u7167\u30c6\u30fc\u30d6\u30eb\u306e\u6d3b\u7528<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\" \u4ed6\u306e\u30c6\u30fc\u30d6\u30eb\u3068\u540c\u3058\u69cb\u9020\u3092\u4f7f\u7528\nDATA: gt_reference LIKE TABLE OF gt_carriers.<\/pre>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u57fa\u790e\u77e5\u8b58\u3092\u62bc\u3055\u3048\u308b\u3053\u3068\u3067\u3001\u9069\u5207\u306a\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u578b\u306e\u9078\u629e\u3068\u52b9\u7387\u7684\u306a\u5b9f\u88c5\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u5b9f\u969b\u306b\u3069\u306e\u3088\u3046\u306b\u64cd\u4f5c\u3059\u308b\u304b\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-5\">\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u52b9\u7387\u7684\u306b\u64cd\u4f5c\u3059\u308b\u30c6\u30af\u30cb\u30c3\u30af<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u30c7\u30fc\u30bf\u306e\u8ffd\u52a0\u30fb\u5909\u66f4\u30fb\u524a\u9664\u3092\u6700\u9069\u5316\u3059\u308b\u65b9\u6cd5<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u306e\u8ffd\u52a0\uff08INSERT\/APPEND\uff09<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DATA: gt_flights TYPE STANDARD TABLE OF sflight.\n\n\" \u5358\u4e00\u884c\u306e\u8ffd\u52a0\uff1aAPPEND\u304c\u6700\u3082\u9ad8\u901f\nAPPEND INITIAL LINE TO gt_flights.        \"\u6700\u5f8c\u306b\u7a7a\u306e\u884c\u3092\u8ffd\u52a0\n\n\" \u8907\u6570\u884c\u306e\u4e00\u62ec\u8ffd\u52a0\uff1aINSERT\u3092\u4f7f\u7528\nINSERT LINES OF lt_new_flights           \"\u4ed6\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\n       INTO TABLE gt_flights.\n\n\" \u4f4d\u7f6e\u3092\u6307\u5b9a\u3057\u305f\u8ffd\u52a0\uff1a\u5fc5\u8981\u306a\u5834\u5408\u306e\u307f\u4f7f\u7528\nINSERT ls_flight INTO gt_flights         \"\u6307\u5b9a\u4f4d\u7f6e\u3078\u306e\u8ffd\u52a0\u306f\u4f4e\u901f\n       INDEX 1.<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u306e\u66f4\u65b0\uff08MODIFY\uff09<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\" \u30ad\u30fc\u306b\u3088\u308b\u66f4\u65b0\uff1a\u30cf\u30c3\u30b7\u30e5\u30c6\u30fc\u30d6\u30eb\u3067\u6700\u901f\nMODIFY TABLE gt_flights                  \n       FROM ls_flight\n       TRANSPORTING price currency       \"\u66f4\u65b0\u9805\u76ee\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\n       WHERE carrid = 'LH'.\n\n\" \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306b\u3088\u308b\u76f4\u63a5\u66f4\u65b0\uff1a\u6a19\u6e96\u30c6\u30fc\u30d6\u30eb\u3067\u6709\u52b9\nMODIFY gt_flights \n       FROM ls_flight\n       INDEX lv_index.                   \"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6307\u5b9a\u3067\u306e\u66f4\u65b0<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u306e\u524a\u9664\uff08DELETE\uff09<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\" \u30ad\u30fc\u306b\u3088\u308b\u524a\u9664\uff1a\u691c\u7d22\u30b3\u30b9\u30c8\u306b\u6ce8\u610f\nDELETE gt_flights WHERE carrid = 'LH'.   \"\u6761\u4ef6\u306b\u3088\u308b\u524a\u9664\n\n\" \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306b\u3088\u308b\u524a\u9664\uff1a\u9ad8\u901f\u3060\u304c\u4f4d\u7f6e\u306e\u628a\u63e1\u304c\u5fc5\u8981\nDELETE gt_flights INDEX 1.               \"\u5148\u982d\u884c\u306e\u524a\u9664\n\n\" \u7bc4\u56f2\u524a\u9664\uff1a\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u4e00\u62ec\u524a\u9664\u306b\u52b9\u679c\u7684\nDELETE gt_flights FROM 1 TO 100.         \"\u7bc4\u56f2\u6307\u5b9a\u3067\u306e\u524a\u9664<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-7\">\u5b9f\u8df5\u7684\u306a\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u6d3b\u7528\u8853<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u3067\u306e\u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30e1\u30e2\u30ea\u52b9\u7387\u3092\u8003\u616e\u3057\u305f\u30c7\u30fc\u30bf\u53d6\u5f97<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\" \u5927\u91cf\u30c7\u30fc\u30bf\u3092\u52b9\u7387\u7684\u306b\u51e6\u7406\u3059\u308b\u4f8b\nDATA: gt_items TYPE STANDARD TABLE OF vbap.\n\n\" \u63a8\u5968\uff1a\u5fc5\u8981\u306a\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u307f\u9078\u629e\nSELECT vbeln posnr matnr kwmeng\n  FROM vbap\n  WHERE vbeln IN @lt_orders\n  INTO CORRESPONDING FIELDS OF TABLE @gt_items\n  PACKAGE SIZE 10000.                    \"\u30d1\u30c3\u30b1\u30fc\u30b8\u30b5\u30a4\u30ba\u306e\u6307\u5b9a\n  \" \u30d1\u30c3\u30b1\u30fc\u30b8\u5358\u4f4d\u306e\u51e6\u7406\nENDSELECT.\n\n\" \u975e\u63a8\u5968\uff1a\u5168\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u9078\u629e\u306f\u907f\u3051\u308b\nSELECT *                                 \"\u4e0d\u8981\u306a\u30e1\u30e2\u30ea\u6d88\u8cbb\n  FROM vbap\n  INTO TABLE @gt_items.<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30d0\u30c3\u30d5\u30a1\u30ea\u30f3\u30b0\u6226\u7565<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\" \u983b\u7e41\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u30c7\u30fc\u30bf\u306e\u30d0\u30c3\u30d5\u30a1\u30ea\u30f3\u30b0\nDATA: gt_buffer TYPE HASHED TABLE OF mara\n      WITH UNIQUE KEY matnr.\n\n\" \u521d\u56de\u30a2\u30af\u30bb\u30b9\u6642\u306b\u30d0\u30c3\u30d5\u30a1\u306b\u683c\u7d0d\nSELECT matnr maktx mtart\n  FROM mara\n  WHERE matnr IN @lt_required_materials\n  INTO TABLE @gt_buffer.\n\n\" \u4ee5\u964d\u306f\u30d0\u30c3\u30d5\u30a1\u304b\u3089\u306e\u9ad8\u901f\u30a2\u30af\u30bb\u30b9\nREAD TABLE gt_buffer\n  WITH TABLE KEY matnr = ls_item-matnr\n  INTO ls_material.<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u3068\u306e\u9023\u643a\u30c6\u30af\u30cb\u30c3\u30af<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u540c\u671f<\/strong><\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\" \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u5dee\u5206\u66f4\u65b0\nLOOP AT gt_changes INTO ls_change\n  GROUP BY ( matnr = ls_change-matnr\n             count = GROUP SIZE )\n  INTO DATA(ls_group).\n\n  \" \u4e00\u62ec\u66f4\u65b0\u51e6\u7406\n  UPDATE mara\n    SET mtart = @ls_new_mtart\n    WHERE matnr = @ls_group-matnr.\n\n  IF sy-subrc = 0.\n    \" \u5185\u90e8\u30c6\u30fc\u30d6\u30eb\u306e\u66f4\u65b0\n    MODIFY gt_materials FROM ls_change\n      TRANSPORTING mtart\n      WHERE matnr = ls_group-matnr.\n  ENDIF.\nENDLOOP.<\/pre>\n\n\n\n<p>\u5b9f\u88c5\u306e\u30dd\u30a4\u30f3\u30c8\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306f\u30d1\u30c3\u30b1\u30fc\u30b8\u30b5\u30a4\u30ba\u3092\u9069\u5207\u306b\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30d0\u30c3\u30d5\u30a1\u7ba1\u7406\u3092\u9069\u5207\u306b\u884c\u3044\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u6700\u9069\u5316<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u540c\u671f\u306f\u5dee\u5206\u66f4\u65b0\u3092\u57fa\u672c\u3068\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u5b9f\u8df5\u7684\u306a\u30c6\u30af\u30cb\u30c3\u30af\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u30d3\u30b8\u30cd\u30b9\u30ed\u30b8\u30c3\u30af\u3092\u52b9\u7387\u7684\u306b\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Warning: Undefined array key &#8220;is_admin&#8221; in \/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/ &#8230; <\/p>\n","protected":false},"author":1,"featured_media":2915,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,11],"tags":[],"class_list":{"0":"post-862","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sap-abap","8":"category-sap"},"_links":{"self":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=862"}],"version-history":[{"count":17,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/862\/revisions"}],"predecessor-version":[{"id":2953,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/862\/revisions\/2953"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/media\/2915"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}