Use This Utility to Find Enhanced ABAP Dictionary Tables and Structures

  • by Qazi Wasif Ali, SAP ABAP Consultant, Descon Engineering Limited
  • December 5, 2013
Use ABAP code to find all the ABAP Dictionary tables and structures that have been enhanced in your SAP system in bulk. This function is not currently available in the SAP standard system. With this ABAP code, you’ll be able to see multiple enhanced ABAP Dictionary tables or structures at a time instead of entering every ABAP Dictionary table or structure name one-by-one and then checking to see if it has been enhanced. This does not require any third-party tool.
Key Concept

Dictionary tables contain transactional data and master data from different areas of the SAP system. Every dictionary structure contains components that are also called fields. Every component has a type associated with it. This type can refer to some data element or directly use some data type and length or some other structure or table type.  Dictionary structures are used in programs and on screen fields for creating field characteristics identical to the dictionary structure. Structures can be used to define data at the interface of module pools and screens and to define parameter types of function modules. ABAP programs and screens use structures. A flat structure only references elementary types. A nested structure references at least one further structure, but not a table type. A deep structure references at least one table type.

ABAP programmers often need to know which ABAP Dictionary tables and structures have been enhanced in the SAP system using an append structure or a customizing include (CI include). In transaction code SE11 or anywhere else in the standard SAP system, there is no option available for simultaneously checking multiple ABAP Dictionary tables or structures to see if they have been enhanced. Now, I take you through two examples of situations in which you need to know which tables are enhanced.

  • Suppose there is one transaction code for purchase order creation with the name ME21N and the requirement is to add four fields in this transaction code at the header level. You first need to find an enhancement and see if that enhancement has provided a CI include. As I explain later in this article there is one CI include for the purchase order main table EKKO with the name CI_EKKODB. You now need to do two things. Initially you check in your system to see if this CI include has already been created. If yes, then add these four fields in it, and if not, then you need to create it from scratch and add these fields. You follow the same process for finding any other CI include. The only difference is the name of the transaction code.  
  • Suppose you want to enhance the material master transaction code MM01. The requirement is to add some additional fields in the basic data 1 tab of this transaction. In this case you have no CI include, so all you need to do is to create an append structure for the material master main table MARA. After adding the fields you can use them on your screen and the screen fields values are saved into the material master main table. Here you need to check any custom append structure that exists for material master table MARA. If it exists, add fields in that. Otherwise you can create a new append structure. There are no restrictions that there should be only one custom append structure for any table.

Let’s take the ABAP Dictionary tables as an example. Say you have 20 ABAP Dictionary tables that you have enhanced, and you want to see their details. The usual process involves entering every ABAP Dictionary table and structure name individually in transaction code SE11, a repetitive, time-consuming process. I’ve developed a utility using ABAP code that allows you to see the details of all ABAP Dictionary structures and tables that have been enhanced in one effort that is completely based on the SAP system. To run it, you should have some basic knowledge of ABAP. I’ll start by showing you the process to view enhanced ABAP Dictionary structures and tables, and then I’ll show you the code involved in my process. 

Qazi Wasif Ali

Qazi Wasif Ali is an SAP ABAP certified consultant at Descon Engineering Limited in Pakistan. He has more than six years of SAP ABAP experience. He has a degree in computer science and has worked in industries such as packaging, beverages, and chemicals. Previously, he worked at Siemens Pakistan and Abacus Consulting. Qazi has also participated in support projects.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.