Profile Parameter (Param Name) Search help query.

[former_member699182]

Can someone tell which field of the TPFYPROPTY table has the profile parameters that comes as a search help list when the search help of the Param. Name in the Maintain Profile Parameters (RZ11)?

Thanks.

[former_member699182]

HI

that is commin from below code it is available in RZ11 program only.

SELECT * FROM TPFYPROPTY

            WHERE PARANAME LIKE DYNPFIELDS_TBL_1000-FIELDVALUE.

*-------------------------------------------------------------------

* Interne Parameter vor dem Kunden verbergen

*-------------------------------------------------------------------

     IF INTERNAL_SYSTEM = NO AND

        ( TPFYPROPTY-PARANAME(1) = '_'            OR

          TPFYPROPTY-PARANAME(6) = 'SAPARG'       OR

          TPFYPROPTY-PARANAME(3) = 'FN_'          OR

          TPFYPROPTY-PARANAME(3) = 'FT_'          OR

          TPFYPROPTY-PARANAME    = 'PHYS_MEMSIZE' OR

          TPFYPROPTY-PARANAME    = 'WP_ID'        ).

       CONTINUE.

     ENDIF.

     PARAMS-PARANAME = TPFYPROPTY-PARANAME.

     APPEND PARAMS.

   ENDSELECT.

in search help PARAM internal table is coming.

check program.

regards

laxman

[custodio_deoliveira]

TPFYPROPTY-PARANAME ?

EDIT: Sorry, didn't notice it's no search help. In fact, the values come from module SHOW_PARAMETER_NAMES of program RSPFLDOC. There's probably no search help for it, but you can create one in SE11.

regards,

Custodio

[Former Member]

HI

that is commin from below code it is available in RZ11 program only.

SELECT * FROM TPFYPROPTY

            WHERE PARANAME LIKE DYNPFIELDS_TBL_1000-FIELDVALUE.

*-------------------------------------------------------------------

* Interne Parameter vor dem Kunden verbergen

*-------------------------------------------------------------------

     IF INTERNAL_SYSTEM = NO AND

        ( TPFYPROPTY-PARANAME(1) = '_'            OR

          TPFYPROPTY-PARANAME(6) = 'SAPARG'       OR

          TPFYPROPTY-PARANAME(3) = 'FN_'          OR

          TPFYPROPTY-PARANAME(3) = 'FT_'          OR

          TPFYPROPTY-PARANAME    = 'PHYS_MEMSIZE' OR

          TPFYPROPTY-PARANAME    = 'WP_ID'        ).

       CONTINUE.

     ENDIF.

     PARAMS-PARANAME = TPFYPROPTY-PARANAME.

     APPEND PARAMS.

   ENDSELECT.

in search help PARAM internal table is coming.

check program.

regards

laxman

[former_member699182]

Thanks a lot for the help Custodio and Laxman. I had a look at RSPFLDOC and the SHOW_PARAMETER_NAMES and the get_parameter_names when used together might provide me the desired output. But there are too many links within and a few part of the code i donot understand also (like why are they doing the internal system check after select in get_parameter_names?? and a few others). Also it seems quite complicated to add inside the simple pgm of mine for just a search help.  Is there a simple way of doing it? I am right now adding only 3 fields using the below code. But I would like to add all the paramters listed in the RZ11 when you click the search help button. Any ideas?

Thanks.

**********************************************************************************

TYPES: BEGIN OF tab_param,
         Parname LIKE spfpflpar-parname,
       END OF tab_param.

DATA it TYPE TABLE OF tab_param.
DATA wa LIKE LINE OF it.

DATA: ret_value TYPE spfpflpar-pvalue.

SELECTION-SCREEN BEGIN OF BLOCK param WITH FRAME.
    PARAMETER: lv_name TYPE spfpflpar-parname DEFAULT 'rdisp/btctime'.
    PARAMETER: lv_value TYPE spfpflpar-pvalue VALUE CHECK OBLIGATORY.
SELECTION-SCREEN END OF BLOCK param.

INITIALIZATION.
   wa-parname = 'rdisp/btctime'.
   APPEND wa TO it.

   wa-parname = 'rdisp/autoabaptime'.
   APPEND wa TO it.

   wa-parname = 'login/accept_sso2_ticket'.
   APPEND wa TO it.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR lv_name.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
   EXPORTING
     retfield               = 'Parname'
     value_org              = 'S'
     DYNPPROG               = SY-REPID
     DYNPNR                 = SY-DYNNR
     DYNPROFIELD            = 'LV_NAME'
   TABLES
     value_tab              = it.

END-OF-SELECTION.

[former_member699182]

Any ideas please?

Thanks.

[Former Member]

you can create search help by use this form

perform get_parameter_names using    l_pattern

                               changing params[].

in program  RSPFLDOC

full code,

TABLES:TPFYPROPTY,TPFYDOC.

DATA: BEGIN OF FIELD_TBL OCCURS 0.                        

         INCLUDE STRUCTURE HELP_VALUE.                     

DATA: END OF FIELD_TBL.

TYPES: BEGIN OF T_PARAMS,

        PARANAME LIKE TPFYPROPTY-PARANAME,

        END OF T_PARAMS.

TYPES: T_PARAMTAB TYPE STANDARD TABLE OF T_PARAMS.

DATA:  PARAMS TYPE T_PARAMTAB WITH HEADER LINE,

       LINES TYPE I,PARNAME LIKE TPFYPROPTY-PARANAME.

PARAMETER: LV_NAME TYPE SPFPFLPAR-PARNAME.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR LV_NAME.

   PERFORM GET_PARAMETER_NAMES(RSPFLDOC) USING    '%'

                             CHANGING PARAMS[].

   DESCRIBE TABLE PARAMS LINES LINES.

   IF LINES = 1.

     READ TABLE PARAMS INDEX 1.

     TPFYDOC-PARANAME = TPFYPROPTY-PARANAME = PARAMS-PARANAME.

     EXIT.

   ENDIF.

   SORT PARAMS.

   FREE FIELD_TBL.

   FIELD_TBL-TABNAME    = 'TPFYPROPTY'.

   FIELD_TBL-FIELDNAME  = 'PARANAME'.

   FIELD_TBL-SELECTFLAG = 'X'.

   APPEND FIELD_TBL.

   CALL FUNCTION 'HELP_VALUES_GET_WITH_TABLE'                "#EC *

     EXPORTING

       SHOW_ALL_VALUES_AT_FIRST_TIME = 'X'

     IMPORTING

       SELECT_VALUE                  = PARNAME

     TABLES

       FIELDS                        = FIELD_TBL

       VALUETAB                      = PARAMS

     EXCEPTIONS

       OTHERS                        = 99.

END-OF-SELECTION.

[former_member699182]

Thank you for the suggestion Mohamed.

But on clicking the parameter name, the field still remains empty and isnt getting updated with the chosen parameter.

How to resolve this?

Thanks.

[Former Member]

just replace

   CALL FUNCTION 'HELP_VALUES_GET_WITH_TABLE'                "#EC *

     EXPORTING

       SHOW_ALL_VALUES_AT_FIRST_TIME = 'X'

     IMPORTING

       SELECT_VALUE                  = PARNAME

     TABLES

       FIELDS                        = FIELD_TBL

       VALUETAB                      = PARAMS

     EXCEPTIONS

       OTHERS                        = 99.

with

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

     EXPORTING

       RETFIELD    = 'PARNAME'

       DYNPROFIELD = 'LV_NAME'"SPFPFLPAR-PARNAME

       DYNPPROG    = SY-CPROG

       DYNPNR      = SY-DYNNR

       VALUE_ORG   = 'S'

     TABLES

       VALUE_TAB   = PARAMS.

[former_member699182]

Thanks Mohamad. I just noticed the below issue. The parameter count on clicking search help in RZ11 differs from the parameter entries I get from the program. I am yet to debug and see since i am held up with an other issue. But do you have any idea why this happens?

Below is the image taken on clicking search help in RZ11 and in our pgm.

RZ11 shows 500 entries and our pgm list shows 1274. I actually need something similar to what the RZ11 search help does. Any ideas?

Thanks,

[former_member699182]

Sorry my miss. I dint notice the 500 entries filter in RZ11. The entries seem to load correctly.

Now the only problem is, If I choose an entry and without executing if I click search help again, the entries seem to double. (meaning, first time it was 1274 and on clicking second time it became 2548 and third time it becomes 3822 like that). Why does this happen?

Thanks

[Former Member]

JUST USE REFRESH PARAMS. STATEMENT

     befor

  PERFORM GET_PARAMETER_NAMES(RSPFLDOC) USING    '%'

                             CHANGING PARAMS[].

full code.

TABLES:TPFYPROPTY,TPFYDOC.

DATA: BEGIN OF FIELD_TBL OCCURS 0.

         INCLUDE STRUCTURE HELP_VALUE.

DATA: END OF FIELD_TBL.

TYPES: BEGIN OF T_PARAMS,

         PARANAME LIKE TPFYPROPTY-PARANAME,

         END OF T_PARAMS.

TYPES: T_PARAMTAB TYPE STANDARD TABLE OF T_PARAMS.

DATA:  PARAMS TYPE T_PARAMTAB WITH HEADER LINE,

        LINES TYPE I,PARNAME LIKE TPFYPROPTY-PARANAME.

PARAMETER: LV_NAME TYPE SPFPFLPAR-PARNAME.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR LV_NAME.

   REFRESH PARAMS.

   PERFORM GET_PARAMETER_NAMES(RSPFLDOC) USING    '%'

                             CHANGING PARAMS[].

   DESCRIBE TABLE PARAMS LINES LINES.

   IF LINES = 1.

     READ TABLE PARAMS INDEX 1.

     TPFYDOC-PARANAME = TPFYPROPTY-PARANAME = PARAMS-PARANAME.

     EXIT.

   ENDIF.

   SORT PARAMS.

   FREE FIELD_TBL.

   FIELD_TBL-TABNAME    = 'TPFYPROPTY'.

   FIELD_TBL-FIELDNAME  = 'PARANAME'.

   FIELD_TBL-SELECTFLAG = 'X'.

   APPEND FIELD_TBL.

   CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

     EXPORTING

       RETFIELD    = 'PARNAME'

       DYNPROFIELD = 'LV_NAME'"SPFPFLPAR-PARNAME

       DYNPPROG    = SY-CPROG

       DYNPNR      = SY-DYNNR

       VALUE_ORG   = 'S'

     TABLES

       VALUE_TAB   = PARAMS.

END-OF-SELECTION.

[former_member699182]

Thanks a lot Mohamed. That worked!!!

Regards,

Gita

[Former Member]

YOU ARE WELCOME. M AMAR