topic Re: RF_TABLE_LIST_CREATE in Application Development and Automation Discussions

RF_TABLE_LIST_CREATE

Former Member — Fri, 04 Apr 2008 13:40:11 GMT

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 user’s access to SE16.

Thanks for your help

Kajsa

We are running ECC 5,0, SAP basis 640

Re: RF_TABLE_LIST_CREATE

Former Member — Fri, 04 Apr 2008 13:50:28 GMT

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...

Re: RF_TABLE_LIST_CREATE

Former Member — Mon, 07 Apr 2008 08:33:57 GMT

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

Re: RF_TABLE_LIST_CREATE

Former Member — Mon, 07 Apr 2008 08:45:07 GMT

Hi,

i had the same problems

and solve i like this

First alternative.

DATA: REPORT LIKE SY-REPID VALUE '/1BCDWB/DBVBAK'.

SUBMIT (REPORT) VIA SELECTION-SCREEN AND RETURN.

Second alternative.

CALL FUNCTION 'SE16N_START'

EXPORTING

I_TAB = 'MARA'.

Hope it helps.

Regards, Dieter

Re: RF_TABLE_LIST_CREATE

Former Member — Mon, 07 Apr 2008 13:54:27 GMT

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

Re: RF_TABLE_LIST_CREATE

Former Member — Mon, 07 Apr 2008 14:33:13 GMT

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

Re: RF_TABLE_LIST_CREATE

Former Member — Mon, 07 Apr 2008 14:36:04 GMT

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).

Re: RF_TABLE_LIST_CREATE

Former Member — Wed, 09 Apr 2008 10:45:35 GMT

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

Re: RF_TABLE_LIST_CREATE

Former Member — Wed, 09 Apr 2008 14:05:27 GMT

Please post your code...I have to examine it before I provide you with a solution.