SAP Knowledge Base Article - Public

2602994 - Update Check-Out Date of Visits via Data Workbench

Symptom

You need to perform mass update of the check-out date of visits, but you noticed that the update does not occur via Data Workbench, and you need to complete those visits, as you have configuration that does not allow the users to check in in multiple visits.

Environment

 SAP Hybris Cloud for Customer

Reproducing the Issue

  1. Go to the Data Workbench work center.
  2. Go to the Export view.
  3. Choose the object Visits.
  4. To find all visits in your SAP solution that are not checked out of, set up these filters:
    Check-In Date/Time: Greater Than: <date that you implemented the SAP solution>
    Check-Out Date/Time: Is Initial: None
  5.  Export the resulting list of visits and set a check-out date.
  6. Import the same list of visits that now have a check-out date.
  7. The import is successful, but the check-out date is not updated.

Cause

[Enter your Cause here...]

Resolution

This is the system expected behavior. Currently is not possible to import check-in date and check-out date.

As work around, you can remove from scope the check-in and check-out validations to set visits that you need to close as "Completed".

Follow the below steps:

  1. Go to the Business Configuration work center.
  2. Go to the Implementation Projects view.
  3. Select the current project.
  4. Press "Edit Project Scope".
  5. Go to the Questions step.
  6. Remove the below question:


    scope visits.png
  7. Save the changes.
  8. Go to the Data Workbench work center.
  9. Go to the Export view.
  10. Choose the object Visits.
  11. To find all visits in your SAP solution that are not checked out of, set up these filters:
    Check-In Date/Time: Greater Than: <date that you implemented the SAP solution>
    Check-Out Date/Time: Is Initial: None
  12. Export the resulting list of visits and set them to status Completed.
  13. Import the same list of visits that now have status Completed.
  14. Reactivate any validation steps in scoping.

See Also

This is documented in our guide in the section Configuring Multiple Visit Check-In Prevention.

Keywords

Visits, Import, Check-Out, Check-In, Data Workbench, Date , KBA , LOD-CRM-ACT-VST , Visit Planning , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions