topic Re: Reading (processing) .dbf file from SAP in Application Development and Automation Discussions

Reading (processing) .dbf file from SAP

Former Member — Sun, 21 Jan 2007 18:50:55 GMT

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

Re: Reading (processing) .dbf file from SAP

athavanraja — Mon, 22 Jan 2007 05:54:09 GMT

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

Re: Reading (processing) .dbf file from SAP

Former Member — Mon, 22 Jan 2007 05:55:14 GMT

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.