Monday, 17 August 2020

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

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

Highlight section shows CDPO is a Pool table in SAP ECC

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

Below is the ABAP Query Joining Codition

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

Below is the Selection Screen

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

Below is the Layout for the ABAP Query

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

Below is the Layout for the ABAP Query continued

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

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

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

Wala here is the Output.

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

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

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

We get all the Output

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

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

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

Below is the Output.

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Certifications, SAP ABAP Learning

No comments:

Post a Comment