‎2008 May 19 10:34 AM
i need to create t.code for (ztable)table maintance...
in that t.code creation we should not use SM30 .
since the user doesnot have access to SM30.
pls help me out..
‎2008 May 19 1:06 PM
1)Write a program and give it a tcode
2)Call the following FM to maintain the table:
CALL FUNCTION 'VIEW_MAINTENANCE_CALL'
EXPORTING
action = 'S'
* CORR_NUMBER = ' '
* GENERATE_MAINT_TOOL_IF_MISSING = ' '
* SHOW_SELECTION_POPUP = ' '
view_name = 'ZSLO_RET_DISPO'
* 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 =
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.
and you job is done...
‎2008 May 19 10:40 AM
Hi,
1. Tcode SE93
2. Create object with type "Transaction with parameters(paramter transaction).
3. Key in SM30 into "transaction", and tick "skip initial screen".
4. Tick checkbox "Inherit GUI attributes".
5. Name of screen field = VIEWNAME, value = "Your table name".
6. Name of screen field = UPDATE, value = x.
Regards
Kiran Sure
‎2008 May 19 10:43 AM
in t.code creation i should not use sm30 since the client doesnot have access to sm30.
‎2008 May 19 10:47 AM
‎2008 May 19 11:00 AM
Hi,
1) Go to SE11
2) In Delivery and Maintenance TAB
i) Delivery Class as A ( most of the times)
ii) Data Browser/Table View Maint. as "Display/Maintenance Allowed"
3) Enter the required fields.
4) Goto Technical Settings.Enter the appropriate data
5) Then go to Utilities-->Table Maintenance Generator
i) Enter the Authorization Group (Varies from project to project...when no authorization required give &NC& )
ii)Function Group as "Table Name"
iii)Package varies from project to project
iv)Maintenance Type as "One Step"
a)Give overview Screen Number (Your own number..but remember)
b)Single Screen "Any number"(it can be 0 also)
6) Then click on the white color create button on menu bar(Create)
7) To view the maintenance Screen Transaction is SM30(There you need to give the table name)
😎 If you want to change the description of the fields,alignment,mandatory,greying the fields,Validations and many more
goto SE51 enter program name as "SAPL(TABLE NAME) EX:SAPLZH116 and enter the screen number what you gave in the step 5,iv,a.
9)If u want to have a transaction to table maintenance
a)Go to SE93
b)Choose "Transaction with Parameters" Radio button
c)Give the Package Name which is given in 5,iii
d)Give transaction as SM30
e)Choose Skip Initial Screen
f)In GUI Support Choose all the three options
g) In the default values Tab
Name of the Screen Field Value
UPDATE X
VIEWNAME (Enter Table Name)
After doing this goto se93..in 9(a)
Cheers
Mohinder Singh
Edited by: Mohinder Singh Chauhan on May 19, 2008 12:06 PM
Edited by: Mohinder Singh Chauhan on May 19, 2008 12:10 PM
‎2008 May 19 11:09 AM
anybody tell me how to create t.code for my screen created in se51
‎2008 May 19 11:12 AM
Hi,
Use Function Module "VIEWCLUSTER_MAINTENANCE_CALL"
Assign points if helpful.
‎2008 May 19 1:06 PM
1)Write a program and give it a tcode
2)Call the following FM to maintain the table:
CALL FUNCTION 'VIEW_MAINTENANCE_CALL'
EXPORTING
action = 'S'
* CORR_NUMBER = ' '
* GENERATE_MAINT_TOOL_IF_MISSING = ' '
* SHOW_SELECTION_POPUP = ' '
view_name = 'ZSLO_RET_DISPO'
* 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 =
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.
and you job is done...
‎2008 May 19 1:31 PM
‎2008 May 19 1:33 PM
thank u for all...
i used the function module which u mentioned above..