Skip to Content

There is a way to extend SAP queries with Extension Fields by simply using Key User Tools.
If you need to use those fields in the PDI itself you can make use of the “Custom Object References”

I tried this with HTML 5; for Silverlight 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 Edit Master Layout via the menu.
  4. Expand the UI by clicking on Show Advanced Filter so that the individual query parameters are
    displayed.
  5. On Mouse-Over the Key User functions are displayed.
    Click on the blue “+” sign and chose Add Fields.
  6. In the following popup you can add a new field.
    Finally tick the Select checkbox for all those fields you want add to the query and then click on Apply.
  7. Now you see the field(s) at the end of regular query parameters.
  8. Finally persist the changes by clicking on End Layout Changes.
  9. To make this visible the normal rules for assiging Business Rules to UIs and users apply.

That’s all, folks.
Horst

To report this post you need to login first.

10 Comments

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

  1. Reinaldo Gutierrez

    Hello Horst,

    Hope you are fine, i am try to add the Tax ID field and isn’t working in the query, can you tell me what can i do to solve this problem??

     

    Regards,

     

    (0) 
      1. Reinaldo Gutierrez

         

        Hello Horst,

        we have an issue with the account central search field in C4C, customer need searching Account & Contact Information by Tax Number (Field TaxID) which is widely used as unique ID number for both persons and organizations in Chile.

        In the standard delivery (1711), we can enable the TaxID field in the “advanced search” via KUT without problems.

        However, in the central search is not taken into account. We would like to know how to enable this behavior (development?), since its priority 1 for end user acceptance. Any pointers would be highly appreciated.

        Thanks in advance,

        (0) 
        1. Horst Schaude
          Post author

          Hello Reinaldo,

          I’ve asked a colleague and he told that any added field should automatically be added to the basic search (= central search).

          Therefore it should work.

          So, please create an incident for this.

          Sorry,
          Horst

          (1) 
  2. Former Member

    Hi Horst,

     

     

    Thank you for sharing info.

    Can you use these KUT fields in query’s in a PDI solution? So I need to be able to query for example an account on a value in an added KUT field from within a PDI development.

     

    Thanks,

     

    Gert

     

    (0) 
    1. Horst Schaude
      Post author

      Hello Gert,

      Simply use the Code Completion if you are using a query in ABSL coding.
      You will not see this field. 🙁

      Because this adds the fields to this query in this UI only.

      Sorry,
      Horst

      (0) 
  3. Jef Lamerant

    Hi,

     

    Is it correct that fields from a full custom object. eg. Custom object X can be added to the query of a standard object eg. Business Partner?

     

    thanks in advance for the reply

     

    Jef

    (0) 

Leave a Reply