on 03-06-2008 8:36 AM
hi all,
iam integrating SAP sytem with Oracle database system.
so iam using JDBC at reciver side.
SAP side data is coming from 3 tables say tab1,tab2,tab3.
tab1 having 3 fields f1,f2,f3, tab2 having 2 fields f4,f5, tab3 having 2 fields f6 f7.
sender side structre is as below:
<node>
<f1>
<f2>
.........
<f7>
</node>
but receiver side they want another extra field table name say <tabname>
in receiver table data has to update like this:
<tabname> <f1> <f2> <f3> <f4> <f5> <f6> <f7>
tab1 value value value null null null null
tab2 null null null value value null null
tab3 null null null null null value value
that means data related to tab1 has to filled in tab1 related fields remainig all r null.
Can anybody help me out?
Thanks,
Sreedhar Goud
hi sreedar,
create 4 data types
data 1 <itab><f1>...<f7>
data 2 <itab1><f1>...<f7>
data 3 <itab2><f1>...<f7>
data 4 <itab3><f1>...<f7>
add this data type four times in messgae mapping i.e
create mapping program say "multi mapping"
with maps source to 4 data types at a shot
<xml>
target as
<f1>...<f7> data1
<f1>...<f7> data 2
<f1>...<f7>data 3
<f1>...<f7>data 4
map accordingly .
after this create 4 interfaces for 4 data types
in interface mapping select one source interface and 4 target interfaces
once u refresh mapping all data types are populated and u can see message mapping program.
in configuration create receiver interface determination go to extended and use interface mapping u did
4 reciever determinations for 4 interfaces and use one communication channel.
create receiver determinatio as one sender and receiver.
thats done hope so.
Thanks & Regards,
Rama krishna
Edited by: rama krishna talluri on Mar 6, 2008 10:20 AM
Edited by: rama krishna talluri on Mar 6, 2008 10:22 AM
Edited by: rama krishna talluri on Mar 6, 2008 10:22 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Seshagiri,
Thanks for ur replay.
In receiver structure I can give the database table name that in not a problem,but the thing is i have a field 'tablename' in my receiver structure.I have to map SAP table name(from where the data is coming) to that field.
How can i track that one.
Thanks,
Sreedhar
Hi,
Refer this link related with JDBC receiver..
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
regards
Aashish Sinha
PS : reward points if helpful
Hi,
You should have the receiver JDBC structure as mentioned in the BLOG.You shldn't have the structure according to your's
Receiver JDBC is having some sort of structure follow that
If you are passing the SAP r/3 table mane to the JDBC structure means where you are capturing this value at Receiver Database side??
Regards
Seshagiri
hi Seshagiri,
Receiver JDBC having some sort of structure....Thats true.
structure is like this:
<Statement>
<table> -
you r saying abt this table name if iam not wrong(JDBC table name)
<action>
<access>
<tabname>----
iam asking abt this table name(it is SAP table)
<f1>
<f2>
.....
<f7>
I am following this structure only at reciver side.I know the jdbc tale name.no problem with this.
I want to track SAP table name.
Here we r extracting the data from 3 sap tables.
thanks,
sreedhar
Edited by: Sreedhar Goud on Mar 10, 2008 10:52 AM
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.