Ecc Idoc to SAP PO single stack

[gurudatta]

Hi All,

I have a requirement

ECC will send idoc to SAP PO then PO to 3rd party(Oracle database)

there are 2 different receiver structures

ECC will send the IDOC which contains an exhaustive structure (Containing all fields of Receiver structure ) .

Depending on the Flag which is sent by ECC in the idoc, i need to map the fields to two different receiver structures

i mean to say 1 source structure(IDOC) but 2 different receiver structures

what should be the approach for Design part in ESR

Doubt :2 message mappings and 2 operation mappings OR 2 message mappings and 1 operation mapping ??

Please throw some light on the above

[former_member190293 · Accepted solution]

Hi Gurudatta!

In this case you could use one operation mapping with two receiving interfaces defined for it and one multimapping inside for creating message of desired type according to input condition. Another way, as we're talking about database operation (and JDBC adapter), might be using one message mapping with dymanic JDBC message creation (you can even use SQL_QUERY operation to build sql query with desired syntax).

Regards, Evgeniy.

[former_member190293]

Hi Gurudatta!

Wouldn't you please clarify what you mean saying "respective receiver" according to Oracle database? Different databases for each warehouse? Or different tables within the same database?

Regards, Evgeniy.

[gurudatta]

Hi Evgeniy,

Sorry for the confusing terms used

same oracle table for both ;

its just 2 different receiver structures

[former_member323679]

Hi Gurudatta,

Depending on the Flag which is sent by ECC in the idoc, i need to map the fields to two different receiver structures

kindly explain the above sentence more briefly.

You can have 2 operation mapping, 2 message mapping, 2 receiver interfaces.

Regards,

Nirmal

[gurudatta]

Hi Nirmal,

"Flag" i mean idoc will have field which holds particular ware house name ..depending on the warehouse name i need to route the data to respective receiver