topic Re: Regarding Table Maintenace in Application Development and Automation Discussions

Regarding Table Maintenace

Former Member — Wed, 11 May 2005 08:00:06 GMT

i have created a table in SE11. I have created a table maintenance also. But in SM30 i emtered table name and cliked on Maintain. But iam getting one dialogue box called " table is cross client(see Help for further info). if i click yes on dialogue box, then it is displayed to enter data. But i dont want to dispaly

thie dialogue box. please any help me to avoide this dialogue box.

Regards,

Ravi KUmar

Re: Regarding Table Maintenace

Former Member — Wed, 11 May 2005 08:03:25 GMT

Hi,

The most simple solution would be to make the table client-dependant by simply adding a client (MANDT) field - is that possible for you?

Regards,

Joerg.

Re: Regarding Table Maintenace

Former Member — Wed, 11 May 2005 08:03:48 GMT

Hello,

Do you have field 'MANDT' - Client in your table??

Regards, Murugesh AS

Re: Regarding Table Maintenace

Former Member — Wed, 11 May 2005 08:20:53 GMT

Hi Murugesh,

Thanks for reply. i have not defined MANDT field in the table.

Regards,

Ravi

Re: Regarding Table Maintenace

athavanraja — Wed, 11 May 2005 09:11:27 GMT

In such a case write a small program which will call FM

VIEW_MAINTENANCE_CALL

which has got a option to disable the client dependency message (NO_WARNING_FOR_CLIENTINDEP)

This is very simple to program, you just need to pass the table name, action (maintain, display, etc).

Here is a sample code for maintain.

*&---------------------------------------------------------------------*
*& Report  Y_TEST_TM                                            *
*&                                                                     *
*&---------------------------------------------------------------------*
*&                                                                     *
*&                                                                     *
*&---------------------------------------------------------------------*

REPORT  Y_TEST_TM                        .

CALL FUNCTION 'VIEW_MAINTENANCE_CALL'
  EXPORTING
    action                               = 'U'
*   CORR_NUMBER                          = '          '
*   GENERATE_MAINT_TOOL_IF_MISSING       = ' '
*   SHOW_SELECTION_POPUP                 = ' '
    view_name                            = '<your table name>'
   NO_WARNING_FOR_CLIENTINDEP           = 'X'
*   RFC_DESTINATION_FOR_UPGRADE          = ' '
*   CLIENT_FOR_UPGRADE                   = ' '
*   VARIANT_FOR_SELECTION                = ' '
*   COMPLEX_SELCONDS_USED                = ' '
*   CHECK_DDIC_MAINFLAG                  = ' '
*   SUPPRESS_WA_POPUP                    = ' '
* TABLES
*   DBA_SELLIST                          =
*   EXCL_CUA_FUNCT                       =
* EXCEPTIONS
*   CLIENT_REFERENCE                     = 1
*   FOREIGN_LOCK                         = 2
*   INVALID_ACTION                       = 3
*   NO_CLIENTINDEPENDENT_AUTH            = 4
*   NO_DATABASE_FUNCTION                 = 5
*   NO_EDITOR_FUNCTION                   = 6
*   NO_SHOW_AUTH                         = 7
*   NO_TVDIR_ENTRY                       = 8
*   NO_UPD_AUTH                          = 9
*   ONLY_SHOW_ALLOWED                    = 10
*   SYSTEM_FAILURE                       = 11
*   UNKNOWN_FIELD_IN_DBA_SELLIST         = 12
*   VIEW_NOT_FOUND                       = 13
*   MAINTENANCE_PROHIBITED               = 14
*   OTHERS                               = 15
          .
IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

If you need more info, do get back.

Regards

Raja

Re: Regarding Table Maintenace

Former Member — Wed, 11 May 2005 09:44:15 GMT

That's a good catch, Raja.

Ravi,

You said that you do not have the MANDT field in your table.

1. If that's the requirement, you will have to adopt Raja's solution.

2. If you've forgotten to include the MANDT field, please include it now.

3. If you are not sure about what difference it would make whether you included MANDT or not, please get back.

Some one should be able to help you.

Regards,

Anand Mandalika.