How to use the FM G_SET_GET_ALL_VALUES in the ALV report

[manorama_b]

what to pass to set_values in Function module ? how to write alv report and how to use above function module in it to populate gl account in the created SET(ZHRA_GL)

[shantraj]

Please check the below link, it may help you.

Using G_SET_GET_ALL_VALUES Method | SAP Community

[raymond_giuseppi]

This FM will return the values of a set of data. (in your case a list of GL accounts)

What's your exact requirement

• Selecting some documents with a G/L account in a parameter set
• Displaying those in hierarchy mode?)

Hints:

• First call G_SET_GET_ID_FROM_NAME to get the set number from its name (check GS03 transaction)
• Class field for GL account group is 0109
• Don't hesitate to perform some tests with SE37 and where-used search

[manorama_b]

i want to populate G/L account from set ZHRA_GL and input should be

and output should be in below format and tables are faglflext skat and set name is zhra_gl

[raymond_giuseppi]

Steps to perform

• Check set definition (GS03)
• First call G_SET_GET_ID_FROM_NAME with set name (SHORTNAME = 'ZHRA_GL') and table name (TABNAME = 'GLT0') to get SETNR
• Then call G_SET_GET_ALL_VALUES with this id (SETNR) and get list of account in SET_VALUES
• Build a range (select-options) from this table SET_VALUES or use it in a FOR ALL ENTRIES
• Use this range in your SELECT to build the ALV displayed table