04-04-2008 2:40 PM
Hi
We have created some Z- t-codes (program) that are showing/updating some tables using RS_TABLE_LIST_CREATE.
The users have not access to SE16. This has worked fine. Up to now
We are patching our systems and SAP has done some changes in RS_TABLE_LIST_CREATE so now the module is checking if the user has access to SE16.
If not, you got "You are not authorized to use transaction ...."
Anyone who has any idea how to deal wit this?
We don't want to give the users access to SE16.
Thanks for your help
Kajsa
We are running ECC 5,0, SAP basis 640
04-07-2008 9:45 AM
04-04-2008 2:50 PM
The function module is not released and there for you should not use it...SAP will make changes without notifying you..and will not support you if you are using it..
Instead you should submit report /1BCDWB/DBxxxx
where xxxx is table name..so if you want to generate vbap table then report will be /1BCDWB/DBVBAP
for VBAK it will be /1BCDWB/DBVBAK..and so on ...so you have to dynamically determine report name for a table and then submit it to generate the list...
04-07-2008 9:33 AM
Hi.
THANKS for your answer.
We try to submit the report you suggest, and it looks OK from the beginning.
It look like your in SE16, and when you push the button "Number of entries" you got that the table" have entries.
But when you press execute to display the entries,. Nothing happen.
Any idea, why and what shall we do to see the entries?
Best Regards
Kajsa
04-07-2008 3:36 PM
Do following changes to your code
DATA: ACTION TYPE SY-UCOMM.
DATA: MEM_ID(32) VALUE 'TABELLENANZEIGER'.
ACTION = 'ANZE'.
EXPORT ACTION TO MEMORY ID MEM_ID.
SUBMIT /1BCDWB/DBxxxx VIA SELECTION-SCREEN AND RETURN.
Where xxxx is name of the table(Dynamically generated).
04-09-2008 11:45 AM
Hi again.
Now it works fine for all view transactions.
But the t-codes were we want to change, we have created a maintenance view in SM31.
When we add the z-tcode, we come direct in the table and can do our changes, but when you leave the transaction, either with green, yellow arrow or red cross, you come to SM31.
And there you can change the table, and if the table you change to have a maintenance view, you can view or do changes in this table also (it´s a little like you are in SE16)
Anyone who has any idea how to skip this?
Maybe not to come to SM31 or not to be able to change table there.
Best regards
from today a snowy Sweden
Kajsa
04-09-2008 3:05 PM
Please post your code...I have to examine it before I provide you with a solution.
04-07-2008 9:45 AM
04-07-2008 2:54 PM
Hi and THANKS.
Dieter, the second alternative it helps us further. We now can display/change the entries
But when you reach SE16N, you are in chance view even on the table line, so the user can change table.
We don't want the user to have access to all tables. Just som special z* tables.
Any idea how we solve this?
Best Regards
Kajsa
04-07-2008 3:33 PM
Hi Kajsa,
you can use authority-object S_TABU_DIS.
If you don't an Selection-screen you can use this:
PARAMETER: P_DBTAB LIKE DATABROWSE-TABLENAME DEFAULT 'Z*'.
*
FIELD-SYMBOLS: <GT_ITAB> TYPE TABLE.
*
DATA: GT_DATA TYPE REF TO DATA.
*
CHECK P_DBTAB(1) = 'Z'.
*
CREATE DATA GT_DATA TYPE TABLE OF (P_DBTAB).
ASSIGN GT_DATA->* TO <GT_ITAB>.
*
SELECT * FROM (P_DBTAB) INTO TABLE <GT_ITAB>.
*
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
I_STRUCTURE_NAME = P_DBTAB
TABLES
T_OUTTAB = <GT_ITAB>.
*
Regards, Dieter