Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 21, 2016 at 01:55 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2016 at 11:59 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded