Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to pull data from R/3 to BW

Former Member
0 Kudos
119

hi Friends,

i have problem i need to pull data from r/3 to BW.

i have data in bapi in r3 and i need to move some data from this bapi to BW bapi

how i can do that its because the bapi located in diffrent system in my company?

Regards

1 ACCEPTED SOLUTION

ferry_lianto
Active Contributor
0 Kudos
76

Hi,

BAPIs are RFC-enabled function modules.

Therefore, you can call BAPIs on remote systems e.g.


CALL FUNCTION 'BAPI_USER_GET_DETAIL'
  DESTINATION <rfc destination to remote system>
  EXPORTING
    ...
  IMPORTING
    ...

Note that the RFC destination has to be defined using transaction SM59.

Regards,

Ferry Lianto

8 REPLIES 8

Former Member
0 Kudos
76

hi friends

maybe some one can help me with that its very impotent for me

Regards

0 Kudos
76

HI TAL

U have couple of user exits, generally you have some 4 to 5 user exit which, ppl will use to pull data.. check that in SAP-IMG.. u have SAP standard extractors in R3.. or you can create your own extractors to through data into BW... as an ABAPer our work will mostly be on the user exits end.. need to pull data from all fields and pass to BW thru that user exits...

former_member191735
Active Contributor
0 Kudos
76

Create an TCP/IP connection between both systems.

Go to tcode sm59. I think talk to basis people to create connection between r/3 and bw. Well, after that you can execute bw bapi from r/3. you can append any data to that bapi and send it back to bw.

talk to basis about connection. they might have been created connection between those systems.

ferry_lianto
Active Contributor
0 Kudos
77

Hi,

BAPIs are RFC-enabled function modules.

Therefore, you can call BAPIs on remote systems e.g.


CALL FUNCTION 'BAPI_USER_GET_DETAIL'
  DESTINATION <rfc destination to remote system>
  EXPORTING
    ...
  IMPORTING
    ...

Note that the RFC destination has to be defined using transaction SM59.

Regards,

Ferry Lianto

0 Kudos
76

hi ferry

thank u very much for your replay!!!

1. i call the FM and i don't have field with DESTINATION plz look below i put all the fields that i get from call this FM:

2. lets say i have 2 fm 0ne in bw that call fm_bw

and i wont to call from this Fm to r3 fm let say

fm_r3, how i use it in the function below and where i put fields of import and tables of the Fm fm_r3 ?

Best Regards

CALL FUNCTION 'BAPI_USER_GET_DETAIL'

EXPORTING

username =

  • IMPORTING

  • LOGONDATA =

  • DEFAULTS =

  • ADDRESS =

  • COMPANY =

  • SNC =

  • REF_USER =

  • ALIAS =

  • UCLASS =

  • LASTMODIFIED =

  • ISLOCKED =

tables

  • PARAMETER =

  • PROFILES =

  • ACTIVITYGROUPS =

return =

  • ADDTEL =

  • ADDFAX =

  • ADDTTX =

  • ADDTLX =

  • ADDSMTP =

  • ADDRML =

  • ADDX400 =

  • ADDRFC =

  • ADDPRT =

  • ADDSSF =

  • ADDURI =

  • ADDPAG =

  • ADDCOMREM =

  • PARAMETER1 =

  • GROUPS =

  • UCLASSSYS =

  • EXTIDHEAD =

  • EXTIDPART =

  • SYSTEMS =

.

matt
Active Contributor
0 Kudos
76

DESTINATION isn't a parameter. It's part of the syntax of CALL FUNCTION. So

CALL FUNCTION 'BAPI_USER_GET_DETAIL' DESTINATION 'bw_system'

EXPORTING username = ...

Just like Ferry Lianto said above.

matt

Edited by: Matthew Billingham on Dec 18, 2007 3:23 PM

0 Kudos
76

hi matthew

thanks

sorry i dont understand u mean that i have to call to the Fm like that:

CALL FUNCTION 'ZR3_BAPI' "the bapi that i wont to use

DESTINATION 'bw_system'

EXPORTING ..... = ...

or i have to use for that BAPI_USER_GET_DETAIL bapi

Regards

Former Member
0 Kudos
76

HI ,

no one now about way to do that ?

Regards