One-Many Mapping IDoc to SQL Adapter

[Former Member]

Hi All,

I need to create a mapping from an IDoc (DEBMAS03) to message(s) that can be consumed by an SQL Adapter.

Part of the requirement is to create a row in a table for every instance of segment (E1KNVMM) which can be repeated multiple times in the IDoc.

What I want to ask is what is the best way to do this. Can I do it with just a message mapping? Or do I have to use BPM or XSLT?

I think I can do it with just a message mapping which produces a message type with multiple STATEMENTs in it. But I would like some advice from more experienced people.

Any help is appreciated.

Thanks.

Gerard

[former_member184720 · Accepted solution]

Hi Gerard - Yes. No need of BPM/xslt..

It's very much possible using graphical mapping.

E1KNVMM-> to access segment..

[Former Member · Accepted solution]

Hi Hareesh,

Thanks for your help, and thanks for the reference.

Gerard

[Former Member]

Hello,

Ur graphical mapping would suffice. No need to create BPM and all.

Thanks

Amit Srivastava

[Former Member]

Hi Amit,

Thanks for your help.

Gerard