Table Cross Client

[Former Member]

I created a table maintenance dialog via the generator.

then, i use it in sm30. When click the maintain , the prompt shows "Caution: The table is cross-client"

How can i resolve it??

[Former Member]

Hi,

That is because you don't have MANDT (CLIENT) field in the table. Modify the table to add the field MANDT as the field field, mark it as key - regenerate the table maintenance, you will not get the warning.

Regards,

Ravi

Note : Please close the thread if the issue is resolved

[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.

Ref. thread:

Regards

Raja

[Former Member]

Hi

It depends on what you really want to do.

You have missed the client (MANDT) as key field when you've created your table: did you want this?

If you didn't, you should insert the MANDT as first key field of your table, otherwise it's ok.

Max

[Former Member]

Hi Chun,

Do have MANDT in your table,and also it should be Key field, check it is there or not,if not try to add it and make it as key field, and delete your old Table maintenance and Regenerate the same.

and try from SM30.

Regards

vijay

[Former Member]

Hi,

Customizing which is specific to more than one client. Settings in cross-client tables relate to all clients, regardless of which client was accessed during the logon process.

so, see in your table weather MANDT field is there or not, if not just add this field ...

Thanks

Sudheer

[Former Member]

Hi,

Please close the thread and reward the helpful answers by clicking the stars on the left hand side.

Regards,

Ravi