Problem solve Get help with specific problems with your technologies, process and projects.

Copy your SAP favorites to another SAP user

Here's how to Copy your SAP favorites to another SAP user or another server.

Here is how to Copy your SAP favorites to another SAP user or another server: a) SMEN_BUFFC - gives information...

of all stored Favorites for a user; the following columns are of interest in the table: REPORT: has name of the transaction code UNAME: contains the sap logon id b) SMEN_BUFFI - gives information of all stored Links for a user; the following columns are of interest in the table: UNAME: contains the sap logon id URL: contains the link address To copy username1's favorites to another user (e.g. username2) within the same server and client do the following: 1. sqlplus system/passwd; create table system.buffc as select * from sapr3.SMEN_BUFFC where uname = 'username1'; 2. update system.buffc set uname = 'username2'; 3. insert into sapr3.SMEN_BUFFC select * from system.buffc; 4. drop table system.buffc; To copy username1's favorites to different server (e.g. from prod to qa) do the following: 1. sqlplus system/passwd; create table system.buffc as select * from sapr3.SMEN_BUFFC where uname = 'username1'; 2. exp userid=system/passwd full=no file=fav.dmp tables=(buffc) 4. ftp the fav.dmp file to the target server 5. imp userid=system/passwd file=fav.dmp full=no tables=(buffc) 6. sqlplus connect system/passwd insert into sapr3.SMEN_BUFFC select * from system.buffc; 7. drop table system.buffc; You can follow the same process for the SMEN_BUFFI table.


 

This was last published in November 2002

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

This is really helpful information.
Cancel

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close