一步步实现ABAP后台导入EXCEL到数据库【1】

时间:2022-05-11 18:39:35

在SAP的应用当中,导入、导出EXCEL文件的情况是一个常见的需求,有时候用户需要将大量数据定期导入到SAP的数据库中。这种情况下,使用导入程序在前台导入可能要花费不少的时间,如果能安排导入程序为后台作业,既可以节约用户的时间,也可以有效利用闲时的服务器资源,最重要的是可以避开程序超时。下面来介绍一下相关的知识和具体实践办法。

本文链接:http://www.cnblogs.com/hhelibeb/p/5912330.html

原创内容,转载请注明

1,定义结构

  首先,新建程序ztest_upload,并准备一个EXCEL文件。假设一个相对简单的情景,比如,要上传的数据库表有三个字段。那么我们也建立一个三列内容的EXCEL文件,test.xlsx:

  一步步实现ABAP后台导入EXCEL到数据库【1】

  由此,可以在代码中定义相应的内表itab:

REPORT ztest_upload.

DATA: BEGIN OF wa,
col1() TYPE c,
col2() TYPE c,
col3() TYPE c,
END OF wa.
DATA itab LIKE STANDARD TABLE OF wa.

2,上传并读取文件

  我们需要有一个选择屏幕,用于指定文件的路径: 

SELECTION-SCREEN BEGIN OF BLOCK block1 WITH FRAME TITLE text-.
PARAMETERS: p_source TYPE rlgrap-filename DEFAULT 'C:\Users\liyue\Desktop\test.xlsx' MODIF ID ty1.
SELECTION-SCREEN END OF BLOCK block

  添加文件选择帮助: 

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_source.

  PERFORM get_filename.

FORM get_filename. TRY.
CALL FUNCTION 'WS_FILENAME_GET'
EXPORTING
mask = '*.XLSX.'
mode = 'O'
IMPORTING
filename = p_source
EXCEPTIONS
inv_winsys =
no_batch =
selection_cancel =
selection_error = .
ENDTRY. IF p_source EQ ''.
MESSAGE s000(zfi01) WITH '未选择文件!' DISPLAY LIKE 'E'.
ENDIF. ENDFORM.

  运行程序后,使用ALSM_EXCEL_TO_INTERNAL_TABLE函数读取文件:

START-OF-SELECTION.

    PERFORM read_data.
PERFORM output_data.
*&---------------------------------------------------------------------*
*& Form FRM_READ_DATA
*&---------------------------------------------------------------------*
* 读取上传的EXCEL文件
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM read_data . TRY.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = p_source
i_begin_col =
i_begin_row =
i_end_col =
i_end_row =
TABLES
intern = gt_excel[]
EXCEPTIONS
inconsistent_parameters =
s_file_ole =
OTHERS = . IF sy-subrc <> .
MESSAGE s000(zfi01) WITH '文件打开失败!' DISPLAY LIKE 'E'.
LEAVE LIST-PROCESSING.
ENDIF.
* CATCH icx_obl_parameter_error INTO .
ENDTRY. FIELD-SYMBOLS <fs_value>.
FIELD-SYMBOLS <fs_excel> LIKE gt_excel. SORT gt_excel BY row col. LOOP AT gt_excel ASSIGNING <fs_excel>. ASSIGN COMPONENT <fs_excel>-col OF STRUCTURE wa TO <fs_value>. <fs_value> = <fs_excel>-value. AT END OF row. APPEND wa TO itab.
CLEAR wa. ENDAT. ENDLOOP. ENDFORM.
*&---------------------------------------------------------------------*
*& Form OUTPUT_DATA
*&---------------------------------------------------------------------*
* 将数据写入到Applacation Server
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM output_data . DATA s_file TYPE rlgrap-filename. PERFORM generate_filename_in_server USING s_file. OPEN DATASET s_file FOR INPUT IN TEXT MODE ENCODING DEFAULT. IF sy-subrc = . LOOP AT itab INTO wa.
   write: \ wa.
ENDLOOP. ENDFORM.

  这里没有使用INSERT语句插入数据库,因为我们还没有建立相应的数据库表:) 因此,先使用write验证数据读取的情况。

  接下来是安排程序作为后台作业运行。在选择屏幕点击F9,安排程序立刻作为后台作业执行,(如果运行成功的话,在假脱机日志中可以查看到write输出的文件内容):

  一步步实现ABAP后台导入EXCEL到数据库【1】

  一步步实现ABAP后台导入EXCEL到数据库【1】

  保存之后查看运行结果,打开工具栏——系统——自有作业

  一步步实现ABAP后台导入EXCEL到数据库【1】

  嗯....什么,已取消?看来作业失败了,得分析下原因才行。双击任务名,点击“任务日志”按钮查看:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA5oAAADuCAIAAADXzO+WAAAgAElEQVR4nO2d3Y4kx3Wg8y0WfgtixB70Qi+we7G+m4sBhJkWWphXIPaGaGBAUlDrnkADwiygBQbDoSR0y6ax8FomIMgGtxstyZ6mZVESpZa40A41S8lrX/SV96KqMuPnnIgTWfkTWf19OBj0ZEVGnszIyvgqKjKruQEAAAAAWCzN3AkAAAAAAPQHnQUAAACABYPOAgAAAMCCQWcBAAAAYMGgswAAAACwYEp09vrs6JGZk/PRct5BfvXpr9fxy1/a4/r6t/b4XQmf/uoX9vhVCf/n8z+4MfeBB4fzE/Fte312ZH43n58cnV0n/m9PxV1PSWwars+Ojk5OzrieAQBUTKnOhr2KtGzlvf26sZuy3nPhdBZ7W3W2wGtXn6Zuy6kxA6sDHL9vz0/Mn0/DNipYVdhmm4q9mlXJDGWXpuuzo/4XMwAAmITRdFbsewrGdy0dSKbvOjk3dW6rfjKdmrc3Ua2bVws2d3N+IrjsLdbZrNGW2ez5Sb6wXiY+GcTT0S8mFDHVE541ypnvF5N3zVJGRxkDPT8xC2BofucnfT9/nJ+4FdnryZcs/qytXs0AAKAaptVZif5d3gw6q5c6Orsu0VnZZW+3ziaNtshm1w2RLK2WUdvYcyC5lFvEUo9WJtAtsViPMkmuz06k0gXvz6CoPqx5fZ1La1ydLbreyCucnzFgCwBQD4vWWZlNvy5Uqn2dmn6pZaOrktdIa2p1qi5763VWNVqbzQZKZxl5lXU2aLNNw7eF43Nss6Rb01qPbMmBFvqL1vUIXpwqoyF/ClutaPTtTT0mnU+1jlzXJDpbdGuAfhQAAGAGdk5nEzK7rc6uun1lbWlkS6wz5bLorGa0lskDA+msiN/28plgHxM2nGZdNWK1QT2WMqkNhvdvbRZcnx2F62tjruGbflNJVLvA9Vl4p1VaZ/Vx38lGZwEAoCbmf7LBoDqblNktdTYxDJtcA53dXmf9O4PyWO4dKrlNad3268L+/8IaDedQcqNBGWUVb1uWMjq6zkrPJVBUcjUl9eTs/Hrz33Uhi87e3JyfRCqu62ziXY7OAgDcSuodnVWm8uUSTPbfQ4zOFnRtcZ0Zl0VnZZ0ttdmBdTb83l6T0pys2r7/Fwdeo3W8bVnKJDco6qz8kC1ZZ89PHh0ddS84q9p0NrwPLaWzqZu50FkAgFvJNDrbY1ramuKxUMPgmOEudTmJbpKhLS10tp/OhkZbbLPD6Kw7p9Q2XTo5CcF44shzDSbX2ZOTo5Nz6Y4nSWfPTx6dnHfvem+oNdZZ+UYw/6KR0Nnkg7Nsd2NuqbPcBgYAUBv1js4WYhr52lJn5VJ68vHmfvPb36Xjnz7+2B6//s21PX5WwtU//tQeRaL86v9+YYmoacvuuhlcZ/M3bCl3CibriYlMWVVSR2EtZRIk5s4Ks2djm1x/j7J51wfzBlI3mkW7rozputeI9MVl69FZ49NJuA0MAKAqSnRW6ioq0VnjbdxbPtnAL5t3WnR2CJ3tYbNDz52Np5mkPv2kZStVQHh9Gp1NyZowcdWfFuBM4JVnsxY8tXZTVtXZTHUjTDYAAID6KdVZM1PqrHlS60A6K2w78RR9dHYrne1js4PfCiaeYr7SHp1dG77cT5yqyhSG+ebOuhl0/w/ttp05sLXOuj6r6KzwpIVoa0PqrL/rAABQKwU6K85Zq2B0tuAOrRF0NpUAOttPZ6ODW9wsg+usaaDTvlXNPO0jrBPqrP/GV9+v2+us47Oyzso3pwVbG3h0dosLAwAATEWBzoo9xew6W/S4gXF0VlUddHZrnU3dxZ5tkQF11vKUNovxivUkK5/zQV3t//1bu7bV2evz88SdXKrO5mV2e509Pz/fFAqey+ZPsGC6AgBAVdh1Vu4GZtbZwmdnbfncWeXJYQWjszc5o0VnPZ2NTcLG0DqbeZ5xV53BpYJS2WnfoqsGpmopk8o8rbNh6VKdFdHehe14c6Cztk812+lsu/mgkPsUsdVjDc5Pep2XAAAwDnadPT+RLt9z6qzBMcQ1euustLnNUu0Rnehsoc7GB7DH2bGFzgrTJbVHFgR5xpqaraenA8cKbCmjUaSz+mOyBphsoK1lv0ZspbPdRlOFNk/p6jcNBgAAxsCss7LNzqqzuVvTLN/+By9pnJxbH+Vl2Rw6a3HZHjarNJH8kC2ljHpWyR9j1JPAUk/+pEuUC5/maigjg85ulnvzC+Rq2gHc9RqM0AIA1IBRZ9U7ip3rfvun4TLvj4MsQ2e1jerJJzaHzuZcts/Y7BA6KxbRJpLop5qpHutJd3MTnnjyUbGUya0lHw6Dwk2rs8r0VdvTV7Q5Ed7kDTlrrxy/pwAAUAk2ndVvwgiu+6nHVglrmgvvIuhsymW3mGkAZVhGZx1NTF0KZO1Pvr/TSl/qpbbR2aKrk8mGAQBgViw6e312VnL9VqYlKFXf6meao7P6scFmpyIa6FQGHTMiqE+un/Djav7io97RCQAAy6XkZxRgNFydnTuXOsBmAQAAwAY6CwAAAAALBp0FAAAAgAWDzgIAAADAgkFnAQAAAGDBoLMAAAAAsGDQWQAAAABYMOgsAAAAACwYdBYAAAAAFkzz7wAAAAAAi6X5NQAAAADAYmGyAQAAAAAsGHQWAAAAABYMOgsAAAAACwadBQAAAIAFg84CAAAAwIJBZwEAAABgwaCzAAAAALBg0FkAAAAAWDDoLAAAAAAsmF46e3129CjJ0dn10In2zGTifAAAAABgWsbR2ckM0qizGO0ucH5CSwMAAEDEGJMNNtpxcj5C5T7XZ0fZ7XTKO0FCtwGjVmYobwx0FgAAAAR66uzVxe+ab/16Hd95deW96GjH2AJZprMY7SDMqbMZVzUUAQAAgB2jh87+6bAVWScOP2kLeLozrly0OqvMOpBeKs/o/OTR0cl5tNb1ebxsSK7Pjk7Or6+rk7Pzk0ePjr7xH/74vHHjR28+evTnexd/9mde7P35o0f/6Xv/ufmpG//lP/7XrXRW9On2FXQWAADgdlGss6d/0yrs70/bpZ/8vvnW744/X/0ntI0R/aKPzpZndH4irLHaS0tN12dHvQaFLUPPc4DOAgAAQEUU6uwnv9+4bCuvGz5/dXjxbzc3N6JtjCVlxZMNeqUU62yhaV6fHfU4BNdnR1Wq2ew6ayjin4MVfiYAAACAoSjT2W5o9m/+FL969bmqs2MpRc/R2e109vrsqMf4Ljo7n84ah9EBAABgiRTp7L8df2ets/vrgVjv1avPhXVubsb81nx6nc0NtLpbOzo7i+ddeOlsqhVyPDlf7dxZ9NLcZjb7rWC6q14dHfq3JYpHGwAAAHaJnjrr3PhlYAKdDZdJ6rKyoB55bHS2dFj2+uzsPFxiHnA9P3n06NHR2dlZdQ5Wtc423/jy/g9/0a4TfU5g3gEAAMCuYdFZ+VEGwqyDT34vTkKYVGc71REtt9cg3fnJaqC1eMXQZ+1zaK/Pjh4dHR0dnV2P/fyEcuQv/fWl0R73PB8Mkw2ujppvfLn5xpeb078VXq313joAAADYBuvorPegWfFusPYusdhop9PZ9v/R3VubkVVzLvIYZDx/IKnIgc+ap9Cenzw6OjtfDeVen53UNUBbhc6enn55ba5afOu/XQUVoLMAAAC7SMFkA99oFZcVZ9ZOprOePGlPbC2/k8tx43j+QG5VZ7+tNrsexG1nJniVzM9CdPYbX26+cXTqVoDOAgAA7CJlTzbYGG3KZQWjnUhnzV/llz43yxvqLXTLbmzVutXWYruJtnU942BBOuvNo0VnAQAAdpLin1G4uvi957Kfv9pXptV2RjuNzpY8DEv8YQRj6cJfRdgUN27SGwnuJLbHw8FGY/ZbwW5umGwAAAAAG3r8yG37fNmbm5ub04tXa2lox2i/s15ydfFq/VXvFDpb+tNb28hvoVtenx2dnJnGV/1R2Oh/ldyYX4XOynArGAAAwO2jj86efiL9hkI7s3aWW8EyP90gP3u24JlZ3s8oXK/vKDMrrfiVu7iVc/khuau9aR9BO+84bRWTDWSiB3UNsV0AAAComl6js8F8g5sb92Fewi8sjK6zyi8lbIRWH04seM7AdVvRRqk21aYrWQ/lpl1Ms754De0GtwmpWmcPwxkG228XAAAAqqaPzq7myzq/pOA+mPb3p3H5sXX25EQasQwcV5YqyzhnV1G8D6nXIgHzbdgtdy4dnLpuAOuYU2d1bHM50FkAAICdo5fOyo+hjZ540DKyzq6+hZelKWU75yePjk4sv1HQwyv1XyDzpSz3e7k1yhc6CwAAABXRU2dvbm7c37yVp8y2TDLZQJSm7qEHwvbLHm9gwzYB4ebm5vwku+2adXZ7ZtgzdBYAAGAX6aWzpVowzdxZfwPegwDEeQWGqZggUafO6vOnZ9doAAAAGJP+Oju3vnSZnJxrhpV5sgFus0OgswAAALeUHdFZKadgg3EBhmYBAAAAFs82c2cBAAAAAGYGnQUAAACABYPOAgAAAMCCQWcBAAAAYMGgswAAAACwYNBZAAAAAFgw6CwAAAAALBh0FgAAAAAWDDoLAAAAAAum+TUAAAAAwGJpLgAAAAAAFguTDQAAAABgwaCzAAAAALBg0FkAAAAAWDDoLAAAAAAsGHQWAAAAABYMOgsAMDP/qjB3XgAAywCdBYCB0eQMejN3kwIAVA06CwDDMLfy7ThzNy8AQL2gswAwAHPL3q1g7kYGAKiUpejs6eHhqbfg6ng/WLJsdn4Hfa6O9/ePr3qstcPHZMm8/93vivG3P/iBPb5/dmqPH/z1X9nje9//wB7fLeG/l/D9v/wLe3z+hz+IMXdTAwDUSLnOXh3vN5M7xelh0zSNI0BXx/vBkvIavb0I/28gIVdXx4dlmdW3g6fHtk2fHvbJcb17hYd8tVbZSldX2eyijxJ99+qWorksOjuGzpqMdnU94bMfANwaWp29Ot63udPWniXXmazv9DDY4NXx/pYphP64+n9RBxApqJ9eSYIV7uC6vI3ifvPqeL/nWt1KUYaHp0rS0YH0BTbu+3ucDcOzPouS7B9fWYr5ByK/RnjApDXWByfhsujsXDqrX5oMq1nO+lzJ+IRJJBO8a/UxAmudUcnUkQgKJ4raSwLA9HSjs8EV8Or4WL6qJESrpGOV0K4Psuxt5xphnWadt6xxepi4KhuSqWEHTw9NGRiLhQyks5sdir8ycF4U8HvjaB+i9rhJvCFGow6dTRc+PEVn69PZVZv1tFnru14rmfocHK2gnV1B7vY6EyWFbJXNC0fOXhIA5sHXWe/NqYhKz3HDLQQtSiRpZsbv+bfXWf3be8mGcrlUt4Pj6qy6XvJbfrvOZvbW33qYS1mXOAebzjX1cSo/zJXfma4Tl/0i7bLo7Eg6mzHaXjbbNXXutMiUXJ8a8cfzeJX2jdYtbUtGfZGtTqlkuxlNkuNvfHqXBIC5SOjs+h0rfu84oc7GYmL5Gjyb4NY663mXN0FTNDV9CmelOziAzvYfrVcS3Vjr6enpzWg6W/7BZmoyMjuczm5ORKXg1TE6W6HOltls/Ca1v50VnRU3HZ9L2tklnN7mOpWS0jtGeRcJbw57SQCYj6TOijfsTKyzsS5tLMZe48p+4noztid/vay65nrthMOpl+SqdlDNa5ti26wnH9H942NJZ9e7nblhMaGzrSQPMOFjFLIyO5jO5suhs/XpbOHY7OA6qxGOm0rjqEpRc50qwqmsvkmiF+wlAWA+0jorDdD27OV7rhbdctB5SkGN4q3rOdtTtEHwMHddWdP06Qf17aCzfh06q60k3UGyOXp9dTa8KbG6Dssgs4PpbGZw9gadrVBn+z0zpOS06DkuGZyUyTqsb7vi2b7RrbGJabLu1HpbSQCYkZzOxrfUTKmz8fQoZ8JqSY3xM7WytqcNcgii1K2rWZSmszXuoLN+ZTobHBBpssHm8GWq98/qtnB8FOOtzottOGrg0Vm9IDo7i87m277vtK7RdDZaJVnH+sXMaV6QRtHm/TeZvSQAzElWZyO20dncYE+8yurZS93QZ3jLdSSWym1SkWfmbG+Vr5BqSmfVu8Pkg1vnDjrrT6uz+r11zjr+t5WhzraLok9hCTbTmvV77AzPrp0Ea+9p1FmVcARNrQudrU1n+9vsiDor3EmVPpkNOivWaU8YnQXYNcp11louwHEz4z2ha7vpthd8o653ypY5qhnb06Vd19mVi4rqIx60SnfQWd9IpkMpqClZ27qnPt5M3o51tm0bZ2elecXOITBRR3dl7zuH0lm5qF8tOluTzm5hs8PrrP/GDwunps3oG0jXmUkknjmbusNscwExlwSAOSnW2Z53goX6FH/LHtCOU27yiu5bKh0mPj10t5a2vcTB0HT28PD4VHldrK/aHXRKjDg6W44zKXC1p4eBzh7rlqaOmVsGOuvorPITWaOy2042CIoLB5XR2el1Nt/wPU/YkXU2Lt6+Ls/p1ya/Gd7ZUrJ+bYaxYX/0xVASAOYkq7OhZPWdSSisp388d+cwquJVnIl3W1vK9uK7poSsA9zyccqh9NW8g0rK2xVzyNyllVptf98ZfT08jG8F2wyN2yQ0KiWslqkpP710GEpkdmidjdbrQGcn1llLu/f9+DXm3FllakDmi5v8B+5sGtoblNFZgF0jqbOC9fQdnFXczPDd2HC2520tYXtpQ0veCuamZv1mv7YddOoaa3S2x1eip4fN/vFpd+yvrq7cyQanp+GnB0P1oapKM/bSOusI3phdWpnMjqazwQayLovOTquzmZs7c4x6K5iufuGHpPbrF/uTDZL3s8oFmDsLsGuoOisP4PW2Wd3NhGdMBa8PZnuuRqm2lxs8tOhsWGgqnR1kB52qxptsYO2vnPLu3NjNstUkjfAOLutdImHuUkvk9q/UNHtQvonRdfbm5ub0EJ2dXmfzj+jqr1Yj62yB+9kebJCrM3kZQGcBdg1RZ9XBrdzd8An6TlIotb3kT8A6F3zN9k5zt9ebdNaU6pradtBJawidbT+unB42zeFxe6OcNEKrVXa1fhqsqLPR8T899CfWWnNfHe9DP6/p5gYr9PHlKXT26vjFxx9n4xef/NwePynhV7/4uT2ufvbP9viHn/7UHv+rhJ9/8gt7/Ov/+5MWiVbdwqyq0Vm7zep1Zj/S6tmEe2cvCQAzEurscWL21UZme90dM5LOKmj5dZXJtncs/5hiuNk+Opv8QqymHXRqGkBnu0ePeTN7b7SDIn2Uag1e0dkbd2/X1RpO0vCUXO1K0L4z62y/wV90drd1VjJa507J3i06qs6mnmQgFbRcqJQ6TV/PqG+S6AV7SQCYj1Znu0n5ypvTnWfQY87BVKOzfas1Dzz30Vl1H5IvzrSDzvpb66x7ZJIHobvlMOqWneFoWWfb+8LWg8+b2XeFOrte09+Ge8/ezenxxF8q9p3JMJDOniY++1wd76OzM+psZLQ95qP3PC2SJa+kXyJx17HcghrUXVanPl9W3pJwMQ8X20sCwGy0Opv+cB+7UOnVcwk6axL0JetsySeQIXTWG2pNJ+BModa/NY11dn+/G5U9PL7qttHpbPQANDXV3NRiYZq3duP0EPSfljuYziqfcFcvoLMV6ez2NjuYzgoymR0sCYrFdyIY6zS7rFdDNBArzYKylQSAuWicv5XBJ80uyi6gO6WzAql105nWtoPO+kZSc1O6F5MJbGbHdmtqc7cT1uu+7OpsYrKxU5XzzYM6FhS+4JwMg/dqtgZI3QST09lcrZkM9o+v0NlKdLa/zSZOhuDcMpVMnlv6p8HEZovqzL9ppGeZZDPoddkHgElpkq+m7y4o0q1F6qw09Cgsi9f1ZmOEk0YzmfiVTL+D+ZdSm/FfCefKaoch/G4gePCWsg/+uKs/vcDVWeWrSjlP1brlN8N49zbPr7N66c3r6OyMOusY7RZjswPrrHbuJj/ythjmuqbrLNRZIYfEO9leEgCmR9ZZ4zynnChEVc6gswWDjDrhLItYZ7WvxqUaKt9BfT+Lsi9P1XbLs+rO8VeRq/TVDBUTTWZJFxaCzs6vs6eJG3gBAG4Frs52+jXChTExJTHNqfZgqdJvzwei7H4gQ5K17eCa3POAN8WmvD1KPCKK9btW2q3jLmXS20Cgs/PqbPpLNACA20B6sgFATUTTYEvGhmFE0Nn5dBabBQBAZwFgCNDZiXV2fdyxWQAAdBYAhgWdnVRnAQAAnQWA2wA6CwCww6CzAHBb2BmdnftAAgDUBToLAHCzIJ2d+1ABAFRHcwEAAOXMorNz7zQAQI0wOgsA0J//PSFz7ysAQKU0n+0KFxcXc6eQZxFJAsCWDGuxc+8NwGwsvdOsP//6M8yCzs7AIpIEAACogaV3mvXnX3+GWdDZGVhEkgAAADWw9E6z/vzrzzALOjsDi0gSAACgBpbeadaff/0ZZkFnZ2ARSQIAANTA0jvN+vOvP8Msns42Odw13f8GL82IvUnEnKfZEUuSlkyKsi3dtXraFAAAbjOzdJo9ymurT5m/UeEClniEg3VDnbWvKeqs/diNxJY62y7vcTb0TlI7kpY8ixhVfwEAAMZgyk5TG6qLV88agqazk+VvX31BR1hLo6fOaqqXzmwC3CZJa2iP9hhJZz+Tjlt8PN0CGuntorMAALA4Ju40jQIXLBRtbPr8e7jNxBl+Zj7C6ZLBKsOPzmrlpyHQWfeP7LHOJjzUHolDyNk3RvaluAYLPQoDAABMRoWdZiKB+I9p8s/uhVb/ZBn2MI3EUQ1K3iKdDYgXuuXFgzvUHiVmRFhOwdKTNbGn2TQMewMAADAiE3eanxnGI8Vq3XXdP6bPv5QKj3C2zmCtrXRWrH2MA21nKJ21LB82yWxWiSWlyy0NnTjJAAAAJmOuTtPS+1tcYuL8e1DtEU6UzOhsGi1LsfYadDbh8pXorD0rd4mlgeybEAujswAAUANTdppa5XZji51hmvwTxbKeUO0Rjg+mVn740dl0ZmOTHZ21HBqtPYbao8QkFcvZoKWRSM/eLvHOztKOAAAAK6bpNBO2F5dP2Fvce87b6Vuo8Ah/llOXYMkuP6hLFLKEpWkvJVbZPslgK5azRHsXWZrP3sTp0wgAAGAaZuk0xarSZYKU2j8mzr9Hl13hEU5sV6ycW8GEJdqeDrVHiSdiWM4b+6vbVJX+LwAAwDRM02kmnCzhZ7H2xLlN2en3M8uaj7Bxuzx3VliiHdyh9ih93liaVjvO2fNAK2BJYJYGBQCAW06Fnaa4uvbfWfJPpxpQ5xEWN62l0X90NltgFvsZZHRWY6g92mbOddz8lsPe4+xHXgEAoAaq7TT76ewE+WdTDaj2CGfraRnyyQa16WyandHZoFhcXiw82c4CAABsQ52dpnHTE+evMaXOpjMcSUv6TzZIv2rJbAwsOqull0h42D1KP684sVHx1cTuZBs0vcuJdQEAAKahwk4zrWjBJqbJ35K2Rp1H2EK7rqezO4B9dHZGFpEkAABADSy906w///ozzILOzsAikgQAAKiBpXea9edff4ZZ0NkZWESSAAAANbD0TrP+/OvPMAs6OwOLSBIAAKAGlt5p1p9//RlmQWdnYBFJAgAA1MDSO836868/wyxrnb0AAAAAAFgszXXjxdz5mAhybuPlqz9WHhcXF7PnQBAEQRCLiKV3mvXnX3+G2fw3kw3+5WYHYuW4sx/WnT9vCIIgCGKyWHqnWX/+9WeYzR+dreW8aTaZN7ZdcIsZV8lWmCaRwIBpEARBEIQbOyBbs+ew9Ayz+aOztZw3Y+hsqaGKVSUqN5YkCIIgiN6xA7I1ew5LzzCbf6ez3/6qozlfPXU08eOju5vld7/5o0Aif/zNLzVf+3Zols4qXVVaPWJhJZ/3vyZI2eZVWWcv3nm9OXga73+4/PLxnlPn3jsfiS89fC4cymcHTdO8/talabsGnS31zn4eOazO4rIEQRDEGDG0bDl9utbXe8tnyP/pw8AC7j6+cArIgpFzlemOsJJVeWL2/FudPf1Kp5inX3Ec8dtfbe3z46O7gemupDPQ2dOvNM2Xvv5xMHSq1ONuy/9byUfw5qTOPn3YNJJWRsufP+hO3+cPuoOu/e2eVU2ss9p2xfOm8YdmLQYp/l3klL11VlTtfjkQBEEQRDqGla2nD1tbvXy81/Xp2vJZ8neSUV4NBeP5g3hYbaYj7MTl4z13Ry4fPxzyc4KbvzzZ4Edf399I6ulXmuYr729eev9rTbN/9OO2zApPZ7/9VVE9lXqcCoP6lXz88MsHOvvRW+2or9fq2vKXYZmDp69WI6/Op6Lgv6+eP2iaB8+80yhbf2+djUsmFqbr0V41js6mE8ZoCYIgiKFiUNla9dqb/3Z9urZ8nvw1ndUE4+nDrfx7LJ29eOd196iOFgadDfzyx9/8kmulgmj62qp4Z1tPuHpUf1Jnw9FicXS2E1Pb8uBMCot5bXP5eG9lscKnokT9wXnTjnFaBjgr1FmNsU9fgiAI4jbEkLIVeGrbp2vLZ8o/PTobCYbv4vMeYTfm1tmPj+5uJgaEw6XhRIJQNN//WtPsf+Wr7cDtZl2lHpvOOvkkFPlfblbPo821emZ50AAJnXU+DPXXWW10M+GF8SramG7CNYOasyXj8sEfYpIEQRAEsWWMqLNt960tnyl/f+5s6BKhYDw7aJq7Dx529yeVjiuPO9lgfKOVdXY1i2DtlH10tivwo6/vy5MK2np+/M0vuRW+/7Um0lkvH31odhid3UyE7QbtL9553T2nnx2sGuajt+42/lzb3qOzL3uNqhp1tvScsFQiei1BEARBjBG3UGedCKaf/vGlrLPBjMcyox3zVrDnDzovH2z+Rpx/pLOCXxaPzgrlE/X8+Jtf6vZ0PxydDfLRh2aHHJ0Nzp7WcZum2bu7Gp2N7jr0JXhynRVXGUlnX0ajs4lxXIIgCILYJm63zgoTecXR2W2Sn+RBXSuvVSd5bnmEA52NniFQOnfWqLPKHNnP3vHr7zgAABfySURBVP9aPBNXurFMGJodVGf1aeDPDqS1Jh2djcto5cfT2Ze+Q/fInyAIgiAscQvnznoRJbNMnR1xKm2gs6I7qk82kHU28NTuv5l6VuE/FUF/Ppey+gQ6q9w8OLzOZgc7x9DZ0iFedJYgCIIYO27hkw28yI7OBppYbo0T6uwo8w38584q7ph+7mz8zAH3SbTh33o9n7kTbdMuq6z+2ZZPNnh24Hiq9HzZ1HyUpY7OWrabrjye+WDMnyAIgiAscfueO6s9CH8dsWC4T6JNPPZ+miPchWdWmcc1bHmENzrrTmDdsJmxKv+al/Pc2RWd1Do/6OWarlxPV9h9doGej2+9KZ11Hs+2Yt26ynJ3tnITNsAKtRm05856202cNz10sBlaZ4sqafxx2ait0FmCIAhimLh9vwqm/pJWQjCcW3qK56eONjrrm9U4Lvsy8dzZhYb8I7f1RW+dja1RpGiV9BbFl7JL0FmCIAhiqJjoq/BbnH/9GWbzR2c5bwiCIAii3lh6p1l//vVnmM0fneW8IQiCIIh6Y+mdZv35159hNn90lvOGIAiCIOqNpXea9edff4bZ/Nc6e7EroLMEQRAEsUux9E6z/vzrzzCb/1pnrxsvZjVSK0HOy0oeAAAWwf/84WUc/+PDC3t8769+aI/3Tv/aHn//k58nYu4jBzAda5198ekXuxEXFxez57AbSRIEQdzmEC12WTobxPf+8of2+Iu//jt7/ODvX7QxRlssvdOsP//6M8zmj86SJEEQBOFF2mXR2YTOZuPFr/7ghaE5lt5p1p9//Rlm80dnq0uyaazNETxBdvb96pFzTPZozL6nsydAGKNfS63WopV3O9Ltm3VZdHZInTV47SJ69kXnX3+G2fzR2SqSdK+tietsrH1u1zuX15YaqriPWtqD6Gyi8uDQGY8hrrOU2OZsoZXrjx4XH3ddcbnFZdHZUXRWN9pF9OyJqD//+jPM5t/p7Lv3nWvA/feccpdv3Nksv/P2B0EtH779WnPwbli1s0pXlVaPWFjJ58mBcMVy1hKaRM4wXu6kYcuwiycHTdO89ualabsGnc1ekd0eNyijX8ENx9/avgWRzj+bdrA83T8ZE8getMQqGtpZEfDam5feie2x98aHX7z49L170lphSzXrU7G4NukE/uDNveClXLXqilqe2n4ZN2Rvaws9ztgoku+a4vfari7/4sWn9itwn2iS79z4v9kTw+iy6OxYOqsY7dCy1etM3iJ65B9dG9eXRG35lsmPqbNijzBwuDr73r1u/9+752zy3fvtobl8406Yyrv3mya8JL13L3Y7tR53W/7fSj7CYUrqrJShuFzbovb3Jj58+7WmaaJd1rYrJtmYfLR7tfEHkOJ/49Dasbx9y0LMJ14oLgl6mnjH+209e8wt6RXHk4NI0cR3ivz2WbdOd4pevnE/uGCptd174v03atD2WiM2tJaPtqKWZ6Ke7Ib6RPY9FduMiFi5864R0i59r+3q8u5V0xV421Yu/a9YFTo7v85KRjusbPU7k7eJnjorWalheZ/kR9PZbM812BGWJxt88Obe5kLjd4dOl7wemIl6wXfvi8dRqSfo44UuP8jHj6i82yRahtpyeYuZDFf75XVp2fqH1VnR9qzHv7x9tZSKXjX6YrBfRZ1TtkxwzNMS0yZgN574+NvMVbG6D99+zRPTgk34awUXl1XNe2880erXLVNcUc1zOp2Nzxbx/Olxzkipxj1H6XttV5dvdQUuaut+/42rsrssOjuuzkZGO6hsFZ/J28f4Ortt8mPpbL7nGuwI53Q2OChRZpFoxt2ndHA39YSrK3uu6KzwESRuEk2FVUX+9IsXzhmTzPDyjTurXk3oiRP1u0lqhqQJUxPpbFvJi8T1WmvH4vYVIttJWBami1mOjD0xew2WqiyrKwNRs+jsehZEu/CDN/eaO29/oH6gVy1TXrFinTW2l6GM+5EgOsKl77VdXe6eJ+VXYHtbG6+c2ZZt0NlborN9z+RtYnSd3Tr5XdVZ52ItDUa6XU54SXpy0DR79+63H7436yr12HQ2Gk8S209pkj4XUyeNRIbOOHR/nS0Nt6sOrtopo9XasbR9lZSMPUq2ZFw++EM8Gulj1e/VROFsVonTyQ9VQH1WDbT+Zl+/Lph1VhlcVNo6OflBWFHLU9uv7IbKQmydxN/xiWdr1m53Xnvz0vtoXfpe29Xlm2M1ts4W/TcNOnsbddZ8Jm8TW8+d7d4p8vKtkx93ssH4Rivr7OqboPW2++hs8LW7NKmgrefDt19zK/THjYR8gmMUDSZtq7ObibDBaFOc4WZoSj11SnXW2JvGve8LvbfuYmSdLT3z4lXSS3pswngk46MaHFuxKrGMEolpTEVzZ7/wjTD+IqmXzrqqLb37TKPF4YpinlOMzloaxdK4+W09OWiag3v3G+/DBjortWNVOpuuCp2tSGd9o72FOuuEMqJXMvI4cobpSPdcw4Sks4K9FY/Olp0orUE2TXNnLxzHCvJRN6Q2Sa+LqX/2SBnKd2Q71lKks2VuKr2keVj/dskfpXyS9lXEShpf8bPSaU+sXd1+tNNoK3af6IRXS3XWK2O7BTOjs377ivdcyvkYVgzynHSyQVEzxW+lzCZWk4a7u4z33viwnXeEzk6ts/Y3ZrZl0Vl0tkqd1efCarch1aWzXlbbv+u1/AOdjbql0nlRxhNF+/r1yUE8E1fqJtURr6HmzibPHtMXsnad1a656d63iQwv1djzzZ01rpLYWe2AWLZrqdZSYbqwvmL6mtJbZ8V3UNHcWW8Cg4/Fki0rBnluq7P5k9zcXtsUfhG9KdpPtvI3WrPPYV3g3Fl7W6evCegsOivEQubOeqElM1zyEz13drSptIHOqmMz3bYjyctMfvU7s0Q9q/CfiqC5bOquvbF1NvHchqHmzrq2Gr8kul27PO1V0vEvbF89YXtou5YtP5TOxscqVrNsPVpWbmhz+d1G2UJnLXNPY511vnmIryzCfAOpWtOKQZ6T6mzcvkUnSbpxoxH3ldx7Y9Ul77VdXe4ermXo7Ase1HUbdLbvmbxNjD46u3XyE+rsKPMN/OfOKu6YfphZfElyb+IO/04+FM3vJHSXTT5Trb/OPjnImrT+xfHAOmsXNVdk02v1e9LeIDpr6VS0Slz17NE5ZWvuV9K0dc3wkqeNanXe+SmKskVnve96pMaNz3zjub1ZUc1zgMkGPT44Wd5N4seY1OfD1ewjYTJS5lp325brZ0tqub2ts29h+0eaNq4++e0o8Yvf2eMffvZre/z0nz61x0+ufmWPf/zn3xTEz6/t8cvfvcpG0C6377mz+oPwe/1EwAgZ2iLfcw12hDc6604P3eDd+7zCycN5dqB3KX/h3Xmn/OyWU09XOHwWppxPcjKi9txZLxlluTtbWfmFJLUZvJ44cWQS501b2th4jX+lbjKjs+rx79G+iUwsqdoraRe2exfQ41glFvbLTYvoAIbnVUJAA9qHwXUozx3M1xb8Sl90yRN+XiSsNr2ilqe2X+n8Cw54ULiR3iBxmcSJlDrHvAvU6nC5N/DW9utc8ywvvAIXt7XYptp/7ecPOrvzOruEXwXTfkkr8Qtbdf4qWLbnGuwIy8+dXW4s4neHxefO2ldvy7vrNr75TRxNjmxu2Z4pXrLlnrpZFeXco8mILcN4tNNN0++9Nvu+37awt3X6VeOVRwx0dtd1duqoP//6M8zmj86SJEEQBOEFOjujzsbNsfROs/78688wmz86S5IEQRBEGOjsLDortsXSO836868/w2z+6CxJEgRBEGqgs5PprNYES+8068+//gyz+aOzJEkQBEHsVCxRZxO7s/ROs/78688wm/9aZy8AAAAAytlGZ+fOHXaEtc6+fPXH3YiLi4vZc9iNJAmCIAiihlh6p1l//vVnmM0fnSVJgiAIgqg3lt5p1p9//Rlm80dna0myacJWiJekl29feKStpB9JO3jmidWDhe1/0we/KG2CIAhi2FhEz77o/OvPMJs/OjtzkmnVE+WpyLQSTtzbJktz7reV7KvpENfVDk66cPwqOksQBDFZLKJnX3T+9WeYzb/T2acPHRN5+Nwpd/m4/UnCvXc+Cmq5eOf15uBpWLWzSleVVo9YWMnn2YHgTc5aQpPIGcbLnTRsGXbx7KBpmtffujRtd+vzJm1XCWMTXdO+FctLlpTsVWVfTeyOtrAtH59HWg3pA04QBEGMGolO86O37kZd8/MHcY/86o9hL79e5fmDpmma5sEzoeSmknUZl9ffev54r2nCXv7y8Z5gSr06fVGZFFHJqdE2R3j7kNpo+DOk1dnnD7rj9fyBs+GnD9tDdvl4L0zo6cO4OeUzSanH3Zb/t5KP0N5JnZUyFJdrW9T+3sTFO6837nmf2W6cpFGqjEsayV/FteJKsvTILVtzNqvsS42ip0H9iWzTafRImyAIghgqdNlq9c7vzQUJCUTz8vHD1d8bVXUdNOzWNT8Ol3/01l1h1K+XLKrK1EuNtjjC24fYRsOfIfJkg4/eurvZ8PMH7qeWZwdNc/fxRVtGSPHpQ/EgKvU4FQb1K/n4EZV3m0TLUFsubzGT4Wq/vHM6W3+ss/HfCdOKpSohbUZjS6xoKWC0RuOmS18Sy2R3p+jgEARBEHOFKlsX77ze3H387J3XveFVyT4vgjJB4XceOD3704erJVmd9ZVglUwkMKn81VDVyw27GvU/wtuH3EYDh0Fng4MSnRDR0fTbQDu4m3rC1ZUTTmkz4fNH3CRae6vnwas/vnQ+GCUzvHy8tzrFhXM9Ub9ldFZTVXFo0KizMVol8X8TW2mi0V+LSloKxDVru2apM9jxxAHRjjNBEAQxfWiytRkNDWSgh85ediNx64mCz00669jC04dqmWJZzKlXsGl/efHQbJ8MzaG00fBniKizzpi8NBgZDq270vbsoGnuPnjYDk9u1lXqsemsPBlF/PwxjM46aSQydMaht9XZ+O+EqxWJpmtviZLiSxYrTVQYFEujrZWoVtRQe7bZiO02mzBBEAQxeCiy1RmS3+Hqkw0EwdgU3oytbqw01Fmf6EvahwfiNINk/nrk1OvlK13Qy4dm+2RoDa2Nhj9DBJ1dfVe+PkZ9dDb42l2aVOCdQE6Fzw7is83LRzpG6SYp09nNjJmuZiVDf4rM8KOz7qtFS5pIZ4M/tHqyUhiXFzOxq166pN1NxZJZnc0aqmUJQRAEMXbIsuX6nCcPqamukY92hZ8+bJqHB5tZB9bR2Wjr5vwTkVavWFS66DkIOpbOqm00/BkS6axgb8Wjs0L5RD1twzRNs3c3/LQR5KNuSG2SXpMN/PFgKUPvwQstzjnUY3Q2kKqsZll8TvvvS0VnjZvLmqjF/KbU2dhcxd0vXUIQBEGMHaJsxSOyie9L/Vh5bXeDkGcjQiXpCvO3Oo0yOit+cd1raLZPhrbQ22jgiHU22ljp3FmjzqYGycOZuEWfP4aaO6ueE2GG/m7a6h/kQV0JbxP/m/Dadrmma5r/aRiLaato6WlL0rKrLTTqrD1ngiAIYoyQOk3/kVVrIkPVopMQr/DTh8KorW3ubGpYdKS5s5Go9J+fOo7OJtpo+DPE1VnRHTO312Umv/pnTPY2Pf+pCLrI658/xtbZxHMb+ulsP9Wza1nsfI2us+nTJet/pcsTWzTqbMIsswstxzn+LxZLEAQxcShPlPcNr/su26iz8aQCN2w666qC/mX6SE82MD4bqucR3j5SbTRw+M+dVdwx/dzZWNrc562Gf+v1vHQn2m7asscD1frr7LODrEn7GboxwOhsPwvsJ2F2/8vWXFTPsEIcm7pxH43HxHXc9DEnCIIgxgtbz9523JJ9el28KyTb6Gy4XHve/GDPnU2JylaPDhhDZ5NtNPwZstFZd3rohk0jyb/m5TxddUWXtDOvVPnZLaeerrD0EOM4H90pwybRMlSW+7cuir9Ppt63qD13Nj4I8nmTMKTSl5qczsZLshvSataw11C0v5Yks5U3igQnDkiPY0UQBEEMFVGnKavbxibjBxFEC5N3ckfL9V8FC63g+QNJFYb7VTBVVNJqVH6Et490Gw1/hsjPnV1uLOJ3h+PJBmKxIjXUygcCF3htrLmJTCwymq4nXaF93X6Vv4y0PqBocxgtQRDENLGInn3R+defYTZ/dJYkCYIgCKLeWHqnWX/+9WeYzR+dJUmCIAiCqDeW3mnWn3/9GWbzR2dJkiAIgiDqjaV3mvXnX3+G2fzRWZIkCIIgiHpj6Z1m/fnXn2E2/7XOXgAAAAAALJC1zr749IvdiIuLi9lz2I0kCYIgCKKGWHqnWX/+9WeYzR+dJUmCIAiCqDeW3mnWn3/9GWbzR2drSbJpylqhtHy/mGYrBEEQBKHFInr2Redff4bZ/NHZWpKMxbF9vL9YWCRdJp2VW6D9O/6DIAiCIKaMRfTsi86//gyz+Xc6++59R3zuv+eUu3zjzmb5nbc/CGr58O3XmoN3w6qdVbqqtHrEwko+Tw4EiXPWEppEzjBe7qRhy7CLJwdN07z25qVpu0mdtdin+KpYPpDRrODGRuv+SxAEQRDTx9CyZbCR2Hamzd9ToKZpmr03PnQKCILhOozsHhMeYS8+eHNP1afhjnCrs+/d6xrvvXvOht+937br5Rt3woTevR8fuPfuxW6n1uNuy/9bycePMKW4SaQMxeXaFrW/3bOqiXVW266YpFFPXyjDpfbC2bWaaIh3wBOOIAiCIEpjWNnSrCZtOxPn7ySjvBqPx7k7Umi0Y+ps69nFkl2UvzzZ4IM39zYbfu9e09x7snnpyUH7EWGt21GK794XTwKlHqfCoH4lHz+i8m6TaBlqy+UtZjJc7Zdn8Nn6t9HZoIw4yBoXKJLgF9I4Ll5LEARBzBKDypZmNartzJK/prOyYHz49mtuth++/Zq7L1MfYT9WuT0pTqn0COd0NmjR6BhFoumfEG0o9YSrK22g6Kzw+SluEk2FVUX+9IsXzpmUzPDyjTsrixUGpBP1B0mKspjWx2AVTTfto7PZQVl0liAIgpglhpQtzWpytjNx/unRWdFMOgkpd/HxdPaDN/eaO29/MPSAd5y/qLOXb9zZHEdpMNL1tvCYPjlomr1799tPD5t1lXpsOuvk44bUYMPorJNGIkNnHLq/zjbK5FRNTxMDpfGrdp1Nv6TlQxAEQRBjx4g623bfOduZOH9/7mzoErFgbEZtD97tBtpmOsJedBabHkPc/ggLOrs6KGun7KOzwdfu0qSCth7hI0Wos14+0jFKN0mZzm4mwnY1KxluPnDIhyXdctpkA/Er/rS/phtYrEET6GwmY5yCBEEQBJGOW6izTggjeoJgeDfKF0+TGEtn3TFKSfCGCklnM0PWptHZshOlNcimae7shaOzQT7qhtQm6TXZwD97pAyjuw59Ce6ls+kl7XK79Tb6oGxWZ435EARBEMSocbt1VhCe9Dfb794vNtqRdNbPM3Fb/wBHONDZaGOlc2eNJ4o2K+XJQTwTV9p5dRLGUHNn1aknYYb+btrqH/BWMGMlge+mXbZ3PgRBEAQxeNzCubNe5NRLvIupyMXH0Vn/+adrRplvEOis6I6Ze/0yk1+7/5ruGfSfiqCLvD7NeWydTTy3YWKdza6SGLi16Gx26JcgCIIgJohb+GQDL7LqtfXQ8ig6G38kGG2+gf/cWcUd009ii6XNfeBZ+HfyiW7dRNtNYxifNZtuEqvOPjnImrSfoRtT66z4amIVy2SDuIw9H4IgCIIYKW7fc2czj94Xh2PbMj1uuhpDZ6U0xppv4OisOz10w8bP5N/JcB5+Fg4gO/NKlZ/dcurpCrsznfV8dKcMm0TLUFn+3j13mfj7ZOpTM7TnzsYHQT5vivRRe8mySqM7a+KldOUEQRAEMV7cvl8F87+mD2/LEQXDdZgafhVM/kjQ4ycejPnLz51dbizid4cTOhs5fJOQTndhWjebwhu8ArXN1k8QBEEQI8UievZF519/htn80VmSJAiCIIh6Y+mdZv35159hNn90liQJgiAIot5YeqdZf/71Z5jNH50lSYIgCIKoN5beadaff/0ZZvNHZ0mSIAiCIOqNpXea9edff4bZ/Nc6ewEAAAAAsEDWOnsDAAAAALBYmn8HAAAAAFgs6CwAAAAALBh0FgAAAAAWDDoLAAAAAAsGnQUAAACABYPOAgAAAMCCQWcBAAAAYMH8f6fEaBjEeNYYAAAAAElFTkSuQmCC" alt="" />

  原来,在后台作业中,ALSM_EXCEL_TO_INTERNAL_TABLE函数并没有正确读取到文件的内容。

  在SCN上查询这个问题,可以发现,有很多人踩过这个坑。也有人给出了解释:之所以无法读取相应的文件内容,是因为后台作业实际上运行在ABAP应用服务器层面(Application Servers),而不是表现层(Presentation),当然也就不可能按照给定的路径读取文件了。

tips: SAP系统架构

1.最底层是数据库层。SAP自己并不提供底层数据库,而使用其他厂商的数据库管理系统(支持所有的主流数据库)。当然,现在已经有了HANA。只有SAP自身管理和运行所需的程序和元数据没有保存在数据库里,而应用系统运行的几乎所有数据都存储在数据库中。

2.ABAP程序运行在应用服务层。ABAP程序包括SAP提供的标准程序和我们自己开发的程序。ABAP程序从数据库读数据,处理数据,有可能还要储存数据。

3.第三层是表示层。这一层就是用户界面,用户可以通过它访问程序,输入数据,接收工作进程处理的结果。SAP把表示层也称为服务器,因为它的工作模式跟web浏览器类似,负责把应用服务器传来的界面布局数据转换成用户可浏览的界面,这种处理也可以成为一种‘服务’。

在SAP系统中,软件的技术分布完全独立与它所安装硬件的物理位置。

对于用户来说,SAP系统的应用层和数据库就是一个Black Box。从技术角度讲,有三种类型的屏幕:标准屏幕、选择屏幕和清单,没中屏幕为用户提供不同的服务。程序员应该根据任务的需要,为用户提供合适的屏幕。

  看来,我们有必要找到一种折衷的方式来实现后台导入数据到数据库。接下来的内容请看一步步实现ABAP后台导入EXCEL到数据库【2】

  

  

 

一步步实现ABAP后台导入EXCEL到数据库【1】的更多相关文章

  1. 一步步实现ABAP后台导入EXCEL到数据库【3】

    在一步步实现ABAP后台导入EXCEL到数据库[2]里,我们已经实现计划后台作业将数据导入数据库的功能.但是,这只是针对一个简单的自定义结构的导入程序.在实践应用中,面对不同的表.不同的导入文件,我们 ...

  2. 一步步实现ABAP后台导入EXCEL到数据库【2】

    前文:http://www.cnblogs.com/hhelibeb/p/5912330.html 既然后台作业只能在应用服务器运行,那么,我们可以先将要上传的数据保存在应用服务器中,之后再以后台作业 ...

  3. 如何使用NPOI 导出到excel和导入excel到数据库

    近期一直在做如何将数据库的数据导出到excel和导入excel到数据库. 首先进入官网进行下载NPOI插件(http://npoi.codeplex.com/). 我用的NPOI1.2.5稳定版. 使 ...

  4. django后台导入excel文件

    1.django 如何从后台上传excel中批量解析数据 要从django后台导入的excel中批量解析数据,举一个例子,我们向后抬批量导入svn历史数据数据格式 假设excel表中有4列,每列分别是 ...

  5. OpenXML&lowbar;导入Excel到数据库

    (1).实现功能:通过前台选择.xlsx文件的Excel,将其文件转化为DataTable和List集合 (2).开发环境:Window7旗舰版+vs2013+Mvc4.0 (2).在使用中需要用到的 ...

  6. ASP&period;NET MVC导入excel到数据库

    MVC导入excel和webform其实没多大区别,以下为代码: 视图StationImport.cshtml的代码: @{ ViewBag.Title = "StationImport&q ...

  7. xadmin后台 导入 excel 功能拓展

    新建 excel 文件 在 xadmin 的 plugins 下添加一个 excel.py # _*_ coding:utf-8 _*_ __author__ = "yangtuo&quot ...

  8. jxl读取excel实现导入excel写入数据库

    @RequestMapping(params = "method=import", method = RequestMethod.POST) @ResponseBody publi ...

  9. OpenXML&lowbar;导入Excel到数据库&lpar;转&rpar;

    (1).实现功能:通过前台选择.xlsx文件的Excel,将其文件转化为DataTable和List集合 (2).开发环境:Window7旗舰版+vs2013+Mvc4.0 (2).在使用中需要用到的 ...

随机推荐

  1. idea 分支主干管理

    1.创建分支 2.切换主干/分支 3.合并主干.分支

  2. Python excel 库:Openpyxl xlrd 对比 介绍

    打算用python做一个写mtk camera driver的自动化工具. 模板选用标准库里面string -> Template 即可 但要重定义替换字符,稍后说明 配置文件纠结几天:cfg, ...

  3. javascript生成GUID的代码

    <script type="text/javascript"> var Guid = function(){}; Guid.prototype = { S4:funct ...

  4. C&num; 线程(三):如何操纵一个线程

    From : http://kb.cnblogs.com/page/42529/ 下面我们就动手来创建一个线程,使用Thread类创建线程时,只需提供线程入口即可.(线程入口使程序知道该让这个线程干什 ...

  5. &lbrack;CF&rsqb;codeforces round 369&lpar;div2&rpar;

    *明早起来再贴代码 A [题意] 给定n*5的方格 将横向的相邻两个变成+输出 [题解] ... B [题意] 一个n*n的正整数矩阵,有且仅有一个数为0 ,在这个位置填上一个数,使得每一列的和 每一 ...

  6. Redis学习手册&lpar;Hashes数据类型&rpar;

    一.概述: 我们可以将Redis中的Hashes类型看成具有String Key和String Value的map容器.所以该类型非常适合于存储值对象的信息.如Username.Password和Ag ...

  7. 精通 Oracle&plus;Python,第 7 部分:面向服务的 Python 架构

    面向服务的架构 (SOA) 在当今的业务战略中具有至关重要的作用.混搭企业组件已成为所有任务关键的企业应用程序的标准要求,从而确保在企业架构的各层实现顺畅的服务编排.对此,Python 是一个不错的选 ...

  8. 通过git和Xcode将代码上传到GitHub

    长话短说: 第一步:初始化一个本地仓库 git init 第二步:将你的文件添加到缓存区 git add . 后面的空格 . 是将全部的文件都添加到缓存区  可以使用git status  查看状态 ...

  9. NodeMCU之旅(四):实现Web配置页面

    引言 利用Web页面做配置可以轻松适应用户的多种设备,如Android, IOS等.本文将介绍如何在NodeMCU中实现配置页面. 接线图请参考NodeMCU之旅(三):响应配置按钮. 配置页面后端 ...

  10. spring boot框架eclipse快速搭建

    1.maven安装配置好,使用eclipse创建maven项目(选择maven-archetype-quickstart) 2.然后进入http://docs.spring.io/spring-boo ...