topic Table control program in Application Development and Automation Discussions

Table control program

shilpik20 — Wed, 15 Aug 2007 05:17:06 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

gopi_narendra — Wed, 15 Aug 2007 05:25:51 GMT

Do something like this...

create 4 radio buttons and for each radio button call the transaction created for that table.

PARAMETERS : p_r1 RADIOBUTTON GROUP r1.
PARAMETERS : p_r2 RADIOBUTTON GROUP r1.

START-OF-SELECTION.

  IF p_r1 = 'X'.
    CALL TRANSACTION 'VA01'.
  ELSEIF p_r2 = 'X'.
    CALL TRANSACTION 'VA02'.
  ENDIF.

Regards

Gopi

Re: Table control program

Former Member — Wed, 15 Aug 2007 05:56:28 GMT

Hi Shilpik,

<b>You can do by using the Authorization object by transaction SU21and procedure is mentioned below</b>(Authorization objects enable you to define complex authorizations,whether a user is allowed to perform a certain action) .

1> F8 SU21,

2> Create Class .

3> create the Authorization object and assign this to class.

4> you can use the ACTVT field.

5> Click on the button "Maintain the permitted activities" and maintain the field value for ACTVT.

Once this is created you can use the "AUTHORITY-CHECK" statement in your program.Example.

AUTHORITY-CHECK OBJECT '<Your Authorization object>'

ID 'ACTVT' FIELD '01'. "For create

if sy-subrc = 0 .

submit SM30 program (skip first screen) and allow the user to fill the entries in table.

endif.

I think this will definitely solve your problem Plz Reward Points.

Thanks,

saj