There is a way to extend SAP queries with Extension Fields by simply using Key User Tools.

If you need to use those field in the PDI itself you can make use of the “Custom Object References”

I tried this with Silverlight; for HTML 5 please look here.

  1. As we use the Key User Tools your Business User should be a Key User.
    This means the “Application and User Management”  work center must be assigned to this user
  2. Go to the UI for which you want to enhance the query.
  3. Switch to the Adaption Mode via the menu
    /wp-content/uploads/2015/08/switch2adaptation_mode_772703.gif
  4. Expand the UI by clicking on “Advanced” so that the individual query parameters are displayed
  5. Switch to Edit Screen via the menu
    /wp-content/uploads/2015/08/edit_screen_772705.gif
  6. Now you see on the right side the supported adaptions.
    Click on the Extension Fields.
    If your required field is not listed you can create one.
    No_ext_field_on_query.gif
  7. Mark the checkbox Visible for all those field you the query to be extended by.
    As result these fields appear on the UI.
    Ext_field_on_Query.gif
  8. Finally click on Save or Publish.
    /wp-content/uploads/2015/08/save_publish_772706.gif

That’s all, folks.

Horst

To report this post you need to login first.

2 Comments

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

  1. Jacques-Antoine Ollier

    Hello Horst,

    Does a field added like that to the Advanced Query panel is added to the Queries of the Root node in the SDK?

    I have extended the Employee BO with a custom field and I would like to add this field to the QueryByIdentificaiotn query, but it seems it does not work as only the Common node is extensible and not the root. Moreover there is no query in the common node.

    thank you for your attention.

    Best regards.

    Jacques-Antoine Ollier

    (0) 
    1. Horst Schaude Post author

      Hello Jacques-Antoine,

      First, this works only with Key User Extension fields, because any Extension Field from SDK may not exist in another tenant in which the Key User content is importet / re-created but no deployment for the resp. solution has happend.

      Second, as you wrote the Root node of the BO Emplyoee is not extensible. Another point for: No, this won’t work. 🙁

      Sorry,

         Horst

      (0) 

Leave a Reply