topic Re: Function module to fetch data from table SETLEAVES in Application Development and Automation Discussions

Function module to fetch data from table SETLEAVES

Former Member — Wed, 26 Sep 2007 14:47:07 GMT

Hi All,

We have a requirement to fetch the data from table SETLEAVES based on the setclass,subclass and group. As the table holds hierarchical data, Please let me know a FM which fetches all the hierarchical data from the table SETLEAVES.

Regards

Shiva

Re: Function module to fetch data from table SETLEAVES

Former Member — Wed, 26 Sep 2007 14:47:42 GMT

Hi,

Sorry the table name is SETLEAF

Re: Function module to fetch data from table SETLEAVES

Former Member — Wed, 26 Sep 2007 14:53:29 GMT

I think FM K_HIERARCHY_TABLES_READ.

rob

Re: Function module to fetch data from table SETLEAVES

Former Member — Wed, 26 Sep 2007 14:55:59 GMT

use the fun module

<b>G_SET_TREE_IMPORT</b>

pass the class and subclass to set id correctly depending on PC's or CC's or CE's

concatenate the Class, Subclass and Cost center(CE or PC )Group together and pass to SETID.

or use the tables SETNODE and SETLEAF in the recursive select statement

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Message was edited by:

Anji Reddy Vangala

Re: Function module to fetch data from table SETLEAVES

Former Member — Wed, 26 Sep 2007 14:56:25 GMT

Hi,

Could you let me know the data to be passed.

I have the following data:

Group

Setclass

Subclass as input.

No other fields are avaible for me

Regards

Shiva

Re: Function module to fetch data from table SETLEAVES

Former Member — Wed, 26 Sep 2007 15:00:50 GMT

Try:

    exporting
      e_class                     = '0102'
      e_setid                     = setid
      e_kokrs                     = my_kokrs
      e_mandt                     = sy-mandt
      e_master_data               = 'XXX'
      e_structure                 = 'X  X0200'
      e_replace_class             = space
      e_replace_unit              = space
      e_suffix                    = space
      e_old_line_level            = 1  "l_ol_level
    tables
      t_nodes                     = it_ceg_nodes
      t_values                    = it_ceg_values
    changing
      c_info                      = c_info
      c_overwrite                 = c_overwrite
    exceptions
      no_controlling_area         = 1
      no_chart_of_account         = 2
      different_controlling_areas = 3
      different_chart_of_accounts = 4
      set_not_found               = 5
      illegal_field_replacement   = 6
      illegal_table_replacement   = 7
      fm_raise                    = 8
      convert_error               = 9
      no_overwrite_standard_hier  = 10
      no_bukrs_for_kokrs          = 11
      others                      = 12.

Rob