Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

need a sample flat file help me out

Former Member
0 Likes
775

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
754

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

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

4 REPLIES 4
Read only

Former Member
0 Likes
754

Hi

Create the file in excel.

While saving, click on File => SAVE AS -> (SAVE AS TYPE) -select "TEXT TAB DELIMMTED.

Best regards,

Prashant

Read only

Former Member
0 Likes
755

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

Read only

Former Member
0 Likes
754

Hi moazam,

problem solved?!?!

Regards, Dieter

Read only

0 Likes
754

hi its solved

thanks very much