Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BEx metadata tables - how to list Query/Chars/KFs

Greetings All

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:

  1. listing all Key Figures (IOBJNM and TXTLG) for each BEx query
  2. identify which characteristics are a Restricted Characteristic

Thanks for you help.

Regards, Rick Merrill

Atmos Energy

Dallas, TX

Former Member
Not what you were looking for? View more on this topic or Ask a question