topic Table control program in Application Development and Automation Discussions

Table control program

shilpik20 — Wed, 15 Aug 2007 10:01:50 GMT

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

Re: Table control program

Former Member — Wed, 15 Aug 2007 10:05:58 GMT

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

Re: Table control program

Former Member — Wed, 15 Aug 2007 10:06:35 GMT

check this

Regards

Peram

Re: Table control program

che_eky — Wed, 15 Aug 2007 10:22:25 GMT

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.

Re: Table control program

shilpik20 — Wed, 15 Aug 2007 10:36:42 GMT

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

Re: Table control program

Former Member — Wed, 15 Aug 2007 10:41:43 GMT

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

Re: Table control program

che_eky — Wed, 15 Aug 2007 10:52:52 GMT

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.

Message was edited by:

Che Eky