Skip to Content
author's profile photo Former Member
Former Member

How to get all tables name in HR, containing particular field.

Hi all,

I want to find the name of all HR tables which contains particular field or data element.

For Example for filed VORNA

One should get the name of all tables which contain VORNA in HR.

Thanks n Regards

Rohit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 12:40 PM

    Hi,

    Goto SE84, then

    ABAP Dectionary --> Fields --> Table Fields, then enter the Field name then press ENter then you will find all the table which is uses this field

    Regards

    Sudheer

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi ..

      Try this way..

      PARAMETERS: P_FIELD TYPE DD03L-FIELDNAME DEFAULT 'VRNAM'.

      Data : begin of wa_Tab,

      tabname type DD02L-TABNAME,

      end of wa_Tab.

      DATA : IT_TAB LIKE TABLE OF WA_TAB.

      START-OF-SELECTION.

      SELECT TABNAME FROM DD02L

      INTO TABLE IT_TAB

      WHERE APPLCLASS IN <HR APPL CLASS>

      AND TABNAME IN (SELECT TABNAME FROM DD03L WHERE FIELDNAME = P_FIELD).

      Here you need to specify the Application Class relevant for HR.

      reward if Helpful..

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2007 at 08:20 AM

    In SE11 put the data element ->VORNA

    where user list , in the PoP-up select the database tables.

    it will list all the tables which uses the Field VORNA.

    if you want it as report then u have to write a program using the table

    DD03L ->Date dictionary tables and fields.

    Reward points if it is usefull ..

    Girish

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.