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.

One-stop SAP Reference & Collaboration: All SAP Transaction Codes (Tcodes) Detail

Have you ever found difficulties in remembering or searching a certain SAP transaction code (tcode)? With so many tcodes available in SAP, I bet you have.

There are more than 100,000 tcodes in SAP. It’s impossible for someone to know them all.

SAP has a tcode to search tcodes based on the text of tcode’s name or menu path. The tcode is ‘SEARCH_SAP_MENU‘. But, the search criteria is not flexible, and the search result is not user-friendly presented. It’s much worse if you forget the ‘SEARCH_SAP_MENU’ tcode’s name itself, or if you don’t have the authorization to run that tcode.

Continue reading