BEx metadata tables - how to list Query/Chars/KFs
My goal is to create listing of BEx queries and their characteristics, key figures, and identify(flag) any Restricted Characteristics. Have studied several threads describing BEx metadata tables; obtained helpful information from advice by Edwin Harpino (thanks!).
To this point, am able to list queries and their Characteristics.
However (not being a programmer), in my attempt to interpret ABAP code to identify tables/columns involved and how to join up the tables, I am unable to list KFs and flag which characteristics are Restricted Chars. Probably misinterpreted ABAP and messed up.
Simply, I need info an ERD would supply for the 2 remaining items with which I struggle.
So, for the 2 items below, please supply the BEx metadata tables involved, how the fields joined, and which table/columns involved:
- listing all Key Figures (IOBJNM and TXTLG) for each BEx query
- identify which characteristics are a Restricted Characteristic
Thanks for you help.
Regards, Rick Merrill