topic Re: Customize Master Table in Application Development and Automation Discussions

Customize Master Table

benlim — Fri, 19 Aug 2016 08:28:06 GMT

Hi Expert,

I have created a customize master table and allowed user maintenance.

How can I do to make sure only 1 xfeld field(X) is allowed to maintain?

Client	Key	XFELD
100	A
100	B	X
100	C
100	D

Thanks.

Regards,

-Ben-

Re: Customize Master Table

Former Member — Thu, 25 Aug 2016 06:42:20 GMT

Hi Ben,

You can go to your customized table, then Utilities -> Table Maintenance Generator. Go to the Overview screen and check/tick whichever field you do not want to user to maintain in the 'Output only' column. This will disable the field for edit in SM30. Hope it solves your issue.

Re: Customize Master Table

benlim — Thu, 25 Aug 2016 06:54:08 GMT

Hi @Angela Chong,

Thanks for your suggestion. But my requirement is allowed the user to maintain but only 1 field is allowed among the key.

Scenario 1:

Key B is allowed to maintain and save.

Client	Key	XFELD
100	A
100	B	X
100	C
100	D

Scenario 2:

Prompt error and not allowed to save as only 1 xfeld field can be maintained.

Client	Key	XFELD
100	A	X
100	B	X
100	C
100	D

How do I achieve scenario 2 for customize table maintenance?

Thanks.

Regards,

-Ben-

Re: Customize Master Table

RaymondGiuseppi — Thu, 25 Aug 2016 07:12:44 GMT

Which event(s) of dialog maintenance did you already try? (did you find some save event where you could loop at table TOTAL and count records with the box checked)

Ref: in online help of BC - Generate Table Maintenance Dialog, look for Extended Table Maintenance Events.

Regards,

Raymond

Re: Customize Master Table

Former Member — Thu, 25 Aug 2016 08:00:20 GMT

You can go to the 'Generate Table Maintenance Dialog', Environment -> Modification -> Events, where you create a subroutine to manipulate the data or perform a checking/validation.

Re: Customize Master Table

Former Member — Thu, 25 Aug 2016 10:10:31 GMT

I tried with your given example and managed to perform the required validation. Here's the source code for your reference.


FORM validate_xfeld.  
     DATA: lw_struc   TYPE ztt_tab,        
                 lv_message TYPE string.   

     LOOP AT total.     
          IF= 'N'.       
               MOVE-CORRESPONDINGTO lw_struc.       
               IF lw_struc-zkey <> 'B' AND lw_struc-xfeld = 'X'.         
                    CONCATENATE 'Field XFELD cannot be maintained by key' lw_struc-zkey           
                         INTO lv_message SEPARATED BY space.         
                    MESSAGE lv_message TYPE 'I'.         
                    vim_abort_saving = 'X'.       
               ENDIF.     
          ENDIF.   
     ENDLOOP. 
ENDFORM.

Re: Customize Master Table

benlim — Fri, 26 Aug 2016 08:03:45 GMT

Hi @Angela Chong,

Thanks for such details explanation with sample code. This has help me achieve my requirements.

Thanks a lot!

Regards,

-Ben-