Data extraction from SAP R3

[Former Member]

We need to pull data like material information, purchase order information from SAP R3 4.6C to our local oracle database on daily basis. We don't want to use BAPI calls.Can somevone guide us how to do it?

[Former Member]

We need to pull data like material information, purchase order information from SAP R3 4.6C to our local oracle database on daily basis. We don't want to use BAPI calls.Can somevone guide us how to do it?

[Former Member]

if you have PI in your landscape you do it Via PI.

IDOC - PI - Database.

Regards,

Suresh

[Former Member]

Thanks Suresh. Can you please explain how to do that. I am new to this field. If you can send me some code example that will be great.

[Former Member]

SAP PI is middleware from SAP and it is all toghether a seperate installation.

if SAP PI system in place along with R3 then co-ordinate with your PI team.

Regards,

Suresh

[Former Member]

Apart from IDOC, there is one more option of flat file or CSV file.

as you want the data daily, you can develop an interface in SAP which extract the creatae / change material master data , purchase oredr of previous day and format in file which is acceptable in Oracle server and send using FTP push or pull method. I believe in Orcale databas we can upload CSV file easiy. The create or change data of previous day, you can easily get in CDHDR/CDPOS tables.