Skip to Content
avatar image
Former Member

how to search by field name and entry

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 17, 2015 at 05:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2015 at 08:12 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2015 at 08:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2015 at 04:39 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded