SalesOrder Casestudy in PI7

[Former Member]

Hi,

I am looking for some help in case study. I am trying to do SalesOrder process. I would like to retrieve data from Oracle and insert into Oracle again. Can you some body share the step by step document or code ?

[Former Member · Accepted solution]

Hi Venkat,

Y do u search for a case study.Y dont you create one.

Here your scenario is JDBC-JDBC.

Find a scenario in SDN to configure JDBC as a sender and JDBC as receiver.Check the tables,Fields and create you DT;s accordingly.

There will be a seperate structure to create you DT accoding to your Action.

Document format for Receiver:

http://help.sap.com/erp2005_ehp_04/helpdata/EN/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

Document format for Sender:

http://help.sap.com/saphelp_nw70/helpdata/EN/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

First understand the tables,Prim Keys,Tables constraints(nullable or not), ER Diagram of the tables etc.

Thanks

Prabhakar

[prateek]

I would like to retrieve data from Oracle and insert into Oracle again

If one of the Oracle system you mentioned is SAP backend database system, then keep in mind that SAP database shouldn't be accesses using JDBC calls. Use Idoc/RFC/Abap proxy interface for your connection with SAP system. For other database use JDBC adapter. For complete description, please search on SDN with sender/ receiver and Idoc/ JDBC scenario as per your requirement.

Regards,

Prateek

[Former Member]

Hi Venkat

I think you have already received basic steps in above message.

But as SalesOrder operation you can find as standard Scneario or IDOC based scenario. What exactly you are trying to achieve using JDBC to JDBC

Thanks

Gaurav