Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Reading (processing) .dbf file from SAP

Former Member

‎2007 Jan 21 6:50 PM

0 Likes
854

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

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

Reply
2 REPLIES 2
Read only

athavanraja
Active Contributor

‎2007 Jan 22 5:54 AM

0 Likes
555

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

Read only

Former Member

‎2007 Jan 22 5:55 AM

0 Likes
555

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.