{"id":2209,"date":"2023-02-28T11:05:16","date_gmt":"2023-02-28T03:05:16","guid":{"rendered":"http:\/\/www.netxintai.com\/?p=2209"},"modified":"2023-02-28T11:07:02","modified_gmt":"2023-02-28T03:07:02","slug":"%e4%bd%bf%e7%94%a8alsm_excel_to_internal_tabl-%e8%af%bb%e5%8f%96excel%e6%95%b0%e6%8d%ae%e5%88%b0sap%e7%a8%8b%e5%ba%8f%e5%86%85%e8%a1%a8","status":"publish","type":"post","link":"https:\/\/www.netxintai.com\/?p=2209","title":{"rendered":"\u4f7f\u7528ALSM_EXCEL_TO_INTERNAL_TABL \u8bfb\u53d6excel\u6570\u636e\u5230SAP\u7a0b\u5e8f\u5185\u8868"},"content":{"rendered":"<p>ABAP\u8bfb\u53d6Excel\u6587\u4ef6\u53ef\u4ee5\u4f7f\u7528\u591a\u79cd\u65b9\u5f0f\u5b9e\u73b0,\u6700\u5e38\u89c1\u7684\u5c31\u662f\u4f7f\u7528\u6807\u51c6\u51fd\u6570\u8fdb\u884c\u8bfb\u53d6\uff0c\u5bf9\u4e8e\u671f\u521d\u5bfc\u5165\u6709\u5f88\u5927\u5e2e\u52a9\u3002\u5e38\u7528\u7684\u6807\u51c6\u51fd\u6570\u67092\u4e2a\uff0cALSM_EXCEL_TO_INTERNAL_TABL \u548c TEXT_CONVERT_XLS_TO_SAP<\/p>\n<p>\u6587\u7ae0\u91c7\u7528\u7684\u662fALSM_EXCEL_TO_INTERNAL_TABL\u5bf9excel\u8fdb\u884c\u5904\u7406\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n<pre class=\"brush:java;toolbar:false\">data&nbsp;:begin&nbsp;of&nbsp;gs_itab&nbsp;,&nbsp;&nbsp;**\u5b9a\u4e49\u5185\u8868\u4eceexcel\u83b7\u53d6\u6570\u636e\u540e\u5199\u5165\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;matnr&nbsp;type&nbsp;mara-matnr,\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mtart&nbsp;type&nbsp;mara-mtart,\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;matkl&nbsp;type&nbsp;mara-matkl,\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MEINS&nbsp;type&nbsp;mara-MEINS.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end&nbsp;of&nbsp;gs_itab.\t\r\n\r\ndata&nbsp;:&nbsp;gt_itab&nbsp;like&nbsp;TABLE&nbsp;OF&nbsp;&nbsp;gs_itab&nbsp;&nbsp;.\t\r\n\r\nPARAMETERS&nbsp;P_FILE&nbsp;LIKE&nbsp;rlgrap-filename&nbsp;OBLIGATORY.\r\n\r\n&nbsp;AT&nbsp;SELECTION-SCREEN&nbsp;ON&nbsp;VALUE-REQUEST&nbsp;FOR&nbsp;P_FILE.\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PERFORM&nbsp;FRM_GET_FILE.\r\n\r\n&nbsp;&nbsp;START-OF-SELECTION.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PERFORM&nbsp;frm_get_excel.\r\n\r\n\r\nFORM&nbsp;FRM_GET_FILE.\r\n\r\n\r\n&nbsp;&nbsp;DATA:&nbsp;lt_filetab&nbsp;TYPE&nbsp;filetable,\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;l_rc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TYPE&nbsp;i.\r\n&nbsp;&nbsp;CLEAR&nbsp;lt_filetab.\r\n\r\n&nbsp;&nbsp;REFRESH&nbsp;lt_filetab.\r\n&nbsp;&nbsp;&nbsp;&nbsp;CALL&nbsp;METHOD&nbsp;CL_GUI_FRONTEND_SERVICES=&gt;FILE_OPEN_DIALOG\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EXPORTING\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;window_title&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&#39;\u6253\u5f00.xls\u6587\u4ef6&#39;&nbsp;&quot;\u5f39\u51fa\u5bf9\u8bdd\u6846\u7684\u62ac\u5934\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&nbsp;default_extension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&#39;123.xlsx&#39;&quot;\u9ed8\u8ba4\u7684\u6269\u5c55\u540d\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;&nbsp;&nbsp;default_filename&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&#39;123&#39;&nbsp;&nbsp;&quot;\u9ed8\u8ba4\u7684\u6587\u4ef6\u540d\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;file_filter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;CL_GUI_FRONTEND_SERVICES=&gt;FILETYPE_EXCEL&nbsp;&quot;\u53ea\u663e\u793a\u67d0\u4e2d\u6587\u4ef6\u7c7b\u578b\r\n*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;with_encoding&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;initial_directory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&#39;d:\\text&#39;&nbsp;&quot;&quot;\u9ed8\u8ba4\u6253\u5f00\u6587\u4ef6\u5730\u5740\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;multiselection&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;abap_FALSE&nbsp;&quot;\u662f\u5426\u53ef\u4ee5\u9009\u62e9\u591a\u4e2a\u6587\u4ef6\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CHANGING\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;file_table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;lt_filetab\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;l_rc&nbsp;&nbsp;.\r\n&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;sy-subrc&nbsp;&lt;&gt;&nbsp;0.\r\n*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Implement&nbsp;suitable&nbsp;error&nbsp;handling&nbsp;here\r\n&nbsp;&nbsp;&nbsp;&nbsp;ENDIF.\r\n\r\n&nbsp;&nbsp;CHECK&nbsp;l_rc&nbsp;EQ&nbsp;1.\r\n\r\n&nbsp;&nbsp;READ&nbsp;TABLE&nbsp;lt_filetab&nbsp;INDEX&nbsp;1&nbsp;INTO&nbsp;P_FILE&nbsp;.\r\nENDFORM.\r\n\r\nFORM&nbsp;frm_get_excel&nbsp;.\r\n\r\n&nbsp;&nbsp;CONSTANTS:\r\n&nbsp;&nbsp;cns_begin_row&nbsp;&nbsp;&nbsp;TYPE&nbsp;i&nbsp;VALUE&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Beginning&nbsp;row&nbsp;of&nbsp;excel&nbsp;file\r\n&nbsp;&nbsp;cns_begin_col&nbsp;&nbsp;&nbsp;TYPE&nbsp;i&nbsp;VALUE&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Beginning&nbsp;column&nbsp;of&nbsp;excel&nbsp;file\r\n&nbsp;&nbsp;cns_end_row&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TYPE&nbsp;i&nbsp;VALUE&nbsp;9999,&nbsp;&nbsp;&nbsp;&nbsp;&quot;Ending&nbsp;row&nbsp;of&nbsp;excel&nbsp;file\r\n&nbsp;&nbsp;cns_end_col&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TYPE&nbsp;i&nbsp;VALUE&nbsp;55&nbsp;.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Ending&nbsp;column&nbsp;of&nbsp;excel&nbsp;file\r\n\r\n&nbsp;&nbsp;DATA:&nbsp;BEGIN&nbsp;OF&nbsp;&nbsp;gs_excel.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;INCLUDE&nbsp;STRUCTURE&nbsp;alsmex_tabline.\r\n\r\n&nbsp;&nbsp;DATA:&nbsp;END&nbsp;OF&nbsp;gs_excel.\r\n\r\n&nbsp;&nbsp;DATA:&nbsp;gt_excel&nbsp;like&nbsp;TABLE&nbsp;OF&nbsp;gs_excel.\r\n\r\n&nbsp;&nbsp;DATA&nbsp;:&nbsp;l_column&nbsp;type&nbsp;i.\r\n\r\n&nbsp;&nbsp;field-symbols&nbsp;:&nbsp;&lt;fs&gt;.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;CALL&nbsp;FUNCTION&nbsp;&#39;ALSM_EXCEL_TO_INTERNAL_TABLE&#39;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EXPORTING\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;filename&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;P_FILE\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i_begin_col&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;1\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i_begin_row&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;1\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i_end_col&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;4\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i_end_row&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;9999\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TABLES\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;intern&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;gt_excel\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EXCEPTIONS\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INCONSISTENT_PARAMETERS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;1\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UPLOAD_OLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;2\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OTHERS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;3\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.\r\n&nbsp;&nbsp;&nbsp;IF&nbsp;sy-subrc&nbsp;&lt;&gt;&nbsp;0.\r\n*&nbsp;Implement&nbsp;suitable&nbsp;error&nbsp;handling&nbsp;here\r\n&nbsp;&nbsp;&nbsp;&nbsp;ENDIF.\r\n\r\n&nbsp;&nbsp;SORT&nbsp;gt_excel&nbsp;by&nbsp;row&nbsp;col.\r\n\r\n&nbsp;&nbsp;loop&nbsp;at&nbsp;gt_excel&nbsp;into&nbsp;gs_excel.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;MOVE&nbsp;GS_EXCEL-COL&nbsp;TO&nbsp;l_column.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;ASSIGN&nbsp;COMPONENT&nbsp;l_columN&nbsp;OF&nbsp;STRUCTURE&nbsp;gs_itab&nbsp;to&nbsp;&lt;fs&gt;.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;MOVE&nbsp;gs_excel-value&nbsp;to&nbsp;&lt;fs&gt;.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;AT&nbsp;END&nbsp;OF&nbsp;ROW.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;APPEND&nbsp;GS_ITAB&nbsp;TO&nbsp;GT_ITAB.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CLEAR&nbsp;GS_itab.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;ENDAT.\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;ENDLOOP.\r\n\r\nENDFORM.<\/pre>\n<p>\u5728\u4f7f\u7528ALSM_EXCEL_TO_INTERNAL_TABL \u9700\u8981\u6ce8\u610f2\u70b9 : \u4e00\u662f\u6bcf\u4e2avalue\u53ea\u80fd\u5bfc\u5165\u524d50\u4e2a\u5b57\u7b26\uff0c\u4e8c\u662f\u5982\u679c\u8d85\u8fc79999\u884c\uff0c\u884c\u53f7\u4f1a\u521d\u59cb\u5316\u4e3a\u4ece\u96f6\u5f00\u59cb.<\/p>\n<p>\u8fd9\u662f\u56e0\u4e3a\u51fd\u6570\u5b9a\u4e49\u8868ALSMEX_TABLINE \u505a\u4e86\u9650\u5b9a\u3002<\/p>\n<p><img decoding=\"async\" src=\"\/ueditor\/php\/upload\/image\/20230228\/1677553364694740.png\" title=\"1677553364694740.png\" alt=\"ALSEX_TABLINE.png\"\/><\/p>\n<p>\u5982\u679c\u9700\u8981\u5bf9\u4e8e\u53d6\u6d88\u5b57\u7b26\u9650\u5236\uff0c\u9700\u8981\u5bf9ALSM_EXCEL_TO_INTERNAL_TABL\u8fdb\u884c\u6539\u9020<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ABAP\u8bfb\u53d6Excel\u6587\u4ef6\u53ef\u4ee5\u4f7f\u7528\u591a\u79cd\u65b9\u5f0f\u5b9e\u73b0,\u6700\u5e38\u89c1\u7684\u5c31\u662f\u4f7f\u7528\u6807\u51c6\u51fd\u6570\u8fdb\u884c\u8bfb\u53d6\uff0c\u5bf9\u4e8e\u671f\u521d\u5bfc\u5165\u6709\u5f88\u5927\u5e2e\u52a9\u3002\u5e38\u7528 <span class=\"ellipsis\">&hellip;<\/span> <span class=\"more-link-wrap\"><a href=\"https:\/\/www.netxintai.com\/?p=2209\" class=\"more-link\"><span>Read More &rarr;<\/span><\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[223],"tags":[238,237,236],"_links":{"self":[{"href":"https:\/\/www.netxintai.com\/index.php?rest_route=\/wp\/v2\/posts\/2209"}],"collection":[{"href":"https:\/\/www.netxintai.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.netxintai.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.netxintai.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.netxintai.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2209"}],"version-history":[{"count":1,"href":"https:\/\/www.netxintai.com\/index.php?rest_route=\/wp\/v2\/posts\/2209\/revisions"}],"predecessor-version":[{"id":2210,"href":"https:\/\/www.netxintai.com\/index.php?rest_route=\/wp\/v2\/posts\/2209\/revisions\/2210"}],"wp:attachment":[{"href":"https:\/\/www.netxintai.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.netxintai.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.netxintai.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}