Table maintenance SM30 with Authority-Check

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Post Reply
STPE12
Posts: 7
Joined: Fri Jul 26, 2013 8:20 am

Table maintenance SM30 with Authority-Check

Post by STPE12 » Mon Jul 08, 2019 11:50 am

Dear ABAP Experts

I have a specific table Zxxx that I'm using to share data cross companies.
In this table, I have a dedicated field BUKRS used to store the relevant company code for a record.
I would like to give access to users to specific transaction ("SM30 like") to maintain this table, but only for their respective company codes.
For that reason, I would like to activate standard "Authority-Check" on BUKRS field.

What is the best/easiest way to achieve that ?

Thanks for your support
Stéphane

EricR
Posts: 143
Joined: Sat Apr 28, 2007 10:35 am

Re: Table maintenance SM30 with Authority-Check

Post by EricR » Tue Jul 09, 2019 10:08 am

Good news.

S_TABU_LIN is a standard authorization object that will be checked by the system if you configure line-oriented authorizations on that table.

IMG -> SAP NetWeaver -> Application Server -> Users and Authorizations -> Line-oriented authorizations is the IMG path to configure this for your table.

Once those steps are done, modify the roles as necessary to include the S_TABU_LIN object.

Finally, create a parameter transaction for your Z-tcode calling SM30 and skipping the initial screen. Done and done!

STPE12
Posts: 7
Joined: Fri Jul 26, 2013 8:20 am

Re: Table maintenance SM30 with Authority-Check

Post by STPE12 » Wed Jul 10, 2019 9:11 am

Thanks for your feedback Eric.

I will follow up on this proposal.

Regards
Stéphane

Post Reply