Skip to Content

HowTo add Default Set for „Last 10 Days“ or „Due within 2 Weeks“ to Advanced List Pane

This enhancement can be used in the context of custom screens. There is no need to modify or add business logic, just UI-Designer magic.

Prerequisites:    The business object has to provide a date that can be used for querying (e.g. CreationDateTime).


Expected result:



Step 1: Enhance Query


  1. Open your query for your advanced list pane
    1. Add a new data field to the SearchParameters data structure that belongs to your data list

Bildschirmfoto 2015-04-25 um 21.37.16.png

    1. Select the CreationDateTime element on the right in the section of your bound query
    2. Add the CreationDateTime to the query-parameter list
    3. Bind CreationDateTime parameter to the previously created data field

Bildschirmfoto 2015-04-25 um 21.26.35.png



Step 2: Create Default Set


  1. Right click the query and choose add default set
  2. Open the newly created default set
  3. Change the title to a meaningful description (e.g. Quotes of last 5 Days)
  4. Select the query parameter on the left and click + to add a parameter option on the right
    1. Set select option to greaterOrEquals (to select all BO-instances that provide a date at or after a certain point of time in the past)
    2. Click … to add a transformation (this will ‘create’ the point of time in the past)

Bildschirmfoto 2015-04-25 um 21.26.44.png



Step 3: Create Transformation


  1. in create transformation window do:
    1. Select Namespace: http://sap. com/xi/A1S/ReuseFunctions
    2. Select Transformation: DaysToGlobalDateTime
    3. Type in the number of days you would like to include (e.g. -31 [minus! 31] for the last 31 days) 

Bildschirmfoto 2015-04-25 um 21.26.50.png


Step 4: Add Default Set to List Pane’s Dropdown List


  1. Click dropdown list bar in designer tab or select the AdvancedListPane: ObjectWorkList in properties tab
  2. Select DefaultSet Mapping in properties tab
  3. In the upcoming window do:
    1. Select the previously created default set
    2. Click > to move it to the list of bound default sets

Bildschirmfoto 2015-04-25 um 21.26.57.png


The result should look like:



You must be Logged on to comment or reply to a post.
    • /
      • Hi Thomas,

        I have set InNowOrToday to True.

        How about other parameters?

        Can you please provide all the three parameters for Today's record? 🙂

        Best Regards


        • Hi Fred,

          I'm not sure right now, since I cannot test it.

          But I'd try:

          • InNumberOfCalenderDays: -1, 1 or 0
          • InDirection: true
          • InNowOrToday: true



          • Hi Thomas,


            Now when I activate the solution, the system is saying that DaysToGlobalDateTime is not in public solution model and the activation failed. 🙁

            Best Regards


          • Hi Fred,

            This is somehow like a known bug. I had some tickets concerning this issue. SAP confirmed that they will solve this by 1511 eventually.

            You can raise a ticket in your system. In case they already solved this, you may get a hotfix.

            Best Regards


  • Hi Thomas,

    I am trying to display multiple data in an embedded component using advanced list pane. I have created a node in my custom BO and displaying it in this embedded component(EC).

    I am able to save multiple data but only one row of data is visible in this EC.

    Hope you could provide any suggestion.



    • Hi Srinivasan,

      I do not understand how this is related to this post. I guess you should create a new question within SCN and add some context or screenshots for your problem.

      Best Regards


  • Hi,

    So I did exactly as you have pointed out in this. Plus, have also imported in my BO. Saved, activated and refreshed the same. But the transformation field is still blank. It is blank for all SAP reuse functions.




    • Hi,


      Figured although the name is given as CreationDateTime, in reality the datatype is AP.Common.GDT:Date and not DateTIme as can be interpreted from name.

      It works.