Quick update on Tables.ofSAP.com




List of all SAP tables by category

After categorizing all SAP Tcodes by modules at http://tcodes.ofsap.com (that I’ve explained on previous post), I’ve also updated another section of ofSAP.com at http://tables.ofsap.com.

At that section, I have categorized the SAP tables whether they are:

  • Transparent table.
    From SAP help: There is a physical table on the database for each transparent table. The names of the physical table and the logical table definition in the ABAP/4 Dictionary agree. All the business and application data is stored in transparent tables.
  • Structure.
    From SAP help: No data records exist on the database for a structure. Structures are used for the interface definition between programs or between screens and programs.
  • Cluster table.
    From SAP help: Cluster tables contain continuous text, for example documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table category. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least part of the keys must agree. Several cluster tables are stored in one corresponding table on the database.
  • Pooled table.
    From SAP help: Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored.
  • General view structure.
    From SAP help: A structure is generated for a view during activation. This structure is used as the interface for the runtime environment. It is not usually displayed in the ABAP Dictionary.
  • Append structure.
    From SAP help: An Append structure defines a subset of fields which belong to another table or structure but which are treated as a separate object in the correction management. Append structures are used to support modifications.
You can search SAP tables based on their table name, description, and category.

Among 297,231 tables I’ve listed there; 67,639 of them are Transparent table; 184,224 are structure; 62 are Cluster table; 2,027 are Pooled table; 41,152 are General view structure; and 2,127 are Append structure.

On the search result page, you can click the table name to go to the table detail page. On the table detail page, there are some other information such as: delivery class, maintenance status, view type and user-generated information and links of the table.

You can also submit new user-generated contents there, such as additional information about the table (explanation of the use of the table, relationship with other tables, some important fields of the table, etc), and links to other website that related to the table.

By submitting additional information or links, you can help other visitors who might need that kind of information.

 


5 thoughts on “Quick update on Tables.ofSAP.com

  1. Hi,

    You can indeed search SAP tables with SE11 tcode, or you can download all SAP tables with SE16 tcode (input DD02L in table field). But, there is no additional information about those tables in SAP. I think, the idea of the http://tables.ofsap.com is to encourage people to share any information about certain SAP tables he/she mastered.

    With SE93 (or SEARCH_SAP_MENU) tcodes, you can't find SAP tcodes based on its module.
    And then, I think, the idea of the http://tcodes.ofsap.com is also to encourage people to share any information about certain SAP tcodes he/she mastered.

Leave a Reply to Sap Online Training Cancel reply

Your email address will not be published. Required fields are marked *