topic Reg: database table in Application Development and Automation Discussions

Reg: database table

Former Member — Fri, 24 Jul 2009 08:35:21 GMT

Hi Experts,

I want to know the function module to delete the user profile in SU01 transaction.

consider the scenario is like this, i want to delete SAP_ALL profile for a particular user id.

Thanks in advance.

Vijay.R

Re: Reg: database table

Former Member — Fri, 24 Jul 2009 08:41:07 GMT

Try FM BAPI_USER_DELETE.

Re: Reg: database table

Former Member — Fri, 24 Jul 2009 08:45:20 GMT

Hello

BAPI_USER_PROFILES_DELETE

Re: Reg: database table

Former Member — Fri, 24 Jul 2009 08:49:18 GMT

<< there is no point in repeating the answer >>

Re: Reg: database table

Former Member — Fri, 24 Jul 2009 08:52:03 GMT

HI arjun,

Thanks for your reply.

But it is deleting the user itself.

But i want to delete the particular profile only (eg: SAP_ALL) and the other profile should not delete.

do u know any other function modue

Thanks in advance.

Vijay.R

Re: Reg: database table

Former Member — Fri, 24 Jul 2009 08:53:23 GMT

Hi Dzed,

Thanks for your reply.

But it is deleting all the profiles created for the user.

But i want to delete the particular profile only (eg: SAP_ALL) and the other profile should not delete.

do u know any other function modue

Thanks in advance.

Vijay.R

Re: Reg: database table

matt — Fri, 24 Jul 2009 08:55:39 GMT

In future, please use a meaningful subject. Your subject has NOTHING to do with the content of your post

Try searching for other BAPIs beginning BAPI_USER... Why is people won't put in a little effort to help themselves?

Re: Reg: database table

Former Member — Fri, 24 Jul 2009 09:01:59 GMT

Hello

Yes, sorry. It deleting all profiles.

For delete one of profiles you may try this scenario:

1. Read users details with BAPI_USER_GET_DETAIL.You will have table PROFILES with all profiles for particular user.

2. Delete from this table particular profile.

3. Use FM BAPI_USER_PROFILES_ASSIGN with user name and table of profiles.

It must be work.

Also refer this:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/668e6629-0701-0010-7ca0-994cb7dec5a3

Re: Reg: database table

Former Member — Mon, 17 Aug 2009 08:50:46 GMT

Hi All,

Sorry for the wrong subject.

I found the solution for this problem.

Thanks for your replies.