08-15-2007 11:01 AM
Hello all
i have an urgent requirement on this..below i m giving the requirement
There are four tables
1> ysd__cond_cntrl
2>ypric_ctrgp_ctrl
3> ypric_ctyp_cntrl
4>ypricing_cntrl
currently those tables are maintained with t-code SM30 by members of the project
team
Now need one transaction code which allows controlled user access to all those tables for maintenance from one selection screen
now i have to create a new T-code
i have to create a new selection screen from where the user can branch out to a specific table
-and for all tables provide maintenance capabilities similar to transaction SM30(switch between display and change, new entries,select multiple,copycreate,
delete,undo change, allow export to excel)
Can anyone give me any idea how to proceed and any sample program regarding
this
thanking all
08-15-2007 11:06 AM
08-15-2007 11:05 AM
why not make 4 tcodes for each sm30 table 1 and put them in the menu ? then you can also authorize through the proper SAP authorization for access .
with SE93 you define a new Tcode for instance zysd__cond_cntrl
at transaction fill in SM30
select skip first screen
add to screenfields
VIEWNAME : ysd__cond_cntrl
UPDATE : X
Message was edited by:
A. de Smidt
Message was edited by:
A. de Smidt
08-15-2007 11:06 AM
08-15-2007 11:22 AM
I like a difficult requirement, lets get started.
-First create a program with a selection screen and allowing users to select which table/s they want to maintain. Make it nice and pretty to get you noticed by the users )
-Next create a transaction code and link it to the program with selection screen. Pick a good transaction code name something memorable but not too long or too short, maybe get consensus from the users it will look good on you ;o)
-Finally create some backend thingy or something like that which is called to allow the users to maintain the table/s selected. To save time and development rather than code bespoke maintenance screens and programs maybe you can call transaction SM30, not a bad idea hey? don;t tell the users they will think you did it all 😮
Any questions just ask.
08-15-2007 11:36 AM
i have got that wht u have written...but i have to add one more functionality
export to excel...that is not in sm30..wht to do
08-15-2007 11:52 AM
Shilpik,
Hmmm I see what you mean. What you can do is add a checkbox to the selection screen "Export to Excel" and then if user selects a table and ticks this checkbox then you export table contents to Excel instead of calling maintenance screen. Or you could even call transaction SE16N which has an export to spreadsheet option.
C
Message was edited by:
Che Eky
08-15-2007 11:41 AM
Hi,
Try using FM VIEW_MAINTENANCE_CALL.
CALL FUNCTION 'VIEW_MAINTENANCE_CALL'
EXPORTING
action = 'S' "S means display, see further documentation through SE37
view_name = 'Zxxx' "the view name
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
.