topic Re: Creating multiple integration models in CFM1 in Application Development and Automation Discussions

Creating multiple integration models in CFM1

Former Member — Fri, 18 Jan 2013 10:00:57 GMT

Hello Experts,

I have the following requirement:

When we create an integration model in CFM1, if the number of materials selected is greater than a certain number (say 1000), then the materials from 1001th should be included in 2nd integration model, then 2001th material in 3rd Integration model so as to avoid transfer of bulk of materials from single intergration model and so on..

So, my check will be to call CFM1, first calculate how many material it picks and then split that array into chunks of 1000 (for e.g), then call CFM1 in loop giving input of the materials in chunks of 1000.

Logical system and APO application name remains same for all. I need give a subsequent model name like Mat1, Mat2 ...

Kindly guide me to achieve this technically.

Regards,

Richa

Re: Creating multiple integration models in CFM1

Former Member — Fri, 18 Jan 2013 14:51:31 GMT

Hi Richa ,

For CFM1 tcode .... Before calling this transaction code .... first check for the no. of value's it fetches from the database table .... all those value will be there in an internal table ..... then read that internal table on the basis of packet size defined say as in ur e.g 1000 and put it in an another internal table and set the flag index as well then call the t_code CFM1 to transfer those data.

when it will come for the next lot of data (1001 to 2000) before this refresh that internal table ....

then it will send only 1000 materials in a single integration model and so on as it's execution proceeds.

Put these all in an condition for subsequent model name.

whenever model name change it will send only 1000 records after that.

Hope this will help ...

Re: Creating multiple integration models in CFM1

Former Member — Mon, 21 Jan 2013 05:43:58 GMT

Dear Amit,

Thanks for your reply.

The records in an internal table are fetched after calling CFM1. So, where do i calculate the number of materials i have fetched.

And, if i keep calling CFM1 in loop, it will repeat the whole process again and start from the first material.

Kindly provide your views on this.

Regards,

Richa

Re: Creating multiple integration models in CFM1

Former Member — Mon, 21 Jan 2013 09:29:02 GMT

Hi Richa ,

Thanks for your valuable update on this issue .....

If after calling the CFM1 it is fetching the data from the database table and filling the internal table1 say.

Then u can do one thing ....

Check after internal table1 is filled with whole data.

on the basis of packet size (in ur case will be 1000) move those value into an another internal table2 and transfer those values.

set the flag value 1 after this transfer happens.

Then refresh internal table2.

Then it will take another 1000 data from internal table1in the second lot move those values to internal table2 and increase the value of flag by one for every subsequent 1000 data.

Put the condition on flag that if flag value is increased then it should call the CFM2 and transfer.

And so on .....

Hope this will help ....

Re: Creating multiple integration models in CFM1

Former Member — Wed, 30 Jan 2013 17:54:40 GMT

Hey Richa

You can use some election option such as Plants, MRP controller, ABC Indicator, LCC and create Imodels based on those selection, which will help to maintain keep integration model specific to plants and whcih is more easy way to maintain it and also it will have less amount of data, but yes number of Imodels will increase.

Let me know if you have any questions.

Regards

Ankur