topic Re: Mandatory field in data dictionary in Application Development and Automation Discussions

Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 14:37:51 GMT

Hi,

I have created a ztable and did table maintainance generator. Even though first 3 fields are primary keys but still system is allowed to store the entries without any value (blank). pls suggest how to make it mandatory?

thanks,

Pradeep

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 14:41:53 GMT

Hi,

It is possible to create one line as blank line,but not one more.

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 14:44:43 GMT

Hello Pradeep,

field entry mandatory( shud not left blank)

This cannot be done in SE11 while creating a table.

This needs to be done in screen painter.

regards,

Kinshuk Saxena

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 14:44:44 GMT

you have to add your own custom checks in table maintenance by modifying the generated code. Go to the screen editor and create your own module in PAI and create a z include and add ur validations there.

Re: Mandatory field in data dictionary

manuel_bassani — Wed, 22 Mar 2006 14:47:04 GMT

Hi Pradeep,

if you don't want blank entries you can

- set the allowed values in the field domain

- if the table can only be modified by the maintainance view, modify the logic flow of the screen (insert a module in which you check the values and display an error message if the user inserts a blank value)

Regards, Manuel

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 15:03:53 GMT

Hi Manuel,

Thanks for the answer. it will be great if you could let me know where to do add the pai (own logic). I am able to write the code but do't know where to write.

Thanks,

Pradeep

Re: Mandatory field in data dictionary

manuel_bassani — Wed, 22 Mar 2006 15:16:13 GMT

Hi,

- Se11 -> Modify

- choose Utilities -> Table maintenance generator (i presume that a maintenace view already exists)

- Environment -> Modification -> Maintenace screen

- Double click on dynpro number

- Inside the LOOP statement (because you have to check all the entries) for example just before the ENDLOOP statement, insert:


FIELD ZFIELD.
  MODULE CHECK_ZFIELD.

Regards, Manuel

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 16:45:06 GMT

Hi Manuel,

As you suggested I have added the code but during debugging still system is not able to recognised this module "MODULE CHECK_ZPRPTN1_SPART INPUT."

Code is given below :

Flow Logic :

PROCESS AFTER INPUT.

MODULE LISTE_EXIT_COMMAND AT EXIT-COMMAND.

MODULE LISTE_BEFORE_LOOP.

LOOP AT EXTRACT.

FIELD ZPRPTN1-SPART .

MODULE CHECK_ZPRPTN1_SPART.

endloop.

code in include is :

MODULE CHECK_ZPRPTN1_SPART INPUT.

IF ZPRPTN1-spart eQ ' '.

MESSAGE E000(VA) WITH 'PLS FILL VALUE'.

EXIT.

ENDIF.

ENDMODULE. " MODULE CHECK_ZPRPTN1_SPART

Pls suggest how to resolve this problem.

Thanx,

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 16:46:39 GMT

Try with

IF ZPRPTN1-spart <b>IS INITIAL</b>.

Sudha

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 16:50:10 GMT

system is not going at if condition during debugging.

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 16:59:29 GMT

Here is a way. Go to SE54. Enter you table name. In the menu, 'Environment-->Events'. Hit 'enter' on the subsequent popup warning. In the next screen, you will see a table control with three columns. First one is 'T' and the next one is 'FORM routine' and the last one is 'Editor'. Click on 'New Entries' button. Enter '01' in the column 'T' and 'VALIDATE_BEFORE_SAVE' under the 'FORM routine' column. I am just taking an example here, but the name can be anything. What is important is the 01.

Now click on the source code icon that appears in the third column. Next you will get a popup asking for the include name where you want to write the code for this routine. This include will be part of your function group's main program. Once you are in the editor, use the following code for validating the blank values.


FORM validate_before_save.

  DATA: BEGIN OF s_myztable.
          INCLUDE STRUCTURE zmyztable.
          INCLUDE STRUCTURE vimtbflags.
  DATA: END OF s_myztable.

  LOOP AT total.
    CLEAR s_myztable.
    MOVE total TO s_myztable.
*-- only if it is not marked for deletion
    CHECK s_myztable-vim_action <> neuer_geloescht.
    IF s_myztable-keyfield1 IS INITIAL OR
       s_myztable-keyfield2 IS INITIAL.
      MESSAGE i000 WITH 'Key Field1 and Key Field2 cannot be blank.'.
      sy-subrc = 4.
      EXIT.
    ENDIF.
  ENDLOOP.

ENDFORM.                                    " VALIDATE_BEFORE_SAVE

Re: Mandatory field in data dictionary

Former Member — Wed, 22 Mar 2006 17:00:37 GMT

Hi Manuel,

problem got resolved, thanx a lot.

Rgds,

Pradeep

Re: Mandatory field in data dictionary

Former Member — Thu, 09 Nov 2006 13:24:57 GMT

Hi Pradeep,

can u tell me the code or explain what u have done as i have the same issue.

Thanxs in advance.