![]() ![]() *” REFERENCE(HEADER) TYPE CHAR1 DEFAULT ‘X’ *” REFERENCE(P_FILE) TYPE RLGRAP-FILENAME Pass Desktop File path, Structure name in p_File and STR as input Parameters respectively.įirst Create Structure in SE11 similar to the Excel File format. Once you create Z FM, for every Excel File you’ll just need to create a structure in SE11 and you’re good to go. In order to avoid extraneous code when it comes to uploading Excel File with huge number of columns, create a FM with below code. ….and so on depending upon number of columns in Excel For this we have to map column number of FM output with columns of required internal table usingĬALL FUNCTION ‘ALSM_EXCEL_TO_INTERNAL_TABLE’įurther based on column number, work area is filled using CASE-ENDCASE and then Appending work area into required internal table in AT END OF ROW block. This blog post will help you avoid extraneous code every time you create Excel upload program by creating a simple Interface and a structure.įor ALSM_EXCEL_TO_INTERNAL_TABLE, explicitly we need to write code to transfer output of this FM into internal table of desired format. ![]() Follow this, only if you are working on older systems to maintain the code where you’ve already used ‘ ALSM_EXCEL_TO_INTERNAL_TABLE’.Īlso this post will help you grasp concept of Field symbols with below application. ![]() WARNING: This post is intended to Excel upload FM which is now obsolete. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |