topic Re: Usage and functionality of SETLEAF and SETNODE tables in Application Development and Automation Discussions

Usage and functionality of SETLEAF and SETNODE tables

Barada_Swain — Fri, 17 Aug 2007 09:24:26 GMT

Hi All,

Can somebody explain me or provide any link for the usage and functionality of SETLEAF and SETNODE tables. I am analysing a program which uses these but I am unable to determine its exact use.

Thank You

Barada

Re: Usage and functionality of SETLEAF and SETNODE tables

Former Member — Fri, 17 Aug 2007 10:52:42 GMT

Hi frend,

Even i have not come to know about this but i have heard about it in the report for tree format or hierarchy report generally used for alv reports where main node is created using 'setnode' and its subnodes are created using 'setleaf'.

U may get the best example for this in program for tcode se80.

Regards,

Ameet

Re: Usage and functionality of SETLEAF and SETNODE tables

Former Member — Fri, 17 Aug 2007 14:44:07 GMT

Hi,

Go through this hope u can get anything/something/nothing.

SAP Maintains Three Tables for Groups in Standard Hirarchy. They are,

SETHEADER,SETNODE and SETLEAF. SETHEADER holds the Top Nodes of the Groups

with SETTYPE either as S or B. If SETTYPE is S, that is indicating that Top

Node has Sub Groups. Then take the SETNAME from SETHEADER and filter SETNODE

Table with SETNAME. Before that there are so many different Groups such as

Cost Cetner Group, Cost Element Group, Profit Center Group etc., Each and

every Group is identified with Unique Code in Field SETCLASS (eg:- 0106 for

Profit Center, 0101 for Cost Center and 0102 for Cost element Groups etc.,).

If the SETTYPE in B, Then the TOP NODE reached the Last Sub Group and with

that SETNAME filter SETLEAF WITH SETCLASS, SUBCLASS AND SETNAME.

You can program using Logic or You can use the Standard Function Modules.

search for Standard function Modules in SE37 with Search Criteria

GRPGETLIST.

Reward points if helpful.

Thanks

Naveen khan

Re: Usage and functionality of SETLEAF and SETNODE tables

Former Member — Sat, 18 Aug 2007 01:57:37 GMT

These tables store data for SETS created / maintained using GS01, GS02, GS03 transactions (and lots of others) and used extensively in the FI/CO modules. Used for Cost Centre groups, Internal Order Groups, etc.

Take a look at program RGSEX001 for a simple program using function modules to read and display set data.

Andrew