Skip to Content
Former Member
Apr 27, 2010 at 02:22 PM

Importing T-Codes to Menu from Excel Spreadsheet in PFCG


I'd like to create a role (e.g., in BW 7.0) that has a menu with all currently available transactions, except for transactions that I want to assign only to administrators (e.g., to DBAs, Basis Admins, Security Admin). I started by importing the standard SAP menu, then finding & eliminating all of the administrative t-codes; but the resulting role provided access to only a fraction of all of the available transactions. So, I downloaded an Excel spreadsheet from SAP containing all transactions included in SAP_ALL, edited that spreadsheet, & naively tried to upload the resulting list of transctions into the role's menu using the "import from file" feature. When it didn't work, I searched the internet & found (in official SAP websites, as well as non-SAP websites) that a number of others had tried to do this too. I downloaded SAP Note 389675, but have no idea from it how to actually convert my spreadsheet into a txt format that PCFG will accept. Manually, I think I can add these transactions to my role menu 17 at a time, but I don't think it is reasonable to spend days doing this 17 transactions at a time. My goal is to create a role that I could assign to developers that would give them nearly unliimited access (e.g., in a sandbox or development environment, or even in production under management-approved firecall conditions) yet not give them access to restricted administrative transactions. Can you help me figure out how to convert an Excel spreadsheet into the required format, or point me to an alternative means of accomplishing my goal (e.g., do I really need to use eCATT)?