Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Aug 14, 2013 at 02:02 AM

    Hi Richard,

    pls check the below discussed thread. may helps you

    http://scn.sap.com/thread/3261297

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 15, 2013 at 02:38 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 29, 2013 at 12:04 AM

    SVU, Kamal Mehta, et al: I have already perused and studied the links you supplied. Am also aware of RSRTQ, which is not a practical approach because I need to get BEx characteristics/KFs/char restrictions for 140+ BEx queries each month - NOT by running that query 140+ times/month!

    I require an approach involving a query I build on the BEx metadata tables. I am having specifc problems with the ERD associated with the tables and what I have studied in many SCN posts.

    Answers to specific questions are not in the form of supplying links for SCN enteries that I have already researched. Please, please, will someone PLEASE answer my specific questions #1. and #2 listed above. Thanks to anyone who has sufficient knowledge to yield specific answers to the two questions as stated. NO post links - answers!

    Regards, Rick

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Mak, sorry for insufficient clarity, sir. Am very impressed with your desire to answer what the user seeks. Hope the wording below doesn't wear you out:

      1. list all Key Figures (IOBJNM and TXTLG) - I meant to state I desire to list all KFs, CKFs, and RKFs as listed in InfoProvider panel of BEx Query Designer (see example snapshot, below). Mak, I require each row of the output to contain(per example screenshot):
        1. BEx query technical name (e.g. [ZFC_MC10_BI166_S101] )
        2. BEx query description (e.g. "Disconnects CO NARUC (BI-166)" )
        3. the KF / CKF / RKF technical name (e.g. [0FC_BETRH] )
        4. the KF / CKF / RKF description (e.g. "Amt in Loc. Currency")
        5. each KF/CKF/RKF simply listed on a separate row
        6. So, Mak, what I need is list of which table(s) and columns (and how to select the rows in tables) I will use to list KF/CKF/RKFs in the BEx query. I assume there will be a separate combination of tables/columns/selection criteria/joins for each KF, CKF and RKF (please list each separate combination per KF/CKF/RKF).

      2. identify which characteristics are a Restricted Characteristic - Similar to 1.5 above, all characteristics are to be listed on separate rows. Now, for said characteristic row output, I need to identify which are Characteristic Restrictions listed in Characteristic Restrictions panel of BEx Query Designer(see example snapshot, below). For each each output row, I simply would "flag" each Characteristic used as a Characteristic Restriction. Here is what I need for output on Characteristics:

      1. BEx query technical name (e.g. [ZFC_MC10_BI166_S101] )
      2. BEx query description (e.g. "Disconnects CO NARUC (BI-166)" )
      3. the Characteristic technical name (e.g. [0FCACTDETID] )
      4. the Characteristic description (e.g. "ADID")
      5. each Characteristic shall be simply listed on their own separate row
      6. list of which table(s) and columns (and how to select the rows in tables) used to create items 2.1 - 2.5, above.
      7. for each Characteristic (item 2.3) used as Characteristic Restriction(via fixed value /variable), I need to get flag the output rows stated in 2.6, above. So, Mak, all I need is list of which table(s) and columns (and how to select the row in those tables) used to identify Characteristic Restrictions, and how to join said tables to the tables listed in item 2.6, above.

      Mak, I hope this provides sufficient clarity. If not, I again apologize; please feel free to demand it! Again, thanks so much for your desire to help.

      Best Regards,

      Rick / Atmos Energy

      C1.PNG (176.2 kB)
      C2.PNG (102.2 kB)
  • avatar image
    Former Member
    Dec 01, 2014 at 02:32 PM

    Hi Richard,

    Did you ever succeed in achieving your objective. I am trying to do something similar which will allow the end user documentation to be produced authomatically

    Colin

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 01, 2014 at 05:56 PM

    Hi Richard,

    Please use below FM , it will give really lot information if you pass any one of below

    GENUNIID,COMPID and COMPUID.

    For this may need ABAP program to pull reports from rsrrepdir and pass to below FM and get output.

    RSZ_X_COMPONENT_GET

    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded