topic Re: Table Control Validation in Application Development and Automation Discussions

Table Control Validation

former_member267445 — Thu, 17 Sep 2015 10:42:39 GMT

Hi Gurus,

I have created a custom screen to vendor master and added 2 radio buttons as Yes and No. Below radio buttons I have created a Table Control with 2 fields. Here what I am doing is, when user runs the transaction No is the default radio button and Table control should be in display mode and if user chose the Yes radio button then Table control should be in enable mode. I have done this.

Now, if user chose the Yes radio button and did not enter any values without entering in Table Control I need to through an error message. Actually in screen attributes I have set Recommended. But in one of the table control field there is a SPACE value in F4 option, when I chose SPACE table control is not accepting when I set Recommended.

Is there any solution to over come this?

Thanks and Regards,

Muralikrishna Peravali

Re: Table Control Validation

VenkatRamesh_V — Thu, 17 Sep 2015 12:37:37 GMT

Hi Murali,

In Process after Input.

MODULE USER_COMMAND_0100.

MODULE USER_COMMAND_0100 INPUT.

WHEN 'ENTER'.

READ table itab with key vbeln NE ' ' transporting no fields.

if sy-subrc <> 0.

Message 'Enter the values' type 'S' display 'E'. or store the error message to internal table display in popup

LEAVE TO LIST-PROCESSING.

ENDMODULE.

Hope it helpful,

Regards,

Venkat.

Re: Table Control Validation

former_member809980 — Thu, 17 Sep 2015 15:22:43 GMT

Hi,

You can make use of CHAIN.. ENDCHAIN inside the table control to put validation on fields of the table control.

for your reference

LOOP AT tc_itab.

CHAIN,

FIELD: <field1>,

<field2>.

.............

MODULE process_validation. " on change-request/ on input, whatever you can use as per your requirement

ENDCHAIN.

ENDLOOP.

THIS MUST BE DONE IN "PROCESS AFTER INPUT"

thanks

Re: Table Control Validation

former_member267445 — Fri, 18 Sep 2015 09:16:55 GMT

Hi Venkat Ramesh,

Thank you for reply. I have tried this one before. As per my knowledge we can not set the option LEAVE to LIST-PROCESSING for sub screens.

Thanks and Regards,

Muralikrishna Peravali.

Re: Table Control Validation

former_member267445 — Fri, 18 Sep 2015 09:23:36 GMT

Hi Aditya,

Thank you for reply. Yes, you are correct, when user enters the values in table control but requirement is when Yes radio button chosen and user didn't enter any values in table control then need to through an error message. As per my understanding by debug the code tc_itab will be empty initially so the loop will not execute.

Thanks and Regards,

Muralikrishna Peravali

Re: Table Control Validation

VenkatRamesh_V — Fri, 18 Sep 2015 09:35:19 GMT

Hi Murali,

Store the error message in internal table, display as popup.

Eg: REUSE_ALV_POPUP_TO_SELECT.

OR create variable to hold the subscreen number, create a blank sub screen.

if the table is empty, change the screen number to blank screen.

DATA DYNNR TYPE SY-DYNNR VALUE '0100',

CALL SUBSCREEN SUB INCLUDING PROGRAMS dynnr. (Screen)

Hope it helpful,

Regards,

Venkat.

Re: Table Control Validation

former_member267445 — Fri, 18 Sep 2015 10:00:31 GMT

Hello Venkat,

I have done with out using LEAVE to LIST-PROCESSING. It is working as expected when user chose the Yes radio button and press enter. But when I save the transaction it is directly saving without giving any values in table control.

Thanks and Regards,

Muralikrishna Peravali.

Re: Table Control Validation

Former Member — Fri, 18 Sep 2015 10:21:55 GMT

Did you put a check for OK_CODE or SY-UCOMM in your code? If yes check if you have the OK_CODE for SAVE added in your IF condition for validation.

Re: Table Control Validation

former_member267445 — Fri, 18 Sep 2015 10:28:15 GMT

Hello Rudra roy,

Yes, I put a check for OK_CODE as UPDA. Because for SAVE ok code here is UPDA.

Thanks and Regards,

Muralikrishna Peravali

Re: Table Control Validation

Former Member — Fri, 18 Sep 2015 10:30:49 GMT

Paste your code pls.

Re: Table Control Validation

former_member267445 — Fri, 18 Sep 2015 11:08:47 GMT

Hello Roy,

Please find attached.

Thanks and Regards,

Muralikrishna Peravali.

Re: Table Control Validation

Former Member — Fri, 18 Sep 2015 11:14:05 GMT

You have used Message type S. It won't stop the processing. Also did not paste the full code

Either use Message type "E".

Or skip the next processing by command like LEAVE TO SCREEN 0.

Re: Table Control Validation

former_member267445 — Fri, 18 Sep 2015 11:17:27 GMT

Hello Roy,

If I use message type as 'E' then table control is going to disable mode. I think LEAVE TO SCREEN 0 is not work for sub screens.

Thanks and Regards,

Muralikrishna Peravali

Re: Table Control Validation

VenkatRamesh_V — Fri, 18 Sep 2015 11:23:10 GMT

Hi,

Kindly View the code.

TYPES:

BEGIN OF ty_error,

msg(30) type c,

END OF ty_error.

DATA: it_error TYPE TABLE OF ty_error,

wa_error TYPE ty_error,

it_fcat TYPE slis_t_fieldcat_alv,

wa_fcat TYPE slis_fieldcat_alv,

wa_fcat-fieldname = 'MSG'.

wa_fcat-seltext_m = 'Error'.

wa_fcat-outputlen = '50'.

APPEND wa_fcat to it_fcat.

IF it_error IS NOT INITIAL.

wa_fcat-fieldname = 'MSG'.

wa_fcat-seltext_m = 'Error'.

wa_fcat-outputlen = '50'.

APPEND wa_fcat to it_fcat.

CALL FUNCTION 'REUSE_ALV_POPUP_TO_SELECT'

EXPORTING

I_TITLE = 'Error Details'

I_SELECTION = 'X'

* I_ALLOW_NO_SELECTION =

I_ZEBRA = 'X'

I_SCREEN_START_COLUMN = 10

I_SCREEN_START_LINE = 20

I_SCREEN_END_COLUMN = 100

I_SCREEN_END_LINE = 30

* I_CHECKBOX_FIELDNAME =

* I_LINEMARK_FIELDNAME =

* I_SCROLL_TO_SEL_LINE = 'X'

I_TABNAME = 'IT_ERROR'

* I_STRUCTURE_NAME = 'BAPIRET2'

IT_FIELDCAT = it_fcat

* IT_EXCLUDING =

* I_CALLBACK_PROGRAM =

* I_CALLBACK_USER_COMMAND =

* IS_PRIVATE =

* IMPORTING

* ES_SELFIELD =

* E_EXIT =

TABLES

T_OUTTAB = it_error

EXCEPTIONS

PROGRAM_ERROR = 1

OTHERS = 2

IF SY-SUBRC <> 0.

* Implement suitable error handling here

ENDIF.

ELSE.

Message 'Data Updated ' Type 'S'.

ENDIF.

Update the error to internal table.

Hope it helpful,

Regards,

Venkat.

Re: Table Control Validation

former_member378318 — Fri, 18 Sep 2015 11:27:32 GMT

Do no put your code in the main PAI table control loop. Place it in the user_command module.

gv_code = sy-ucomm.

clear sy-ucomm.

IF gv_code eq gc_t03 or gv_code = gc_upda.

IF rb_yes eq gc_x.

IF gt_crt is INITIAL.

MESSAGE e956(zl).

ENDIF.

Re: Table Control Validation

Former Member — Fri, 18 Sep 2015 11:35:58 GMT

Where did you put the code. Subscreen PAI? Or Main Screen PAI?

For me empty check should be done in Main Screen PAI.

Re: Table Control Validation

former_member267445 — Fri, 18 Sep 2015 12:46:37 GMT

Hello Surbjeet,

I put this code in the user_command module only.

Thanks and Regards,

Muralikrishna Peravali

Re: Table Control Validation

former_member267445 — Wed, 30 Sep 2015 07:27:49 GMT

Hello Rudra Roy,

As I was not feel well, I was on vacation. Sorry for the delay response. I have created a subscreen(9000) using function group and I have attached to Vendor master badi. I have written the logic in 9000 Screen of PAI.

Thanks and Regards,

Muralikrishna Peravali

Re: Table Control Validation

former_member267445 — Wed, 30 Sep 2015 09:46:16 GMT

Hello All,

Any help on this please.

Thanks and Regards,

Muralikrishna Peravali

Re: Table Control Validation

nishantbansal91 — Wed, 30 Sep 2015 10:02:56 GMT

Hi,

Each table control has one workarea. WA contains value if user has press anything,

So check the W.A, if the WA is initial throw an error message.

Thanks

Nishant