how to search by field name and entry

[Former Member]

Hi

I have problem

Need find table in abap stack where column name = AAA and value of AAA = BBB.

How I can find it, please help

thank you

[roberto_forti · Accepted solution]

Hi Baji,

You can select the table DD03L and fill the field FIELDNAME = AAA.

After that you will see the list with the tables.

Regards

[ashish_suri29]

This message was moderated.

[former_member230742]

Hi Baji,

what is your database, if Oracle, you can use tx DB02 > Performance > Additional Functions > SQL Command Editor. if MMS, you can use tx ST04 > Diagnostics > SQL Command Editor, then you can write a SQL command to find it. but sorry, I am not a SQL expert.

br,

Lalio

[naresh_kabar]

Hi,

First you have to find table name which having field AAA from SE84 transaction you can get list of table names.

second based in that table you have to check individual is there any value have with value AAA = BBB.

Regards,

Naresh.

[Former Member]

hmmm....

I can't check all tables entry from BBB?