RFC-XI-JDBC

[Former Member]

Hi All,

I have One Custom BAPI in R/3 Which is having the

Import Parameters :::From_Date

To_Date

Export Parameters:::: Customer Number

Customer Name

<u><b>Requirement::</b></u>

1) ABAPer Will write the Program to call this Custom BAPI.

2) When Ever this BAPI Executed he will give the Input as From_Date & To_Date. and extract the Values of Customer Number & Customer Name to XI, for Further Processing.

3) this Response will send to JDBC.

<u><b>Doubts:::</b></u>

1) Should we Cretae Any Message Interface for this RFC ????Or Not ????

If NO Means, I Will Use the BAPI Interface itself.

2) Is any BPM is Required for this Process???

3) Here we dont have any request msg to be sent to R/3 thourgh XI as we have the process mentioned in point 1.

4) So can we map only the response msg thru' to JDBC. In that case we are not able to directly take the response msg in the interface mapping.

Regards

Bopanna

[Former Member]

hi Bopanna ,

you can try likre this:

send your input parameters <b>From_Date & To_Date</b> from XI through File to RFC scenario - <b>file (this can be change)RFC(request)RFC(response)JDBC</b>

XI will call your BAPI and BAPI will executed and response will came back ,so you can use this response as a request to XI and you can do:

RFC to JDBC scenario.

you can go for BPM also but without BPM also you can do

hope this will help

regards

HONEY

[Former Member]

Hi,

How to configure this scenario which you mentioned without BPM????

Regards,

Bopanna

[Former Member]

Hi,

I have Done the Scenario RFC-XI-JDBC By mapping BAPI Response to JDBC.

Here in MONI Iam getting "No Message Available for selection" information

What could be the problem?????

Sender RFC CC is having no Errors.

Regards

Bopanna

[Former Member]

Hi,

Any Clues ????

Regards

Bopanna

[Former Member]

Hi Honey,

Ok, I will do this Using BPM.

But I Want to Automize the Interface.Means I Want to Run this Interface Daily Once. FOr this I Can Schedule the Adapter in CC.

How to Put the Request File With From Date & To Date in FTP Server ??????

Regards

Bopanna

[Former Member]

Hi Bopanna,

1. NO....we dont need to create any MI for this.....just import the RFC/BAPI in your SC and use it as an interface in mapping.

2. The scenario seems like a stateless one and we dont need BPM for this.

3. You have to write a report to input the data to this RFC/BAPI.

4. The RFC request needs to be mapped and not the request message of RFC.

Also, check out the following blogs:

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Cheers,

Puneet

[prabhu_s2]

1. Ur imported bapi in IR will be ur message interface which carries response also.

2. no bpm req in this case

pt# 3 & 4 are not clear....what is the kinda scenario u are working

[Former Member]

Hi,

This is RFC_XI_JDBC Scenario.

In R/3 BAPI Will be Executed & Response will be Sent to XI.

Response Comes into XI , I Need to MApp it to JDBC Structure to Insert that Value in Database.

Here Iam Asking is If I Did the Mapping Between BAPI Response & JDBC Structure Means,

In Interface MApping if I Select Sender Interface as BAPI & Click on Read Interfaces means , Iam Getting Only Request of the BAPI Only. Iam not getting the Response of the BAPI.

Regards

Bopanna

[GabrielSagaya]

since your requirement is asynchronous interface

There is no way of having BAPI request / Response.

In interface mapping

There is only one BAPI Request and DB Response MT alone for maping.

[Former Member]

Hi,

In Mapping I Will do the Mapping Between ::::

Mapping

BAPI Response----

---

JDBC Structure( Normal, No Req Or Response here )

When Come to Interface Mapping :::::

I Will Select the Source Interface as BAPI Interface & Target Interface as Inbound Asysnchronous JDBC Interface .

When I Click on Read Interfaces, Iam Able to get the Request BAPI Name instead of Response BAPI Name,

Here Iam Expecting to get the Response BAPI Name Instead of Request NAme.

Regards

Bopanna

[Former Member]

Hi,

My BAPI is Having Import & Export Parameters .

I Heard that if we have Req & Response with BAPI means we should Use Request -

---

Request Mapping &&&&& Response -

---

Response MApping

But here Iam Getting the Response From R/3 when Ever Executing the BAPI.

No Need to Mapp the Request -

---

Request Mapping

Where do I Mapp this Request MApping ?????

Should I Left it As Blank ????

Regards

Bopanna

[Former Member]

What I understood from your requirement is:

- You will execute BAPI in R/3 using ABAP and result of this execution should go to XI which will be stored in Database.

- You are want response in XI.

If my understanding is correct then you only need to map response. There are tricks also where you can create dummy RFC to map request also (Call actual BAPI in dummy RFC and map export parameter in import parameter. Search in forum you will surely find one.

Regards,

Gourav

[Former Member]

Hi,

I have the BAPI "BAPI_ZEMP" in R/3 . ABAP Program will be executed in the R/3 System By Calling this BAPI & It will give the Response to XI.

I Will Use this BAPI in IR For MApping.

I CAn Do the MApping Between Response BAPI To JDBC Structure

Then what About Request BAPI. Where I Nedd to Do the Request BAPI Mapping.

Regards

Bopanna

[Former Member]

well here is what i understood,

you have a ZBAPI in R/3 which will be triggered by some ABAP report/code,this BAPI will look for some response data based upon the request data within R/3 itself,until now no XI is involved,once this response is pulled from R/3 you need to send this response to a Database(JDBC) via XI,so basically its a async scenario from R/3 to JDBC.

now let me know if i understood your scenario correctly so that we can be of more help

Thanx

Aamir

[Former Member]

Create one dummy RFC "ZTest" and in ABAP program called BAPI_ZEMP and output of this BAPI send to ZTest in background.

Import parameters of ZTEST should be identical to your input requirement of mapping, this ZTEST may or may not contain any useful coding.

Import ZTEST in IR for mapping.

Map request of ZTEST with your JDBC structure.

Done!!

Pre-requisite: all configuration related to SALE and RFC destination should be completed.

Regards,

Gourav

[Former Member]

Hi Aamir,

YES , Your Understanding is Correct.

So tell me now How the Mapping Between Source & The Target Message Structures.

Regards

Bopanna

[GabrielSagaya]

1) Should we Cretae Any Message Interface for this RFC ????Or Not ????

If NO Means, I Will Use the BAPI Interface itself.

==> Use the BAPI Interface itself.

2) Is any BPM is Required for this Process???

==> BPM not required

[Former Member]

Hi,

1) Then How Can I Mapp that Response ,which is Comming from R/3 of the BAPI to JDBC Structure in Mapping. ?????

Can Any One give me the Mapping Shot ????

Regards

Bopanna

[GabrielSagaya]

This is Synchronous scenario

2 mapping is provided

RFC BAPI Request MT <---> DB request MT

DB response MT <--> RFC BAPI Response MT

[Former Member]

Hi,

This is RFC-XI-JDBC Asynchronous Scenario,

Here the Requirement is to Insert the Records in Database Using JDBC Adapter

Regards

Bopanna