Hi Again,

Let me start with SE11 t-code, suppose requirement is search a data element, which has been used in what are the tables, structure etc..

Now, in simple way, we use where use tool to search the same.

But now, a bit change in question, search a Field-Name used in which tables, structure etc..

Now As developer, i will search table, which starts with DD*.

Here is a simple program, which provide the same solution with few more condition.

Like, Based on Data element, and one extra column in same table.

Why data element? 😕

Take an example of KUNNR (Customer No), in KNA1 table, the field name and data element are same.

info.JPG

But the same is different in VBAK table, where KUNNR field name with different data element.

info.JPG

In this program, user can restrict the search criteria, It’s return the result set from Transparent table, Structure, Cluster table, Pooled table and view.

Input:

info.JPG

Here, Field Name is obligatory, to get more specific and restrictive result, provide data element, With Field name from same table or table category.

info.JPG

With Field name from same table : With this option, put some more condition in search criteria. For example search table, where the MATNR and KUNNR both fields are available.


After execution the below output will display.

info.JPG

Heppy Learning 🙂

Praveer

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Suhas Saha

    The document needs to be reworked –

    1. The embedded pictures are not visible.
    2. Use proper English.

    Until these are corrected the document will remain rejected.

    (0) 
    1. Praveer Sen Post author

      Hi Suhas


      I have updated the picture again, and change some of the statements to make much clear with object.

      Thanks Again.

      Praveer.

      (0) 
  2. Suhas Saha

    Now that i understand somewhat “much clear” what you intend do to, i’m gonna revise my rating.

    But now, a bit change in question, search a Field-Name used in which tables, structure etc..

    Now As developer, i will search table, which starts with DD*.

    Only when one doesn’t know that such things can be done in SE84 (Repository Info System).

    SE84.JPGSo much for reinventing the wheel 😡

    (0) 
    1. Praveer Sen Post author

      Good one, I didn’t know about this..

      In my case, i have added one more option to get some more specific value..

      Thanks for sharing.. 😉

      Praveer.

      (0) 

Leave a Reply