Regarding Message Mapping in JDBC Scenario

[Former Member]

Hello Experts,

I need your help in Message Mapping.I am using JDBC Adapter. So My message strucuters are like

Sender Message Structure:

File_MT

Kunnr

Name1

ORT01

Receiver Message Structure:

JDBC_MT

Update_Insert

KNA1 ->this is main table

Action -> Required

CustNo

Name

City

So here I need to update Receiver database which is coming from external sender file.

So here i am facing problem how to mapping to sender to reciever and how to specify to update database here?

Thank you

[former_member194786]

Hi Ravi,

You can do the mapping like this:

JDBC_MT->File_MT

Update_Insert

KNA1 ->this is main table

Action -> UPDATE

CustNo

Name->Name1

City

Cust No and city you can fill up based upon the input fields.

Also you need to have a Key element in the target structure:

Key

FieldName

Your field name in the key will be the field based upon which you need to identify the record which needs to be updated.

Regards,

Sanjeev.

[Former Member]

Hi,

Map like below

kunnr -

---

> CustNo

Name1 -

---

> Name

ORT01 -

---

> City

Action is the statement INSERT/UPDATE/..

Table is the data base table, where the data should save.

By writing the query you can update the data in the data base table, for query separate column is there.

Reffer this

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

[Former Member]

Hi Ravi,

yes u can map never think that sr and target structure is different we can over come that problem using mapping pls do chk this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a04cd6f9-9eb0-2a10-07b8-a0fc6e88...

if found worth full pls do the req

Thanx

Sampath