Skip to Content

Z abap report for Basis daily check


I want to share a Z Report that maybe could help some Basis Administrators who need to make a daily checklist on the system.

First of all, I know that there is specific SAP ways to do that, like SSAA, CCMS, Solution Manager, and so on.

But in our case, and maybe other Basis analysts cases, we don´t have a Solution Manager configurated in all customers, and we need to check every landscape status through a checklist, opening some transactions one by one. that takes some time, time that can be usefull in something else.

So, basically, this report prints some of the principle Basis transactions (sm66, sm51, sm37, tablespaces status, st22, dbachecks) in only one page.

In my case, at least, saving some time everyday.

This Report is only usefull with Oracle Databases.






Richard W. L. Brehmer

You must be Logged on to comment or reply to a post.
    • Hello Sadiq!

      I guess to use this on DB2, you have to make some changes on the “SELECTs” statements on the Oracle´s block in the Report.

      Sorry, but unfortunately I don´t have a system on DB2 to develop those changes. If you have some ABAP skills you can try do it yourself.

      Thak you for the comment.


      Richard W. L. Brehmer

      • Hi Richard,

        thank you for the report. the database check returns value as below. does it mean something is wrong? DB is oracle.

        Database Check: 24.09.2015 20150924%

          Level    Date           Time      Type   Name                   Description

          Nenhuma informação, verifique o JOB CHECKORACLE.



        • Hello Ranjith,

          Sorry, the message is in portuguese. It means that no information was found.

          So you should verify if the Job CheckDB was completed, if yes, then your database is ok, without any alert.

          Verify the job CheckDB in DB13:


          Richard Brehmer

          • Easy, just edit this report through se38, and change the below text in the line 107. Save and active.

            The text could be: “There is no information, verify the job CheckDB”.

            Any problems, tell me.

            In ABAP, it´s not the “right way” to do that, the correct way would be making this report multilangage,maybe some abapers would not like what im doing here, but my focus it´s on the Netweaver administration.