Finding any of the SAP tables that have been changed

Edit, create, delete or adjust your database table

A D V E R T I S E M E N T

The database ustility is the interface between the ABAP Dictionary and the relational database  underlying the R/3 System.

This tools allows you to delete all the data in the tables.

You can call the database utility from the initial screen of the ABAP Dictionary with

Utilities -> Database utility (Transaction SE14). 

You can use the database utility to edit all the database objects that are generated from objects of the ABAP Dictionary.

These are database tables that are generated from transparent tables or physical table pools or table clusters, indexes, database views and matchcode pooled tables or matchcode views.

If you want to use the database utility, you need authorization for authorization object

S_DDIC_OBJ, e. g. S_DDIC_ALL.

During the production run of the SAP system, additional fields might have been added and you might have lost tracks of the SAP tables changes.

Transaction Code SPDD have been created to help you to find all the SAP tables that have been modified.

Other ABAP Dictionary objects such as lock objects, matchcodes, and views, for which modification would not result in data loss, are not processed during the upgrade with transaction SPDD, but only after the upgrade is complete with transaction SPAU.

Welcome to Sap Learning dot com ! This is your very first post. Click the Edit link to modify or delete it, or start a new post. If you like, use this post to tell readers why you started this blog and what you plan to do with it.

Happy blogging!