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.
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.
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.