topic Re: How to know who create db table (in code) in Application Development and Automation Discussions

How to know who create db table (in code)

Former Member — Fri, 03 Jan 2014 15:16:25 GMT

Hello,

I writing a function module. I have string that contains the name of database table, and I need to know if the table is SAP standart table, or z table that not created by SAP.

Thanks,

Ednri.

Re: How to know who create db table (in code)

Former Member — Fri, 03 Jan 2014 15:49:09 GMT

Ednri,

Custom table should always start either with Z or Y so check for first character in the string and find out if it is a stanndard table or custom table

To find out who created table look into table DD02L

Thanks

Bala Duvvuri

Re: How to know who create db table (in code)

Sudhakargadde — Fri, 03 Jan 2014 15:49:38 GMT

Hi ednri,

you can use this link Where all the database tables are stored? | SCN.

and the table name is DD02L help to solve your problem.

Regards

sudhakar

Re: How to know who create db table (in code)

nishantbansal91 — Fri, 03 Jan 2014 15:51:37 GMT

HI Ednri,

There is a Table for the TABLE DD02L that table store the SAP Table name with Author.

Select TABNAME from DD02l where AS4user = (Function module paramter name) and Tabname like 'Z%' .

Try this code its works fine for me.

Regards.

Nishant

Re: How to know who create db table (in code)

Arun_Prabhu_K — Sat, 04 Jan 2014 03:11:47 GMT

DD02L table does not contain the user who created the table but contains only who last changed that table.

Re: How to know who create db table (in code)

Former Member — Sat, 04 Jan 2014 12:10:15 GMT

Do you have other way to solve the problem?

Re: How to know who create db table (in code)

Former Member — Sat, 04 Jan 2014 13:02:11 GMT

Hi,

You can find the table history in DBTABLOG table! check the report RSTBZAHL

Re: How to know who create db table (in code)

Former Member — Sun, 05 Jan 2014 21:47:37 GMT

I don't understand how should I use this table in order to check who created the table.

Re: How to know who create db table (in code)

Arun_Prabhu_K — Mon, 06 Jan 2014 03:02:15 GMT

It is stored in TADIR table : AUTHOR field.

TADIR -> OBJECT= TABL and OBJ_NAME = Table Name -> AUTHOR

Regards.

Re: How to know who create db table (in code)

Former Member — Mon, 06 Jan 2014 10:42:17 GMT

Hi Ednri,

you can try this code on your Function Module. i think it works fine.

goto se37,

make the following entries.

import parameter

export parameter

include the below code in source code

TYPES : BEGIN OF ty_tables,

tabname TYPE tabname,

END OF ty_tables.

TYPES : BEGIN OF ty_tadir,

author TYPE author,

END OF ty_tadir.

DATA lt_dd02l TYPE TABLE OF ty_tables.

DATA ls_tadir TYPE ty_tadir.

SELECT tabname

FROM dd02l

INTO TABLE lt_dd02l

WHERE tabname EQ im_tabname.

IF sy-subrc NE 0.

return-type = 'W'.

return-message = 'NO tables found'.

ELSE.

return-type = 'S'.

return-message = 'Table exists'.

SELECT SINGLE author

FROM tadir

INTO ls_tadir

WHERE obj_name EQ im_tabname.

IF sy-subrc eq 0.

MOVE ls_tadir-author to author.

MOVE im_tabname to tablename.

ELSE.

return-type = 'E'.

return-message = 'Could not found'.

ENDIF.

save and activate.

Cheers

Re: How to know who create db table (in code)

RaymondGiuseppi — Mon, 06 Jan 2014 11:04:31 GMT

As already written, information is stored in repository table TADIR. Access the table with the full primary key (as another type of object may share the same name) PGMID = 'R3TR', OBJECT = 'TABL',OBJ_NAME = name of the table .

AUTHOR :id of (e.g. SAP)
SRCSYSTEM : was created on (e.g. SAP)
DEVCLASS : package

In most systems, customer namespace are the default 'Y*' or 'Z*' range (1), in some other some namespace were reserved (2), so from package DEVCLASS you could check in table TDEVC the value of NAMESPACE which should be /0CUST/ for your customer developments and start with /0SAP for SAP standard /0SAP/, /0SAPBAS/, etc.) or even check owner of namespace in table TRNSPACETT.


DD02L -> TADIR -> TDEVC -> TRNSPACETT

Regards,
Raymond

(1) 16466 - Customer name range for SAP objects

(2) http://service.sap.com/namespaces

Re: How to know who create db table (in code)

anupam_anand — Mon, 06 Jan 2014 11:58:30 GMT

Hi Ednri,

As most of us have already indicated above, use table TADIR with the fields PGMID as R3TR, OBJECT as TABL and OBJ_NAME as the table name that you want to check. The correct field to retrieve the name of the user who created the table is TADIR-AUTHOR. Use this for your results.

Also, to find if the table is standard or a custom, check the first character of the table name and it should be Z or Y. Thats a standard coding practice for mostly all SAP implementations.

Hope it helped.

Thanks,

Anupam

Re: How to know who create db table (in code)

hiriyappa_myageri — Mon, 06 Jan 2014 12:00:15 GMT

check in attributes tab of database table in se11.