topic Re: Profile Parameter (Param Name) Search help query. in Application Development and Automation Discussions

Profile Parameter (Param Name) Search help query.

former_member699182 — Fri, 14 Nov 2014 05:33:31 GMT

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.

Re: Profile Parameter (Param Name) Search help query.

custodio_deoliveira — Fri, 14 Nov 2014 05:40:34 GMT

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

Re: Profile Parameter (Param Name) Search help query.

Former Member — Fri, 14 Nov 2014 05:47:02 GMT

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

Re: Profile Parameter (Param Name) Search help query.

former_member699182 — Fri, 14 Nov 2014 06:49:39 GMT

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.

Re: Profile Parameter (Param Name) Search help query.

former_member699182 — Mon, 17 Nov 2014 04:59:11 GMT

Any ideas please?

Thanks.

Re: Profile Parameter (Param Name) Search help query.

Former Member — Mon, 17 Nov 2014 05:33:06 GMT

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.

Re: Profile Parameter (Param Name) Search help query.

former_member699182 — Mon, 17 Nov 2014 07:58:58 GMT

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.

Re: Profile Parameter (Param Name) Search help query.

Former Member — Mon, 17 Nov 2014 08:52:43 GMT

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.

Re: Profile Parameter (Param Name) Search help query.

former_member699182 — Tue, 18 Nov 2014 01:15:41 GMT

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,

Re: Profile Parameter (Param Name) Search help query.

former_member699182 — Tue, 18 Nov 2014 01:36:01 GMT

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

Re: Profile Parameter (Param Name) Search help query.

Former Member — Tue, 18 Nov 2014 05:15:03 GMT

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.

Re: Profile Parameter (Param Name) Search help query.

former_member699182 — Tue, 18 Nov 2014 06:08:11 GMT

Thanks a lot Mohamed. That worked!!!

Regards,

Gita

Re: Profile Parameter (Param Name) Search help query.

Former Member — Tue, 18 Nov 2014 08:48:55 GMT

YOU ARE WELCOME. M AMAR