topic Re: change_pointer_read issue in Application Development and Automation Discussions

change_pointer_read issue

Former Member — Wed, 12 Apr 2006 15:12:45 GMT

Hello Gurus,

I am facing a problem with change_pointer_read function module. i am not using idocs but using this function module to select all the changes and then i send the data using flat file transfer. now this worked ok in development and testing environment but it is taking lot of time to read change pointers in preproduction environment. there are 187 million entries in bdcp table in that environment. it took almost 45 min to read change pointers for matmas...i am supplying parameters like message type , object class, not processed pointers (yes),

and time frame ( creation date - high low and creation time high low)...am i doing any mistake? now sap processes the pointers once it creates the idocs and the parameter supplied to this FM are only message type and read not processed pointers (yes)...here i am not processing change pointers ( because we are in shared environment) but reading for a time frame ( from date/time to date/time)...even if i process my pointers and keep on reading not processed pointers then i will also be reading pointers for other projects for previous period thats why i dont want to process, but instead i read for a time frame

please suggest...

thanks

Re: change_pointer_read issue

christian_wohlfahrt — Thu, 13 Apr 2006 11:05:19 GMT

Hi!

In general: you have too much pointers in the system. Plan regularly the report of transaction BD22 delete unecessary pointers (older than 1-2 weeks and marked as 'processed').

To your task: create an own message type, assign (just) the fields you are interested in. Then you can mark the pointers after file creation as 'processed' (-> no one else is using this message type) and you will get only exactly the relevant pointers by only reading 'not processed' pointers (without additional time-frame selection). This is even easier, you don't have to struggle to select correct time-frame since last interface run.

Back to general: check, if some messages are not marked 'processed' at all -> probably no process is using these pointers any longer and they can be deactivated / deleted with option 'obsolete' in BD22.

Regards,

Christian

Re: change_pointer_read issue

Former Member — Thu, 13 Apr 2006 20:18:43 GMT

Christian,

You rock ! perfect ! I have not implemented this solutions yet but sounds perfect to me. Now I am sending material master, BOM, Routing and classification in this interface. So i am planning to group all the tables and fields under new message type and then read pointers at once and then analyze them based on the table names. But here is my question, how do i get the functionality of CLFMAS ( classification ) in this custom message ? becuase i am surprised to see no field under CLFMAS in BD52 and it still write change pointer entries...how do i make SAP behave the same way for my custom message...and one more question is if i just create a new msg type in we81 and add it in BD50 / BD52...is this much config sufficient?...i think i dont have to link it in we82 as i am not using idocs...

your help is highly appreciated.

thanks a lot

Re: change_pointer_read issue

christian_wohlfahrt — Mon, 17 Apr 2006 16:56:30 GMT

Hi!

WE81, BD50, BD52 should be enough, no IDOC link is necessary (this you do 'hardcoded' in your program...). Just make a test and look with SE16, if you get some new pointers after a change.

For CLFMAS, it's a different story. SAP made some hardcoding here (maybe classification isn't so easy linked to tables with change documents). Have a look at this , here the question was already discussed.

I hope you will get a MUCH faster solution!

Regards,

Christian

Re: change_pointer_read issue

Former Member — Wed, 24 May 2006 20:43:39 GMT

Hello,

Ninad Are you working in sap?

Re: change_pointer_read issue

Former Member — Thu, 01 Jun 2006 18:10:37 GMT

Christian

Maybe you can help me with this ....I have created a ZDEBMAS msg type and included a limited number of customer tables ( under class DEBI ) and want to track changes only to those customer master fields. I have made entries for ZDEBMAS in BD50, BD52 and WE81 ( I am not interested in using IDOCs ) . When I change customers, the change ptr objects get generated for ZDEBMAs. But when I create customers , I do not see change ptr objects for ZDEBMAS. Would you know if I am missing anything else ? ( The CD docs are generated for the customer create action and the change pointer objects do get generated for DEBMAS msg type )

Please help !!!

Re: change_pointer_read issue

Former Member — Thu, 01 Jun 2006 19:00:23 GMT

Hi karthik,

In creation mode, SAP does not necessarily write the change pointers for all the fields. It actually inserts a key record in a table with fieldname as KEY. So try to incorporate key fields for customer master tables in addition to the other fields that you have used. This should be helpful in identifying when customer is created and when a customer changes SAP wont make any changes to KEY fields but then you will have a change pointer written for other fields. So you are all covered.

Christian: I forgot to say thank you to you. Thanks a lot for your answer was really helpful in solving my issue.

cheers,

Ninad.

Re: change_pointer_read issue

Former Member — Thu, 01 Jun 2006 21:14:49 GMT

Ninad

Thanks a lot for that tip... that worked !!!I really appreciate your timely response

Karthik