topic Re: extract vendor master changes /creation in Application Development and Automation Discussions

extract vendor master changes /creation

Former Member — Mon, 14 Dec 2009 22:27:39 GMT

Hello All,

My requirement is to capture if a new vendor is created or if changes made to the Vendor master and put them in a flat file and send it to the application server .So that the 3rd party system can update these changes in their system to keep both the system in sync . They dont want it to be a idoc ( using change pointer concept ) .

I would like to know the efficient of solivng this problem . If i write a report , how to approach fetching hte datas ?

Thanks,

Riya.

Re: extract vendor master changes /creation

Former Member — Mon, 14 Dec 2009 22:33:56 GMT

If you want to send it in mass, then write a program which will select the list of vendors updated based on the changed date and run the report in background. If there are entries then only send the data to applicaton server else not required.

Regards

Shiva

Re: extract vendor master changes /creation

Former Member — Mon, 14 Dec 2009 22:37:59 GMT

Let me mak it more clear ,

I have to send the values of the changed field in case of changes and in case of new vendor creation i have to send the values of all the fields along with the field name in the flat file . so that their 3rd party system can update the same changes in their vendor master records as well.

Please help me

Re: extract vendor master changes /creation

Former Member — Mon, 14 Dec 2009 23:10:33 GMT

If the vendor is created today then send all the details else

You can check the CDHDR and CDPOS table for the changes related to particular vendor.

It will impact the performance.

Regards

Shiva

Re: extract vendor master changes /creation

Former Member — Mon, 14 Dec 2009 23:46:40 GMT

It will become a performance issue of reading CDHDR & CDPOS table.

so i just wantto know if there is an alternate way to do it.

Pls suggest me a solution!

Re: extract vendor master changes /creation

Former Member — Tue, 15 Dec 2009 03:13:27 GMT

Can please some one give some valuable inputs to solve this....

Re: extract vendor master changes /creation

Former Member — Tue, 15 Dec 2009 03:23:09 GMT

Any valuable inputs will be greatly appreciate! badly in need of help.

Edited by: RiyaPreet on Dec 15, 2009 4:23 AM

Re: extract vendor master changes /creation

Former Member — Tue, 15 Dec 2009 14:10:11 GMT

Hi,

Alternative solution will be send all the data including the changed for the day also. The third party also can copy the same and change.

Regards

Shiva

Re: extract vendor master changes /creation

Former Member — Tue, 15 Dec 2009 14:13:01 GMT

is it possible for you to use ALE Master Data distribution via a model?