Graphical mapping - conditional node creation and sub-element mapping

[masjo]

Hi,

I have a graphical mapping issue. I have a source document:

Documents 0..1

--Document 0.. N

--Header 0..1

--Line 0..N

-- LineTypeCode 0..1

-- GLAccountNum 0..1

I am mapping this to idoc ACC_DOCUMENT.ACC_DOCUMENT02.

For segment E1BPACGL09 in the idoc, I only want to map the Lines where LineTypeCode = 'GLITEM'.

My issue is when I map GLAccountNum (source) to a field in E1BPACGL09 (target), I need to do a RFC lookup as part of the mapping. The RFC lookup and mapping works fine when all Lines are 'GLITEM' but as soon as one of the line items should be suppressed, my mapping no longer works. Below is the GLAccountNum mapping I currently have:

Ideally, I would like to perform the RFC lookup only for the GLITEM Lines but not sure if this is possible with the way PI handles queues. Regardless, I need the mapping to work whether all Lines are relevant or some need to be suppressed.

I'm hoping someone who's much better at graphical mapping can help or even suggest a simpler solution.

Thank you!

[former_member190293]

Hi Joy!

As I could see you use useOneAsMany functions in your mapping. It seems to me that you can assign your source values (it looks like document or message level constants) to variables and use it instead of useOneAsMany. This will simplify the mapping.

As for RFC lookup, I'm not quite sure but I would try to move lookup to "then" condition of your IfWithoutElse function: if true then lookup.

Regards, Evgeniy.