topic Re: Parameters validation in selection screen in Application Development and Automation Discussions

Parameters validation in selection screen

former_member390654 — Wed, 23 Oct 2013 09:18:51 GMT

HI Frnds,

Can anyone please help me on, how to completely validate parameters (optional) and parameters (mandatory).

eg 1:

Parameters : p_matnr type matnr(optional).

parameters : p_mtart type mtartoptional.

validation:??

eg 2:

Parameters : p_matnr type matnr obligatory.

parameters : p_mtart type mtart.

validation:????

Re: Parameters validation in selection screen

Former Member — Wed, 23 Oct 2013 09:22:03 GMT

Use AT SELECTION SCREEN* EVENTS in your program for validation..

e.g.

PARAMETER : p_vbeln TYPE vbak-vbeln.

AT SELECTION-SCREEN ON p_vbeln.

IF NOT p_vbeln IS INITIAL.

SELECT single vbeln FROM vbak into lv_vbeln WHERE vbeln EQ p_vbeln.

IF sy-subrc NE 0.

MESSAGE 'No sales doc exists', type 'E'.

ENDIF.

Re: Parameters validation in selection screen

Former Member — Wed, 23 Oct 2013 09:23:17 GMT

Hi Bala Krishna,

We have to define paramters either optional or obligatory:

1. If it is optional, then no need to specify

Parameters : P_matnr type mara-matnr.

2. If it is mandatory, then we have to specify using "OBLIGATORY".

Parameters : P_matnr type mara-matnr OBLIGATORY.

Then as usual you can do validation in At selection screen event.

Regards

Kusuma

Re: Parameters validation in selection screen

RaymondGiuseppi — Wed, 23 Oct 2013 09:28:29 GMT

What are you looking for, the only difference is that you should not code validation for an initial value of a non-obligatory field, else look Abap documentation for information on PARAMETERS and AT SELECTION-SCREEN ON.

Regards,

Raymond

Re: Parameters validation in selection screen

Former Member — Wed, 23 Oct 2013 11:48:26 GMT

hi Bala,

If the field is mandatory, you directly need to check the value of that field in the database table for validation under AT SELECTION-SCREEN on <field>. If user skips this entry, system will pop a message for mandatory field.

If the field is not mandatory, then first check if field is not initial and then proceed with similar validation for the entered value as done in case of mandatory field( Validation req only if user entry is made).

I am still not clear with the term 'how to completely validate parameters (optional) and parameters (mandatory).' can you explain what do you expect when you say completely validate.

Regards,

DN.

Re: Parameters validation in selection screen

Former Member — Wed, 23 Oct 2013 12:17:07 GMT

Hii Bala,

U can validate the parameters at event called AT SELECTION SCREEN like below

DATA v_matnr TYPE matnr.

AT SELECTION-SCREEN.

IF p_matnr IS INITIAL.

    set CURSOR FIELD 'P_MATNR'.

    MESSAGE 'Enter the material number' TYPE 'E'.

ELSE.

    SELECT SINGLE MATNR               ---->to check the existence of entered materail no

      FROM mara

      INTO v_matnr

      WHERE MATNR eq p_matnr.

      IF sy-subrc <> 0.

        MESSAGE 'Enter the valid material number' TYPE 'E'.

      ENDIF.

ENDIF.

IF p_mtart IS INITIAL.

    SET CURSOR FIELD 'P_MTART'.

    MESSAGE 'Enter the description' TYPE 'E'.

ENDIF.

If u want that after selecting the matnr the mtart field should be automatically filled with respect to material number then u can achieve it like below is the simple [rogram illustrating that.

REPORT zr05_test.

PARAMETERS: p_matnr TYPE matnr, "OBLIGATORY value CHECK,

            p_mtart TYPE mtart.

DATA: t_mara TYPE STANDARD TABLE OF mara,

      v_matnr TYPE matnr.

DATA: t_f4 TYPE STANDARD TABLE OF mara, ----->will hold the data displayed in dynamic search help window

      t_dd TYPE TABLE OF dselc,    ---->for dynamic value selection

      t_ft TYPE TABLE OF dfies,

      t_ret TYPE TABLE OF ddshretval,    ------>will hold the selected value in search help

      x_dd TYPE dselc,

      x_ft TYPE dfies.

FIELD-SYMBOLS <fs> TYPE mara.

AT SELECTION-SCREEN on VALUE-REQUEST FOR p_matnr.

PERFORM dynamic_f4.    ----> To provide dynamic search help to matnr and mtart get automatically filled based on the matnr value

AT SELECTION-SCREEN. -------->Evenet to validate data

IF p_matnr IS INITIAL.

    set CURSOR FIELD 'P_MATNR'.

    MESSAGE 'Enter the material number' TYPE 'E'.

ELSE.

    SELECT SINGLE MATNR

      FROM mara

      INTO v_matnr

      WHERE MATNR eq p_matnr.

      IF sy-subrc <> 0.

        MESSAGE 'Enter the valid material number' TYPE 'E'.

      ENDIF.

ENDIF.

IF p_mtart IS INITIAL.

    SET CURSOR FIELD 'P_MTART'.

    MESSAGE 'Enter the description' TYPE 'E'.

ENDIF.

START-OF-SELECTION.

SELECT *

    FROM mara

    INTO TABLE t_mara

    UP TO 3 rows

    WHERE matnr eq p_matnr
    AND mtart eq p_mtart.

    IF sy-subrc eq 0.

           SORT t_mara by MATNR ASCENDING.

     ELSE.
          MESSAGE 'No Records Found for entered Value' TYPE 'I' DISPLAY LIKE 'E'.
    ENDIF.

    LOOP AT t_mara ASSIGNING <fs>.

      WRITE:/ <fs>-matnr,

              <fs>-mtart,

              <fs>-ersda,

              <fs>-ernam.

    ENDLOOP.

*&---------------------------------------------------------------------*

*&      Form DYNAMIC_F4

*&---------------------------------------------------------------------*

*       text

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

* --> p1        text

* <-- p2        text

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

FORM DYNAMIC_F4 .

IF t_f4 IS INITIAL.

    SELECT *

      FROM Mara

      CLIENT SPECIFIED

      INTO TABLE t_f4

      UP TO 500 ROWS

      WHERE mandt eq sy-mandt.

ENDIF.

REFRESH t_dd.

x_dd-fldname   = 'MTART'.

x_dd-dyfldname = 'P_MTART'.

APPEND x_dd TO t_dd.

CLEAR x_dd.

REFRESH t_ft.

x_ft-tabname   = 'MARA'.

x_ft-fieldname = 'MATNR'.

APPEND x_ft TO t_ft.

CLEAR x_ft.

x_ft-tabname   = 'MARA'.

x_ft-fieldname = 'MTART'.

APPEND x_ft TO t_ft.

CLEAR x_ft.

IF NOT t_f4 IS INITIAL.

    CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

      EXPORTING

        retfield               = 'MATNR'

       DYNPPROG               = sy-repid

       DYNPNR                 = sy-dynnr

       DYNPROFIELD            = 'P_MATNR'

       WINDOW_TITLE           = 'Search Help Selection'

       VALUE_ORG              = 'S'

      tables

       value_tab              = t_f4

       FIELD_TAB              = t_ft

*       RETURN_TAB             = t_ret

       DYNPFLD_MAPPING        = t_dd

     EXCEPTIONS

       PARAMETER_ERROR        = 1

       NO_VALUES_FOUND        = 2

       OTHERS                 = 3.

    IF sy-subrc <> 0.

* Implement suitable error handling here

    ENDIF.

ENDIF.

ENDFORM.                    " DYNAMIC_F4

This is the example of dynamic search help and dynamic field value filled based on other field value.

regards

Syed

Re: Parameters validation in selection screen

former_member864767 — Wed, 23 Oct 2013 12:46:47 GMT

Hi Bala Krishna,

You can use "AT SELECTION-SCREEN" event for validations on Screen.

Though once you use "Obligatory" statement, system will not execute untill you pass value in parameter.

Example 1:

Parameters : p_matnr type matnr(optional).

Parameters : p_mtart type mtartoptional.

AT SELECTION SCREEN.

IF P_MATNR IS NOT INITIAL.

....<Validation Statements>....

ENDIF.

Example 2:

Parameters : p_matnr type matnr obligatory.

parameters : p_mtart type mtart.

AT SELECTION SCREEN.

IF P_MATNR IS NOT INITIAL.

....<Validation Statements>....

ENDIF.

Thanks & Regards,

Tushar Trivedi.

Re: Parameters validation in selection screen

Former Member — Wed, 23 Oct 2013 13:08:26 GMT

Its possible to make an field look like an obligatory field but not more with the following coding:

AT SELECTION-SCREEN OUTPUT.

LOOP AT SCREEN.
     IF screen-name = '[FIELDNAME]'.
       screen-required = '2'. "<-recommend = 2   obligatory = 1   optional = 0
       MODIFY SCREEN.
     ENDIF.
   ENDLOOP.

Re: Parameters validation in selection screen

former_member390654 — Fri, 25 Oct 2013 07:19:33 GMT

Thank you Everyone. For all your valuable answers.

Re: Parameters validation in selection screen

former_member188282 — Fri, 25 Oct 2013 07:33:52 GMT

Hi Krishna,

Sample for reference

TYPE-POOLS: vrm.
DATA: tab_values TYPE vrm_values,
rcd_values LIKE LINE OF tab_values,
variant_id TYPE vrm_id,
oneorzero TYPE c.
LOAD-OF-PROGRAM.
rcd_values-key = '0'.
rcd_values-text = '0'.
APPEND rcd_values TO tab_values.
rcd_values-key = '1'.
rcd_values-text = '1'.
APPEND rcd_values TO tab_values.
PARAMETERS: dropdown TYPE n AS LISTBOX VISIBLE LENGTH 3 OBLIGATORY,
checkbox AS CHECKBOX,
checkaft TYPE c.
AT SELECTION-SCREEN OUTPUT.
variant_id = 'DROPDOWN'.
CALL FUNCTION 'VRM_SET_VALUES'
EXPORTING
id = variant_id
values = tab_values
EXCEPTIONS
OTHERS = 0.
AT SELECTION-SCREEN ON checkbox.
IF checkbox IS INITIAL.
oneorzero = '0'.
ELSE.
oneorzero = '1'.
ENDIF.
AT SELECTION-SCREEN ON checkaft.
IF checkaft NE '0' AND checkaft NE '1'.
MESSAGE 'Invalid value' TYPE 'E'.
ENDIF.

Regards,

Rajesh

Re: Parameters validation in selection screen

Former Member — Fri, 25 Oct 2013 07:52:04 GMT

If you use obligatory the system itself will throw an error message if the field is left blank.

Once you enter the value and after that you want to display the message you can write it under

AT SELECTION SCREEN event so that it will dispay message at the that screen itself.

AT SELECTION SCREEN.

write the query.

if sy-subrc ne 0.

message 'type the message' type 'E' (for error) can use W for warning, S status message

With regards

Suneesh

Re: Parameters validation in selection screen

sandeep_suggu — Thu, 01 Sep 2022 07:24:16 GMT

SELECT single vbeln FROM vbak into lv_vbeln WHERE vbeln EQ p_vbeln.

A small mistake in This line

the word which shown in italic is - replacing - p_vbeln

Thanks,

Suggu Sandeep.

Re: Parameters validation in selection screen

SowmyaSurekha — Thu, 01 Sep 2022 07:35:11 GMT

hi,

We can Validate Selection Screen With the Help of the Following Events.

AT SELECTION-SCREEN ON
AT SELECTION-SCREEN ON BLOCK
AT SELECTION-SCREEN OUTPUT
AT SELECTION-SCREEN.

At selection-screen on
select stmt ------------------ where = .
if sy-subrc = 0.
validation success for LOw value in selection screen
At selection-screen on
select stmt-------------------- where =
if sy-subrc <> 0.
validation failure on high value in the selection field.
else
success.

endif

with regards 
SOWMYA.