2007 Aug 20 1:33 PM
hi to all experts,
i need a sample flat file of vendor master data.when im creating it using a notepad there is formatting error in it.i have ides system.plz anybody help me out
2007 Aug 20 2:00 PM
Hi,
try simle this as example to create.
DATA: ILFA1 TYPE TABLE OF LFA1.
DATA: DATEI_PC TYPE STRING.
*
SELECT * FROM LFA1 INTO TABLE ILFA1 UP TO 100 ROWS.
*
CALL METHOD CL_GUI_FRONTEND_SERVICES=>GET_DESKTOP_DIRECTORY
CHANGING
DESKTOP_DIRECTORY = DATEI_PC.
*
CALL METHOD CL_GUI_CFW=>FLUSH.
*
CONCATENATE DATEI_PC '\LFA1.TXT' INTO DATEI_PC.
*
CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD
EXPORTING
FILENAME = DATEI_PC
FILETYPE = 'ASC'
CHANGING
DATA_TAB = ILFA1[].
Regards, Dieter
2007 Aug 20 1:51 PM
Hi
Create the file in excel.
While saving, click on File => SAVE AS -> (SAVE AS TYPE) -select "TEXT TAB DELIMMTED.
Best regards,
Prashant
2007 Aug 20 2:00 PM
Hi,
try simle this as example to create.
DATA: ILFA1 TYPE TABLE OF LFA1.
DATA: DATEI_PC TYPE STRING.
*
SELECT * FROM LFA1 INTO TABLE ILFA1 UP TO 100 ROWS.
*
CALL METHOD CL_GUI_FRONTEND_SERVICES=>GET_DESKTOP_DIRECTORY
CHANGING
DESKTOP_DIRECTORY = DATEI_PC.
*
CALL METHOD CL_GUI_CFW=>FLUSH.
*
CONCATENATE DATEI_PC '\LFA1.TXT' INTO DATEI_PC.
*
CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD
EXPORTING
FILENAME = DATEI_PC
FILETYPE = 'ASC'
CHANGING
DATA_TAB = ILFA1[].
Regards, Dieter
2007 Aug 21 1:29 PM
2007 Aug 22 10:11 AM
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |