Skip to Content
author's profile photo Former Member
Former Member

Table maintenace - restrict changes to the existing entries

Hi All,

I have a created a table maintenance generator for a table. I have a requirement like this, I need to restrict changes to the existing entries based on perticular scenario. Is it possible to include this logic in the standard program generated by SAP for table maintenance. If so, how to achieve this.

Thanks in advance

Regards,

Rajavardhana Reddy

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2006 at 12:04 PM

    Hi Rajavardhana,

    Yes it's possible to do it. you need to look into the code of the generated function pool attached to the function group. in that you can select the relevant screen and their associated includes namely the PBO and PAI where in you can include your scenario.

    But it would be quite time consuming in the sense you will have to look for the table field from the screen and also the processing them will be complex.

    Regards,

    Jagath

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Right now i have written extra code in the standard SAP program for some other requirement. Current requirement is based on particular field value, say for example i have 3 fields in the table f1, f2 f3. Based on the value for f3, i need to make the particular record(line) locked(i.e. should not allow to change the data).

      what i am thinking is, i need to get the position of the entry in the table and based on that i need do something to make the entry to display mode.

      any ideas

      Thanks

      Rajavardhana Reddy

  • author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2006 at 12:10 PM

    Hi

    If you have a maintenance dialog defined for that table then you can define a Event. To do this from Se11 select the table got to the Table maintenance screen and from the menu Environment --> Modifications --> Events and create your own event and select a proper triggering option.

    This was you can define your own logic to have ur check in place.

    Regards

    VJ

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 07, 2006 at 12:23 PM

    Hi

    table maintance.

    In standard program of table maintance, there are provided lot of include.

                                                                                                                        • User-defined Include-files (if necessary)**********************************************************

                                                                                                                      • INCLUDE LSVIMF... " Subprograms

                                                                                                                      • INCLUDE LSVIMF01. " Subprograms for date subscreen D0001

                                                                                                                        INCLUDE LSVIMF02. " Subprograms textmaintenance screen D0100

                                                                                                                        INCLUDE LSVIMF03. " Subprograms for VIEW_MAINTENANCE_CALL

                                                                                                                        INCLUDE LSVIMF26. " Subprograms for VIEW_IMPORT_TEXTTAB_LOW_LEVEL

                                                                                                                        INCLUDE LSVIMF58. " Subprograms for VIEW_BCSet_IMPORT

                                                                                                                        • INCLUDE LSVIMO... " PBO-Modules

                                                                                                                        INCLUDE LSVIMO01. " PBO-Modules for date subscreen D0001

                                                                                                                        INCLUDE LSVIMO02. " PBO-Modules for textmaintenance screen D0100

                                                                                                                        • INCLUDE LSVIMI... " PAI-Modules

                                                                                                                        INCLUDE LSVIMI01. " PAI-Modules for date subscreen D0001

                                                                                                                        INCLUDE LSVIMI02. " PAI-Modules for textmaintenance screen D0100

                                                                                                                        which can be used for before PAI,PBO etc.

                                                                                                                        U can create ur own screen as well as u can

                                                                                                                        add validatin or processing logic in between.

                                                                                                                        U just add peform in between standard code of maintaince.

                                                                                                                        (chose any include which provided by SAP (LS...01,02)

                                                                                                                        regards

                                                                                                                        vinod

                                                                                                                      Add a comment
                                                                                                                      10|10000 characters needed characters exceeded

                                                                                                                    • author's profile photo Former Member
                                                                                                                      Former Member
                                                                                                                      Posted on Apr 07, 2006 at 01:23 PM

                                                                                                                      Hi,

                                                                                                                      Its possible to restrict the changes to existing entries without disturbing the standard transaction SM30 functionality.

                                                                                                                      Below is the code which may help you and you can have try by creating the Parameter transaction with the tcode se93.

                                                                                                                      PROCESS BEFORE OUTPUT.

                                                                                                                      MODULE liste_initialisieren.

                                                                                                                      *-- Start of changes by chintsk D01K947457 on 03/28/2006

                                                                                                                      *-- Module to validate extract table at plant level

                                                                                                                      *-- in the Table Maintenance Generator for Z0MM_TBL_FREIGHT

                                                                                                                      *-- And logic to exclude Display/Change toggle push button

                                                                                                                      MODULE validate_plant_pbo.

                                                                                                                      *-- End of changes by chintsk D01K947457 on 03/28/2006

                                                                                                                      LOOP AT extract WITH CONTROL

                                                                                                                      tctrl_z0mm_tbl_freight CURSOR nextline.

                                                                                                                      MODULE liste_show_liste.

                                                                                                                      ENDLOOP.

                                                                                                                      *

                                                                                                                      PROCESS AFTER INPUT.

                                                                                                                      MODULE liste_exit_command AT EXIT-COMMAND.

                                                                                                                      MODULE liste_before_loop.

                                                                                                                      LOOP AT extract.

                                                                                                                      MODULE liste_init_workarea.

                                                                                                                      CHAIN.

                                                                                                                      FIELD z0mm_tbl_freight-werks .

                                                                                                                      FIELD z0mm_tbl_freight-z0mm_inco1 .

                                                                                                                      FIELD z0mm_tbl_freight-inco1 .

                                                                                                                      FIELD z0mm_tbl_freight-txz01 .

                                                                                                                      MODULE set_update_flag ON CHAIN-REQUEST.

                                                                                                                      *-- Start of changes by chintsk D01K947457 on 03/28/2006

                                                                                                                      *-- Module to Validate the Plant for the New entries

                                                                                                                      MODULE validate_plant_pai ON CHAIN-INPUT.

                                                                                                                      *-- End of changes by chintsk D01K947457 on 03/28/2006

                                                                                                                      ENDCHAIN.

                                                                                                                      FIELD vim_marked MODULE liste_mark_checkbox.

                                                                                                                      CHAIN.

                                                                                                                      FIELD z0mm_tbl_freight-werks .

                                                                                                                      FIELD z0mm_tbl_freight-z0mm_inco1 .

                                                                                                                      MODULE liste_update_liste.

                                                                                                                      ENDCHAIN.

                                                                                                                      ENDLOOP.

                                                                                                                      MODULE liste_after_loop.

                                                                                                                      Cheers,

                                                                                                                      Sampath.

                                                                                                                      Add a comment
                                                                                                                      10|10000 characters needed characters exceeded

                                                                                                                    • author's profile photo Former Member
                                                                                                                      Former Member
                                                                                                                      Posted on Apr 23, 2007 at 11:43 AM

                                                                                                                      This was done by changing the module pool program to write some condition based on which the data needs to changed

                                                                                                                      Add a comment
                                                                                                                      10|10000 characters needed characters exceeded

                                                                                                                    • Before answering

                                                                                                                      You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
                                                                                                                      You must be Logged in to submit an answer.

                                                                                                                      Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.