Reading (processing) .dbf file from SAP

[Former Member]

We are developing an interface that requires the ABAP program to process a .dbf (dBASE, FoxPro) file.

Can you please suggest on accessing and processing .dbf file from SAP.

Additional Information:

SAP Version: SAP 4.7

Platform: HP-UNIX

Database: Oracle

(We get the .dbf file on to the network. I came across on the web someone suggesting using a script to convert the .dbf file to text or csv file . Can you please suggest on how to process using script, if you have done it on Windows or UNIX platform).

Thank you very much for your help.

Regards,

Vidya

[athavanraja]

you can use

gui upload with binary option.

data: dbf_tab type standard table of solix .

call function 'GUI_UPLOAD'

exporting

filename = filename

filetype = 'BIN'

has_field_separator = ' '

header_length = 0

importing

filelength = size

tables

data_tab = dbf_tab

exceptions

others = 1.

if size > 0 .

data: ftext_tab type standard table of soli .

call function 'SCMS_BINARY_TO_FTEXT'

exporting

input_length = size

• FIRST_LINE = 0

• LAST_LINE = 0

• APPEND_TO_TABLE = ' '

• MIMETYPE = ' '

• IMPORTING

• OUTPUT_LENGTH = OUTPUT_LENGTH

tables

binary_tab = dbf_tab

ftext_tab = ftext_tab

exceptions

failed = 1

others = 2

.

if sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

Raja

[Former Member]

Hi !

You may have a look to a tool such as "CDBF for Windows" is.

Just have a look herer

http://www.whitetown.com/cdbf/

Ther's also a "console" and a linux version !

Regards

Rainer

Some points would be nice if that helped.