Regarding Table Maintenace

[Former Member]

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

[Former Member]

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.

[former_member214131]

Hello,

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

Regards, Murugesh AS

[Former Member]

Hi Murugesh,

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

Regards,

Ravi

[athavanraja]

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

[Former Member]

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.