topic Re: Table Cross Client in Application Development and Automation Discussions

Table Cross Client

Former Member — Tue, 18 Apr 2006 07:48:41 GMT

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??

Re: Table Cross Client

Former Member — Tue, 18 Apr 2006 07:51:48 GMT

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

Re: Table Cross Client

Former Member — Tue, 18 Apr 2006 07:52:58 GMT

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

Re: Table Cross Client

Former Member — Tue, 18 Apr 2006 07:54:34 GMT

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

Re: Table Cross Client

Former Member — Tue, 18 Apr 2006 07:56:57 GMT

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

Re: Table Cross Client

athavanraja — Tue, 18 Apr 2006 07:57:06 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.

Ref. thread:

Regards

Raja

Re: Table Cross Client

Former Member — Tue, 18 Apr 2006 09:03:15 GMT

Hi,

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

Regards,

Ravi