Change Logs – CDHDR and CDPOS

Change logs are used to track changes to master data or transaction data. Examples are Customer Master, Material Master or Sales Txns.

For example, if you change a field , say Search Term in the Customer Master, the change is logged in the tables CDHDR and CDPOS. Here is an example.

Screenshot is Copyright SAP AG

In this example, the Search Term is changed from MINERVA to MINERVA1. The fields are logged in the tables specified above. Let’s take a look at them. If you want to understand more about viewing the contents of SAP Database Tables, click on the links above.

CDHDR entryScreenshot is Copyright SAP AG

Screenshot is Copyright SAP AG

As you can see from the tables above, the basic data regarding the change is recorded in CDHDR along with a “Change Number” which will be used as the basis to search in CDPOS for the actual change.The new value and old value are specified in the CDPOS table.

Please also note that proper object class needs to be specified. In this case it is DEBI , since the object being discussed is Customer master. Also, the object ID needs to be proceeded by leading Zeros.

The practical use of this is to create custom reports/functionality based on master data change or transactional data change.  For more, please visit us at SAP SD Training. This post applies equally well to SAP CRM Training also.

Exercises :

Scenario 1 : Your Accounting User has asked for a report that requires all changes to a Customer’s Address over a particular period. This report is used to find out if there are any deliberate changes to the address and to make a decision on how the credit limits for the customers should be effected. The fields to be verified are listed below

  • Customer City.
  • Customer Country.

Question # 1 : List down the technical name and the database tables of the fields listed above.

Question # 2 : Find out changes that happened to the customer 1110 for the field “City” . List the methodology ( Tables and fields used ) you used to find this out.

Question # 5 : Write a Functional specification for a report that will provide the requirements listed in the Scenario. In the functional specification, list out the input parameters, output fields and the processing logic.

Advertisements

One thought on “Change Logs – CDHDR and CDPOS

  1. serving simply bamboo says:

    Right here is the perfect site for everyone who would like to understand
    this topic. You realize a whole lot its almost hard
    to argue with you (not that I really will need to…HaHa).
    You certainly put a brand new spin on a topic which has been discussed for years.
    Wonderful stuff, just great!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s