Skip to Content
0

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

Nov 21, 2016 at 12:03 PM

50

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Evgeniy Kolmakov Nov 21, 2016 at 01:55 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Dan Kennedy Nov 21, 2016 at 11:59 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded