SAP Knowledge Base Article - Public

3341663 - Error "Cannot define visiting days for visit frequency type YEARLY/MONTHLY/DAILY" Shows while Uploading Visit Plan

Symptom

Error "Cannot define visiting days for visit frequency type YEARLY/MONTHLY/DAILY" shows while Uploading Visit Plan via data import and export.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Cloud for Customer 

Reproducing the Issue

  1. Go to Data Import and Export View
  2. Click on "Import" button 
  3. Select entity "Visit Plans" and switch on "Complete entity" 
  4. Select "Update" & “Ignore” 
  5. Select file type "Excel" 
  6. Drop the modified ZIP file 
  7. Click "Import Data"
  8. It failed with "Error" Status 
  9. Download the error file 
  10. It shows error "Cannot define visiting days for visit frequency type YEARLY/MONTHLY/DAILY" 

Cause

For Visit Frequency WEEKLY, values for visiting days can be maintained as TRUE/FALSE as only weekly frequency supports visiting days. For Visit Frequency YEARLY & MONTHLY & DAILY, visiting days cannot be maintained.

Resolution

For Visit Frequency YEARLY & MONTHLY & DAILY, visiting days cannot be maintained, so please leave them empty in the Visit_Plan_Sales_Data  excel.

Keywords

Cannot define visiting days for visit frequency type;YEARLY;MONTHLY;DAILY;DVP;Data Import;Data Impex;Data Import and Export;Visit Plan;Upload;Update , KBA , LOD-CRM-DVP , SAP Sales Cloud, dynamic visit planning add-on , How To

Product

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

Attachments

Pasted image.png
Pasted image.png
2023-06-06_10-06-22.png