IDOC to JDBC mapping

[Former Member]

Hi,

All

I have a ZIDOC having one SEGEMENT in that segment having some fields .

that fields have to map to 12 tables in ORACLE .

is it possible? if yes how?

and

i have ZIDOC having 8 SEGMENTS in that ,this 8 segments have to map 12 tables in ORACLE.

is it possible ? if yes how?

regards

kumar

[Former Member · Accepted solution]

Hi kumar,

design 12 Datatypes for each table

Design one datatype (which nests the table-datatypes) having the structure:

DT_all_tables

__statement_for_table_1

____dbTableName

_____action (=attribute) map to constant "insert"

_____table map to constant YourTableName#1

_____access in column "type" assign datatype designed for table # 1

__statement_for_table_2

____dbTableName

_____action (=attribute) map to constant "insert"

_____table map to constant YourTableName#2

_____access in column "type" assign datatype designed for table # 2

..

__statement_for_table_12

____dbTableName

_____action (=attribute) map to constant "insert"

_____table map to constant YourTableName#12

_____access in column "type" assign datatype designed for table #12

Regards Mario

[Former Member · Accepted solution]

Hi,

Thankyou for your prompt reply and I appreciate your help.

i have designed as you said.

But

DT_all_tables (i have created as you said)

__statement_for_table_1 (wht i have to assign this field?)

____dbTableName( what i have to fill this field ?)

_____action (=attribute) map to constant "insert"

_____table map to constant YourTableName#1 ( i did not defined the table in DATA type)

_____access in column "type" assign datatype designed for table # 1 ( i have defined fields under this one)

__statement_for_table_2(what i have to assign to this field)

____dbTableName

_____action (=attribute) map to constant "insert"

_____table map to constant YourTableName#2

_____access in column "type" assign datatype designed for table # 2

..

__statement_for_table_12

____dbTableName

_____action (=attribute) map to constant "insert"

_____table map to constant YourTableName#12

_____access in column "type" assign datatype designed for table #12

as you said it is possible to send 1 SEGEMNT to 12 fields

and

8 segments to 12 tables .

thnx in advance points is awarded to you if you send any DOCS to me related to this Scenario.

regards

kumar

[Former Member · Accepted solution]

Hi S Kumar,

Once you created the stucture.. you need to Mapp create

one Message type

Message Interface

message Mapping in these Message mapping you need to assing the IDoc fields to Oracle Fields. Under access

once you done that you will need to Configure in ID.

Hope these helps you.

Regd's

Hari

[Former Member · Accepted solution]

Hi Kumar

Please refer to the following help page "Document Formats for the Receiver JDBC Adapter" for structuring your XML document.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Here you should be able to get explanations for the fields - StatementName, dbTableName, action , table, access, key, etc.

For each table opration you would need to repeat the XML section <dbTableName action=”<your action>”>

Every <access> node in the XML would create a row in the DB table (assuming action is "INSERT")

You can specify the column names and the column values by using the <col1>, <col2> element. Replace col1 and col2 by the actual field names.

Regards,

Gaurav

[moorthy]

Hi,

Other than current design,

Just a suggestion, try with Stored Procedure i.e call a procedure from the XI and pass the all the values. Inside the procedure write a logic to insert the data into multiple tables.

Regards,

Moorthy