Mapping not using IDocs as source

[Former Member]

Hi,

I wish to get some advise from you if it would be possible to do mapping wherein your data are sourced directly from an SAP R/3 table. There is a table that contains all the data needed for your target fields.

In this case, no IDoc is being sent to XI.

Given this scenario, what trigger mechanism would you suggest in order to initiate the mapping? Is it possible to automate the trigger in XI?

Your response is very much appreciated.

Thanks a ton!

[justin_santhanam · Accepted solution]

Lex,

Do u want to get some table values in R/3 during Mapping isn't it?

raj.

[Former Member · Accepted solution]

Hi Raj,

Yes, I want to get table values in R/3 during Mapping.

Pretty much, the structure of the table in R/3 contains all the data sourced for the mapping.

We use Oracle tho as the database.

Thanks!

[justin_santhanam · Accepted solution]

Lex,

Plz confirm, do u want to get during mapping? or the values will be your source message?

During mapping then it's RFC Lookup.

If you want it as source message, then it's not good idea to get the data from SAP Database directly. Better option would be write RFC and then trigger from R/3.

raj.

[Former Member · Accepted solution]

Raj,

The values will be the source message.

If you are suggesting about the RFC, I was wondering how the trigger mechanism is setup or what initiates the trigger.

I found some guide on rfc though, but would you have anything available that is specific to this kind of scenario?

Lex

[justin_santhanam · Accepted solution]

Lex,

You can write own RFC , or there is RFC called RFC_READ_TABLE which gets the input of table name and give the response, you can use that to trigger.

raj.

[Former Member · Accepted solution]

Jai,

I'll look into the version of our R/3 and XI. But basically, both R/3 and XI should be running > 6.40 right?

1. ABAP Proxy (Web As >6.40) Most stable & Recommended

Lex

[Former Member · Accepted solution]

>>both R/3 and XI should be running > 6.40 right?

Dont worry about XI. Even the old version XI 3.0 comes with WebAS 6.40. PI 7.0 has Web AS7.0.

You only got to check you R/3 system.

@Raj,

Well. That was exactly what I had in my mind when I wrote "JDBC adapters are not preferred".

Regards,

Jaishankar

[Former Member · Accepted solution]

Everyone, thank you so much!

YOU guys are AMAZING!

[Former Member · Accepted solution]

>>YOU guys are AMAZING!

You know what, just these 4 words keeps the whole SDN wheel in motion

Regards,

Jaishankar