Change hardcoded account values..Help

[Former Member]

Hi All,

I have a report which uses GL account value in hard-coded form as:

IF P_RVLTBL = 'X'.
    SELECT * FROM T030H WHERE KTOPL = 'CAWW'
  RANGE_HKONT-OPTION = 'EQ'.
      RANGE_HKONT-SIGN = 'I'.
      RANGE_HKONT-LOW = T030H-HKONT.
      APPEND RANGE_HKONT.
    ENDSELECT.
    RANGE_HKONT-OPTION = 'BT'.
    RANGE_HKONT-SIGN = 'I'.
    RANGE_HKONT-LOW = '0000100000'.
    RANGE_HKONT-HIGH = '0000100999'.
    APPEND RANGE_HKONT.
    RANGE_HKONT-OPTION = 'BT'.
    RANGE_HKONT-SIGN = 'I'.
    RANGE_HKONT-LOW = '0000104100'.
    RANGE_HKONT-HIGH = '0000104301'.
    APPEND RANGE_HKONT.
  ELSE.
    RANGE_HKONT[] = S_HKONT[].
  ENDIF.

I need to change it to a set and update as when desired.

I don't understand what does the set here mean?

Create a set with SETNAME: ZCASH_EXPOSURE_ACCTS.

Instead of hardcoding users can change it.

Note: HKONT is a selection screen input field.

Thanks.

Edited by: Mishra.Manas on Feb 24, 2010 10:21 AM

Edited by: Mishra.Manas on Feb 24, 2010 10:27 AM

[RaymondGiuseppi]

Use transaction GS01 to create a SET.

Regards,

Raymond

[Former Member]

Thanks Raymond...

Please let me know the process to create a set for my above requirement...

Thanks in advance.

Edited by: Mishra.Manas on Feb 24, 2010 10:43 AM

[RaymondGiuseppi]

- Read [Set Creation |http://help.sap.com/saphelp_40b/helpdata/EN/5b/d2297e43c611d182b30000e829fbfe/content.htm] - Transaction GS01 - use the Z-name and select table BSEG field HKONT - create hierarchy with the ranges of your actual program (individual values and ranges)

- In your report/program provide an input field for the set name. Check if the set provided is correct via FM [G_SET_GET_INFO|http://forums.sdn.sap.com/search.jspa?objID=c42&q=G_SET_GET_INFO] (0000, Z-name -> check INFO-TABNAME and -FLD), get the values to be mapped to an internal RANGE of account number via [G_SET_TREE_IMPORT|http://forums.sdn.sap.com/search.jspa?objID=c42&q=G_SET_TREE_IMPORT] (beware SETID = class '0000' + name 'Z-name', -> internal table SET_VALUES-FROM and -TO)

Regards,

Raymond