{"id":14022,"date":"2026-10-24T00:38:52","date_gmt":"2026-10-23T15:38:52","guid":{"rendered":"https:\/\/sap-career.com\/saplabo\/?p=14022"},"modified":"2026-10-24T00:38:53","modified_gmt":"2026-10-23T15:38:53","slug":"adt_sql_console","status":"publish","type":"post","link":"https:\/\/sap-career.com\/saplabo\/adt_sql_console\/","title":{"rendered":"\u3010SAP\u57fa\u790e\u3011ADT\u306eSQL\u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u7167\u4f1a\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<div class=\"wp-block-group has-border -border01\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><strong>\u3053\u306e\u8a18\u4e8b\u3092\u8aad\u3080\u30e1\u30ea\u30c3\u30c8<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Eclipse \u306e ADT \u3067\u3001\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3092\u958b\u3044\u3066\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u3092\u8868\u793a\u30fb\u7d5e\u308a\u8fbc\u307f\u3059\u308b\u65b9\u6cd5\u304c\u5206\u304b\u308b<\/li>\n\n\n\n<li>SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067 SELECT \u6587\u3092\u6d41\u3057\u3001INNER JOIN \u3067\u306e\u7d50\u5408\u3084 GROUP BY \u3067\u306e\u96c6\u8a08\u3092\u3059\u308b\u65b9\u6cd5\u304c\u5206\u304b\u308b<\/li>\n\n\n\n<li>\u300cMax. Rows\u300d\u300cNumber of Entries\u300d\u300cShow Log\u300d\u306e\u4f7f\u3044\u5206\u3051\u3068\u3001\u3088\u304f\u51fa\u308b\u30a8\u30e9\u30fc\u306e\u76f4\u3057\u65b9\u304c\u5206\u304b\u308b<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u3092\u78ba\u304b\u3081\u308b\u3068\u304d\u3001SE16N \u3067\u306f 2 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3057\u305f\u308a\u3001\u4ef6\u6570\u3092\u96c6\u8a08\u3057\u305f\u308a\u3059\u308b\u306e\u306b\u624b\u9593\u304c\u304b\u304b\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Eclipse \u306b ABAP Development Tools(ADT)\u3092\u5165\u308c\u308b\u3068\u3001<strong>\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc<\/strong> \u3067\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u3092\u8868\u793a\u3067\u304d\u3001<strong>SQL \u30b3\u30f3\u30bd\u30fc\u30eb<\/strong> \u3067 SELECT \u6587\u3092\u305d\u306e\u307e\u307e\u6d41\u305b\u307e\u3059\u3002\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u3089\u305a\u306b\u3001\u7d50\u5408\u3084\u96c6\u8a08\u306e\u7d50\u679c\u3092\u3059\u3050\u306b\u898b\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u6b21\u306e\u64cd\u4f5c\u3092\u753b\u9762\u3092 1 \u3064\u305a\u3064\u8ffd\u3063\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067 <strong>\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u3092\u8868\u793a\u3057\u3001\u7d5e\u308a\u8fbc\u3080\u624b\u9806<\/strong><\/li>\n\n\n\n<li>SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067 <strong>SELECT \u6587\u3092\u6d41\u3057\u3001\u7d50\u5408\u30fb\u96c6\u8a08\u3059\u308b\u624b\u9806<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-left\" data-col=\"red\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u65b0\u5352_\u6012\u308a-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u30ec\u30a4\u30ca<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u535a\u58eb\uff01SE16N \u3060\u3068\u30012 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u3064\u306a\u3044\u3060\u308a\u4ef6\u6570\u3092\u6570\u3048\u305f\u308a\u3059\u308b\u306e\u304c\u5927\u5909\u306a\u3093\u3067\u3059\u2026<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-right\" data-col=\"blue\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2024\/12\/image-12.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u535a\u58eb<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u3046\u3080\u3001Eclipse \u306e ADT \u306a\u3089\u3001SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067 SELECT \u6587\u3092\u305d\u306e\u307e\u307e\u6d41\u305b\u308b\u305e\u3044\u3002\u7d50\u5408\u3082\u96c6\u8a08\u3082\u4e00\u767a\u3058\u3083\uff01<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3068 SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u306e\u6982\u8981<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3068 SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3068\u306f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc<\/strong>(Data Preview)\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u3084\u30d3\u30e5\u30fc\u3001CDS \u30d3\u30e5\u30fc\u306e\u4e2d\u8eab\u3092\u8868\u3068\u3057\u3066\u8868\u793a\u3059\u308b\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u753b\u9762\u3067\u5217\u3084\u6761\u4ef6\u3092\u9078\u3076\u3068\u3001\u88cf\u3067 ABAP SQL \u306e SELECT \u6587\u304c\u7d44\u307f\u7acb\u3066\u3089\u308c\u3066\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e2\u5b9a\u3067\u306f\u3001\u5148\u982d\u306e 100 \u4ef6\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u8868\u793a\u3059\u308b\u4ef6\u6570\u306e\u4e0a\u9650\u306f\u300cMax. Rows\u300d\u3067\u5909\u3048\u3089\u308c\u3001100,000 \u4ef6\u307e\u3067\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SQL \u30b3\u30f3\u30bd\u30fc\u30eb<\/strong>(SQL Console)\u306f\u3001ABAP SQL \u306e SELECT \u6587\u3092\u81ea\u5206\u3067\u66f8\u3044\u3066\u5b9f\u884c\u3059\u308b\u753b\u9762\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u66f8\u3051\u308b\u306e\u306f<strong>\u65b0\u3057\u3044 ABAP SQL \u306e\u69cb\u6587\u3060\u3051<\/strong>\u3067\u3059\u3002\u5217\u306f\u30ab\u30f3\u30de\u3067\u533a\u5207\u308a\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u5225\u540d\u3068\u5217\u306f <code>~<\/code> \u3067\u3064\u306a\u304e\u307e\u3059(\u4f8b: <code>c~bukrs<\/code>)\u3002<\/p>\n\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-left\" data-col=\"red\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u65b0\u5352_\u7591\u554f-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u30ec\u30a4\u30ca<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>c~bukrs \u306e c \u3063\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u306b\u4ed8\u3051\u305f\u3042\u3060\u540d\u307f\u305f\u3044\u306a\u3082\u306e\u3067\u3059\u304b\uff1f<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-right\" data-col=\"blue\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u535a\u58eb_\u901a\u5e38-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u535a\u58eb<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u305d\u306e\u3068\u304a\u308a\u3058\u3083\uff01FROM t001 AS c \u306e\u3088\u3046\u306b\u4ed8\u3051\u305f\u5225\u540d\u3058\u3083\u3088\u3002\u7d50\u5408\u306e\u4f8b\u3067\u306f\u3001T005T \u306b\u3082 t \u3092\u4ed8\u3051\u3066\u3001t~landx \u306e\u3088\u3046\u306b\u66f8\u304f\u306e\u3058\u3083\u3002<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u5b9f\u52d9\u306e\u4f8b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7d4c\u7406\u90e8\u306a\u3069\u304b\u3089\u3001\u4f1a\u793e\u30b3\u30fc\u30c9\u3054\u3068\u306e\u56fd\u540d\u306e\u4e00\u89a7\u3084\u3001\u4f1d\u7968\u30bf\u30a4\u30d7\u3054\u3068\u306e\u4f1d\u7968\u306e\u4ef6\u6570\u3092\u3001\u3059\u3050\u306b\u77e5\u308a\u305f\u3044\u3068\u983c\u307e\u308c\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u306f\u3001\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u78ba\u304b\u3081\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u306e\u7d50\u5408\u3084\u3001\u4f1d\u7968\u30bf\u30a4\u30d7\u3054\u3068\u306e\u4ef6\u6570\u96c6\u8a08\u306f SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u8a18\u4e8b\u306e\u64cd\u4f5c\u3068\u306e\u5bfe\u5fdc\u306f\u3001\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure style=\"font-size:15px\" class=\"wp-block-table\"><table><thead><tr><th>\u3057\u305f\u3044\u3053\u3068<\/th><th>\u4f7f\u3046\u64cd\u4f5c<\/th><\/tr><\/thead><tbody><tr><td>\u4f1a\u793e\u30b3\u30fc\u30c9\u306e\u8a2d\u5b9a\u3092\u898b\u308b<\/td><td><a href=\"#data-preview\">\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u898b\u308b<\/a><\/td><\/tr><tr><td>\u56fd\u540d\u3092\u65e5\u672c\u8a9e\u3067\u4e26\u3079\u308b(2 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3059\u308b)<\/td><td><a href=\"#sql-console\">SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067 SELECT \u6587\u3092\u6d41\u3059<\/a><\/td><\/tr><tr><td>\u4f1d\u7968\u30bf\u30a4\u30d7\u3054\u3068\u306e\u4ef6\u6570\u3092\u6570\u3048\u308b(\u96c6\u8a08\u3059\u308b)<\/td><td><a href=\"#sql-console\">SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067 SELECT \u6587\u3092\u6d41\u3059<\/a><\/td><\/tr><tr><td>\u30c7\u30fc\u30bf\u3092\u76f4\u3059<\/td><td>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u6271\u3044\u307e\u305b\u3093\u3002\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3068 SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u3092\u898b\u308b\u305f\u3081\u306e\u9053\u5177\u3067\u3059<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3068 SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u306e\u4f7f\u3044\u5206\u3051<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_diagram1-1024x683.png\" alt=\"\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3068 SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u306e\u95a2\u4fc2\" class=\"wp-image-14021\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_diagram1-1024x683.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_diagram1-300x200.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_diagram1-768x512.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_diagram1.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"swl-marker mark_yellow\">\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u753b\u9762\u304b\u3089\u6761\u4ef6\u3092\u9078\u3076\u3068 SELECT \u6587\u304c\u7d44\u307f\u7acb\u3066\u3089\u308c\u3001SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u306f SELECT \u6587\u3092\u76f4\u63a5\u66f8\u3044\u3066\u7d50\u679c\u3092\u898b\u308b<\/span>\u3001\u3068\u3044\u3046\u95a2\u4fc2\u3067\u3059\u3002<\/p>\n\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-left\" data-col=\"red\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u65b0\u5352_\u7591\u554f-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u30ec\u30a4\u30ca<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u7d5e\u308a\u8fbc\u3093\u3060\u6761\u4ef6\u306f\u3001SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u3082\u3046\u4e00\u5ea6\u5165\u529b\u3057\u76f4\u3059\u3093\u3067\u3059\u304b\uff1f<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-right\" data-col=\"blue\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u535a\u58eb_\u901a\u5e38-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u535a\u58eb<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u305d\u306e\u5fc5\u8981\u306f\u306a\u3044\u305e\u3044\u3002\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u306e\u300cSQL Console\u300d\u304b\u3089\u958b\u3051\u3070\u3001\u305d\u306e\u6761\u4ef6\u306e SELECT \u6587\u304c\u5165\u3063\u305f SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u304c\u958b\u304f\u306e\u3058\u3083\u3002<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n\n<p class=\"wp-block-paragraph\">2 \u3064\u306e\u753b\u9762\u306e\u9055\u3044\u306f\u3001\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure style=\"font-size:15px\" class=\"wp-block-table\"><table style=\"--swl-cell1-width:160px;\"><thead><tr><th><\/th><th>\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc<\/th><th>SQL \u30b3\u30f3\u30bd\u30fc\u30eb<\/th><\/tr><\/thead><tbody><tr><td>\u958b\u304d\u65b9<\/td><td>\u30c6\u30fc\u30d6\u30eb\u3092\u958b\u3044\u3066 Run As \u2192 ABAP Application<\/td><td>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u53f3\u30af\u30ea\u30c3\u30af \u2192 SQL Console\u3001\u307e\u305f\u306f\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u306e\u300cSQL Console\u300d<\/td><\/tr><tr><td>\u6761\u4ef6\u306e\u6307\u5b9a<\/td><td>\u300cAdd Filter\u300d\u3067\u5217\u3068\u5024\u3092\u9078\u3076<\/td><td>WHERE \u53e5\u3092\u66f8\u304f<\/td><\/tr><tr><td>\u7d50\u5408\u30fb\u9805\u76ee\u5225\u96c6\u8a08<\/td><td>\u3067\u304d\u307e\u305b\u3093<\/td><td>INNER JOIN\u30fbGROUP BY\u30fbCOUNT \u306a\u3069\u3092\u66f8\u3051\u307e\u3059<\/td><\/tr><tr><td>\u4ef6\u6570\u306e\u4e0a\u9650<\/td><td>\u300cMax. Rows\u300d(\u65e2\u5b9a 100)<\/td><td>\u300cMax. Rows\u300d(\u65e2\u5b9a 100)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 id=\"data-preview\" class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u898b\u308b<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4f7f\u3046\u30c7\u30fc\u30bf<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7d4c\u7406\u90e8\u304b\u3089\u300c\u4f1a\u793e\u30b3\u30fc\u30c9\u3054\u3068\u306e\u56fd\u540d\u306e\u4e00\u89a7\u3068\u3001\u4f1a\u793e\u30b3\u30fc\u30c9 1010 \u306e\u4eca\u5e74\u5ea6\u306e\u4f1d\u7968\u304c\u4f1d\u7968\u30bf\u30a4\u30d7\u3054\u3068\u306b\u4f55\u4ef6\u3042\u308b\u304b\u3092\u3001\u3059\u3050\u306b\u77e5\u308a\u305f\u3044\u300d\u3068\u983c\u307e\u308c\u305f\u5834\u9762\u3092\u8003\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u3053\u306e\u4f9d\u983c\u3092\u4f8b\u306b\u64cd\u4f5c\u3057\u307e\u3059\u3002\u4f7f\u3046\u30c7\u30fc\u30bf\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure style=\"font-size:15px\" class=\"wp-block-table\"><table style=\"--swl-cell1-width:220px;\"><thead><tr><th>\u30c7\u30fc\u30bf<\/th><th>\u3053\u306e\u4f8b\u306e\u5024<\/th><th>\u4f7f\u3046\u3068\u3053\u308d<\/th><\/tr><\/thead><tbody><tr><td>\u4f1a\u793e\u30b3\u30fc\u30c9\u306e\u30c6\u30fc\u30d6\u30eb<\/td><td>T001<\/td><td>\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u958b\u304d\u3001SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u3082\u7167\u4f1a\u3057\u307e\u3059<\/td><\/tr><tr><td>\u56fd\u540d\u306e\u30c6\u30fc\u30d6\u30eb<\/td><td>T005T(\u8a00\u8a9e J \u306e\u884c)<\/td><td>T001 \u3068 INNER JOIN \u3067\u3064\u306a\u304e\u3001\u65e5\u672c\u8a9e\u306e\u56fd\u540d\u3092\u51fa\u3057\u307e\u3059<\/td><\/tr><tr><td>\u4f1a\u8a08\u4f1d\u7968\u30d8\u30c3\u30c0\u306e\u30c6\u30fc\u30d6\u30eb<\/td><td>BKPF<\/td><td>\u4f1d\u7968\u30bf\u30a4\u30d7(BLART)\u3054\u3068\u306e\u4ef6\u6570\u3092 GROUP BY \u3067\u6570\u3048\u307e\u3059<\/td><\/tr><tr><td>\u4f1a\u793e\u30b3\u30fc\u30c9<\/td><td>1010(\u7d50\u5408\u306e\u4f8b\u3067\u306f 1010\u30fb1710\u30fbJZ01)<\/td><td>\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u306e\u7d5e\u308a\u8fbc\u307f\u3068\u3001SELECT \u6587\u306e WHERE \u53e5\u306b\u5165\u308c\u307e\u3059<\/td><\/tr><tr><td>\u4f1a\u8a08\u5e74\u5ea6<\/td><td>2026<\/td><td>BKPF \u306e\u4ef6\u6570\u3092\u6570\u3048\u308b WHERE \u53e5\u306b\u5165\u308c\u307e\u3059<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u8a18\u306e\u5024\u306f\u3001\u3053\u306e\u8a18\u4e8b\u3067\u4f7f\u3063\u305f\u691c\u8a3c\u74b0\u5883\u306e\u3082\u306e\u3067\u3059\u3002\u3054\u81ea\u5206\u306e\u74b0\u5883\u3067\u306f\u3001\u4f1a\u793e\u30b3\u30fc\u30c9\u3068\u4f1a\u8a08\u5e74\u5ea6\u3092\u3001\u305d\u308c\u305e\u308c\u306e\u5024\u306b\u8aad\u307f\u66ff\u3048\u3066\u304f\u3060\u3055\u3044\u3002\u30c6\u30fc\u30d6\u30eb\u540d\u306f\u8aad\u307f\u66ff\u3048\u305a\u306b\u3001\u305d\u306e\u307e\u307e\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u524d\u63d0\u6761\u4ef6\u3068\u3057\u3066\u3001Eclipse \u306b ABAP Development Tools(ADT)\u3092\u5165\u308c\u3001SAP \u306e\u30b7\u30b9\u30c6\u30e0\u306b\u3064\u306a\u3044\u3060 ABAP \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3042\u308f\u305b\u3066\u3001ADT \u3092\u4f7f\u3046\u305f\u3081\u306e\u30ed\u30fc\u30eb(SAP \u306e\u6a19\u6e96\u30ed\u30fc\u30eb\u3067\u306f SAP_BC_DWB_ABAPDEVELOPER \u306a\u3069)\u3068\u3001\u898b\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u8868\u793a\u6a29\u9650\u3082\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Eclipse \u3068 ADT \u306e\u5165\u308c\u65b9\u3001ABAP \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4f5c\u308a\u65b9\u306f\u3001\u6b21\u306e\u8a18\u4e8b\u306e\u300cEclipse \u3092\u6e96\u5099\u3059\u308b\u300d\u3067\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type2\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/odatarap_eyecatch-300x158.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/sap-career.com\/saplabo\/sap-fiori-odata-rap\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u3010SAP Fiori\u3011RAP\u3067OData\u30b5\u30fc\u30d3\u30b9\u3092\u4f5c\u308b\u65b9\u6cd5<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">\u3053\u306e\u8a18\u4e8b\u3092\u8aad\u3080\u30e1\u30ea\u30c3\u30c8 RAP \u3067 OData \u30b5\u30fc\u30d3\u30b9\u3092\u4f5c\u308b\u9806\u756a(CDS \u30d3\u30e5\u30fc \u2192 \u30b5\u30fc\u30d3\u30b9\u5b9a\u7fa9 \u2192 \u30b5\u30fc\u30d3\u30b9\u30d0\u30a4\u30f3\u30c7\u30a3\u30f3\u30b0 \u2192 \u516c\u958b)\u304c\u5206\u304b\u308b Eclipse(ADT)\u306e\u753b\u9762\u3067\u3001CDS \u30d3\u30e5\u30fc\u30fb&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n<h3 class=\"wp-block-heading\">1. \u30c6\u30fc\u30d6\u30eb\u3092\u958b\u304f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Project Explorer \u3067 ABAP \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u3073\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30e1\u30cb\u30e5\u30fc\u306e\u300cNavigate\u300d\u2192\u300cOpen ABAP Development Object&#8230;\u300d\u3092\u9078\u3073\u307e\u3059\u3002Ctrl+Shift+A \u30ad\u30fc\u3067\u3082\u958b\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cOpen ABAP Development Object\u300d\u306e\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"546\" height=\"793\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_01_open_object_u2.png\" alt=\"\u30c6\u30fc\u30d6\u30eb\u3092\u63a2\u3059\" class=\"wp-image-14409\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_01_open_object_u2.png 546w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_01_open_object_u2-207x300.png 207w\" sizes=\"(max-width: 546px) 100vw, 546px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>\u691c\u7d22\u6b04<\/strong>: \u958b\u304f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u540d\u524d\u3092\u5165\u308c\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>Matching items<\/strong>: \u540d\u524d\u306b\u5408\u3046\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u4e00\u89a7\u3067\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u300c(Database Table)\u300d\u304c\u4ed8\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>OK<\/strong>: \u9078\u3093\u3060\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u958b\u304d\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u4f8b\u3067\u306f\u3001<code>T001<\/code> \u3068\u5165\u308c\u3001\u300cT001 (Database Table)\u300d\u3092\u9078\u3093\u3067\u2462\u300cOK\u300d\u3092\u62bc\u3057\u307e\u3059\u3002T001 \u306e\u5b9a\u7fa9\u304c\u30a8\u30c7\u30a3\u30bf\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. \u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3092\u958b\u304f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">T001 \u306e\u5b9a\u7fa9\u3092\u958b\u3044\u305f\u307e\u307e\u3001\u30e1\u30cb\u30e5\u30fc\u306e\u300cRun\u300d\u2192\u300cRun As\u300d\u2192\u300c1 ABAP Application\u300d\u3092\u9078\u3073\u307e\u3059(F8 \u30ad\u30fc\u3067\u3082\u958b\u3051\u307e\u3059)\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"701\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_02_run_as_u3-1024x701.png\" alt=\"Run As \u30e1\u30cb\u30e5\u30fc\" class=\"wp-image-14454\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_02_run_as_u3-1024x701.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_02_run_as_u3-300x205.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_02_run_as_u3-768x526.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_02_run_as_u3.png 1384w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>Run<\/strong>: \u5b9f\u884c\u306e\u30e1\u30cb\u30e5\u30fc\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>Run As<\/strong>: \u5b9f\u884c\u306e\u3057\u304b\u305f\u3092\u9078\u3073\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>1 ABAP Application<\/strong>: \u30c6\u30fc\u30d6\u30eb\u3067\u306f\u3001\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u304c\u958b\u304d\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">3. \u7d50\u679c\u306e\u753b\u9762\u3092\u898b\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cData Preview\u300d\u306e\u30bf\u30d6\u306b\u3001T001 \u306e\u4e2d\u8eab\u304c\u8868\u3068\u3057\u3066\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"443\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_03_preview_v2-1-1024x443.png\" alt=\"\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\" class=\"wp-image-14036\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_03_preview_v2-1-1024x443.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_03_preview_v2-1-300x130.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_03_preview_v2-1-768x332.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_03_preview_v2-1.png 1445w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>\u53d6\u308a\u51fa\u3057\u305f\u4ef6\u6570<\/strong>: \u300c100 rows retrieved\u300d\u306f\u3001100 \u4ef6\u3092\u53d6\u308a\u51fa\u3057\u3066\u8868\u793a\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u8868\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>SQL Console<\/strong>: \u3044\u307e\u306e\u6761\u4ef6\u306e SELECT \u6587\u3092 SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u958b\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>Number of Entries<\/strong>: \u6761\u4ef6\u306b\u5408\u3046\u4ef6\u6570\u3092\u6570\u3048\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>Add Filter<\/strong>: \u7d5e\u308a\u8fbc\u3080\u5217\u3092\u9078\u3073\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>Show Log<\/strong>: \u88cf\u3067\u5b9f\u884c\u3057\u305f SQL \u6587\u306e\u8a18\u9332\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>Max. Rows<\/strong>: \u53d6\u308a\u51fa\u3059\u4ef6\u6570\u306e\u4e0a\u9650\u3067\u3059\u3002\u65e2\u5b9a\u306f 100 \u4ef6\u3067\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-left\" data-col=\"red\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u65b0\u5352_\u7591\u554f-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u30ec\u30a4\u30ca<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u300c100 rows retrieved\u300d\u3063\u3066\u3001T001 \u306b\u306f 100 \u4ef6\u3057\u304b\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u304b\uff1f<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-right\" data-col=\"blue\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u535a\u58eb_\u901a\u5e38-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u535a\u58eb<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u305d\u3046\u3068\u306f\u9650\u3089\u3093\u305e\u3044\u3002\u65e2\u5b9a\u3067\u306f\u3001\u5148\u982d\u306e 100 \u4ef6\u3060\u3051\u3092\u53d6\u308a\u51fa\u3057\u3066\u8868\u793a\u3057\u3066\u304a\u308b\u306e\u3058\u3083\u3002\u6761\u4ef6\u306b\u5408\u3046\u4ef6\u6570\u3092\u3059\u3079\u3066\u6570\u3048\u308b\u306b\u306f\u3001\u300cNumber of Entries\u300d\u3092\u4f7f\u3046\u306e\u3058\u3083\u3088\u3002<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n\n<h3 class=\"wp-block-heading\">4. \u6761\u4ef6\u3067\u7d5e\u308a\u8fbc\u3080<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u2460\u300cAdd Filter\u300d\u3092\u62bc\u3057\u3066\u3001\u7d5e\u308a\u8fbc\u3080\u5217\u3092\u9078\u3073\u307e\u3059\u3002\u3053\u306e\u4f8b\u3067\u306f BUKRS(\u4f1a\u793e\u30b3\u30fc\u30c9)\u3092\u9078\u3073\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u53f3\u306b\u300cFilters\u300d\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u5024\u306e\u6b04\u306b <code>1010<\/code> \u3068\u5165\u308c\u3066 Enter \u30ad\u30fc\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"247\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_04_filter_v2-1-1024x247.png\" alt=\"\u7d5e\u308a\u8fbc\u3093\u3060\u7d50\u679c\" class=\"wp-image-14037\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_04_filter_v2-1-1024x247.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_04_filter_v2-1-300x72.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_04_filter_v2-1-768x185.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_04_filter_v2-1-1536x371.png 1536w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_04_filter_v2-1.png 1864w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>Add Filter<\/strong>: \u7d5e\u308a\u8fbc\u3080\u5217\u3092\u9078\u3076\u30dc\u30bf\u30f3\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>Filters<\/strong>: \u9078\u3093\u3060\u5217\u3068\u6761\u4ef6\u3067\u3059\u3002\u300c=\u300d\u306e\u53f3\u306b\u5024\u3092\u5165\u308c\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u53d6\u308a\u51fa\u3057\u305f\u4ef6\u6570<\/strong>: \u300c1 rows retrieved\u300d\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>\u7d50\u679c<\/strong>: \u4f1a\u793e\u30b3\u30fc\u30c9 1010 \u306e 1 \u884c\u3060\u3051\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">5. \u4ef6\u6570\u3092\u6570\u3048\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cNumber of Entries\u300d\u3092\u62bc\u3059\u3068\u3001\u300cNumber of Entries\u300d\u306e\u30c0\u30a4\u30a2\u30ed\u30b0\u306b\u3001\u6761\u4ef6\u306b\u5408\u3046\u4ef6\u6570\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"880\" height=\"250\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_05_entries.png\" alt=\"\u6761\u4ef6\u306b\u5408\u3046\u4ef6\u6570\" class=\"wp-image-14009\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_05_entries.png 880w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_05_entries-300x85.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_05_entries-768x218.png 768w\" sizes=\"(max-width: 880px) 100vw, 880px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>\u4ef6\u6570<\/strong>: \u300cNumber of entries that meet the selection criteria: 1\u300d\u3067\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cNumber of Entries\u300d\u306f\u3001\u300cMax. Rows\u300d\u306b\u95a2\u4fc2\u306a\u304f\u3001\u6761\u4ef6\u306b\u5408\u3046\u4ef6\u6570\u3092\u3059\u3079\u3066\u6570\u3048\u307e\u3059\u3002\u4ef6\u6570\u306e\u591a\u3044\u30c6\u30fc\u30d6\u30eb\u3067\u3001\u8868\u793a\u3057\u304d\u308c\u306a\u3044\u4ef6\u6570\u3092\u78ba\u304b\u3081\u308b\u3068\u304d\u306b\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">6. \u88cf\u3067\u5b9f\u884c\u3057\u305f SQL \u6587\u3092\u898b\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cShow Log\u300d\u3092\u62bc\u3059\u3068\u3001\u300cData Explorer Log\u300d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u304c\u7d44\u307f\u7acb\u3066\u3066\u5b9f\u884c\u3057\u305f SQL \u6587\u304c\u3001\u65b0\u3057\u3044\u3082\u306e\u307b\u3069\u4e0b\u306b\u4e26\u3073\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"880\" height=\"780\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_06_log_u2.png\" alt=\"\u5b9f\u884c\u3057\u305f SQL \u6587\u306e\u8a18\u9332\" class=\"wp-image-14411\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_06_log_u2.png 880w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_06_log_u2-300x266.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_06_log_u2-768x681.png 768w\" sizes=\"(max-width: 880px) 100vw, 880px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>Generated SQL<\/strong>: \u8868\u3092\u8868\u793a\u3057\u305f\u3068\u304d\u306e SELECT \u6587\u3067\u3059\u3002\u5217\u304c <code>T001~MANDT, T001~BUKRS, \u2026<\/code> \u306e\u3088\u3046\u306b\u4e26\u3073\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u4ef6\u6570\u3092\u6570\u3048\u305f SQL<\/strong>: \u300cNumber of Entries\u300d\u3067\u5b9f\u884c\u3057\u305f <code>SELECT COUNT( * )<\/code> \u306e\u6587\u3067\u3059\u3002\u7d5e\u308a\u8fbc\u307f\u306e\u6761\u4ef6(<code>WHERE BUKRS = '1010'<\/code>)\u3082\u5165\u3063\u3066\u3044\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">7. \u7d50\u679c\u3092\u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7d50\u679c\u306e\u8868\u306e\u53f3\u4e0a\u306b\u3042\u308b\u4fdd\u5b58\u306e\u30a2\u30a4\u30b3\u30f3\u306e \u25bc \u3092\u62bc\u3059\u3068\u3001\u4fdd\u5b58\u3059\u308b\u5f62\u5f0f\u3092\u9078\u3079\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"925\" height=\"290\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_07_export_v2-1.png\" alt=\"\u4fdd\u5b58\u306e\u5f62\u5f0f\" class=\"wp-image-14039\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_07_export_v2-1.png 925w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_07_export_v2-1-300x94.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_07_export_v2-1-768x241.png 768w\" sizes=\"(max-width: 925px) 100vw, 925px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>\u4fdd\u5b58\u306e\u30a2\u30a4\u30b3\u30f3<\/strong>: \u7d50\u679c\u3092\u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u5f62\u5f0f<\/strong>: \u300cDelimited text file\u300d(\u533a\u5207\u308a\u6587\u5b57\u306e\u30c6\u30ad\u30b9\u30c8)\u3001\u300cHTML file\u300d\u3001\u300cXML file\u300d\u3001\u300cABAP value statement text file\u300d\u304b\u3089\u9078\u3073\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h2 id=\"sql-console\" class=\"wp-block-heading\">SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067 SELECT \u6587\u3092\u6d41\u3059<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3092\u958b\u304f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Project Explorer \u3067 ABAP \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3001\u300cSQL Console\u300d\u3092\u9078\u3073\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"870\" height=\"1020\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_09_console_from_project_u2.png\" alt=\"\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304b\u3089\u958b\u304f\" class=\"wp-image-14412\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_09_console_from_project_u2.png 870w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_09_console_from_project_u2-256x300.png 256w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_09_console_from_project_u2-768x900.png 768w\" sizes=\"(max-width: 870px) 100vw, 870px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>ABAP \u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/strong>: SELECT \u6587\u3092\u6d41\u3059\u30b7\u30b9\u30c6\u30e0\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>SQL Console<\/strong>: \u4f55\u3082\u5165\u3063\u3066\u3044\u306a\u3044 SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3092\u958b\u304d\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u306e\u300cSQL Console\u300d\u304b\u3089\u958b\u304f\u3068\u3001\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u7d5e\u308a\u8fbc\u3093\u3060\u6761\u4ef6\u306e SELECT \u6587\u304c\u5165\u3063\u305f\u72b6\u614b\u3067\u958b\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u3067\u5f62\u3092\u4f5c\u3063\u3066\u304b\u3089\u3001SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u66f8\u304d\u8db3\u3059\u3068\u697d\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_08_console_from_preview_v2-1024x535.png\" alt=\"\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u304b\u3089\u958b\u3044\u305f SQL \u30b3\u30f3\u30bd\u30fc\u30eb\" class=\"wp-image-14040\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_08_console_from_preview_v2-1024x535.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_08_console_from_preview_v2-300x157.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_08_console_from_preview_v2-768x402.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_08_console_from_preview_v2-1536x803.png 1536w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_08_console_from_preview_v2.png 1865w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>SQL \u306e\u6b04<\/strong>: SELECT \u6587\u3092\u66f8\u304d\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u304b\u3089\u958b\u304f\u3068\u3001\u305d\u306e\u6761\u4ef6\u306e\u6587\u304c\u5165\u308a\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u7d50\u679c<\/strong>: \u5b9f\u884c\u3057\u305f\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30ed\u30b0<\/strong>: \u5b9f\u884c\u3057\u305f\u6642\u523b\u3068\u3001\u6210\u529f\u3057\u305f\u304b\u5931\u6557\u3057\u305f\u304b\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2. SELECT \u6587\u3092\u6d41\u3059<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQL \u306e\u6b04\u306e\u4e2d\u8eab\u3092\u6d88\u3057\u3066\u3001\u6b21\u306e\u6587\u3092\u5165\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT bukrs, butxt, land1, waers, ktopl FROM t001 WHERE bukrs = '1010'<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cRun\u300d\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_10_select_v2-1024x535.png\" alt=\"SELECT \u6587\u306e\u7d50\u679c\" class=\"wp-image-14041\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_10_select_v2-1024x535.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_10_select_v2-300x157.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_10_select_v2-768x402.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_10_select_v2-1536x803.png 1536w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_10_select_v2.png 1865w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>SELECT \u6587<\/strong>: \u5217\u306f\u30ab\u30f3\u30de\u3067\u533a\u5207\u308a\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>Run<\/strong>: \u6587\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u7d50\u679c<\/strong>: SELECT \u6587\u3067\u9078\u3093\u3060 5 \u3064\u306e\u5217\u3060\u3051\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30ed\u30b0<\/strong>: \u300cQuery successfully executed\u300d\u306f\u3001\u5b9f\u884c\u304c\u6210\u529f\u3057\u305f\u3053\u3068\u3092\u8868\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">3. 2 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">T001 \u306e LAND1 \u306b\u306f\u56fd\u306e\u30ad\u30fc\u304c\u5165\u3063\u3066\u3044\u307e\u3059\u3002\u65e5\u672c\u8a9e\u306e\u56fd\u540d\u306f\u3001\u30c6\u30fc\u30d6\u30eb T005T \u306e\u8a72\u5f53\u3059\u308b\u8a00\u8a9e\u306e\u884c\u304b\u3089\u53d6\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306e\u6587\u3067\u30012 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092 INNER JOIN \u3067\u3064\u306a\u304e\u3001\u65e5\u672c\u8a9e\u306e\u56fd\u540d\u3092\u4e26\u3079\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT c~bukrs, c~butxt, c~land1, t~landx\n  FROM t001 AS c\n  INNER JOIN t005t AS t ON t~land1 = c~land1 AND t~spras = 'J'\n  WHERE c~bukrs IN ('1010','1710','JZ01')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_11_join_v2-1024x535.png\" alt=\"\u7d50\u5408\u306e\u7d50\u679c\" class=\"wp-image-14042\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_11_join_v2-1024x535.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_11_join_v2-300x157.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_11_join_v2-768x402.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_11_join_v2-1536x803.png 1536w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_11_join_v2.png 1865w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>SELECT \u6587<\/strong>: <code>AS c<\/code>\u30fb<code>AS t<\/code> \u3067\u30c6\u30fc\u30d6\u30eb\u306b\u5225\u540d\u3092\u4ed8\u3051\u3001\u5217\u306f <code>c~bukrs<\/code> \u306e\u3088\u3046\u306b <code>~<\/code> \u3067\u3064\u306a\u304e\u307e\u3059\u3002T005T \u306f\u8a00\u8a9e\u3054\u3068\u306b\u884c\u304c\u3042\u308b\u306e\u3067\u3001<code>t~spras = 'J'<\/code> \u3067\u65e5\u672c\u8a9e\u306e\u884c\u3060\u3051\u306b\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u53d6\u308a\u51fa\u3057\u305f\u4ef6\u6570<\/strong>: 3 \u4ef6\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>\u7d50\u679c<\/strong>: LANDX(\u56fd\u540d)\u306b\u30011010\u30fb1710 \u306e\u884c\u306f\u300c\u30c9\u30a4\u30c4\u300d\u3001JZ01 \u306e\u884c\u306f\u300c\u65e5\u672c\u300d\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">4. \u4ef6\u6570\u3092\u96c6\u8a08\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306e\u6587\u3067\u3001\u4f1a\u793e\u30b3\u30fc\u30c9 1010 \u306e 2026 \u5e74\u5ea6\u306e\u4f1a\u8a08\u4f1d\u7968\u3092\u3001\u4f1d\u7968\u30bf\u30a4\u30d7(BLART)\u3054\u3068\u306b\u6570\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT blart, COUNT(*) AS cnt FROM bkpf\n  WHERE bukrs = '1010' AND gjahr = '2026'\n  GROUP BY blart ORDER BY cnt DESCENDING<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_12_groupby_v2-1024x535.png\" alt=\"\u96c6\u8a08\u306e\u7d50\u679c\" class=\"wp-image-14043\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_12_groupby_v2-1024x535.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_12_groupby_v2-300x157.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_12_groupby_v2-768x402.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_12_groupby_v2-1536x803.png 1536w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_12_groupby_v2.png 1865w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>SELECT \u6587<\/strong>: <code>COUNT(*)<\/code> \u3067\u4ef6\u6570\u3092\u6570\u3048\u3001<code>GROUP BY blart<\/code> \u3067\u4f1d\u7968\u30bf\u30a4\u30d7\u3054\u3068\u306b\u307e\u3068\u3081\u307e\u3059\u3002<code>ORDER BY cnt DESCENDING<\/code> \u3067\u4ef6\u6570\u306e\u591a\u3044\u9806\u306b\u4e26\u3079\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u53d6\u308a\u51fa\u3057\u305f\u4ef6\u6570<\/strong>: \u3053\u306e\u4f8b\u3067\u306f 22 \u4ef6(\u4f1d\u7968\u30bf\u30a4\u30d7\u304c 22 \u7a2e\u985e)\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>\u7d50\u679c<\/strong>: SA \u304c 409 \u4ef6\u3001WE \u304c 271 \u4ef6\u3068\u3001\u4ef6\u6570\u306e\u591a\u3044\u9806\u306b\u4e26\u3073\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-right\" data-col=\"blue\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u535a\u58eb_\u9ed2\u677f\u6307\u793a-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u535a\u58eb<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u3053\u306e\u4f8b\u306e\u96c6\u8a08\u6587\u3067\u306f\u3001SELECT \u306e\u5217\u306b\u3082 blart \u3092\u5165\u308c\u308b\u306e\u3058\u3083\u3002\u5165\u308c\u306a\u3044\u6587\u3067\u306f\u300cIncorrect nesting\u300d\u306e\u30a8\u30e9\u30fc\u306b\u306a\u308b\u305e\u3044\u3002<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n\n<h3 class=\"wp-block-heading\">5. \u53d6\u308a\u51fa\u3059\u4ef6\u6570\u3092\u6c7a\u3081\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cMax. Rows\u300d\u3092 <code>5<\/code> \u306b\u3057\u3066\u3001\u3082\u3046\u4e00\u5ea6\u300cRun\u300d\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_13_maxrows_v2-1-1024x535.png\" alt=\"\u4ef6\u6570\u3092 5 \u4ef6\u306b\u3057\u305f\u7d50\u679c\" class=\"wp-image-14044\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_13_maxrows_v2-1-1024x535.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_13_maxrows_v2-1-300x157.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_13_maxrows_v2-1-768x402.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_13_maxrows_v2-1-1536x803.png 1536w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_13_maxrows_v2-1.png 1865w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>Max. Rows<\/strong>: \u53d6\u308a\u51fa\u3059\u4ef6\u6570\u306e\u4e0a\u9650\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>\u53d6\u308a\u51fa\u3057\u305f\u4ef6\u6570<\/strong>: \u300c5 rows retrieved\u300d\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>\u7d50\u679c<\/strong>: \u4ef6\u6570\u306e\u591a\u3044\u9806\u306e\u4e0a\u304b\u3089 5 \u4ef6\u3060\u3051\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"swl-marker mark_yellow\">SQL \u6587\u306e\u4e2d\u306e\u4ef6\u6570\u306e\u6307\u5b9a\u3067\u306f\u306a\u304f\u3001\u300cMax. Rows\u300d\u3067\u53d6\u308a\u51fa\u3059\u4ef6\u6570\u306e\u4e0a\u9650\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/span>SQL \u6587\u306e\u4e2d\u306b\u4ef6\u6570\u3092\u66f8\u3044\u3066\u3082\u3001\u300cMax. Rows\u300d\u306e\u5024\u304c\u4f7f\u308f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5168\u4f53\u306e\u4ef6\u6570\u3092\u77e5\u308a\u305f\u3044\u3068\u304d\u306f\u3001\u7d50\u679c\u306e\u4e0a\u306e\u300cNumber of Entries\u300d\u3092\u62bc\u3057\u307e\u3059\u3002\u3053\u306e\u4f8b\u3067\u306f 22 \u4ef6\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">6. \u524d\u306b\u6d41\u3057\u305f\u6587\u3092\u547c\u3073\u51fa\u3059<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u300cRun\u300d\u306e\u53f3\u306e \u25bc \u3092\u62bc\u3059\u3068\u3001\u3053\u308c\u307e\u3067\u306b\u6d41\u3057\u305f SELECT \u6587\u304c\u65b0\u3057\u3044\u9806\u306b\u4e26\u3073\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"620\" height=\"702\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_16_history_v2-1.png\" alt=\"\u5b9f\u884c\u306e\u5c65\u6b74\" class=\"wp-image-14047\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_16_history_v2-1.png 620w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_16_history_v2-1-265x300.png 265w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>\u25bc<\/strong>: \u5c65\u6b74\u3068\u304a\u6c17\u306b\u5165\u308a\u306e\u30e1\u30cb\u30e5\u30fc\u3092\u958b\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u5c65\u6b74<\/strong>: \u524d\u306b\u6d41\u3057\u305f SELECT \u6587\u3067\u3059\u3002\u9078\u3076\u3068\u3001\u305d\u306e\u6587\u304c\u5165\u3063\u305f SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u304c\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>History&#8230; \u306a\u3069<\/strong>: \u300cHistory&#8230;\u300d\u3067\u5c65\u6b74\u306e\u4e00\u89a7\u3092\u958b\u304d\u3001\u300cClear History\u300d\u3067\u5c65\u6b74\u3092\u6d88\u3057\u307e\u3059\u3002\u3088\u304f\u4f7f\u3046\u6587\u306f\u300cAdd To Favorites\u300d\u3067\u304a\u6c17\u306b\u5165\u308a\u306b\u5165\u308c\u3066\u304a\u304f\u3068\u3088\u3044\u3067\u3057\u3087\u3046\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u3088\u304f\u3042\u308b\u3064\u307e\u305a\u304d<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u300cThe elements in the &#8220;SELECT LIST&#8221; list must be separated using commas.\u300d\u3068\u51fa\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5217\u3092\u30ab\u30f3\u30de\u3067\u533a\u5207\u3063\u3066\u3044\u307e\u305b\u3093\u3002SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u306f\u3001\u65b0\u3057\u3044 ABAP SQL \u306e\u69cb\u6587\u3060\u3051\u304c\u4f7f\u3048\u307e\u3059\u3002<br><code>SELECT bukrs butxt<\/code> \u3067\u306f\u306a\u304f <code>SELECT bukrs, butxt<\/code> \u3068\u66f8\u304f\u306e\u304c\u6b63\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_14_err_comma_v2-1-1024x535.png\" alt=\"\u30ab\u30f3\u30de\u304c\u7121\u3044\u3068\u304d\u306e\u30a8\u30e9\u30fc\" class=\"wp-image-14045\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_14_err_comma_v2-1-1024x535.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_14_err_comma_v2-1-300x157.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_14_err_comma_v2-1-768x402.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_14_err_comma_v2-1-1536x803.png 1536w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_14_err_comma_v2-1.png 1865w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>\u30a8\u30e9\u30fc\u306e\u5370<\/strong>: \u30a8\u30e9\u30fc\u306e\u3042\u308b\u884c\u306b\u8d64\u3044\u5370\u304c\u4ed8\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30ed\u30b0<\/strong>: \u300cQuery execution failed\u300d\u3068\u3001\u30a8\u30e9\u30fc\u306e\u7406\u7531\u304c\u8d64\u5b57\u3067\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u300cIncorrect nesting: For the statement &#8220;CATCH&#8221;, there is no open structure introduced by &#8220;TRY&#8221;.\u300d\u3068\u51fa\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u4f8b\u306e\u96c6\u8a08\u6587\u3067\u306f\u3001GROUP BY \u306b\u66f8\u3044\u305f\u5217 blart \u304c SELECT \u306e\u5217\u306b\u5165\u3063\u3066\u3044\u306a\u3044\u3068\u3001\u3053\u306e\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<br>GROUP BY \u306e\u5217\u3092\u3001SELECT \u306e\u5217\u306b\u3082\u5165\u308c\u308b\u3068\u901a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u4f8b\u306e 2 \u3064\u306e\u6587\u306e\u7d50\u679c\u306f\u3001\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure style=\"font-size:15px\" class=\"wp-block-table\"><table><thead><tr><th>SELECT \u6587<\/th><th>\u7d50\u679c<\/th><\/tr><\/thead><tbody><tr><td>SELECT COUNT(*) AS cnt \u2026 GROUP BY blart<\/td><td>\u3053\u306e\u30a8\u30e9\u30fc\u306b\u306a\u308b<\/td><\/tr><tr><td>SELECT blart, COUNT(*) AS cnt \u2026 GROUP BY blart<\/td><td>\u901a\u308b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u30a8\u30e9\u30fc\u306e\u6587\u306f SELECT \u6587\u3068\u95a2\u4fc2\u306a\u304f\u898b\u3048\u308b\u306e\u3067\u3001GROUP BY \u3092\u4f7f\u3063\u305f\u6587\u3067\u3053\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3089\u3001\u307e\u305a SELECT \u306e\u5217\u3092\u78ba\u304b\u3081\u308b\u3068\u3088\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_15_err_groupby_v2-1-1024x535.png\" alt=\"GROUP BY \u306e\u5217\u304c\u7121\u3044\u3068\u304d\u306e\u30a8\u30e9\u30fc\" class=\"wp-image-14046\" srcset=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_15_err_groupby_v2-1-1024x535.png 1024w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_15_err_groupby_v2-1-300x157.png 300w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_15_err_groupby_v2-1-768x402.png 768w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_15_err_groupby_v2-1-1536x803.png 1536w, https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2026\/10\/adtsql_15_err_groupby_v2-1.png 1865w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_point\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"0\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><strong><span class=\"swl-fz u-fz-l\"><span class=\"swl-marker mark_yellow\">\u753b\u9762\u306e\u898b\u65b9<\/span><\/span><\/strong><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMiA0NkM3LjkgMjkuMSAyMi40IDIgNDYgMmMtMTYuMiA5LjUtMTMuMiAyOS0yNiAyOS0xLjIgMC0yLjQuMS0zLjYuMi0zIC40LTQuOCAxLjktNi42IDQuNEM4LjIgMzcuOSA1LjMgNDMgNCA0NkgyeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsQuill\" data-id=\"5\" aria-hidden=\"true\" class=\"swl-inline-icon\"><span class=\"swl-fz u-fz-l\">\u2003<\/span><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list is-style-num_circle\">\n<li><strong>SELECT \u6587<\/strong>: GROUP BY \u306e\u5217 blart \u304c SELECT \u306b\u5165\u3063\u3066\u3044\u307e\u305b\u3093\u3002<\/li>\n\n\n\n<li><strong>\u30ed\u30b0<\/strong>: \u300cIncorrect nesting\u300d\u306e\u30a8\u30e9\u30fc\u3067\u3059\u3002<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u305d\u306e\u307b\u304b<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>2 \u3064\u306e\u5217\u3092\u6bd4\u3079\u308b\u6761\u4ef6\u304c\u30a8\u30e9\u30fc\u306b\u306a\u308b<\/strong>: \u5225\u540d\u3092\u4ed8\u3051\u305a\u306b <code>WHERE bwkey &lt;&gt; werks<\/code> \u306e\u3088\u3046\u306b\u5217\u3069\u3046\u3057\u3092\u6bd4\u3079\u308b\u3068\u3001\u53f3\u306e\u5217\u304c ABAP \u306e\u5909\u6570\u3068\u307f\u306a\u3055\u308c\u3066\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<br><code>FROM t001w AS x WHERE x~bwkey &lt;&gt; x~werks<\/code> \u306e\u3088\u3046\u306b\u3001\u5225\u540d\u3092\u4ed8\u3051\u3066 <code>~<\/code> \u3067\u3064\u306a\u304e\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u4ef6\u6570\u304c 100 \u4ef6\u3067\u6b62\u307e\u308b<\/strong>: \u300cMax. Rows\u300d\u306e\u65e2\u5b9a\u306f 100 \u4ef6\u3067\u3059\u3002<br>\u5168\u4f53\u306e\u4ef6\u6570\u306f\u300cNumber of Entries\u300d\u3067\u78ba\u304b\u3081\u3001\u8868\u793a\u3057\u305f\u3044\u4ef6\u6570\u306b\u5408\u308f\u305b\u3066\u300cMax. Rows\u300d\u3092\u5909\u3048\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>CDS \u30d3\u30e5\u30fc\u306e\u4ef6\u6570\u304c\u601d\u3063\u305f\u3088\u308a\u5c11\u306a\u3044<\/strong>: CDS \u30d3\u30e5\u30fc\u306b\u30a2\u30af\u30bb\u30b9\u5236\u5fa1\u304c\u4ed8\u3044\u3066\u3044\u308b\u3068\u3001\u30e6\u30fc\u30b6\u306e\u6a29\u9650\u3067\u884c\u304c\u7d5e\u3089\u308c\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u76f4\u63a5\u898b\u308b\u5834\u5408\u3068\u4ef6\u6570\u304c\u9055\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<br>\u4ef6\u6570\u3092\u6bd4\u3079\u308b\u3068\u304d\u306f\u3001\u30a2\u30af\u30bb\u30b9\u5236\u5fa1\u306e\u5f71\u97ff\u3082\u78ba\u304b\u3081\u308b\u3068\u3088\u3044\u3067\u3057\u3087\u3046\u3002<\/li>\n\n\n\n<li><strong>\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u306a\u3044\u30fb\u6a29\u9650\u306e\u30a8\u30e9\u30fc\u306b\u306a\u308b<\/strong>: \u898b\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u8868\u793a\u6a29\u9650\u304c\u8db3\u308a\u306a\u3044\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<br>\u30a8\u30e9\u30fc\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u6a29\u9650\u306e\u7ba1\u7406\u8005\u306b\u4f1d\u3048\u3066\u3001\u78ba\u304b\u3081\u3066\u3082\u3089\u3046\u3068\u3088\u3044\u3067\u3057\u3087\u3046\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u307e\u3068\u3081<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u958b\u3044\u3066\u300cRun\u300d\u2192\u300cRun As\u300d\u2192\u300c1 ABAP Application\u300d(F8)\u3067\u958b\u304d\u307e\u3059\u3002<br>\u300cAdd Filter\u300d\u3067\u7d5e\u308a\u8fbc\u307f\u3001\u300cNumber of Entries\u300d\u3067\u4ef6\u6570\u3092\u6570\u3048\u3001\u300cShow Log\u300d\u3067\u88cf\u306e SELECT \u6587\u3092\u78ba\u304b\u3081\u3089\u308c\u307e\u3059\u3002<\/li>\n\n\n\n<li>SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u306f\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u53f3\u30af\u30ea\u30c3\u30af\u3001\u307e\u305f\u306f\u30c7\u30fc\u30bf\u30d7\u30ec\u30d3\u30e5\u30fc\u306e\u300cSQL Console\u300d\u3067\u958b\u304d\u307e\u3059\u3002<br>\u65b0\u3057\u3044 ABAP SQL \u306e\u69cb\u6587\u3067 SELECT \u6587\u3092\u66f8\u304d\u3001\u300cRun\u300d\u3067\u7d50\u679c\u3092\u898b\u307e\u3059\u3002INNER JOIN \u3067\u306e\u7d50\u5408\u3084\u3001GROUP BY\u30fbCOUNT \u3067\u306e\u96c6\u8a08\u3082\u66f8\u3051\u307e\u3059\u3002<\/li>\n\n\n\n<li>\u53d6\u308a\u51fa\u3059\u4ef6\u6570\u306e\u4e0a\u9650\u306f\u300cMax. Rows\u300d\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\u524d\u306b\u6d41\u3057\u305f\u6587\u306f\u3001\u300cRun\u300d\u306e\u53f3\u306e \u25bc \u304b\u3089\u547c\u3073\u51fa\u305b\u307e\u3059\u3002<\/li>\n<\/ul>\n\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-left\" data-col=\"red\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u65b0\u5352_\u7591\u554f-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u30ec\u30a4\u30ca<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u524d\u306b\u6d41\u3057\u305f\u96c6\u8a08\u6587\u3092\u4f7f\u3044\u305f\u3044\u3068\u304d\u306f\u3001\u307e\u305f\u4e00\u304b\u3089\u66f8\u304d\u76f4\u3059\u3093\u3067\u3059\u304b\uff1f<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>\n\n<div class=\"swell-block-balloon\"><div class=\"c-balloon -bln-right\" data-col=\"blue\"><div class=\"c-balloon__icon -square\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/sap-career.com\/saplabo\/wp-content\/uploads\/2023\/12\/\u535a\u58eb_\u9ed2\u677f\u6307\u793a-150x150.png\" alt=\"\" class=\"c-balloon__iconImg\" width=\"80px\" height=\"80px\"><span class=\"c-balloon__iconName\">\u535a\u58eb<\/span><\/div><div class=\"c-balloon__body -speaking -border-on\"><div class=\"c-balloon__text\">\n<p>\u305d\u306e\u5fc5\u8981\u306f\u306a\u3044\u305e\u3044\u3002\u300cRun\u300d\u306e\u53f3\u306e \u25bc \u306e\u5c65\u6b74\u304b\u3089\u9078\u3079\u3070\u3001\u305d\u306e\u6587\u304c\u5165\u3063\u305f SQL \u30b3\u30f3\u30bd\u30fc\u30eb\u304c\u958b\u304f\u306e\u3058\u3083\u3002\u66f8\u304d\u76f4\u3059\u3068\u304d\u3082\u3001\u5217\u306f\u30ab\u30f3\u30de\u3067\u533a\u5207\u308b\u65b0\u3057\u3044\u69cb\u6587\u3067\u66f8\u304f\u306e\u3058\u3083\u305e\u3002<\/p>\n<span class=\"c-balloon__shapes\"><span class=\"c-balloon__before\"><\/span><span class=\"c-balloon__after\"><\/span><\/span><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>\u3053\u306e\u8a18\u4e8b\u3092\u8aad\u3080\u30e1\u30ea\u30c3\u30c8 \u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u3092\u78ba\u304b\u3081\u308b\u3068\u304d\u3001SE16N \u3067\u306f 2 \u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3057\u305f\u308a\u3001\u4ef6\u6570\u3092\u96c6\u8a08\u3057\u305f\u308a\u3059\u308b\u306e\u306b\u624b\u9593\u304c\u304b\u304b\u308a\u307e\u3059\u3002 Eclipse \u306b ABAP Development Tools(ADT) [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":14023,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","footnotes":""},"categories":[295],"tags":[79,123,1045,1046,1047],"class_list":["post-14022","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","tag-sap","tag-abap","tag-adt","tag-sql","tag-eclipse"],"_links":{"self":[{"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/posts\/14022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/comments?post=14022"}],"version-history":[{"count":8,"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/posts\/14022\/revisions"}],"predecessor-version":[{"id":15021,"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/posts\/14022\/revisions\/15021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/media\/14023"}],"wp:attachment":[{"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/media?parent=14022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/categories?post=14022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sap-career.com\/saplabo\/wp-json\/wp\/v2\/tags?post=14022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}