on 04-06-2010 2:36 PM
Hi ALL,
Can any one help me out by sending the javacode for the below reqirement.
My sender data is coming from database.So based on 2 fields i have to spilt the idocs at target side.
my reqirement is
1)Material number and 2)Batch
Case 1: For the same material number if the batch is empty spilt it into idocs
I.e material number -
> 123
batch -
> empty
123
empty
In the above case it must be splited into 2 idocs
Case 2: For the same material number if the batch is same then spilt these data into idocs
material number -
> 123
batch -
> 11
123
11
In the above case it must be splited into 2 idocs
Case 3: For the same material number if the batch is different then combine these data into one idoc
material number -
> 123
batch -
> 11
123
12
In the above case it must be combined into 1 idoc
however if material number changes new idoc must be cretaed.
Good points will be given
Hi Abhishek/Raj,
Now the reqirement has changed.
They want it whenever the same materials appears then check the batch of both the materials and then spilt accordingly.
If batch of both repeating materials is same then spilt into different idocs.If batch of both repeating materials is different
then
example:
materials: 123
133
144
155
123
111
110
In above case from 123 to 155 it should be in one idoc.Since material is repeating(123) then check batch of both
123 materials .If they are different then whole set of materials should go into one idoc.Else materials from 123 to 155 in one idoc
and 123 ,111,110 into another idoc.
or just split the same materials with same batch into different idocs .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nagendra,
After reading all the posts above, vt i can draw the conclusion is... Thz requirement is nt possible with a single UDF..
U have to write many UDF's for different purposes...
Vt i recommend is better go for a Java mapping... In java mapping u have lot of control on data and structure.. thtz y..
Also if the functional guyz change the logic again and again... even then u can handle it well with the Java mapping.. else u need to completely create a new UDF's...
For java mapping u have lot of posts in SDN.. plz search it..
If still any confusion.. pl do post
Babu
My sender data is coming from database.So based on 2 fields i have to spilt the idocs at target side.
In the above case it must be splited into 2 idocs
I dont think IDOC allows split.......or are you referring to IDOC bundling?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Will all the Materials/Batch numbers come in sorted order? Just give the structure how the xml looks like
is it
<Material number> (0..unbounded)
<BatchNumber/> (0..unbounded)
</Material number>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
Please see the xml structure.It does not come in the sorted order
<?xml version="1.0" encoding="utf-8" ?>
- <row>
<BEGIN />
<IDOC_ID>5c6b4851bb25583baa47b0c8ff6b8ce4</IDOC_ID>
<TS>2010-03-30 15:04:52.781957</TS>
<STATE>1</STATE>
<PLANT>2401</PLANT>
<COUNTRYCODE />
<STGE_LOC>0100</STGE_LOC>
<DOC_DATE>20100330</DOC_DATE>
<MATERIAL>000000000001201501</MATERIAL>
<BATCH />
<SERIALNO>000000000000000000</SERIALNO>
<ZREASON>45</ZREASON>
<ZQUANTITY>00000000000003-</ZQUANTITY>
<ZQUAN_UNIT>STK</ZQUAN_UNIT>
<IDOC_ID>5c6b4851bb25583baa47b0c8ff6b8ce4</IDOC_ID>
</row>
- <row>
<BEGIN />
<IDOC_ID>5c6b4851bb25583baa47b0c8ff6b8ce4</IDOC_ID>
<TS>2010-03-30 15:04:52.781957</TS>
<STATE>1</STATE>
<PLANT>2401</PLANT>
<COUNTRYCODE />
<STGE_LOC>0100</STGE_LOC>
<DOC_DATE>20100330</DOC_DATE>
<MATERIAL>000000000001201501</MATERIAL>
<BATCH />
<SERIALNO>000000000000000000</SERIALNO>
<ZREASON>45</ZREASON>
<ZQUANTITY>00000000000002-</ZQUANTITY>
<ZQUAN_UNIT>STK</ZQUAN_UNIT>
<IDOC_ID>5c6b4851bb25583baa47b0c8ff6b8ce4</IDOC_ID>
</row>
> Good points will be given
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.