SAP Library - Find your answers

Question: Hello,

I need to restrict access for a specific field of a table.

Can you tell me how to know the authorization object links to this field AND how to create a auth. object ?

Thanks.

Answer:
There is no easy way doing this. Auth Object(s) for standard tables are S_TABU_DIS, S_TABU_CLI. You can use this to restrict access to display only or client specific tables. However if that requirement is mandatory you need to create a custom t.code to display table restricting the field.

Answer:
What do you mean by the statement "restrict specific field of a table?"
Can you be a bit more specific in your problem?
_________________
Regards
Vijay

Answer:
One option could be S_TABU_LIN, but I think you are better off with a custom transaction

Answer:
Exact.

We find a solution by creating a specific transaction.

Once I had couple of roles which where made just t hold reports. The number of reports where huge. Here is how I did it.
First create a CATT script with a dummy role and add one tcode. Make the role and T-code as variant. Once you have this you can add any number of tcode to any existing role. Icould resuse this tocreate another roles where I had to insert lot of T-codes.

Edit, create, delete or adjust your database table

The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System.

This tools allows you to delete all the data in the tables.

You can call the database utility from the initial screen of the ABAP Dictionary with

Utilities -> Database utility (Transaction SE14).

You can use the database utility to edit all the database objects that are generated from objects of the ABAP Dictionary.

These are database tables that are generated from transparent tables or physical table pools or table clusters, indexes, database views and matchcode pooled tables or matchcode views.

If you want to use the database utility, you need authorization for authorization object

To Create, Display, Delete SAP Marketplace User ID, please go through the following link:-

http:\service.sap.com\user-admin

If the user that you've created is not sapuser, than you must login to the
service market place and get the Developer Access Key.

The procedure is as follows:

Login to *service market place*.
Click on *Keys & Requests*
Click on *SSCR Keys* Tab
Click on *Register Developer*
Enter *User Name* and click on *Register* button.

Easy way to create a Logical System is go to TCode BD54.

Click on New Entries and give the name of the Logical System Name. Generally the Logical System name is followed by SID-CLNT-Client Number i.e (DEVCLNT100).

Click on Save and Workbench Transport Request is generated save the transport request.

How can I create multiple User Id at Random

Can I create multiple user id having same profile at once.

Yes you can, use tcode SCAT. First, make sure your client setting (SCC4) is enabled with ' X eCATT and CATT allowed'. Just in case your Production disabled this.
Then, you need to create a simulation (test case) of creating new user id by calling tcode
SU01 later.

Test case must start with Z, example ZCREATE_NEW_USER. Create this case, put title and
choose component as BC (basis components).

Save and choose Local if you dont want to transport it or choose a dev. class (example ZDEV)
if you want to transport it later.

Go back and click Change button. Then key -in Object as example SU01, and choose Record
button on top. When it prompts to enter Transaction code, key in SU01 (if for roles,
key-in PFCG) and begin recording. As usual in SU01 create 1 user id, dept field, password,
roles, group and so on.

Make sure you press Enter on each field because we want to capture the value/object and
SCAT is a bit stupid if you become familiar later....but still useful...indeed.

You will see a clock on the bottom which means the recording process is on going.
Once done, click Back button and press End button to end the recording.

Then double click the Object to begin inserting parameters. Then you will see an object for each fields that you run from SU01. Choose the right field example user id (BNAME) and choose button 'Insert Import Parameter (F6)' and you may click Next Screen to 'watch' what have been recorded and proceed to choose several other objects like password field (PASSWORD1, PASSWORD2), roles field (AGR_NAME), group field etc. If you happen to choose the wrong object, then you can reset back (Edit -> Reset Parameterization). You may see so many junk fields captured and this is because SCAT records every steps/dialogs.

Once done, choose Back and save this case. Then you need to click 'Goto -> Variant -> Export' and save it. After that use Ms Excel to open it and begin inserting all other user ids. Save and close. Remember to close this file because SCAT will use it.
Then last one, get back to SCAT and click button execute, processing mode chose Background, choose external file 'the one you created with Excel' and execute. At this moment don't use tcode SU01 coz you may interrupt the simulation. Wait for the logs. If you see reds then error occurred.