cancel
Showing results for 
Search instead for 
Did you mean: 

POWL selection criteria not displaying

s_prakash1
Discoverer
0 Kudos

Hi,

I have tried to display the report through POWL configuration without Webdynpro.

I have done the following configuration but event am not able to view the selection criteria in my report but i can able to display the report.

FPB_MAINTAIN_HIER

POWL_TYPE

POWL_TYPER

POWL_QUERY

POWL_QUERYR.

If i missed anything please let me know.

Accepted Solutions (0)

Answers (2)

Answers (2)

vinita_kasliwal
Active Contributor
0 Kudos

HI Prakash

Did you check in /SAPSRM/POWL_CUST and in your qquery did you include the DB criteria value

I think this is needed for the sel criteria to show up

Regards

Vinita

s_prakash1
Discoverer
0 Kudos

Hi Vinita,

I am not understand./SAPSRM/POWL_CUST is not available(ECC system).Can u explain more

Regards,

Prakash.S

Former Member
0 Kudos

Hi Prakash,

Go to POWL_QUERY and select your POWL query and click the parameters, here you can set which is quick search criterieas if any.

In WD_GLOBAL_SETTING chech whether the personlize parameter is set or not. this is for you to be able to personlize your own powerlist.

It might be the powerlist that you are using that hasn't got any selection criterieas as well, that needs to be coded in the feeder class, which you can find using POWL_TYPE.

s_prakash1
Discoverer
0 Kudos

Hi Jakob,

I have set the query parameter in POWL_QUERY.Still am not got the selection criteria in my output.Please help on the same.

this is my feeder class code

METHOD IF_POWL_FEEDER~GET_SEL_CRITERIA.

  DATA: ls_selcrit TYPE powl_selcrit_sty,

        ls_default TYPE rsparams.

  CLEAR c_selcrit_defs.

  CLEAR c_default_values.

  ls_selcrit-selname = 'CARRID'.

  ls_selcrit-kind = 'S'.

  ls_selcrit-param_type = 'I'.

  ls_selcrit-selopt_type  = 'A'.

  ls_selcrit-allow_admin_change = 'X'.

  ls_selcrit-datatype = 'S_CARR_ID'.

  ls_selcrit-ref_table = 'SCARR'.

  ls_selcrit-ref_field = 'CARRID'.

  ls_selcrit-mandatory = 'X'.

  INSERT ls_selcrit INTO TABLE c_selcrit_defs.

  CLEAR ls_selcrit.

  ls_selcrit-selname = 'CONNID'.

  ls_selcrit-kind = 'S'.

  ls_selcrit-param_type = 'I'.

  ls_selcrit-selopt_type  = 'A'.

  ls_selcrit-allow_admin_change = 'X'.

  ls_selcrit-datatype = 'S_CONN_ID'.

  ls_selcrit-ref_table = 'SPFLI'.

  ls_selcrit-ref_field = 'CONNID'.

  INSERT ls_selcrit INTO TABLE c_selcrit_defs.

  CLEAR ls_selcrit.

  ls_selcrit-selname = 'FLDATE'.

  ls_selcrit-kind = 'S'.

  ls_selcrit-param_type = 'I'.

  ls_selcrit-selopt_type  = 'A'.

  ls_selcrit-allow_admin_change = 'X'.

  ls_selcrit-datatype = 'S_DATE'.

  INSERT ls_selcrit INTO TABLE c_selcrit_defs.

  CLEAR ls_selcrit.

  ls_selcrit-selname = 'CFLDATE'.

  ls_selcrit-kind = 'S'.

  ls_selcrit-param_type = 'I'.

  ls_selcrit-selopt_type  = 'A'.

  ls_selcrit-datatype = 'S_DATE'.

  ls_selcrit-allow_admin_change = 'X'.

  ls_selcrit-crittext = ''' Comma escape '''.               "#EC NOTEXT

  INSERT ls_selcrit INTO TABLE c_selcrit_defs.

  CLEAR ls_selcrit.

* show params in table

*  ls_selcrit-selname = 'PARAONLY'.

*  ls_selcrit-hidden = 'X'.

*  ls_selcrit-kind = 'P'.

*  ls_selcrit-param_type = 'C'.

*  ls_selcrit-allow_admin_change = 'X'.

*  ls_selcrit-datatype = 'POWL_XFLAG_TY'.

*  ls_selcrit-crittext = 'Show Sel.Criteria in output table'.

*                                                            "#EC NOTEXT

*

*

*  INSERT ls_selcrit INTO TABLE c_selcrit_defs.

  CLEAR ls_selcrit.

  ls_default-selname = 'PARAONLY'.

  ls_default-kind = 'P'.

  ls_default-sign = 'I'.

  ls_default-option = 'EQ'.

  ls_default-low = 'X'.

  INSERT ls_default INTO TABLE c_default_values.

    ls_default-selname = 'CARRID'.

  ls_default-kind = 'P'.

  ls_default-sign = 'I'.

  ls_default-option = 'EQ'.

  ls_default-low = 'AA'.

  INSERT ls_default INTO TABLE c_default_values.

  e_selcrit_defs_changed = 'X'.

  e_default_val_changed = 'X'.

ENDMETHOD.