topic Re: DD02L in Application Development and Automation Discussions

DD02L

Former Member — Fri, 08 Feb 2008 10:57:12 GMT

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.

Re: DD02L

Former Member — Fri, 08 Feb 2008 11:00:20 GMT

Use table DD03L instead to find the fields ...

Re: DD02L

former_member404244 — Fri, 08 Feb 2008 11:03:31 GMT

hi,

use the table DD03L ..

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

Regards,

Nagaraj

Re: DD02L

Former Member — Sat, 16 Feb 2008 12:09:49 GMT

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

Re: DD02L

Former Member — Sat, 16 Feb 2008 19:26:38 GMT

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

Re: DD02L

Former Member — Sat, 16 Feb 2008 20:25:57 GMT

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