SAP r/3 insert or update

[former_member238007]

Hi,

We have a scenario, in which we need to insert or update the data in the SAP r/3 based on the availability of the primary field in the SAP r/3.

For ex, if i have the employee details in SAP r/3 where in for a particular existing employee the salary details might be updated based upon the salary hike or if he is a new employee the details have to be inserted.

For this we have the primary field as the emp no.

How to proceed with this scenario.

Regards,

Kishore

[Former Member]

Hi,

Uploaded the document that describes the steps required for this scenario.

http://www.esnips.com/web/viveklrsStuff

Please award me points if it is useful to you.

Regards,

Vivek LR

[Former Member]

Hi,

kindly try File to RFC Scenario... in SAP R/3,Write a RFC ... in RFC write logic to Insert or Update based on Salary Hike..

Regards

R.Ragu

[Former Member]

Hello

you can use the BDC tech or BAPIS tech for uploading data in R3.

these tech r followed to upload data .

thanks.

Chetan .

[Former Member]

Hi,

Do you need to do this through XI? If so, You can do it through RFC scenario. (Calling remote enabled custom built function module)

Regards,

Vivek LR

[former_member238007]

Hi Vivek,

could u please elaborate more on the process

regards,

Kishore

[Former Member]

Hi,

Can u describe what all data are coming form the which systems and where it has to be updated.

Ur target system is R3?

chirag

[former_member238007]

Hi Chirag,

Actually i am getting an xml file as input where it contains empno, ename and salary, where in the empno was the base reference i.e primary key which was maintained in R/3.

the problem was if salary is hiked then we need to update the R/3, there we have to check wheter the empno is an existed or new, if the record is new then we have to insert else need to be update the entire row. i.e eno,ename and salary.

regards,

Kishore

[Former Member]

Hi,

U can do with the server proxy create an proxy. Inside the method write ur code in ABAP

1) First check the employee no which u got from file with the employee no which is maintained in the abap table if it exits then update the information if it is not then insert the data in table.

refer the server proxy scenario for ur reference.

first:

ABAP Proxy configuration:

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

second:

Server Proxy -

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

File to Inbound Proxy:

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy

Debugging Inbound Proxy:

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

chirag

[Former Member]

Create an RFC function module which takes input as eno,ename and salary.

and return success or failure as per your requirement.

Whatever you want to check whether to create or update all this you can do in RFC function.

SAP XI will read the details from XML file and send it function module.

Since you are getting the file call RFC in Asynchrounous mode.

Gaurav Jain

Reward Points if answer is helpful