4 Replies Latest reply: Feb 21, 2008 7:30 AM by anbulakshmi arul RSS

t.code for custom table

Kumar k
Currently Being Moderated

hi

 

i need to attach the T.code to Custom table to allow data display and access by users. this should be SE16 data browser view.

 

how to do this? pls help me

 

points will be reward

 

Thanks

Kumar

  • Re: t.code for custom table
    DEEPANKER MAHAJAN
    Currently Being Moderated

    Hi

     

    Hope it will help you.

     

    Pls reward if help.

     

     

    I

    Once you geenrate the table maintenance for that Z table

    use the tcode SM30 to add/change the entries in that table.

     

    If you wants to create a new Tcode you can create using the Transaction SE93

     

    for authorization object see the doc;

     

    In general different users will be given different authorizations based on their role in the orgn.

    We create ROLES and assign the Authorization and TCODES for that role, so only that user can have access to those T Codes.

    USe SUIM and SU21 T codes for this.

     

    Much of the data in an R/3 system has to be protected so that unauthorized users cannot access it. Therefore the appropriate authorization is required before a user can carry out certain actions in the system. When you log on to the R/3 system, the system checks in the user master record to see which transactions you are authorized to use. An authorization check is implemented for every sensitive transaction.

     

    If you wish to protect a transaction that you have programmed yourself, then you must implement an authorization check.

     

    This means you have to allocate an authorization object in the definition of the transaction.

     

    For example:

     

    program an AUTHORITY-CHECK.

     

    AUTHORITY-CHECK OBJECT <authorization object>

    ID <authority field 1> FIELD <field value 1>.

    ID <authority field 2> FIELD <field value 2>.

    ...

    ID <authority-field n> FIELD <field value n>.

     

    The OBJECT parameter specifies the authorization object.

     

    The ID parameter specifies an authorization field (in the authorization object).

     

    The FIELD parameter specifies a value for the authorization field.

     

    The authorization object and its fields have to be suitable for the transaction. In most cases you will be able to use the existing authorization objects to protect your data. But new developments may require that you define new authorization objects and fields.

     

    http://help.sap.com/saphelp_nw04s/helpdata/en/52/67167f439b11d1896f0000e8322d00/content.htm

     

     

    To ensure that a user has the appropriate authorizations when he or she performs an action, users are subject to authorization checks.

     

    Authorization : An authorization enables you to perform a particular activity in the SAP System, based on a set of authorization object field values.

     

    You program the authorization check using the ABAP statement AUTHORITY-CHECK.

    AUTHORITY-CHECK OBJECT 'S_TRVL_BKS'

    ID 'ACTVT' FIELD '02'

    ID 'CUSTTYPE' FIELD 'B'.

    IF SY-SUBRC 0.

    MESSAGE E...

    ENDIF.

     

    'S_TRVL_BKS' is a auth. object

    ID 'ACTVT' FIELD '02' in place 2 you can put 1,2, 3 for change create or display.

     

     

    The AUTHORITY-CHECK checks whether a user has the appropriate authorization to execute a particular activity.

     

     

    This Authorization concept is somewhat linked with BASIS people.

    As a developer you may not have access to access to SU21 Transaction where you have to define, authorizations, Objects and for nthat object you assign fields and values. Another Tcode is PFCG where you can assign these authrization objects and TCodes for a profile and that profile in turn attached to a particular user.

  • Re: t.code for custom table
    taranam dhindsa
    Currently Being Moderated

    create a tranc with last radio button, ie trans with parameter

    2. In default value tab give trans as SE 16.

    3. In default values at end, give DATABROWSE-TABLENAME on LHS and in right give your table name.

     

    Reward points if useful

  • Re: t.code for custom table
    anbulakshmi arul
    Currently Being Moderated

    Hi Kumar

     

     

     

    1. go to Transaction: SE93

    2. Enter Short Text

    3. Select Radio button "Transaction with Parameters(Parameter Transaction)"

    4. Next screen, give transaction as SM30

    5. Check "Skip Initial Screen"

    6. Under Detault Values tab give two rows

    a. VIEWNAME for screen field and <your table name> for value

    b. UPDATE for screen and 'X' as value

    7. Save and Execute

Actions