{"id":389,"date":"2010-02-22T19:55:32","date_gmt":"2010-02-22T17:55:32","guid":{"rendered":"http:\/\/www.karadere.com\/blog\/?p=389"},"modified":"2010-02-22T19:55:32","modified_gmt":"2010-02-22T17:55:32","slug":"abap-excel-to-internal-table","status":"publish","type":"post","link":"https:\/\/www.karadere.com\/blog\/abap-excel-to-internal-table.html","title":{"rendered":"Abap Excel to Internal Table"},"content":{"rendered":"<p><strong><em><code><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-309\" title=\"sap-abap-logo\" src=\"http:\/\/www.karadere.com\/blog\/uploads\/\/2010\/02\/sap-abap-logo.png\" alt=\"sap-abap-logo\" width=\"230\" height=\"121\" \/><\/code><\/em><\/strong><\/p>\n<p><strong><em><\/em><\/strong><\/p>\n<p><strong><em><\/em><\/strong><\/p>\n<p><strong><em><\/em><\/strong><\/p>\n<p><strong><em><\/em><\/strong><\/p>\n<p><strong><em><\/em><\/strong><\/p>\n<p><strong><em><code>REPORT Z_EXCEL_to_ITAB.<br \/>\n<\/code><\/em><\/strong><strong><em><code>TYPE-POOLS: truxs.<br \/>\nPARAMETERS: p_file TYPE rlgrap-filename.<\/code><\/p>\n<p><\/em><\/strong><code><strong><em>TYPES: BEGIN OF t_datatab,<br \/>\nebeln LIKE ymtil_cons_po-ebeln,<br \/>\nebelp LIKE ymtil_cons_po-ebelp,<br \/>\nEND OF t_datatab.<\/em><\/strong><\/code><\/p>\n<pre><strong><em>DATA: it_datatab TYPE STANDARD TABLE OF t_datatab,\n\n\u00a0wa_datatab TYPE t_datatab.<\/em><\/strong><\/pre>\n<pre><strong><em>DATA: it_raw TYPE truxs_t_text_data.<\/em><\/strong><\/pre>\n<pre><strong><em>AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.\n\n\u00a0CALL FUNCTION 'F4_FILENAME'\n\n\u00a0EXPORTING\n\n\u00a0field_name = 'p_file'\n\n\u00a0IMPORTING\n\n\u00a0file_name  = p_file.<\/em><\/strong><\/pre>\n<pre><strong><em>START-OF-SELECTION.\n\n\u00a0CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'\n\n\u00a0EXPORTING\n\n\u00a0i_line_header        = 'X'\n\n\u00a0i_tab_raw_data       = it_raw\n\n\u00a0i_filename           = p_file\n\n\u00a0TABLES\n\n\u00a0i_tab_converted_data = it_datatab[]\n\n\u00a0EXCEPTIONS\n\n\u00a0conversion_failed    = 1\n\n\u00a0OTHERS               = 2.\n\n\u00a0IF sy-subrc &lt;&gt; 0.\n\n\u00a0*  key in some message\n\n\u00a0ENDIF.<\/em><\/strong><\/pre>\n<pre><strong><em>END-OF-SELECTION.\n\n\u00a0LOOP AT it_datatab INTO wa_datatab.\n\n\u00a0* Do anything with the work area wa_datatab.\n\n\u00a0ENDLOOP.<\/em><\/strong><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>TYPES: BEGIN OF t_datatab,<br \/>\nebeln LIKE ymtil_cons_po-ebeln,<br \/>\nebelp LIKE ymtil_cons_po-ebelp,<br \/>\nEND OF t_datatab.<\/p>\n<p>DATA: it_datatab TYPE STANDARD TABLE OF t_datatab,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[87],"tags":[394,916],"class_list":["post-389","post","type-post","status-publish","format-standard","hentry","category-advanced-business-application-programming","tag-abag","tag-excel","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"aioseo_notices":[],"views":3232,"_links":{"self":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/comments?post=389"}],"version-history":[{"count":0,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/389\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/media?parent=389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/categories?post=389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/tags?post=389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}