creation of sales order from Non Sap to Sap using sap xi

[Former Member]

hi

can any body expalin me how to create sales order in sap from data in MS Sql with highest performance becz the sales order is going to be of around 1000 items ,

sales order needs to be created in sap

pl help immediately as its anongoing project

rgds

shazia

[Former Member]

HI,

For My SQL you need JDBC communication and on R/3 end it will be BAPI or IDOC

Use BAPI_SALESORDER_CREATEFROMDAT1. (In ECC 5.0 and above)

With IDOC either you have to follow any one of the below option

1.Go to BD87 and give the IDOC number and respective parameters and execute....then select the ORDERS node in the next screen and press PROCESS....this will post the IDOC onto a sales order.... What message type are you using with the IDOC....???

2. Second : Go to SE38...execute program RBDAPP01 and provide the same thing.. IDOC number...

3. Third: Copy the IDOC in WE19 - (in case your IDOC processed incorrectly and you want to alter some data on the IDOC)....and modify contents /segments as you desire and then process it directly....

Even though the line items are 1000 it will not affect much on performance if you avoid any complex mapping or any other extra features such as BPM.

Refer below link to configure JDBC sender adapter

/people/community.user/blog/2007/12/06/exactly-once-handling-for-pixi-jdbc-sender-adapter

Thanks

Swarup

[Former Member]

Hi ,

Thanks for your reply , the concept is clear , can u please tell me what can be the possible time for sending one idoc of probably 1000 lines , accordingly we can calculate for total no of idocs

rgds

shazia

[Former Member]

Hi,

The processing time of JDBC to IDOCs depends upon the configuration of your Integration Engine for max utilization of memmory and paging for processing.

As far as I know it will take hardly few miliseconds to process the 1000 lines in either single IDOC or multiple IDOCs.

Maintain the Memory utilization at maximum for this.

Thanks

Swarup

Edited by: Swarup Sawant on Feb 19, 2008 8:34 AM

[Former Member]

hi swarup ,

"Maintain the Memory utilization at maximum for this."

can u please elaborate how to mantain the memory utilization to maximum??

thanks

rgds

shazia

[Former Member]

Hi,

See the example Program for Mass Processing IDocs

http://help.sap.com/saphelp_nw04/helpdata/en/78/21760251ce11d189570000e829fbbd/frameset.htm

Refer the link for this utilization

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/72e2bb90-0301-0010-e883-c390ad8a...

See the below tunning guid for imporving the performance

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/423f5046-0a01-0010-2698-b2dc7c31...

Thanks

Swarup

[Former Member]

Hi

Actually this scenario needs to be implemented using ABAP Proxy,

the requiremnt is :

there is a legacy system from it almost 6000 lines of data are genereated daily , and from it they want to create SO , PO , inventory, etc etc but they want to use abap proxy . so i have to go for abap proxy ,

can any body help me out with a step by step how can the scenario be implemented using abap proxy on the serve side .

I know the concept of server proxy implementation but how to go with the above ,

pl ans fast , time is melting away from my hand

rgds

shazia

[Former Member]

Hi,

Please refer below link for ABAP proxy on server side

ABAP Server Proxies -- /people/siva.maranani/blog/2005/04/03/abap-server-proxies

Example for creating proxies and call BAPI via the Exchange

Infrastructure

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/7038b290-0201-0010-41a9-83b61d95...

Setting Up Point-to-Point Connections with proxy

http://help.sap.com/saphelp_nw04s/helpdata/en/85/78af1bf407434796aaf8dbd6d4e7b7/frameset.htm

Reliable Messaging – EOIO in ABAP Proxies

/people/arulraja.ma/blog/2006/08/18/xi-reliable-messaging-150-eoio-in-abap-proxies

/people/stefan.grube/blog/2006/07/28/xi-debug-your-inbound-abap-proxy-implementation

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3dfac358-0d01-0010-5598-d4900e81...

RFC/BAPI Communication

http://help.sap.com/saphelp_nw04/helpdata/en/67/6d0540ba5ee569e10000000a155106/content.htm

Configuring the Sender RFC Adapter - step by step

/people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

XI: RFC or ABAP Proxy ? ....ABAP Proxies with attachments

/people/michal.krawczyk2/blog/2006/04/19/xi-rfc-or-abap-proxy-abap-proxies-with-attachments

ABAP Proxy Generation --

http://help.sap.com/saphelp_nw04/helpdata/en/14/555f3c482a7331e10000000a114084/content.htm

Actiave ABAP Proxies -- /people/vijaya.kumari2/blog/2006/01/26/how-do-you-activate-abap-proxies

ABAP Client Proxies -- /people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

Thanks

Swarup

[Former Member]

Hi Shazia,

create a JDBC->XI->Idoc scenario, where target IDoc will be standard IDoc for Sales Order. (ORDERSxx - contact your ERP consultant for details about target IDoc).

Peter