topic Re: Describe Table in Application Development and Automation Discussions

Describe Table

Former Member — Mon, 14 Feb 2005 18:34:16 GMT

Hi,

I want to learn every properties of a given table such as attributes, total lines, primary keys. I was suggested to examine "describe table". Is there any good reference that explains "describe table" that you know?.

Thanks,

Re: Describe Table

vani_krishnamoorthy — Mon, 14 Feb 2005 18:37:44 GMT

HI Huseyin,

In your program type in Describe and hit F1. You will get help on describe.

or go the documentation at

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3798358411d1829f0000e829fbfe/frameset.htm

Regards,

Vani

Re: Describe Table

ssimsekler — Mon, 14 Feb 2005 21:30:14 GMT

Hi Huseyin

"DESCRIBE" statement is used for getting simple information about internal tables and I guess you want to acquire information about a database table. So, you can use the FM "DDIF_NAMETAB_GET" .

This FM will give technical information about the database table. To acquire the number of records you can use "SELECT COUNT( * ) " statement.

Hope this helps...

Kind Regards

*--Serdar

ssimsekler@yahoo.com

Re: Describe Table

Former Member — Mon, 14 Feb 2005 23:51:02 GMT

Hi,

Yes Serdar, I want to learn a database table's properties. I need more information about "DDIF_NAMETAB_GET" function. Can you suggest a reference such as in which BC series I can find information? Or another good reference?

Re: Describe Table

athavanraja — Tue, 15 Feb 2005 04:52:04 GMT

Check out the Function module documentation for DDIF_NAMETAB_GET

Its well explained there.

Regards

Raja

Re: Describe Table

Former Member — Tue, 15 Feb 2005 06:40:55 GMT

Hello Huseyin,

In addition to the FM mentioned, you can also consider the FM DDIF_TABL_GET. This FM is very well documented.

You can also look at the Class CL_REBF_DDIC_TABL.

Regards,

Anand Mandalika.

Re: Describe Table

ssimsekler — Tue, 15 Feb 2005 11:04:45 GMT

Hi Huseyin

These type FMs are not explained in BC or other training documents. However, as mentioned, you can refer to FM documentation at SE37.

Kind Regards

*--Serdar

ssimsekler@yahoo.com

Re: Describe Table

Former Member — Mon, 14 Mar 2005 22:16:46 GMT

Hello,

two more options for getting table descriptions:

1) ABAP command "import nametab" (see ABAP documentation)

2) using the Run-Time Type Identification classes (class CL_ABAP_TYPEDESCR and children)

data:

lt_but000 type table of but000,

lr_structdescr type ref to cl_abap_structdescr.

lr_structdescr ?= cl_abap_typedescr=>describe_by_data( lt_but000 ).

Cheers,

Thorsten