ABAPer's Tabloscope-The SAP Table Relationships & Fields Explorer

[Former Member]

Please find the source code  and the user manual (with links to download) below.

Note:

Check this document regularly for latest version source code as the functionality of this tool is being improved further.

___________________________________________________________________________________________

SAP is like an ocean and often an ABAP consultant looses much of the time in finding relationships among tables and searching for fields, which causes unnecessary delays. Even SAP quick viewer and other SAP standard search methods doesn't provide one with accurate results always and many times they propose very large result set, most of which are irrelevant solutions for the queried scenario. Some problems, an ABAP consultant would usually encounter are:

For example:

•  To search for direct relationships between tables 'EBAN' and 'T16FS', the easy method is to go for SAP Quick Viewer (SQVI). But SQVI shows relationships only if the field names, data elements or domains match. So, in this case it shows only one relationship i.e, between FRGGR fields of both the tables but it doesn't show relationship between fields FRGST and FRGSX of tables EBAN and T16FS respectively which can also be related, as both are ' Release strategies'.

 

•  To search for indirect relationships (link tables) between two tables in the absence of direct relationships.For example, there are no direct relationships between tables 'VBAK' and 'EKKO' and there is no standard method or tool to find indirect relationships i.e., link tables between them than manually checking, which is cumbersome.

 

•  To search for the field with description 'Bill-to party', one usually goes for 'SE80' which is a case-sensitive search. That is, it would show only those fields with the given description in lower case alphabets when the search term is typed as 'bill-to party'. And most of the times a consultant would be aware of the field description but not the cases of alphabets in field description.

 

•  And moreover, with the usual standard methods an ABAPer uses, the result set would be huge with all SAP tables in which the relevant solutions for our scenario  is somewhere in the remote corner. It's like searching for 'Titanic' in Atlantic ocean. It would be more easy to search for 'Titanic' if the Atlantic would be of the size of Lake Superior. I.e., It would make the job of an ABAP consultant more easier if the search  can be carried out separately in each module or application area instead of all SAP.

           I developed a tool (overcoming all these limitations and adding somemore useful features) which I named as 'ABAPer's Tabloscope' can be a very useful assistant especially for an ABAP consultant.

                               USER MANUAL

This is cover page, click on any of the links below to download/view complete user manual:

Tabloscope-User Manual.pptx - Google Drive (PPT)

Tabloscope-User Manual.pdf   - Google Drive (PDF)

Source Code