FAA_FILE_UPLOAD_EXCEL SAP Function module

FAA_FILE_UPLOAD_EXCEL is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.

See here to view full function module documentation and code listing, simply by entering the name FAA_FILE_UPLOAD_EXCEL into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: FAA_FILE
Released Date: Not Released
Processing type: Normal fucntion module

Pattern for FM FAA_FILE_UPLOAD_EXCEL - FAA FILE UPLOAD EXCEL

CALL FUNCTION 'FAA_FILE_UPLOAD_EXCEL' "
  EXPORTING
    i_filename =                " rlgrap-filename  Local File for Upload/Download
*   i_test =                    " rarep-xtest   Test Run
*   i_ucomm =                   " sscrfields-ucomm  Screens, Function Code That Triggered PAI
*   i_maxcols =                 " sy-index
*   i_delimiter = ','           " c
  TABLES
    et_filecontent =            "               Rows for Table with Excel Data
  EXCEPTIONS
    ERROR_ACCESSING_FILE = 1    "
    .  "  FAA_FILE_UPLOAD_EXCEL

ABAP code example for Function Module FAA_FILE_UPLOAD_EXCEL

The ABAP code below is a full code listing to execute function module FAA_FILE_UPLOAD_EXCEL including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).

DATA:
it_et_filecontent  
 
 TYPE STANDARD TABLE OF STRING,"TABLES PARAM
wa_et_filecontent
 
 LIKE LINE OF it_et_filecontent
.



DATA(ld_i_filename) = some text here


DATA(ld_i_test) = some text here


DATA(ld_i_ucomm) = some text here

DATA(ld_i_maxcols) = '123 '.

DATA(ld_i_delimiter) = '123 '.
 

"populate fields of struture and append to itab
append wa_et_filecontent to it_et_filecontent.
.

CALL FUNCTION 'FAA_FILE_UPLOAD_EXCEL'
  EXPORTING
    i_filename =                 ld_i_filename
*   i_test =                     ld_i_test
*   i_ucomm =                    ld_i_ucomm
*   i_maxcols =                  ld_i_maxcols
*   i_delimiter =                ld_i_delimiter
  TABLES
    et_filecontent =             it_et_filecontent
  EXCEPTIONS
    ERROR_ACCESSING_FILE =       1
    .  "  FAA_FILE_UPLOAD_EXCEL

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "Exception
  "Add code for exception here
ENDIF.

ABAP code to compare 7.40 inline data declaration with original syntax

The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.

DATA:

ld_i_filename
 
 TYPE RLGRAP-FILENAME ,
it_et_filecontent
 
 TYPE STANDARD TABLE OF STRING ,
wa_et_filecontent
 
 LIKE LINE OF it_et_filecontent,
ld_i_test
 
 TYPE RAREP-XTEST ,
ld_i_ucomm
 
 TYPE SSCRFIELDS-UCOMM ,
ld_i_maxcols
 
 TYPE SY-INDEX ,
ld_i_delimiter
 
 TYPE C .



ld_i_filename = some text here 

"populate fields of struture and append to itab
append wa_et_filecontent to it_et_filecontent.

ld_i_test = some text here

ld_i_ucomm = some text here
ld_i_maxcols = '123 '.
ld_i_delimiter = '123 '.