Skip to Content
author's profile photo Former Member
Former Member

JBDC-Sender - split message when new value occurs

Hi,

i am reading data from database. There we have a field which should tell when to create new target-datatype. Scenario is JDBC2IDoc - so when in value <ART> a "P" instead of a "H" occurs - a new IDoc should be generated.

Is this possible to achieve?! When how do i have to do this?! Do i have to map in two different steps?! First read the whole data from DB and then take this payload to map to the target structure depending on the value sin <ART>?!

Source Structure looks like this:

<?xml version="1.0" encoding="utf-8"?>

<MT_EPLAN_DB>

<row>

<ID>79</ID>

<ART>P</ART>

<DATA1>63140300065400</DATA1>

<DATA2></DATA2>

<DATA3></DATA3>

<DATA4></DATA4>

<DATUM>20071113101505</DATUM>

<PROCESSED>0</PROCESSED>

</row>

<row>

<ID>80</ID>

<ART>W</ART>

<DATA1>71000002</DATA1>

<DATA2>1</DATA2>

<DATA3>1</DATA3>

<DATA4>Bohrer </DATA4>

<DATUM>20071113101505</DATUM>

<PROCESSED>0</PROCESSED>

</row> <row>

<ID>83</ID>

<ART>P</ART>

<DATA1>66341000829400</DATA1>

<DATA2></DATA2>

<DATA3></DATA3>

<DATA4></DATA4>

<DATUM>20071114132612</DATUM>

<PROCESSED>0</PROCESSED>

</row>

<row>

<ID>84</ID>

<ART>W</ART>

<DATA1>71000002</DATA1>

<DATA2>1</DATA2>

<DATA3>2</DATA3>

<DATA4>Bohrer </DATA4>

<DATUM>20071114132612</DATUM>

<PROCESSED>0</PROCESSED>

</row>

</MT_EPLAN_DB>

can somebody help?!

br

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 04, 2007 at 03:18 PM

    Ur <row> node has multiple occurrences. Just map it to the receiver Idoc structure.

    This way do simple mapping.

    Now in ID, use conditional receiver determination. In the condition, if the value of field <ART> is "P", then use SAP system as receiver for Idoc. Otherwise mention the condition u want to use if the field is other than "P"

    I think the BPM wont be required then

    Regards,

    Prateek

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Justin Santhanam

      Hi Raj,

      well this is a really great solution!!! I really appreciate ur help!

      I guess i have to get in contact with UDFs more deeply because it occurs more often than i thought. Even the context-changes are not in my focus yet!

      Do u have some advices for doing some excersises on this issue?!

      great job!! Thx!

      br Jens

  • Posted on Dec 04, 2007 at 02:55 PM

    Hi,

    According to your senario, i guess at the time of message mapping you need to map it to the other output structure you want. this is a senario of n : 1 transformation of Multi -mapping. So for this, use ccBPM to complete you steps and then configure accordingly at ID.

    regards

    Aashish Sinha

    PS : Reward points if helpful

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.