Skip to Content
author's profile photo Former Member
Former Member

Customer changes log

Hi

We are implementing a CRM system, and need to extract customer details held in SAP. An Abap Program has been written to extract all of the information that we need.

We anticipate that after the full extract we will need to extract those customers whose details were created or changed after the initial extract. Transaction OV51 will display the changes to the customer. These changes are held in tables CDHDR and CDPOS.

But I cannot find a link between the customer number KNA1-KUNNR, and CDHDR.

Any ideas?

Regards Nigel

This discussion was first posted incorrectly in the wrong forum. Mike Lindquist responded that CDHDR contained the Customer number in the CDHDR-OBJECTID field. this does not hold true all of the time.

I made two changes to customer 270 (in devl) the address and the phone number. One of those has listed the customer number in Objectid, the other has not.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 23, 2013 at 06:55 PM

    You might want to start a SQL trace (ST05) and then view changes for a customer. It should show how exactly the change documents are accessed.

    Also as a side note - SAP has an option to distribute master data changes via change pointers and IDocs.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 19, 2013 at 11:46 PM

    Addresses are an extra object, a central object used cross applications. the link is via the address number field which can be found in KNA1 table

    Add a comment
    10|10000 characters needed characters exceeded

    • Agree with Jurgen comments.

      Apart from that hope you are aware that any changes made to customer address in Sales Doc will not have any effect on Customer Master(KNA1). Any change in customer address will have separate address number which you can track in table ADRC. In addition to that any change made in sales doc header and item are recorded on Tables CDHDR and CDPOS, respectively.

      If you like to know, how you can fetch customer address change made in transaction can be fetch, please refer my response in following existing SCN thread:

      - Ship to party address details from transactions


      Thanks, JP

  • Posted on Dec 23, 2013 at 08:52 PM

    the BP is the address group, it stands for business partner and is used for vendors too.

    Use SE16 and press F4 at Address group to see all possible variations.

    For change documents SAP does it this way in LSZA0F4:

    MOVE address_group TO objectid.

    MOVE address_number TO objectid+4.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.