Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

T code for Table maintenace

Former Member
0 Likes
522

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
481

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

3 REPLIES 3
Read only

Former Member
0 Likes
481

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

Read only

Former Member
0 Likes
482

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

Read only

Former Member
0 Likes
481

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