is it possible to give a user read access to an SAP table but to restrict it to a subset of columns?

[Diggeshhjoshi]

Hi,

is it possible to give a user read access to an SAP table but to restrict it to a subset of columns?

Thanks,
Digesh

[Former Member]

Not through standard table browser transactions.  If you want to give bespoke views on data then you have plenty of options: ABAP queries, ABAP reports, BW reports, BOBJ stuff.

[Former Member]

Hi Digesh,

If your requirement is to restrict the excess to specific rows it is possible to use S_TABU_LIN, but it works only for table which contains org units, like plant, company code, etc.

Please search for S_TABU_LIN if this is your requirement.

Otherwise please follow Alex's suggestion.

BR,

Mangesh

[Former Member]

Also, be very aware of the several disadvantages S_TABU_LIN presents. In Note 1832365 is a detailled "how-to" on that object which also makes clear, to what ends you have to go to make this work.

[Former Member]

Hello Mylene,

Nice to hear from you again   Thanks for the interesting note!

In this case guru wants to restrict columns, not rows. So he needs a reporting application and object, not a table browser and S_TABU* basis objects.

Cheers,

Julius

[Former Member]

Awww. *insertcursehere* My bad. Can't read clearly. I apologise.

edit: Thomas, that's a rather nice idea ...

[ThomasZloch]

You could also try creating a projection view with just the desired columns of the base table and assign a separate authorisation group to it.

Thomas