How to download list of transaction from SAP area menu in SAP1 transaction

[thanga_prakash]

Hello All,

My requirement is I want to download the list of transaction under the SAP area menu in SAP1 transaction.

I tried with SE43, entered area menu as S000, but it doesn't give me of the same hierarchy and some transaction were missing, for example IH08 is available in SAP1 transaction and not available in SE43.

Could you please let me know is there any way to download the list.

Regards,

Thanga

[Former Member · Accepted solution]

If you open SE43N, type SAP1 and Display (F7), Tree is shown with collapsed nodes. Print option in Menu shows the same tree as a list. The nodes do not get expanded by default.

So in order to get expanded tree in list ( so that transaction codes can be seen), you need to expand the tree before choosing Area Menu > Print.

This works for average area menu which is less number of transactions.

Since you are looking for SAP1, it has lot of transactions, and on expanding it, information message is shown as:

The tree could only be partially expanded for performance reasons
Diagnosis: The hierarchy could not be completely expanded for performance reasons; it has too many subnodes.
Procedure:
Restrict the number of nodes to be expanded by expanding a lower-level node
or
Expand this node repeatedly until this message no longer appears. The hierarchy is then completely expanded.

As a result, IH08 transaction which is under Quality Management node can't be seen in list view as overflow occurred before this node was reached.

On debugging, it can be seen that the tree is expanded recursively by standard until an overflow flag is set.

In order to get around this overflow protection, you can write a custom code.

Below snippet is for demonstration purpose.

1. Run FM BMENU_DISPLAY_RSTREE in SE37 with tree_id as QM01

2. Run my snippet that calls same FM in the end

Compare 2 outputs and see the difference.

I am going 1 level deep and IH08 transaction can be seen in output.

Similarly, you can write a code that recursively expands every sub-tree found so that entire list can be seen.

1. DATA: ls_nodes  TYPE hier_iface,
2.       lt_nodes  TYPE STANDARD TABLE OF hier_iface,
3.       lt_nodes1 TYPE STANDARD TABLE OF hier_iface,
4.       lt_nodes2 TYPE STANDARD TABLE OF hier_iface,
5.       lt_refs1  TYPE STANDARD TABLE OF hier_ref,
6.       lt_refs2  TYPE STANDARD TABLE OF hier_ref,
7.       lt_text1  TYPE STANDARD TABLE OF hier_texts,
8.       lt_text2  TYPE STANDARD TABLE OF hier_texts,
9.       lv_tree_id TYPE hier_guid VALUE 'QM01'.
10. * read top level node
11. CALL FUNCTION 'STREE_HIERARCHY_READ'
12.   EXPORTING
13.     structure_id       = lv_tree_id
14.     read_also_texts    = abap_true
15.   TABLES
16.     list_of_nodes      = lt_nodes
17.     list_of_references = lt_refs2
18.     list_of_texts      = lt_text2.
19. * read hierarchies of sub-trees
20. lt_nodes2 = lt_nodes.
21. LOOP AT lt_nodes INTO ls_nodes WHERE node_type EQ 'AMRF'.
22.   CLEAR: lt_nodes1, lt_refs1, lt_text1.
23.   CALL FUNCTION 'STREE_HIERARCHY_READ'
24.     EXPORTING
25.       structure_id       = ls_nodes-reftree_id
26.       read_also_texts    = abap_true
27.     TABLES
28.       list_of_nodes      = lt_nodes1
29.       list_of_references = lt_refs1
30.       list_of_texts      = lt_text1.
31. * add sub-tree details to main tree
32.   APPEND LINES OF lt_nodes1 TO lt_nodes2.
33.   APPEND LINES OF lt_refs1 TO lt_refs2.
34.   APPEND LINES OF lt_text1 TO lt_text2.
35. ENDLOOP.
37. CALL FUNCTION 'BMENU_DISPLAY_RSTREE'
38.   EXPORTING
39.     tree_id       = lv_tree_id    " Unique ID - 32 Characters
40.   TABLES
41.     list_of_nodes = lt_nodes2    " Hierarchy Maintenance Tool Node Passing Interface
42.     list_of_refs  = lt_refs2     " List of References to Structure Items
43.     list_of_texts = lt_text2.    " General Structure Repository Node Text

/.

[thanga_prakash · Accepted solution]

Hello Manish,

Thanks a lot for your inputs. it helped me a lot really.

Regards,

Thanga

[Former Member]

Hi Thanga,

You need to explore on it. The following tables are involved - TTREE, TMENU01, TMENU01T, TMENU01R.  From table TMENU01, you will get all the nodes based on ID 'SAP1'. TMENU01T contains the description of the nodes. TMENU01R contains the tcode information, pass the node information to get the tcodes. You need to do recursive search based on the tree nodes. Also you will find a reference_node field in TMENU01 like ECC_T. If you strip off _T and pass the ID 'ECC', again it will expand to give all the nodes under it.

This is just a pointer. I had a look at it but was not able to connect all the dots. You need to investigate further.

Regards,

DPM

[raymond_giuseppi]

Try to call SE43N and input menu SAP1 and not menu S000.

Regards,

Raymond

[Former Member]

Hi Thanga,

Can you check and try, SAP standard program SSM_LIST, which will download the Download Session Manager Menu Tables in Formatted Form.

Thanks in Advance.

Regards,

Rajesh

[thanga_prakash]

Hello Rajesh,

Thanks I have tried but it is giving all the t.codes in the system and not in the same hierarchy as in SAP1.

Regards,

Thanga

[Former Member]

Hi Thanga,

Goto SE43, provide SAP1 as area menu and click on display

Expand all the entries present in the area menu,

now goto Area Menu -> give PRINT

You get the below screen

Then goto print list -> Save to PC file. which you will able to save in Spreadsheet.

Let me know whether this helps you out.

Thanks in Advance.

Regards,

Rajesh Chowdary Velaga

[thanga_prakash]

Hello All,

Yes thanks, It works but the problem is I am not getting the t.code in SE43N, it is giving some technical name which is not t.code.

[Former Member]

Did you expand the tree before going for Print option?

[former_member206650]

Hi,

go to se16n take table TSTC ,put the filter condition and download.

hope it helps..

[thanga_prakash]

Hello Vishnu,

What is the filter condition I need to specify in TSTC ?

Regards,

Thanga

[former_member206650]

right know i don't have access to  sap ,can u try with the program name....only few parameters are there in TSTC...dig into it...the output will be a alv display there u can export to xls file.