T-code SE11 and SE16 was here for ages within every SAP Basis/NetWeaver/ABAP Platform based SAP system. The very basics function of the SE16 was to browse for the data in the tables, views. With an SAP S4/HANA system there were a new t-codes delivered related to data browser.
SE16*
SE16T – Umbrella t-code from where the others can be ran.
SE16N – Comprehensive version of SE16, enables selection criteria to be specified immediately upon request, output is in the ALV Grid, etc. In a nutshell more convenient for the user.
SE16N_EMERGENCY – Allows editing data in the tables.
SE16H - HANA DB optimized table display and analysis. Has more less same features as the SE16N t-code. Enables analysis on how table entries are distributed across specific fields.
SE16J – Dedicated SE16* t-code for table joins. Allow making a database joins (query data with joins).
SE16S - Generic table and value search. E.g. in case a search in DB tables needs to be performed on multiple tables.
SE16S_CUST – Allows to setup predefined searches for t-code SE16S.
SE16SL - Searching content.
Side note: SE16S and SE16SL can be used to find any values in any tables. Difference between them is how the selection is done. A search term is sought in all tables in SE16S, the search in SE16SL is limited to the found tables that match the entered field description. That makes SE16SL is theoretically faster.
TAANA - Detailed table analysis for functional tables. Covers scenarios like: record count, record distribution per time period (e.g. year), company code, plant, document type, any other business related objects.
KOBJ - used to search for any objects in any tables.
KTABL - i used to search for tables and table names.
KTRAN - used to search for transactions.
More information:
1636416 - CO-OM tools: Functions of transaction SE16H
3529563 - Functions of transaction SE16J
2002588 - CO-OM Tools: Documentation for SE16S, SE16SL, and SE16S_CUST
No comments:
Post a Comment