Update the Oracle database with Material Number

[Former Member]

Hi Friends,

I would like to insert all material numbers in my Oracle Database from SAP.

Can any one please guide me how to do that?.

Thanks

RM

[Former Member · Accepted solution]

1) Configure your Oracle database in MII (Data Services -> Data Servers).

2) Create query template (SQL Query, Command Mode) and write your insert/update statement in

'Fixed Query' tab with required parameters.

3) Create a BLS that gets the materials by using a RFC.

4) Insert/Update the data with the SQL Query action block by using the query template created in step# 2.

Please search through the posts or ask in this forum if you have questions on any of the steps above.

John

[Former Member · Accepted solution]

Thanks John.

In RFC_READ_TABLE we can' t see fields. How can we link to RFC Table fields and my SQL Insert Query?

Please give me description.

Thanks

R M

[Former Member · Accepted solution]

If you are using RFC_READ_TABLE to extract the data, you must predefine what are the fileds you want to extract. And you will have to use the Sting List To Xml Parser.

These threads would be helpful for you:

https://forums.sdn.sap.com/click.jspa?searchID=14671910&messageID=5751160

https://forums.sdn.sap.com/click.jspa?searchID=14671910&messageID=5321255

In order to link fields, suppose you have created a query template like this:

insert into <<your table>> values ('[Param.1]','[Param.2]')

You must use a SQL query action block in your BLS and map the parameters to the individual fields (to the output of the Sting List To Xml Parser, which is of Rowsets/Rowset/Row format).

By the way, did you check with your BASIS goup on this? They will be able to post SAP data directly to external databases (it depends on your requirement).

John

[Former Member · Accepted solution]

Hi John

I am getting error when I execute my transaction like

[ERROR]: RFC Execution Error: Selected fields do not fit into structure DATA

[ERROR]: ACTION FAILED: End Action RFC_READ_TABLE_MARC : ()

I am using here MARC Table and I would like to use WERKS AND MATNR from the Table.

Can you please suggest me.

Thanks

Raghav

[Former Member · Accepted solution]

Use the link type 'Assign Xml' on your link editor when you map the .Request{/RFC_READ_TABLE/TABLES/FIELDS}

Also Make sure that you have defined the fields (XML) correctly:

<?xml version="1.0" encoding="UTF-8"?>

<FIELDS>

<item>

<FIELDNAME>WERKS</FIELDNAME>

<OFFSET/>

<LENGTH/>

<TYPE/>

<FIELDTEXT/>

</item>

<item>

<FIELDNAME>MATNR</FIELDNAME>

<OFFSET/>

<LENGTH/>

<TYPE/>

<FIELDTEXT/>

</item>

</FIELDS>

[Former Member]

Hi All,

Thanks for the Help.

[former_member192939]

RM, is this the similar post that u have already posted in SDN?

Here is your post on the 23rd of July

[Former Member]

Yes.