1、选择excel文件: PARAMETERS: P_FILELIKERLGRAP-FILENAMEOBLIGATORY.ATSELECTION-SCREENONVALUE-REQUESTFORP_FILE.CALLFUNCTION'KD_GET_FILENAME_ON_F4'EXPORTINGPROGRAM_NAME= SYST-REPID DYNPRO_NUMBER= SYST-DYNNR*FIELD_NAME = ' 'STATIC ='X'MASK=',*.XLS,*.XLS'CHANGINGFILE_NAME=P_FILEEXCEPTIONSMASK_TOO...
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file. CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING mask = ',Microsoft Excel Files,*.xls' static = 'X' CHANGING file_name = p_file. *&---* *& Event START-OF-SELECTION *&---* START-OF-SELECTION. PERFORM ZALSM_EXCEL_TO_INTERNAL_TABLE...
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file. CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING mask = ',Microsoft Excel Files,*.xls' static = 'X' CHANGING file_name = p_file. *&---* *& Event START-OF-SELECTION *&---* START-OF-SELECTION. PERFORM ZALSM_EXCEL_TO_INTERNAL_TABLE...
1.选择excel文件: PARAMETERS: P_FILE LIKE RLGRAP-FILENAME OBLIGATORY. AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE. CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING PROGRAM_NAME = SYST-REPID DYNPRO_NUMBER = SYST-DYNNR * FIELD_NAME = ' ' STATIC = 'X' MASspark 读取 ftp class FtpShow...
CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING static = 'X' CHANGING file_name = c_file. IF sy-subrc <> 0. MESSAGE text-002 TYPE 'E'. ENDIF.AT SELECTION-SCREEN. PERFORM validity_check.START-OF-SELECTION. IF c_file IS NOT INITIAL. PERFORM upload_cc_material_info. PERFORM update_...
call Function 'KD_GET_FILENAME_ON_F4' 上传文件控制文件类型 msak = '*.xls' *** check全角or半角的方法 第一种方法 SJIS_DBC_TO_SBC 全角转半角 SJIS_SBC_TO_DBC 半角转换为全角 设定import all =x text = 文本 全角-〉半角,返回值 1 全角...
CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING MASK = '文本文件(制表符分隔)*.xls' STATIC = 'X' CHANGING FILE_NAME = g_FILE. PERFORM SUB_GET_MAX_COL USING alv_out[] CHANGING G_MAX_COL. PERFORM SUB_IMPORT_XLS_TO_ITAB TABLES alv_out USING alv_out g_FILE. LOOP AT alv_out. SE...
使用FM: KD_GET_FILENAME_ON_F4 CALL FUNCTION 'KD_GET_FILENAME_ON_F4' CHANGING file_name = s_file EXCEPTIONS MASK_TOO_LONG = 1 OTHERS = 2. 使用Class cl_gui_frontend_services的静态方法file_open_dialog 此方法功能强大,可以修饰文件选择框,指定默认选择路径,设置文件类型过滤,同时打开多个文件,返回...
RP_CALC_DATE_IN_INTERVAL 年月日加减 DATE_CHECK_PLAUSIBILITY 日期有效性检查 SD_DATETIME_DIFFERENCE 两日期作差 DATE_CONVERT_TO_FACTORYDATE 把输入日期转为工厂日历日期 MONTH_NAMES_GET 获得所有的月和名字 F4_DATE 弹出一个窗口显示一个日历允许用户选择一个日期。 RP_LAST_DAY_OF_MONTHS 获得一个月的最后...
1.选择excel文件: PARAMETERS: P_FILE LIKE RLGRAP-FILENAME OBLIGATORY. AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE. CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING PROGRAM_NAME = SYST-REPID DYNPRO_NUMBER = SYST-DYNNR * FIELD_NAME = ' ' STATIC = 'X' MAS ...