Search Engine for SAP Tables / Table Finder and Analysis Tool in SAP S/4HANA - SE16T

 

Transaction SE16T is a relatively new and powerful tool in SAP S/4HANA (specifically available from version 1709 onwards). It is officially called the "Table Finder and Analysis Tool."

Think of SE16T as a "Search Engine for SAP Tables." Unlike SE16N, where you must know the specific table name (like MARA or VBAK), SE16T allows you to search for a value across multiple tables at once.

 

Key Features of SE16T

1. Search Tool: Find a specific string (e.g., a Sales Order number) across an entire functional area.
2. Relation Analysis: View how different tables are technically linked (Foreign Key relationships).
3. Data Environment: See all documents related to a specific object.

 

Step-by-Step Guide to Using SE16T

1. The Entry Screen

When you execute SE16T, you are presented with several execution modes. The most commonly used is the Search Engine (Tool 01).

[ Visual Representation of Screen ]

• Command Field: SE16T
• List of Tools:
• 01 Full Text Search (Find data in tables)
• 02 Relation Analysis (Find how tables link)
• 03 Value Search (Search for a specific field value)

2. Using the Full-Text Search (Tool 01)

If you have a document number (e.g., 10004562) but you don't know if it's a Sales Order, a Delivery, or a Billing document, this is the tool to use.

Steps:

1. Double-click on Full Text Search.
2. Selection Criteria:
• Search String: Enter your value (e.g., 12345).
• Package/Functional Area: You can restrict the search to a specific package (e.g., VA for Sales) to make it faster.
• Tables: You can list specific tables or leave it blank to search all tables in that functional area.
3. Execute (F8).

[ Visual Representation of Results ] The system will scan the tables and show:

• VBAK: 1 Hit (Sales Header)
• VBAP: 5 Hits (Sales Items)
• LIKP: 1 Hit (Delivery Header)

3. Relation Analysis (Tool 02)

This is a consultant’s dream for building custom reports. If you know two tables but don't know how to "Join" them, SE16T will tell you.

Steps:

1. Select Relation Analysis.
2. Enter Table 1 (e.g., MARA) and Table 2 (e.g., MARD).
3. Execute.
4. The Output: SAP will display a graphical or list view showing that these tables are linked by the field MATNR (Material Number).

 

Why should you use SE16T?

• Troubleshooting: When you see a value on a Fiori screen and want to know exactly which database table it is stored in.
• Knowledge Gaps: When you are working in a new module (e.g., EWM or TM) and don't know the table names yet.
• Data Consistency: Checking if a deleted record still has "ghost" entries in related tables.