Report on overdue tickets

[pieter_rijlaarsdam1]

Hey guys,

I am working on a report showing overdue tickets.

What we would like is a report containing tickets in a certain stage where the completion due date (determined by the SLA) is in the past.

Apparently, it is not possible to create a variable select on the completion due field as this is a date/time field.

Any suggestions how to create the report anyway?

We want the ticket to show up in the report the moment it is overdue (so not the next day). A variable selection on a date field is not sufficient.

Thanks,

Pieter

[pieter_rijlaarsdam1]

Saurav,

We have not done any SDK developments to get this in the datasource.

There are 2 fields in the standard data source:

- Completion Due Date Time.

- Completion Due Date.

As this is SLA related, I would like to select tickets based on the Completion Due Date Time.

As you will understand, Completion Due Date doesn't cover it when the SLA for initial review is for instance 4 hours.

In order to create correct reporting on SLA expiry, we should be able to create a relative select on the Date Time field.

Any suggestions?

Anyone by the way who agrees to needing this, vote for the customer influence idea here:

https://influence.sap.com/sap/ino/#/idea/228202/

Thanks,

Pieter

[former_member497128]

Dear pieter_rijlaarsdam,

If its a date/time field, then we don't have any option to fulfill your requirement.

Thanks for raising the concern in influence forum.Someone from concerned team will look into this and based on complexity/feasibility/effort needed they will assist you accordingly.

Regards,
Saurav Kumar

[former_member497128]

Dear pieterrijlaarsdam,

We don't have complete due date already added to data source, so it seems you have added it via SDK and if this is the case, please add only date field as in this case, we might be able to get your requirement fulfilled.

If its date field,then we can create custom relative selection (with from value as fixed date and to date as current date) which will give the details of tickets with completion due date less than today.

Please try and let us know in case of any further concerns.

Regards,
Saurav Kumar

[former_member694641]

SAP Cloud is the Best option for SAP Product Deploy.