while Mapping from Idoc to Oracle Structure

[Former Member]

Hi Guys,

While i am mapping from Idoc Struc to Oracle Struc.

Here for action field i am assing Contstant that need to be assing from Source field. just confused is it true.

some one can confirm me please.

Regd's

Raj

[Former Member · Accepted solution]

Hi Raj,

The action must be mapped with CONSTANT function in Message MApping and the CONSTANT value should be INSERT or UPDATE or INSERT|UPDATE as per your requirements.

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Hope the above document will help you out.

Thank you.

[moorthy]

Hi,

Action field tells about the action supposed to take in the Oracle side.

You can give constant value for this. Like INSERT, DELETE etc. No need of passing from the source structure,.

Make sure that your document format is looking like this-

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

Regards,

Moorthy

[Former Member]

Hi Krishna Moorthy,

My query is while i created a Target Datatype like below Structure.

Statement

Tablename

action

RealTablename

access

Field1

field2

key

Field1

Field2

while i am Mapping from Source to Target I understad we need to create Constant.Here i am getting confusion

from source prospective do i need to assing a constant or shall i need to write a xml code for assing a Update word for action Field.

please clarify me here the above stucure i design the way jdbc reaciver in sap help.

Regd's

Raj

[Former Member]

Hi Raj,

Map CONSTANT function with action.

You have to double click the CONSTANT and enter INSERT in the VALUE.

Hope this helps.

Thanks.

[moorthy]

Just go to Message Mapping and insert Constant built in function and give the properties for the function as UPDATE. And then map this with action attribute from the target structure. No need of passing from the Source structure.

Regards,

Moorthy