RFLQ_UPLOAD_QR SAP ABAP Report - Upload of Queries from Local File

RFLQ_UPLOAD_QR is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Automatic creation of queries with data from a local file The local file from which the data is to be taken should be generated as follows: Execution of the report RFLQ_LISTQR (transaction: FLQLQR) in the sources system with generation of a standard list, optimization of column widths inactive...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter RFLQ_UPLOAD_QR into the relevant SAP transactions such as SE38 or SE80

Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

FLQUPQR - Upload Queries

ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.

Text pool values

INCLUDES used within this REPORT RFLQ_UPLOAD_QR

INCLUDE FLQCONSTANTS .

TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!

Function Modules used within report and the associated call statement:

WS_ULDL_PATH
  CALL FUNCTION 'WS_ULDL_PATH'
    IMPORTING
      UPLOAD_PATH = FILENAME.

DDUT_DOMVALUES_GET
  CALL FUNCTION 'DDUT_DOMVALUES_GET'                        "note838167
    EXPORTING
      NAME                = 'FLQORIG'
    TABLES
      DD07V_TAB           = L_T_DD07V.

WS_FILENAME_GET
  CALL FUNCTION 'WS_FILENAME_GET'
    EXPORTING
      MASK     = ',*.txt,*.txt,*.xls,*.xls,*.xlsx,*.xlsx,'  "nte1702967

WS_QUERY
  CALL FUNCTION 'WS_QUERY'
    EXPORTING
      QUERY    = 'FE' "Filename exist
      FILENAME = FILENAME
    IMPORTING
      RETURN   = L_TMP_FL.

COMPANY_CODE_READ
    CALL FUNCTION 'COMPANY_CODE_READ'
      EXPORTING
        I_BUKRS = P_BUKRS.

FLQ_AUTHORITY_SETTINGS
    CALL FUNCTION 'FLQ_AUTHORITY_SETTINGS'
      EXPORTING
        I_ACTVT = CON_LQ_ACTVT_CHANGE
        I_BUKRS = P_BUKRS.

GUI_UPLOAD
  CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      FILENAME                = L_FILESTRING
    TABLES
      DATA_TAB                = L_TABLE
    EXCEPTIONS
      FILE_OPEN_ERROR         = 1
      FILE_READ_ERROR         = 2
      NO_BATCH                = 3
      GUI_REFUSE_FILETRANSFER = 4
      INVALID_TYPE            = 5
      NO_AUTHORITY            = 6
      UNKNOWN_ERROR           = 7
      BAD_DATA_FORMAT         = 8
      HEADER_NOT_ALLOWED      = 9
      SEPARATOR_NOT_ALLOWED   = 10
      HEADER_TOO_LONG         = 11
      UNKNOWN_DP_ERROR        = 12
      ACCESS_DENIED           = 13
      DP_OUT_OF_MEMORY        = 14
      DISK_FULL               = 15
      DP_TIMEOUT              = 16
      OTHERS                  = 17.

CONVERSION_EXIT_ALPHA_INPUT
        CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'         "nte1702967
          EXPORTING
            INPUT  = GT_HEADER_TABLE-LQPOS
          IMPORTING
            OUTPUT = GT_HEADER_TABLE-LQPOS.

COMPANY_CODE_READ
        CALL FUNCTION 'COMPANY_CODE_READ'
          EXPORTING
            I_BUKRS = GT_HEADER_TABLE-BUKRS
          EXCEPTIONS
            OTHERS  = 5.

FLQ_READ_POS
      CALL FUNCTION 'FLQ_READ_POS'
        EXPORTING
          I_LQPOS = GT_HEADER_TABLE-LQPOS
        EXCEPTIONS
          OTHERS  = 2.

REUSE_ALV_HIERSEQ_LIST_DISPLAY
  CALL FUNCTION 'REUSE_ALV_HIERSEQ_LIST_DISPLAY'
    EXPORTING
      I_CALLBACK_PROGRAM      = G_REPID
      I_CALLBACK_USER_COMMAND = 'USER_COMMAND'
      IS_LAYOUT               = GS_LAYOUT
      IT_FIELDCAT             = GT_FIELDCAT[]
      IT_EVENTS               = GT_EVENTS[]
      I_TABNAME_HEADER        = 'GT_HEADER_TABLE'
      I_TABNAME_ITEM          = 'GT_ITEM_TABLE'
      I_SAVE                  = G_SAVE
      IS_VARIANT              = GS_VARIANT
      IS_KEYINFO              = GS_KEYINFO
    TABLES
      T_OUTTAB_HEADER         = GT_HEADER_TABLE
      T_OUTTAB_ITEM           = GT_ITEM_TABLE
    EXCEPTIONS
      PROGRAM_ERROR           = 1
      OTHERS                  = 2.

REUSE_ALV_FIELDCATALOG_MERGE
  CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
    EXPORTING
      I_PROGRAM_NAME     = G_REPID
      I_INTERNAL_TABNAME = 'GT_HEADER_TABLE'
      I_INCLNAME         = G_REPID
    CHANGING
      CT_FIELDCAT        = LT_FIELDCAT.

REUSE_ALV_FIELDCATALOG_MERGE
  CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
    EXPORTING
      I_PROGRAM_NAME     = G_REPID
      I_INTERNAL_TABNAME = 'GT_ITEM_TABLE'
      I_INCLNAME         = G_REPID
    CHANGING
      CT_FIELDCAT        = LT_FIELDCAT.