Get Fields Combination Information betweens SAP tables..
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.
But the same is different in VBAK table, where KUNNR field name with different data element.
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.
Here, Field Name is obligatory, to get more specific and restrictive result, provide data element, With Field name from same table or table category.
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.
Heppy Learning 🙂
Informative to get key combination..
The document needs to be reworked -
Until these are corrected the document will remain rejected.
I have updated the picture again, and change some of the statements to make much clear with object.
Now that i understand somewhat "much clear" what you intend do to, i'm gonna revise my rating.
Only when one doesn't know that such things can be done in SE84 (Repository Info System).
So much for reinventing the wheel 😡
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.. 😉