.dbf file in SAP PO 7.4 single stack

[monikandan_p]

Hi Experts,

  Need to process .dbf file from FTP through SAP PO.

Is this possible to process the (.dbf) file from FTP in PO 7.4 single stack.

Kindly suggest some ideas to process this.

Thanks.

Best Regards,

Moni.

[monikandan_p]

Hi all,

   Using function module GUI_Download to generate (.DBF) from SAP r/3?

or this is possible with function module like WS_Download?

Kindly suggest is there any FM that we can export it as (.DBF) file from SAP r/3 also is there any logic we need to implement in FM.

Kindly do the needful.

Best Regards,

Monikandan.

[former_member186851]

Hello Moni,

Are you trying for Pick and drop(by pass) scenario or you have mappings?

[monikandan_p]

Hi Raghu,

To pick and drop will proceed normal (filename.dbf) using fileadapter in a sender/receiver channel path?

But here to read the file like .csv .Have mapping logic & target is webservice.

Kindly suggest for both.

Best Regards,

Moni

[former_member186851]

Hello Moni,

ya.pick and drop that will work.

for .DBF file try JDBC instead of FIle

[monikandan_p]

Hi Raghu,

  Iam confused can you pls explain clearly.Can you pls suggest SAP note for this.

If i deploy dbase driver in PI server and using JDBC adapter, Is this possible to read  the (.dbf) file from FTP without using file adapter (or) you are suggesting for DB server itself to place the file and read the (.dbf) file.

Because client not accepting to provide database credentials,If they provide credentials to access the DB then i can able to connect with JDBC adapter using select sql query to pull the data to PI.

Correct me if iam wrong.

The below provided link is not working

http://help.sap.com/saphelp_nw2004s/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm

Kindly suggest.

Thanks.

Best Regards,

Moni.

[former_member186851]

Hello Moni,

If client gives you the DB access you can get the query done and pick the table values.

But I doubt .DBF file can be picked by file channel.

[Former Member]

You can request them to generate DbF file as CSV and place it in FTP folder. Afterwards you can use regular procedure.. File to web Service.

[monikandan_p]

Hi Raghu,

      Have any idea on this approach from SAP system ->PI->Generate(.dbf) file that means PI need to write in (.dbf) file format also from (.dbf) file ->PI-> SAP system vice versa.

Kindly suggest some approach how to process the (.dbf) file.

Best Regards,

Monikandan

[former_member186851]

Hello Moni,

Why don't you try with JDBC adapter for picking the .dbf file?

[monikandan_p]

Hi Raghu,

    If we using JDBC adapter,suppose it will pick the (.DBF) file after that how to convert to xml and  update to SAP? in receiver side we need to think from both side.

My ideas:

1. Creating one table in Live SQL server and moving the data from SAP(RFC) to SQL table using JDBC adapter to generate (.DBF) file also (.DBF) file data to Live SQL server table then using JDBC adapter to pull data from table to SAP(RFC).

   2. Using JDBC adapter we can use select query in sender channel to pull the data from the SQL database to SAP or in(. CSV) file. (Client is not accepting to provide Database credentials ,(.csv) file).

3.(.DBF) file to intermediate SQL server to feed the data and then using JDBC adapter to pick those data and update to SAP also From SAP( RFC) to send data to intermediate SQL server using JDBC adapter and finally generate (.DBF) file.

Kindly suggest.

Best Regards,

Monikandan

[iaki_vila]

Hi Monikandan,

I haven't worked with .dbf files but they seems to be files with any structure that with determinated drivers you can do queries over them. I don't know if you will find any jdbc driver for this because it is not a real DB. However, you can find some libraries across Internet to work with java JavaDBF Tutorial

I encourage you to use any of this libraries in a java mapping or adapter module and to share the experience with us in the forum

Regards.

[former_member186851]

Ok Mani,

Then the ways could be

Request them to convert to CSV and place.

Or Read the .DBF file and use a module to convert to to XML then process it to SAP.

[monikandan_p]

H Raghu,

   Kindly tell me how to use the module and to convert to XML. Pls share the module steps to convert .dbf to xml through PI.

Kindly help.

Best Regards,

Monikandan

[former_member186851]

Hello Moni,

I haven;t worked on such modules,Just gave you and idea.

The link I shared is not helpful.

lets see if any other expert has a written module for this.