‎2007 Aug 17 10:24 AM
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
‎2007 Aug 17 3:44 PM
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
‎2007 Aug 17 11:52 AM
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
‎2007 Aug 17 3:44 PM
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
‎2007 Aug 18 2:57 AM
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