Is it possible with multiple IDOC segments map to multiple JDBC table structures in SAP PO

[former_member268562]

Dear Experts,

My requirement is we have multiple IDOC segments from source and need to map with multiple table structures in JDBC receiver.

Please let me know is it possible for multiple IDOC structures to multiple JDBC receiver structures?

Please let me know how the receiver structures?

Please let me know advantages/disadvantages by using multiple receiver JDBC structures.

Thanks,

SAI

[Former Member]

You can do this two ways - Either have individual mapping scenarios if for example you are connecting to different sql servers/schemas. You would recycle the same source message type and service interface for each. Or as Evgeniy has stated, you create separate 'statements' for your different tables for each segment as required.

[former_member190293]

Hi Saisreevastav!

Since JDBC message structure allows using multiple statements within one message you can use separate statements with its own table name for each of your IDoc segments.

Regards, Evgeniy.