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
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
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