Technical Articles
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
Conclusion
This can be used only in SAP S/4 HANA and not SAP ECC
Below is the Video version
Hi,
Are you sure this cannot be done in ECC? EHP8 on HANA server?
You cannot do this using SQVI. You can always write an ABAP Program for this.
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.
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.
Thanks for the information. In this program you cannot do multiple select like the ones business wants.
@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?
If you have the Authorization you can do this pretty easy.
Check the video version which will help you if document is a problem.
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.
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
"does not give everything" - meaning? What did you expect and not found there? Any specific examples?
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
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. ?
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
Hi Arghadip,
thanks . was really helpful.
I just built this in 30 min following your blog.
Regards
Gaurav
Great news
Great work around change documents trace. Thankyou
Hi Arghadip,
Is there a way we can convert this SAP Query into parameterised CDS View and consume in SAP ABAP report or FIORI ?