Skip to Content
Technical Articles
Author's profile photo arghadip kar

In SAP S/4HANA You can create Change History Report in less than 15 minutes. I mean any Change History Documents

Introduction

One of the greatest Success story of SAP is the Audit Trace it has using SAP Standard Change History Object. It is used anywhere everywhere for the following

To Track whether the Company is making the best Deal
Cost Cutting on changes that is being made caught in Change History.
Automation or RPA usage for regular changes so that Human works on Important stuff
Find Process Design through history
Find place where Training is Required.

Solution

In SAP ECC as an ABAPER we always had to built a Report Joining the change History table and other tables as it was created as a Pool/Cluster table hence it could not be used in ABAP Query(SQVI)

Below is the Error message which you get when you try to add CDPOS as a Table join in SQVI

Highlight section shows CDPO is a Pool table in SAP ECC

Below is the ABAP Query Joining Codition

Below is the Selection Screen

Below is the Layout for the ABAP Query

Below is the Layout for the ABAP Query continued

Now we Execute the Report to Find the Change History on Payment Block Field(ZLSPR) and Table is BSEG

Wala here is the Output.

I am not sure about the Change Document Object. Lets check BUPA*(aka Business Partner/Vendor/Customer/Employee)

We get all the Output

Now I want check who is Changing Price in the Purchase order. If it is less great if it is more WHY 🙂

Below is the Output.

Also check the blog to generate an ABAP Report from ABAP Query

https://blogs.sap.com/2020/07/28/how-to-write-a-report-directly-in-production-and-share-it-with-use-of-sqvi/

 

Conclusion

This can be used only in SAP S/4 HANA and not SAP ECC

 

Below is the Video version

 

 

Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Farhad Farshimi
      Farhad Farshimi

      Hi,

      Are you sure this cannot be done in ECC? EHP8 on HANA server?

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      You cannot do this using SQVI. You can always write an ABAP Program for this.

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      Technically, you can use "real" query (SQ01/SQ02) and bring any table as an "additional table" in the infoset. It's not great for performance though. But (see my comment below) standard SAP transaction AUT10 exists for this purpose already, maybe give that a try.

      Author's profile photo Ramki Maley
      Ramki Maley

      Use Tcode RSSCD100 or ABAP report with the same name. It has been around for a long long time and is availabale in S/4 aswell. No custom program needed.

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Thanks for the information. In this program you cannot do multiple select like the ones business wants.

      Author's profile photo Muhammad Junaid
      Muhammad Junaid

      @arghadip Kar

      Is it a standard report in S/4 HANA 1809 which will be available through standard configuration or need to have a ABAPER?

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      If you have the Authorization you can do this pretty easy.

      Check the video version which will help you if document is a problem.

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      AUT10 (Evaluate Audit Trail) transaction existed for this in ECC and I'm pretty sure it still exists in S/4 but can't confirm at the moment.

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      I ran it and it does not give everything. Probably it has configuration associated. It would be great if you can create a Blog for that and then we will all know.

      Thanks

      Arghadip

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      "does not give everything" - meaning? What did you expect and not found there? Any specific examples?

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      I did not get all the Entries I was getting in the ABAP Query. By the way I found another tcode S_AUT10 similar to AUT10

      Author's profile photo Lakshmipathi Ganesan
      Lakshmipathi Ganesan

      In ECC, yes you cannot table join CDHDR and CDPOS but possible in S/4 Hana.  So, can you please let me know as to why you added other tables like TCDOB, DD03L etc. ?

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Hi Lakshmipati

       

      I added this to help the users so that they can query the report by table name or field name and get meaningful field description in the output also.

       

      Thanks

      Arghadip

      Author's profile photo Gaurav Chopra
      Gaurav Chopra

      Hi Arghadip,

       

      thanks . was really helpful.

      I just built this in 30 min following your blog.

       

      Regards

      Gaurav

      Author's profile photo Arghadip Kar
      Arghadip Kar

      Great news

      Author's profile photo Micheal Mathews
      Micheal Mathews

      Great work around change documents trace. Thankyou

      Author's profile photo Shasank Gupta
      Shasank Gupta

      Hi Arghadip,

      Is there a way we can convert this SAP Query into parameterised CDS View and consume in SAP ABAP report or FIORI ?