topic Re: T code for Table maintenace in Application Development and Automation Discussions

T code for Table maintenace

Former Member — Mon, 05 May 2008 14:23:07 GMT

Hi,

I have a requirment like I need to create a Tcode for Table maintenance generator, once i execute the T code first it should the Selection screen, in the next screen it should allow change/create entries for the given selection data.

Thanks in advance,

Sudheer. A

Re: T code for Table maintenace

Former Member — Mon, 05 May 2008 14:27:21 GMT

Goto SE93

Enter a variant name -> Create

Select radiobutton 'Transaction with parameteres (parameter transaction)'

Enter transaction text

Enter Transaction = SM30

Check the checkbox for Skip Initial screen and 'Inherit GUI attributes.

In the defalut values section create foll 2 entries

VIEWNAME <table name>

UPDATE X

Save and run the transaction

Look at :

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc

Re: T code for Table maintenace

Former Member — Mon, 05 May 2008 14:31:57 GMT

Hi,

Use the FM

*Call the Function module

CALL FUNCTION 'VIEW_MAINTENANCE_CALL'

EXPORTING

ACTION = P_ACTION

CORR_NUMBER = ' '
GENERATE_MAINT_TOOL_IF_MISSING = ' '

SHOW_SELECTION_POPUP = P_G_POPUP

VIEW_NAME = G_VIEW

NO_WARNING_FOR_CLIENTINDEP = ' '
RFC_DESTINATION_FOR_UPGRADE = ' '
CLIENT_FOR_UPGRADE = ' '
VARIANT_FOR_SELECTION = ' '
COMPLEX_SELCONDS_USED = ' '

CHECK_DDIC_MAINFLAG = 'X'

SUPPRESS_WA_POPUP = ' '

TABLES

DBA_SELLIST =

EXCL_CUA_FUNCT = P_TB_FUN

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.

santhosh

Re: T code for Table maintenace

Former Member — Mon, 05 May 2008 14:36:12 GMT

1. Go to transaction SE93 ,

2. Give the name of ur tcode say zxxxx, for maintaining your ztable.

3. Click on create button,now a page opens.

4. Choose the radio button Transaction with parameters (PARAMETER TRANSACTION).

5. In the next screen enter transaction as : SM30

code" Here DO NOT check the SKIP Initial Screen check box[/code]

6. Also check all the three check boxes for the GUI support.

7. Scroll down you will find a table control for default values

Name of the screen field | value

___________________________________

VIEWNAME | your ztable name

UPDATE | X

Regardsm

Santosh