SAP Knowledge Base Article - Public

2700494 - Error: “Recommended visiting frequency ZZZZZZ is not valid” While Importing Account Visits Details Using Data Workbench

Symptom

Your requirement is to add new Recommended Visit Frequency for the existing Accounts. Upon trying to import data using Data Workbench object Account Visits Details, you receive the processing error:

Recommended visiting frequency ZZZZZZ is not valid

*ZZZZZZ represents the recommended visit frequency for Account

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Login to the HTML5 client
  2. Go to Data Workbench workcenter
  3. Go to Import tab
  4. Select the radio button for Individual Object
  5. Go to Insert tab
  6. Go to Standard Object tab
  7. Search for the data workbench object Account Visits Details
  8. Select Download Metadata
  9. Fill data in the fields
  10. Example:
  11. External_Key: EXT _001 (where EXT _001 represents the External Key for recommended visit frequency
  12. Account_ID: XXXXXX (where XXXXXX represents the Account ID)
  13. Recommended_Visit_Frequency: 25 Day(s) (where 25 represents the days in recommended visit frequency)
  14. Save the file
  15. Select Next and Browse for the file
  16. Select Upload
  17. Choose Next
  18. Select Import
  19. Check the Monitor view for the Task
  20. The records in the file have the Processing Error

Cause

In the upload file, the value specified in the field Recommended_Visit_Frequency has incorrect format.

Resolution

In any Account, there are two facets in which the field Recommended Frequency is available.

  1. Visits facet which is related to the standard Data Workbench object Account
  2. Visits Details related to the standard Data Workbench object Account Visits Details

The general documentation of Account Visits Details:
With the Account Visits Details Data Workbench object, you can maintain the Recommended Visit Frequency and Visit Duration for a visit detail instance belonging to the specified Account. A visit detail instance is described by a unique combination of Visit Type and Sales Area (Sales Organization ID, Distribution Channel, Division). The fields Visit Duration and Recommended Visit Frequency are of data type duration.

Definition of datatype duration:
Duration is based on the built-in data type of W3C xsd:duration. This is structured according to the extended representation of ISO 8601 (you may refer to portal).

The representation is PnYnMnDTnHnMnS

Example: P12Y12M2DT4H12M40S

The representation uses the following literals:

P = denotes the duration and must precede every duration value

n Y = the number prefix ( n ) is the duration in years

n M = the number prefix ( n ) is the duration in months

n D = the number prefix ( n ) is the duration in days

T = is the prefix for the time period in hours, minutes, and seconds. Not required if no times are represented

n H = the number prefix ( n ) is the duration in hours

n M = the number prefix ( n ) is the duration in minutes

n S = the number prefix ( n ) is the duration in seconds

or

n .nnn S = a decimal point precedes fractions of seconds.

Tenths ( n S), hundredths ( n S), and thousandths ( nnn S) of a second can be shown.

The number prefix ( n ) in each case is the duration in fractions of a second.

 

Example:

To describe a Visit Duration of 1 hour the field entry would be PT1H

To specify 25 days as the Visit Frequency, then Recommended_Visit_Frequency field should be P25D

Once the data is uploaded for Account Visits Details, you may check in the Visits Details facet in the Account.

  1. Go to Customers workcenter
  2. Go to Accounts view
  3. Find the respective Account ID and open the Account
  4. Go to the facet Visits Details
  5. Under the section Visits Details, you can see the Recommended Visit Frequency in the field Recommended Frequency

Keywords

Recommended Visit Frequency, Recommended Frequency, Account Visits Details, Visits Details , KBA , recommended visit frequency , recommended frequency , visits details , visit duration , account visits details , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer all versions