DD02L

[Former Member]

Hi,

I need to automate the process of finding the field name vbeln within all our bespoke (Z* Y*) tables. I found all the tables in DD02L, but so far have not found an easy way of checking that vbeln exists in each table. I've tried to debug the "where used" function in SE11 to no success. Any help much appreciated.

[Former Member]

Use table DD03L instead to find the fields ...

[former_member404244]

hi,

use the table DD03L ..

select * from DD03L where TABNAME = TABLE and FIELDNAME = FIELD.

Regards,

Nagaraj

[Former Member]

Hi,

what about using DD03L table , you can query by giving the field name ( vbeln ) and you will receive all the table contains the field.

Cheers,

Chaitanya

[Former Member]

Hi,

DD02L Table contains the SAP Tables.

DD02T Table contains the SAP Table Texts.

DD01L Table contains the Domains

DD01T Table contains the Domain Texts.

DD03L Table contains the Table Fields.

DD03T Table contains the Table Field Texts. (Language Dependent)

DD04L Table contains the Data Elements.

DD04T Table contains the Data Element Texts.

DD05s Table contains the Foreign Key Fields

last words with L and T only. L->Database Fetch T-> Text

Regards,

Chandru

[Former Member]

Hi,

You can use the FM : AKB_WHERE_USED_LIST to get the list of all the objects where the object is used. inside this FM : there is one more FM RSCROSS which gives the object list , and the object list found also has ENCL_OBJECT field which gives the fields used in different ABAP objects.

There is one more FM which gives the Where Used list iteratively. You can search that by giving whereused* in SE37.

Please reward if useful.

Edited by: Vivek Shah on Feb 16, 2008 9:26 PM