June 6, 11 minute read. Executable SE38 report. User Interface selection-screen begin of block b04 with frame title text-b Exception Handling You will get exception of structure infliction if xlsx file is not for that table. Alert Moderator. Alerting is not available for unauthorized users. Assigned Tags. Similar Blog Posts. Related Questions.
You must be Logged on to comment or reply to a post. Tomas Buryanek. Like 1 Share. Right click and copy the link to share this comment. Trevor Zhang Blog Post Author. Thanks a lot. This is my understanding. Instead of one large file, the path containing the smaller files should then be specified in the Excel upload. Input existing table, e. Change the value of non-key column in xlsx file. Lambert Osborne's Ownd. This page therefore offers a place holder for information about this t-code so anyone can use the comments section below to ask questions or contribute any useful hints, tips, screenshots or anything else relevant to this transaction.
This will then be available for everyone to easily find by simply searching on the transaction code GLPLUP or its description. Google Docs is also interchangeable with this format.
Searching for Excel upload and download ABAP programs, which support the open xlsx format can sometimes be time consuming. Here is a program which provides all of the code to upload and download an xlsx file. Most ABAP developers are aware of the ultimate solution, which is the open source abap2xlsx project.
However, sometimes that may be difficult to install at a large customer, where the security organization rules. If you simply want to generate an xlsx spreadsheet, and read in a spreadsheet, the abap2xlsx library may be overkill. Standard SAP libraries are used here. This Blog demonstrates a program that allows you to maintain a Z Table in SAP by entering data in an Excel spreadsheet in the xlsx format.
This program was built to support this Blog for a Kotlin Application. If we display our program in the Object List, we see the following methods, referenced in the above diagram:. Choose a file name and directory on your PC. Save the file, then Alt-Tab back to our selection screen. Execute the program, and you will get a pop-up with a record count of the refresh number of records deleted and the insert count:.
One nice feature, you can keep your Excel file open, edit the data, run the program and see the results in SAP all together. For example, tile your 3 sessions, as follows:. Refresh Button:.
Note, to upload the Excel data, you may have your Excel file open, but to download the data, you must have the file closed because it will be locked. You can add logic specific to your own custom Z table in this method. More on this later. The select-option parameters are passed to the execute method denoting upload, download, table name and the Excel File name and path. Here is the definition and implementation of our Exception class:. Never update data directly in standard SAP tables:.
As is, this program should only be used for tables that do not have too many records. For large datasets, the program would timeout. For large data loads, you would need to load your data directly from the SAP operating system, as a background job. For tables with large datasets, you could adjust this program to update subsets of records, rather than perform a complete refresh. Since both options upload or download will require dynamic creation of an internal table, based on the table name entered on the selection screen, we will do the following for both options:.
Because we will need all of the data in the table for both the upload and download methods, we then select all records into the internal table. If we are doing an upload, we will need this in order to completely refresh the table. If we are downloading, of course we need all of the records.
0コメント